protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string strResult = "";
//string lblMessage = "";
if (hdnstatus.Value == "EE")
{
string accNo = objDbutility.ReturnSingleValue("SELECT CustomerID FROM [CustomerMaster] WHERE ACCNO ='" + Accno.Value.Trim() + "'");
strCon1 = "Update CustomerMaster Set FirstName=" + objDbutility.fReplaceChar(firstname.Value.Trim()) + ",MiddleName=" + objDbutility.fReplaceChar(middlename.Value.Trim()) + "" +
" , LastName=" + objDbutility.fReplaceChar(lastname.Value.Trim()) + ",Sex='" + (genderM.Checked == true ? 'M' : 'F') + "',DateOfBirth=" + objDbutility.ReturnDateorNull(txtDOB.Value.Trim()) + ", " +
" EmailID=" + objDbutility.fReplaceChar(email.Value.Trim()) + ",PanNo=" + objDbutility.fReplaceChar(panNo.Value.Trim()) + ",FatherName=" + objDbutility.fReplaceChar(FatherName.Value.Trim()) + "," +
" UpdateUserID = '1',UpdateDate= Getdate() where CustomerID= " + accNo + "";
Session["UID"] = "1";
strCon2 = strCon2 + "~INSERT INTO UserUpdateDetails(UID,SessionID,UpdateDate,FormName,Details) VALUES('" + Session["UID"] + "','" + Session.SessionID + "',GETDATE(),'mnuStudent','Student, Name: " + firstname.Value.Trim().Replace("'", "''") + " " + middlename.Value.Trim().Replace("'", "''") + " " +
" " + lastname.Value.Trim().Replace("'", "''") + " With Accno No : " + Accno.Value.Trim().Replace("'", "''") + " & Cust ID: " + accNo + " Is updated')";
}
else
{
int intCustID = objDbutility.ReturnNumericValue("SELECT ISNULL(MAX(CustomerID),0)+1 FROM CustomerMaster ");
string accNo = "0";
accNo = objDbutility.ReturnSingleValue("SELECT ISNULL(MAX(CAST([CustomerID] AS Bigint)),0)+1 FROM [CustomerMaster] WHERE ISNUMERIC([CustomerID])= 1 ");
Accno.Value = "MI-000" + accNo;
strCon1 = "INSERT INTO CustomerMaster (CustomerID,FirstName,MiddleName,LastName,Sex,DateOfBirth,EmailID,ACCNO,PanNo,FatherName,Balance,EntryUserID,EntryDate" +
" ) VALUES(" + intCustID + "," + objDbutility.fReplaceChar(firstname.Value.Trim()) + "," + objDbutility.fReplaceChar(middlename.Value.Trim()) + "," +
" " + objDbutility.fReplaceChar(lastname.Value.Trim()) + ",'" + (genderM.Checked == true ? 'M' : 'F') + "'," + objDbutility.ReturnDateorNull(txtDOB.Value.Trim()) + "," +
" " + objDbutility.fReplaceChar(email.Value.Trim()) + "," + objDbutility.fReplaceChar(Accno.Value.Trim()) + "," + objDbutility.fReplaceChar(panNo.Value.Trim()) + "," +
" " + objDbutility.fReplaceChar(FatherName.Value.Trim()) + ",'0.00',1,GETDATE())";
Session["UID"] = "1";
strCon2 = strCon2 + "~INSERT INTO UserUpdateDetails(UID,SessionID,UpdateDate,FormName,Details) VALUES('" + Session["UID"] + "','" + Session.SessionID + "',GETDATE(),'mnuStudent','Student, Name: " + firstname.Value.Trim().Replace("'", "''") + " " + middlename.Value.Trim().Replace("'", "''") + " " +
" " + lastname.Value.Trim().Replace("'", "''") + " With Accno No : " + Accno.Value.Trim().Replace("'", "''") + " & Cust ID: " + accNo + " Is Added In Student Information')";
lblMessage.Text = strResult;
}
if (strResult == "")
{
if (hdnFlag.Value == "N~" || hdnFlag.Value == "A")
{
strResult = objDbutility.pDisplayMessage("", "1", "");
}
else
{
strResult = objDbutility.pDisplayMessage("", "2", "");
}
lblMessage.Text = strResult;
ClientScript.RegisterStartupScript(this.GetType(), "myModal", "ShowPopup();", true);
}
else
{
//ClientScript.RegisterStartupScript(this.GetType(), "dipt", "<script language=javascript>alert('" + strResult + "')</script>");
ClientScript.RegisterStartupScript(this.GetType(), "myModal", "ShowPopup();", true);
}
strResult = objDbutility.ExecuteQuery("EXEC DMLQuery '" + strCon1.Replace("'", "''") + "','" + strCon2.Replace("'", "''") + "'");
// ",'" + strCon3.Replace("'", "''") +
//"','" + strCon4.Replace("'", "''") + "','" + strCon5.Replace("'", "''") + "','" + strCon6.Replace("'", "''") + "','" + strCon7.Replace("'", "''") + "','" + strCon8.Replace("'", "''") + "','" + strCon9.Replace("'", "''") + "','" + strCon10.Replace("'", "''") + "','" + strCon11.Replace("'", "''") + "','" + strCon12.Replace("'", "''") + "','" + strCon13.Replace("'", "''") + "','" + strCon14.Replace("'", "''") + "'");
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script>alert(" + ex.Message.Replace("'", "") + ");</script>");
}
}