save and update using ado.net in c#
SqlConnection con = new SqlConnection(inductionConnectionString);
if (BtnSave.Text == "Save" && GetApplicationId() == 0)
{
cmd = new SqlCommand(@"INSERT INTO [forms].[AdminPersonalInformation] values
(
@AdminLogin_ID,
@AdminPersonalInformation_Name,
@AdminPersonalInformation_MobileNo,
@AdminPersonalInformation_LandLineNo,
@AdminPersonalInformation_OfficeNo,
@AdminPersonalInformation_Fax,
@AdminPersonalInformation_Address ,
@AdminPersonalInformation_Country,
@AdminPersonalInformation_State ,
@AdminPersonalInformation_City,
@AdminPersonalInformation_Gender,
@AdminPersonalInformation_Nationality,
@AdminPersonalInformation_Qualification,
@AdminPersonalInformation_DateOfBirth,
@AdminPersonalInformation_Image,
@AdminPersonalInformation_ImageThumbnail,
@AdminPersonalInformation_WebsiteURL,
@AdminPersonalInformation_BlogURL,
@InsertedOn,
@InsertedBy,
@LastModifiedOn ,
@LastModifiedBy ,
@IsActive ,
@IsDelete)", con);
cmd.Connection = con;
con.Open();
}
else
{
cmd = new SqlCommand(@"UPDATE [forms].[AdminPersonalInformation]
SET AdminLogin_ID=@AdminLogin_ID,
AdminPersonalInformation_Name=@AdminPersonalInformation_Name,
AdminPersonalInformation_MobileNo=@AdminPersonalInformation_MobileNo,
AdminPersonalInformation_LandLineNo=@AdminPersonalInformation_LandLineNo,
AdminPersonalInformation_OfficeNo=@AdminPersonalInformation_OfficeNo,
AdminPersonalInformation_Fax=@AdminPersonalInformation_Fax,
AdminPersonalInformation_Address=@AdminPersonalInformation_Address ,
AdminPersonalInformation_Country=@AdminPersonalInformation_Country,
AdminPersonalInformation_State=@AdminPersonalInformation_State ,
AdminPersonalInformation_City=@AdminPersonalInformation_City,
AdminPersonalInformation_Gender=@AdminPersonalInformation_Gender,
AdminPersonalInformation_Nationality=@AdminPersonalInformation_Nationality,
AdminPersonalInformation_Qualification=@AdminPersonalInformation_Qualification,
AdminPersonalInformation_DateOfBirth=@AdminPersonalInformation_DateOfBirth,
AdminPersonalInformation_Image=@AdminPersonalInformation_Image,
AdminPersonalInformation_ImageThumbnail=@AdminPersonalInformation_ImageThumbnail,
AdminPersonalInformation_WebsiteURL=@AdminPersonalInformation_WebsiteURL,
AdminPersonalInformation_BlogURL=@AdminPersonalInformation_BlogURL,
InsertedOn=@InsertedOn,
InsertedBy=@InsertedBy,
LastModifiedOn=@LastModifiedOn ,
LastModifiedBy= @LastModifiedBy,
IsActive= @IsActive ,
IsDelete=@IsDelete
WHERE AdminPersonalInformation_ID = @AdminPersonalInformation_ID", con);
cmd.Parameters.Add("@AdminPersonalInformation_ID", SqlDbType.VarChar).Value = GetApplicationId();
cmd.Connection = con;
con.Open();
}
cmd.Parameters.Add("@AdminLogin_ID", SqlDbType.VarChar).Value = loginId;
cmd.Parameters.Add("@AdminPersonalInformation_Name", SqlDbType.VarChar).Value = txtAPIname.Text;
cmd.Parameters.Add("@AdminPersonalInformation_MobileNo", SqlDbType.VarChar).Value = txtAPImobileno.Text;
cmd.Parameters.Add("@AdminPersonalInformation_LandLineNo", SqlDbType.VarChar).Value = txtAPIlandlineno.Text;
cmd.Parameters.Add("@AdminPersonalInformation_OfficeNo", SqlDbType.VarChar).Value = txtAPIofficeno.Text;
cmd.Parameters.Add("@AdminPersonalInformation_Fax", SqlDbType.VarChar).Value = txtAPIfax.Text;
cmd.Parameters.Add("@AdminPersonalInformation_Address", SqlDbType.VarChar).Value = txtAPIaddress.Text;
cmd.Parameters.Add("@AdminPersonalInformation_Country", SqlDbType.VarChar).Value = Radtxtcountry.Text;
cmd.Parameters.Add("@AdminPersonalInformation_State", SqlDbType.VarChar).Value = Radtxtstate.Text;
cmd.Parameters.Add("@AdminPersonalInformation_City", SqlDbType.VarChar).Value = Radtxtcity.Text;
cmd.Parameters.Add("@AdminPersonalInformation_Gender", SqlDbType.VarChar).Value = rdoAPIgender.SelectedValue;
cmd.Parameters.Add("@AdminPersonalInformation_Nationality", SqlDbType.VarChar).Value = txtnationality.Text;
cmd.Parameters.Add("@AdminPersonalInformation_Qualification", SqlDbType.VarChar).Value = txtqualification.Text;
cmd.Parameters.Add("@AdminPersonalInformation_DateOfBirth", SqlDbType.VarChar).Value = DPAPIdateofbirth.SelectedDate;
cmd.Parameters.Add("@AdminPersonalInformation_Image", SqlDbType.VarChar).Value = "xx";//Session["fileName"].ToString();
cmd.Parameters.Add("@AdminPersonalInformation_ImageThumbnail", SqlDbType.VarChar).Value = "thumbnail";//Session["fileName"].ToString();
cmd.Parameters.Add("@AdminPersonalInformation_WebsiteURL", SqlDbType.VarChar).Value = txtwebsiteurl.Text;
cmd.Parameters.Add("@AdminPersonalInformation_BlogURL", SqlDbType.VarChar).Value = txtblogurl.Text;
cmd.Parameters.Add("@InsertedOn", SqlDbType.VarChar).Value = DateTime.UtcNow;
cmd.Parameters.Add("@InsertedBy", SqlDbType.VarChar).Value = loginId;
cmd.Parameters.Add("@LastModifiedOn", SqlDbType.VarChar).Value = DateTime.UtcNow;
cmd.Parameters.Add("@LastModifiedBy", SqlDbType.VarChar).Value = loginId;
cmd.Parameters.Add("@IsActive", SqlDbType.VarChar).Value = true;
cmd.Parameters.Add("@IsDelete", SqlDbType.VarChar).Value = false;
int k = cmd.ExecuteNonQuery();
if (k != 0)
{
//Response.Write("<script>alert('Data Succesfully ')</script>");
RNAMessage.Text = "Data Save Successfully";
RNAMessage.Show();
Session["fileName"] = "";
Session["fileName"] = null;
GetAllAdminProfile();
}
con.Close();
}
}
catch (Exception ex)
{
}
if (BtnSave.Text == "Save" && GetApplicationId() == 0)
{
cmd = new SqlCommand(@"INSERT INTO [forms].[AdminPersonalInformation] values
(
@AdminLogin_ID,
@AdminPersonalInformation_Name,
@AdminPersonalInformation_MobileNo,
@AdminPersonalInformation_LandLineNo,
@AdminPersonalInformation_OfficeNo,
@AdminPersonalInformation_Fax,
@AdminPersonalInformation_Address ,
@AdminPersonalInformation_Country,
@AdminPersonalInformation_State ,
@AdminPersonalInformation_City,
@AdminPersonalInformation_Gender,
@AdminPersonalInformation_Nationality,
@AdminPersonalInformation_Qualification,
@AdminPersonalInformation_DateOfBirth,
@AdminPersonalInformation_Image,
@AdminPersonalInformation_ImageThumbnail,
@AdminPersonalInformation_WebsiteURL,
@AdminPersonalInformation_BlogURL,
@InsertedOn,
@InsertedBy,
@LastModifiedOn ,
@LastModifiedBy ,
@IsActive ,
@IsDelete)", con);
cmd.Connection = con;
con.Open();
}
else
{
cmd = new SqlCommand(@"UPDATE [forms].[AdminPersonalInformation]
SET AdminLogin_ID=@AdminLogin_ID,
AdminPersonalInformation_Name=@AdminPersonalInformation_Name,
AdminPersonalInformation_MobileNo=@AdminPersonalInformation_MobileNo,
AdminPersonalInformation_LandLineNo=@AdminPersonalInformation_LandLineNo,
AdminPersonalInformation_OfficeNo=@AdminPersonalInformation_OfficeNo,
AdminPersonalInformation_Fax=@AdminPersonalInformation_Fax,
AdminPersonalInformation_Address=@AdminPersonalInformation_Address ,
AdminPersonalInformation_Country=@AdminPersonalInformation_Country,
AdminPersonalInformation_State=@AdminPersonalInformation_State ,
AdminPersonalInformation_City=@AdminPersonalInformation_City,
AdminPersonalInformation_Gender=@AdminPersonalInformation_Gender,
AdminPersonalInformation_Nationality=@AdminPersonalInformation_Nationality,
AdminPersonalInformation_Qualification=@AdminPersonalInformation_Qualification,
AdminPersonalInformation_DateOfBirth=@AdminPersonalInformation_DateOfBirth,
AdminPersonalInformation_Image=@AdminPersonalInformation_Image,
AdminPersonalInformation_ImageThumbnail=@AdminPersonalInformation_ImageThumbnail,
AdminPersonalInformation_WebsiteURL=@AdminPersonalInformation_WebsiteURL,
AdminPersonalInformation_BlogURL=@AdminPersonalInformation_BlogURL,
InsertedOn=@InsertedOn,
InsertedBy=@InsertedBy,
LastModifiedOn=@LastModifiedOn ,
LastModifiedBy= @LastModifiedBy,
IsActive= @IsActive ,
IsDelete=@IsDelete
WHERE AdminPersonalInformation_ID = @AdminPersonalInformation_ID", con);
cmd.Parameters.Add("@AdminPersonalInformation_ID", SqlDbType.VarChar).Value = GetApplicationId();
cmd.Connection = con;
con.Open();
}
cmd.Parameters.Add("@AdminLogin_ID", SqlDbType.VarChar).Value = loginId;
cmd.Parameters.Add("@AdminPersonalInformation_Name", SqlDbType.VarChar).Value = txtAPIname.Text;
cmd.Parameters.Add("@AdminPersonalInformation_MobileNo", SqlDbType.VarChar).Value = txtAPImobileno.Text;
cmd.Parameters.Add("@AdminPersonalInformation_LandLineNo", SqlDbType.VarChar).Value = txtAPIlandlineno.Text;
cmd.Parameters.Add("@AdminPersonalInformation_OfficeNo", SqlDbType.VarChar).Value = txtAPIofficeno.Text;
cmd.Parameters.Add("@AdminPersonalInformation_Fax", SqlDbType.VarChar).Value = txtAPIfax.Text;
cmd.Parameters.Add("@AdminPersonalInformation_Address", SqlDbType.VarChar).Value = txtAPIaddress.Text;
cmd.Parameters.Add("@AdminPersonalInformation_Country", SqlDbType.VarChar).Value = Radtxtcountry.Text;
cmd.Parameters.Add("@AdminPersonalInformation_State", SqlDbType.VarChar).Value = Radtxtstate.Text;
cmd.Parameters.Add("@AdminPersonalInformation_City", SqlDbType.VarChar).Value = Radtxtcity.Text;
cmd.Parameters.Add("@AdminPersonalInformation_Gender", SqlDbType.VarChar).Value = rdoAPIgender.SelectedValue;
cmd.Parameters.Add("@AdminPersonalInformation_Nationality", SqlDbType.VarChar).Value = txtnationality.Text;
cmd.Parameters.Add("@AdminPersonalInformation_Qualification", SqlDbType.VarChar).Value = txtqualification.Text;
cmd.Parameters.Add("@AdminPersonalInformation_DateOfBirth", SqlDbType.VarChar).Value = DPAPIdateofbirth.SelectedDate;
cmd.Parameters.Add("@AdminPersonalInformation_Image", SqlDbType.VarChar).Value = "xx";//Session["fileName"].ToString();
cmd.Parameters.Add("@AdminPersonalInformation_ImageThumbnail", SqlDbType.VarChar).Value = "thumbnail";//Session["fileName"].ToString();
cmd.Parameters.Add("@AdminPersonalInformation_WebsiteURL", SqlDbType.VarChar).Value = txtwebsiteurl.Text;
cmd.Parameters.Add("@AdminPersonalInformation_BlogURL", SqlDbType.VarChar).Value = txtblogurl.Text;
cmd.Parameters.Add("@InsertedOn", SqlDbType.VarChar).Value = DateTime.UtcNow;
cmd.Parameters.Add("@InsertedBy", SqlDbType.VarChar).Value = loginId;
cmd.Parameters.Add("@LastModifiedOn", SqlDbType.VarChar).Value = DateTime.UtcNow;
cmd.Parameters.Add("@LastModifiedBy", SqlDbType.VarChar).Value = loginId;
cmd.Parameters.Add("@IsActive", SqlDbType.VarChar).Value = true;
cmd.Parameters.Add("@IsDelete", SqlDbType.VarChar).Value = false;
int k = cmd.ExecuteNonQuery();
if (k != 0)
{
//Response.Write("<script>alert('Data Succesfully ')</script>");
RNAMessage.Text = "Data Save Successfully";
RNAMessage.Show();
Session["fileName"] = "";
Session["fileName"] = null;
GetAllAdminProfile();
}
con.Close();
}
}
catch (Exception ex)
{
}
Comments
Post a Comment