مبتدی: ذخيره اطلاعات در بانك [بایگانی]

fakhravari

سه شنبه 12 آذر 1392, 22:54 عصر

$(document).ready(function () {
$("#btn1").click(function () {
if ($("#Address").val() === "" || $("#Position").val() === "" || $("#Name").val() === "") return;

$("#btn1").hide(); $("#LoadingImage").show();
var ajax = $.ajax({
type: "GET",
timeout: 8000,
url: "Default.aspx",
data: { Name: $("#Name").val(), Address: $("#Address").val(), AcceptLink: $("#AcceptLink").prop('checked'), Position: $("#Position").val(), Act: 'I' }
});
ajax.done(function (msg) { alert(msg); $("#btn1").show(100); Control(0); })
ajax.fail(function () { alert("Fail Ajax"); $("#btn1").show(100); Control(1); })
ajax.error(function (x, t, m) { if (t != "timeout") { alert("ajax.error " + t); } })
});

$("#btn3").click(function () {
if ($("#LinkID").val() === "" || $("#Address").val() === "" || $("#Position").val() === "" || $("#Name").val() === "") return;

$("#btn3").hide(); $("#LoadingImage").show();
var ajax = $.ajax({
type: "GET",
timeout: 8000,
url: "Default.aspx",
data: { Name: $("#Name").val(), Address: $("#Address").val(), AcceptLink: $("#AcceptLink").prop('checked'), Position: $("#Position").val(), LinkID: $("#LinkID").val(), Act: 'U' }
});
ajax.done(function (msg) { alert(msg); $("#btn3").show(100); Control(0); })
ajax.fail(function () { alert("Fail Ajax"); $("#btn3").show(100); Control(1); })
ajax.error(function (x, t, m) { if (t != "timeout") { alert("ajax.error " + t); } })
});

$("#btn2").click(function () {
if ($("#LinkID").val() === "") return;

$("#btn2").hide(); $("#LoadingImage").show();
var ajax = $.ajax({
type: "GET",
timeout: 8000,
url: "Default.aspx",
data: { LinkID: $("#LinkID").val(), Act: 'D' }
});
ajax.done(function (msg) { alert(msg); $("#btn2").show(100); Control(0); })
ajax.fail(function () { alert("Fail Ajax"); $("#btn2").show(100); Control(1); })
ajax.error(function (x, t, m) { if (t != "timeout") { alert("ajax.error " + t); } })
});

using System;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["Act"] == "I")
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationMa nager.ConnectionStrings["fakhravaryConnectionString1"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO Link (Name, Address, AcceptLink, Position) VALUES (@Name, @Address, @AcceptLink, @Position);SELECT CAST(scope_identity() AS int);", con);
cmd.Parameters.AddWithValue("@Name", Request.QueryString["Name"]);
cmd.Parameters.AddWithValue("@Address", Request.QueryString["Address"]);
cmd.Parameters.AddWithValue("@AcceptLink", Request.QueryString["AcceptLink"]);
cmd.Parameters.AddWithValue("@Position", Request.QueryString["Position"]);

int ID = (int)cmd.ExecuteScalar();
if (ID > 0)
{
Response.Clear();
Response.Write("اطلاعات ثبت شد کد رهگیری : " + ID);
}
else
{
Response.Clear();
Response.Write("خطادر ثبت اطلاعات");
}
}

if (Request.QueryString["Act"] == "U")
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationMa nager.ConnectionStrings["fakhravaryConnectionString1"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("UPDATE Link SET Name = @Name, Address = @Address, AcceptLink = @AcceptLink, Position = @Position WHERE LinkID = @LinkID ", con);
cmd.Parameters.AddWithValue("@Name", Request.QueryString["Name"]);
cmd.Parameters.AddWithValue("@Address", Request.QueryString["Address"]);
cmd.Parameters.AddWithValue("@AcceptLink", Request.QueryString["AcceptLink"]);
cmd.Parameters.AddWithValue("@Position", Request.QueryString["Position"]);
cmd.Parameters.AddWithValue("@LinkID", Request.QueryString["LinkID"]);

if (cmd.ExecuteNonQuery() > 0)
{
Response.Clear();
Response.Write("اطلاعات بروز شد");
}
else
{
Response.Clear();
Response.Write("خطادر بروز اطلاعات");
}
}

if (Request.QueryString["Act"] == "D")
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationMa nager.ConnectionStrings["fakhravaryConnectionString1"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("DELETE FROM Link WHERE LinkID = @LinkID ", con);
cmd.Parameters.AddWithValue("@LinkID", Request.QueryString["LinkID"]);

if (cmd.ExecuteNonQuery() > 0)
{
Response.Clear();
Response.Write("اطلاعات حذف شد");
}
else
{
Response.Clear();
Response.Write("خطادر حذف اطلاعات");
}
}

}
}