protected void LinkButton1_Click(object sender, EventArgs e) { if (Session["Cache"] != null) { Cache.Remove(Session["Cache"].ToString()); } objCCWeb.ExecuteQuery("UPDATE MDUserLoginDetails SET LoggedOutTime=GETDATE() WHERE LoggedOutTime IS NULL AND SessionDetails='" + Session["UserLogin"] + "'"); Session.Clear(); Response.Redirect("Logon.aspx"); }
protected void btnDelete_Click(object sender, EventArgs e) { try { string strResult; string[] strArray = hidFlag.Value.ToString().Split('^'); if (objCCWeb.ReturnNumericValue("EXEC spGetPrimaryValueExists 'SchoolID','MTClientCompany','" + Convert.ToInt32(gvInstitute.Rows[Convert.ToInt32(strArray[2])].Cells[1].Text) + "'") > 0) { //ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language='javascript'>" + strHideID + "alert('School Is In Use')</script>"); strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "4", ""); ClientScript.RegisterStartupScript(this.GetType(), "dispScript", "<script language='javascript'>" + strHideID + "alert('" + strResult + "')</script>"); return; } else { strResult = objCCWeb.ExecuteQuery("INSERT INTO UserUpdateDetails(UID,SessionID,UpdateDate,FormName,Details) VALUES(" + Session["UID"] + ",'" + Session.SessionID + "',GETDATE(),'mnuInstitutionMaster','School " + (txtInstitution1.Text.Trim().Replace("'", "''") != "" ? txtInstitution1.Text.Trim().Replace("'", "''") : txtInstitution2.Text.Trim().Replace("'", "''")) + " Information ,Is Deleted')"); strResult = objCCWeb.ExecuteQuery("DELETE FROM MTClientCompany WHERE SchoolID=" + Convert.ToInt32(gvInstitute.Rows[Convert.ToInt32(strArray[2])].Cells[1].Text) + ""); if (strResult == "") { //ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language=javascript>" + strHideID + "alert('Deleted Successfully')</script>"); strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "3", ""); ClientScript.RegisterStartupScript(this.GetType(), "displayDelete", "<script language=javascript>" + strHideID + "alert('" + strResult + "')</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language=javascript>" + strHideID + "alert('" + strResult + "')</script>"); } } BindDDL(); btnCancel_Click(sender, e); } catch (Exception exMyError) { ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language='javascript'>" + strHideID + "alert('" + exMyError.Message.Replace("'", "") + "')</script>"); } }
protected void lnkOnline_Click(object sender, EventArgs e) { int intAcastart = objCCWeb.ReturnNumericValue("Select MAX(AcaStart) From MTAcademicsessionmaster"); Session["UserLogin"] = Session.SessionID; objCCWeb.ExecuteQuery("INSERT INTO MDUserLoginDetails(IPAddress,LoginTime,SessionDetails,UserAgent,Referrer,URL,LoggedOutTime,LoginSuccessStatus) VALUES ('" + Request.ServerVariables.Get("remote_addr").ToString() + "',GETDATE(),'" + Session.SessionID.ToString() + "','" + hidBrsr.Value.Trim().ToString() + "','" + Request.UrlReferrer.ToString() + "','" + Request.Url.ToString() + "',null,'Y')"); ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language=\"javascript\">alert('Online Registration Not Started !');</script>"); Response.Redirect("NewGuideline.aspx"); }
protected void btnReset_Click(object sender, EventArgs e) { string strResult = ""; string[] strUID; string StrStudentID = ""; ((MSCaptcha.CaptchaControl)btnReset.FindControl("ccJoin")).ValidateCaptcha(((TextBox)btnReset.FindControl("txtCapText")).Text); if (!((MSCaptcha.CaptchaControl)btnReset.FindControl("ccJoin")).UserValidated) { lblCode.Text = "Code Mismatch. Please enter the Code again."; txtCapText.Text = ""; txtCapText.Focus(); return; } else { lblCode.Text = ""; } if (rbtnReg.Checked == true) { StrStudentID = objCCWeb.ReturnSingleValue("Select SM.Applicationid from AdmStudentMaster SM Inner Join ADMFatherDetails FD on SM.ApplicationID=FD.ApplicationID where SM.FirstName='" + txtFirstName.Text.Trim().Replace("'", "''") + "' and SM.DOB='" + objCCWeb.ChangeYYYYMMDD(txtDOB.Text.Trim()) + "' and SM.MobileNo='" + txtMobileNo.Text.Trim().Replace("'", "''") + "' "); if (StrStudentID != "") { strUID = objCCWeb.ReturnSingleValue("SELECT CAST(UID AS VARCHAR)+'^'+CAST(UserID aS VARCHAR) From MTUserMaster where EmployeeIDStudentID=" + StrStudentID + " AND UsertypeID=6 and UserStatus='Y'").ToString().Split('^'); if (strUID[0] != "") { string strPassword = getCode(); if (strResult == "") { strResult = objCCWeb.ExecuteQuery("UPDATE MTUserMaster SET UserPassword='******' WHERE UID=" + strUID[0] + " and UserTypeID=6 and UserStatus='Y' and UserID like 'SR%'"); strResult = strResult + objCCWeb.ExecuteQuery("Update AdmStudentMaster Set StrNum='" + strPassword + "' where ApplicationId=" + StrStudentID + ""); if (strResult == "") { sendSMS("91" + txtMobileNo.Text.Trim().Replace("'", "''") + "", "Your UserID is " + strUID[1] + " and your password is " + strPassword + ". Please retain this information for future reference.", strUID[0]); txtMobileNo.Text = ""; txtDOB.Text = ""; txtFirstName.Text = ""; txtCapText.Text = ""; strResult = "The New Password Has Been Sent To The Registered Mobile No."; } } } else { strResult = "User ID Does not Exist For This Child."; } } else { strResult = "UserID Does not Exist For This Child."; } } if (rbtnParentlogin.Checked == true) { StrStudentID = objCCWeb.ReturnSingleValue("Select ParentID from SIStudentMaster SM Inner join SIStudentFatherDetails FD on FD.StudentID=SM.StudentID where SM.FirstName='" + txtFirstName.Text.Trim().Replace("'", "''") + "' and SM.DateofBirth='" + objCCWeb.ChangeYYYYMMDD(txtDOB.Text.Trim()) + "' and FD.MobileNo like '%" + txtMobileNo.Text.Trim().Replace("'", "''") + "%' "); if (StrStudentID != "") { strUID = objCCWeb.ReturnSingleValue("SELECT CAST(UID AS VARCHAR)+'^'+CAST(UserID aS VARCHAR) From MTUserMaster where EmployeeIDStudentID=" + StrStudentID + " AND UsertypeID=3 and UserID like 'P%'").ToString().Split('^'); if (strUID[0] != "") { string strPassword = getCode(); if (strResult == "") { strResult = objCCWeb.ExecuteQuery("UPDATE MTUserMaster SET UserPassword='******' WHERE UID=" + strUID[0] + " and UserTypeID=3 and UserID like 'P%'"); if (strResult == "") { sendSMS("91" + txtMobileNo.Text.Trim().Replace("'", "''") + "", "Your UserID is " + strUID[1] + " and your password is " + strPassword + ". Please retain this details for future reference.", strUID[0]); txtMobileNo.Text = ""; txtDOB.Text = ""; txtFirstName.Text = ""; strResult = "The New Password Has Been Sent To The Registered Mobile No."; } } } else { strResult = "Parent User ID Does not Exist For This Child."; } } else { strResult = "Entered data is not matching with our data"; } } if (rbtnStudentlogin.Checked == true) { StrStudentID = objCCWeb.ReturnSingleValue("Select SM.StudentID from SIStudentMaster SM Inner join SIStudentFatherDetails FD on FD.StudentID=SM.StudentID where SM.FirstName='" + txtFirstName.Text.Trim().Replace("'", "''") + "' and SM.DateofBirth='" + objCCWeb.ChangeYYYYMMDD(txtDOB.Text.Trim()) + "' and FD.MobileNo like '%" + txtMobileNo.Text.Trim().Replace("'", "''") + "%' "); if (StrStudentID != "") { strUID = objCCWeb.ReturnSingleValue("SELECT CAST(UID AS VARCHAR)+'^'+CAST(UserID aS VARCHAR) From MTUserMaster where EmployeeIDStudentID=" + StrStudentID + " AND UsertypeID=2 and UserID like 'S%'").ToString().Split('^'); if (strUID[0] != "") { string strPassword = getCode(); if (strResult == "") { strResult = objCCWeb.ExecuteQuery("UPDATE MTUserMaster SET UserPassword='******' WHERE UID=" + strUID[0] + " and UserTypeID=2 and UserID like 'S%'"); if (strResult == "") { sendSMS("91" + txtMobileNo.Text.Trim().Replace("'", "''") + "", "Your UserID is " + strUID[1] + " and your password is " + strPassword + ". Please retain this details for future reference.", strUID[0]); txtMobileNo.Text = ""; txtDOB.Text = ""; txtFirstName.Text = ""; txtCapText.Text = ""; strResult = "The New Password Has Been Sent To The Registered Mobile No."; } } } else { strResult = "Student User ID Does not Exist For This Child."; } } else { strResult = "Entered data is not matching with our data"; } } ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script>alert('" + strResult + "');</script>"); }
protected void Page_Load(object sender, EventArgs e) { string strResult = ""; if (Request["TypeID"] != null && Request["TypeID"] != "") { //SqlDataReader sqlRdr; if (Request["TypeID"] == "FillListBox") { sqlRdr = objCCWeb.BindReader(Request["StrQuery"]); //if (Request["pAction"]=="FillListBox") // { // sqlRdr = objCCWeb.BindReader(Request["strQuery"]); // } while (sqlRdr.Read()) { strResult = strResult + sqlRdr.GetValue(0).ToString() + "^" + sqlRdr.GetValue(1).ToString() + "~"; } if (strResult != "") { strResult = strResult.Remove(strResult.Length - 1); } } else if (Request["TypeID"] == "ReturnSingleValue") { sqlRdr = objCCWeb.BindReader(Request["StrQuery"]); //if (Request["pAction"]=="FillListBox") // { // sqlRdr = objCCWeb.BindReader(Request["strQuery"]); // } if (sqlRdr.Read()) { strResult = sqlRdr.GetValue(0).ToString(); } } //else if (Request["TypeID"] == "ExecuteQuery") //{ // strResult = objCCWeb.ExecuteQuery(Request["StrQuery"]); //} else if (Request["TypeID"] == "FillClientGrid") { Int32 intcount = 0; sqlRdr = objCCWeb.BindReader(Request["StrQuery"]); while (sqlRdr.Read()) { if (intcount == 0) { intcount = 1; for (int intForLoop = 0; intForLoop < sqlRdr.FieldCount; intForLoop++) { strResult = strResult + sqlRdr.GetName(intForLoop).ToString() + "^"; } if (strResult != "") { strResult = strResult.Remove(strResult.Length - 1); } strResult = strResult + "~"; } for (int intForLoop = 0; intForLoop < sqlRdr.FieldCount; intForLoop++) { strResult = strResult + sqlRdr.GetValue(intForLoop).ToString() + "^"; } if (strResult != "") { strResult = strResult.Remove(strResult.Length - 1); } strResult = strResult + "~"; } if (strResult != "") { strResult = strResult.Remove(strResult.Length - 1); } } else //if (Request["TypeID"] == "FillGrid") { sqlRdr = objCCWeb.BindReader(Request["StrQuery"]); while (sqlRdr.Read()) { for (int intForLoop = 0; intForLoop < sqlRdr.FieldCount; intForLoop++) { strResult = strResult + sqlRdr.GetValue(intForLoop).ToString() + "^"; } if (strResult != "") { strResult = strResult.Remove(strResult.Length - 1); } strResult = strResult + "~"; } if (strResult != "") { strResult = strResult.Remove(strResult.Length - 1); } } sqlRdr.Close(); sqlRdr.Dispose(); Response.Clear(); Response.ContentType = "text/xml"; Response.Write(strResult); Response.End(); } else if (Request["TypeID"] == "ExecuteQuery") { strResult = objCCWeb.ExecuteQuery(Request["StrQuery"]); Response.Clear(); Response.ContentType = "text/xml"; Response.Write(strResult); Response.End(); } //} }
protected void btnSave_Click(object sender, EventArgs e) { try { string strResult; string strResult1; string[] astrFlag = hidFlag.Value.Split('^'); if (astrFlag[0] == "N") { astrFlag[1] = "0"; } List <string> lstArray = new List <string>(); if (astrFlag[0] == "N") { // objCCWeb.FillCheckedBoxList(chkReportName, "SELECT 0 AS ReportID,'' AS ReportName" + Session["Type"] + " UNION SELECT ReportID,ReportName" + Session["Type"] + " FROM MTReportMaster WHERE ReportID>0 AND ModuleID="+Convert.ToInt32(ddlModuleID.SelectedValue)+"ORDER BY ReportID, ReportName" + Session["Type"] + "", "ReportID", "ReportName" + Session["Type"] + "", " "); if (objCCWeb.ReturnNumericValue("SELECT Count(*) FROM MTReportGroupMaster WHERE ModuleID=" + ddlModuleID.SelectedValue + "") == 5) { ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language='javascript'>" + strHideID + "alert('Only Five Group Per Module Is Allowed To Create')</script>"); return; } if (objCCWeb.ReturnNumericValue("SELECT COUNT(GroupId) FROM MTReportGroupMaster WHERE UPPER(PriorityNo)='" + txtpriority.Text.Trim() + "' AND GroupId<>" + astrFlag[1] + " AND ModuleID=" + ddlModuleID.SelectedValue) > 0) { strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "5", lblpriority.Text); ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language='javascript'>" + strHideID + "alert('" + strResult + "')</script>"); txtpriority.Focus(); return; } if (objCCWeb.ReturnNumericValue("SELECT COUNT(GroupId) FROM MTReportGroupMaster WHERE UPPER(GroupName)='" + txtReportGroupName1.Text.Trim().Replace("'", "''").ToUpper() + "' AND GroupId<>" + astrFlag[1]) > 0) { strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "5", lblpriority.Text); ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language='javascript'>" + strHideID + "alert('" + strResult + "');</script>"); txtReportGroupName1.Focus(); return; } if (objCCWeb.ReturnNumericValue("SELECT COUNT(*) FROM MTReportGroupMaster") == 0) { strResult = objCCWeb.ExecuteQuery("INSERT INTO MTReportGroupMaster(GroupID,GroupName,ModuleID,PriorityNo) values(0,'',0,0)"); } strResult = objCCWeb.ExecuteQuery("INSERT INTO MTReportGroupMaster(GroupID,GroupName,ModuleID,PriorityNo) SELECT ISNULL(MAX(GroupID),0)+1,'" + txtReportGroupName1.Text.Trim().Replace("'", "''") + "'," + ddlModuleID.SelectedValue + "," + txtpriority.Text.Trim() + " FROM MTReportGroupMaster "); int GroupID = objCCWeb.ReturnNumericValue("SELECT ISNULL(MAX(GroupID),0) FROM MTReportGroupMaster"); for (int intForLoop = 0; intForLoop < chkReportName.Items.Count; intForLoop++) { if (chkReportName.Items[intForLoop].Selected == true) { string[] ReportName = chkReportName.Items[intForLoop].Text.Split('#'); int INTModuleID = objCCWeb.ReturnNumericValue("SELECT ModuleID FROM MTReportMaster where ReportName" + Session["Type"] + "='" + ReportName[0].Trim() + "'"); int INTReportID = objCCWeb.ReturnNumericValue("SELECT ReportID FROM MTReportMaster where ReportName" + Session["Type"] + "='" + ReportName[0].Trim() + "'"); //lstArray.Add("INSERT INTO MTReportGroupMaster(ModuleID) VALUES("+ INTModuleID + ")"); lstArray.Add("INSERT INTO MTReportGroupDetails(GroupID,ReportID) Values(" + GroupID + "," + INTReportID + ")"); } } strResult1 = objCCWeb.ExecuteQueryList(lstArray); } else { if (astrFlag[0] == "E" && astrFlag[6].Trim() != txtpriority.Text.Trim()) { //int moduleid = int.Parse(ddlModuleID.SelectedValue); // int i = objCCWeb.ReturnNumericValue("SELECT COUNT(GroupId) FROM MTReportGroupMaster WHERE UPPER(PriorityNo)='" + txtpriority.Text.Trim() + "' AND GroupId<>" + astrFlag[1] + " AND ModuleID=" + ddlModuleID.SelectedValue); if (objCCWeb.ReturnNumericValue("SELECT COUNT(GroupId) FROM MTReportGroupMaster WHERE UPPER(PriorityNo)='" + txtpriority.Text.Trim() + "' AND GroupId<>" + astrFlag[1] + " AND ModuleID=" + astrFlag[5]) > 0) { strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "5", lblpriority.Text); ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language='javascript'>" + strHideID + "alert('" + strResult + "')</script>"); hidFlag.Value = "E'" + "^" + "^" + "^" + "^" + "^" + "^"; //string str = hidFlag.Value.Split('^'); // str.Replace('E','U'); // hidFlag.Value = str; //string temp="U"; //for (int i = 0; i < str.Length; i++) //{ // if (str[i] == 'E') // { // temp = temp + str[i]; // } //} // astrFlag[0].Replace('E','U'); //hidFlag.Value = ""; txtpriority.Focus(); return; } } if (astrFlag[0] == "E" && astrFlag[2].Trim().ToUpper() != txtReportGroupName1.Text.Trim().ToUpper()) { if (objCCWeb.ReturnNumericValue("SELECT COUNT(GroupID) FROM MTReportGroupMaster WHERE UPPER(GroupName)='" + txtReportGroupName1.Text.Trim().Replace("'", "''").ToUpper() + "' AND GroupId<>" + astrFlag[1]) > 0) { strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "5", lblReportGroupName1.Text); ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language='javascript'>" + strHideID + "alert('" + strResult + "')</script>"); hidFlag.Value = "E'" + "^" + "^" + "^" + "^" + "^" + "^"; //hidFlag.Value = ""; txtReportGroupName1.Focus(); return; } } //lstArray.Add("DELETE FROM MTReportGroupMaster WHERE GroupID =" + Convert.ToInt32(astrFlag[1]) + ""); lstArray.Add("DELETE FROM MTReportGroupDetails Where GroupID=" + Convert.ToInt32(astrFlag[1]) + ""); strResult = objCCWeb.ExecuteQuery("UPDATE MTReportGroupMaster SET GroupName='" + txtReportGroupName1.Text.Trim().Replace("'", "''") + "',ModuleID=" + astrFlag[5] + ",PriorityNo=" + txtpriority.Text.Trim() + "WHERE GroupId=" + Convert.ToInt32(astrFlag[1]) + ""); int GroupID = objCCWeb.ReturnNumericValue("SELECT ISNULL(MAX(GroupID),0) FROM MTReportGroupMaster"); for (int intForLoop = 0; intForLoop < chkReportName.Items.Count; intForLoop++) { if (chkReportName.Items[intForLoop].Selected == true) { string[] ReportName = chkReportName.Items[intForLoop].Text.Split('#'); int INTModuleID = Convert.ToInt32(ddlModuleID.SelectedValue); //objCCWeb.ReturnNumericValue("SELECT Moduleid FROM MTUserGroupMaster where ModuleName" + Session["Type"] + "='" + ModuleID[0].Trim() + "'"); //int INTReportID = objCCWeb.ReturnNumericValue("SELECT ReportID FROM MTReportMaster where ReportName" + Session["Type"] + "='" + ReportName[intForLoop].Trim() + "'"); int INTReportID = Convert.ToInt32(chkReportName.Items[intForLoop].Value); //lstArray.Add("INSERT INTO MTReportGroupMaster(GroupID,ModuleID) VALUES(" + Convert.ToInt32(astrFlag[1]) + "," + INTModuleID + ")"); lstArray.Add("Insert INTO MTReportGroupDetails(GroupID,ReportID) VALUES(" + Convert.ToInt32(astrFlag[1]) + "," + INTReportID + ")"); } } strResult1 = objCCWeb.ExecuteQueryList(lstArray); } btnCancel_Click(sender, e); //strResult1 = objCCWeb.ExecuteQueryList(lstArray); if (strResult == "") { if (astrFlag[0] == "N") { strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "1", ""); } else { strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "2", ""); } ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language=javascript>" + strHideID + "alert('" + strResult + "');</script>"); objCCWeb.FillCheckedBoxList(chkReportName, "SELECT ReportID,ReportName" + Session["Type"] + " FROM MTReportMaster WHERE ReportID>0 ORDER BY ReportID, ReportName" + Session["Type"] + "", "ReportID", "ReportName" + Session["Type"] + "", ""); } else { ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language=javascript>" + strHideID + "alert('" + strResult + "')</script>"); } hidFlag.Value = ""; } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "disError", "<script language='javascript'>" + strHideID + "alert('" + ex.Message.ToString().Replace("'", "") + "');</script>"); } }
protected void btnSave_Click(object sender, EventArgs e) { try { string[] strArray = hidFlag.Value.Split('^'); string strResult; string strShowFlag = "N"; string PayGatewayFlag = "N"; if (chkShowParentLogin.Checked == true) { strShowFlag = "Y"; } if (chkPayGatewayFlag.Checked == true) { PayGatewayFlag = "Y"; } if (objCCWeb.ReturnNumericValue("SELECT COUNT(*) FROM MTAcademicSessionMaster WHERE AcaStart<" + txtAcaSession1.Text.Trim() + " AND AcaEndDate>" + objCCWeb.ReturnDateorNull(txtSessionStart.Text.Trim())) > 0) { //ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language=javascript>alert('Existing Academic Session Overlapping')</script>"); strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "101_1", ""); ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language=javascript>alert('" + strResult + "')</script>"); return; } if (objCCWeb.ReturnNumericValue("SELECT COUNT(*) FROM MTAcademicSessionMaster WHERE AcaStart>" + txtAcaSession1.Text.Trim() + " AND AcaStartDate<" + objCCWeb.ReturnDateorNull(txtSessionEnd.Text.Trim())) > 0) { //ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language=javascript>alert('Existing Academic Session Overlapping')</script>"); strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "101_1", ""); ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language=javascript>alert('" + strResult + "')</script>"); return; } if (strArray[0] == "N") { if (objCCWeb.ReturnNumericValue("SELECT COUNT(*) FROM MTAcademicSessionMaster WHERE AcaStart='" + txtAcaSession1.Text.Trim() + "'") > 0) { //ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language=javascript>alert('Academic Session already Exist')</script>"); strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "5", lblAcademicSession1.Text); ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language=javascript>alert('" + strResult + "')</script>"); return; } strResult = objCCWeb.ExecuteQuery("INSERT INTO MTAcademicSessionMaster(AcaStart,AcaStartDate,AcaEndDate,EntryUserID,EntryDate,ShowFlag,PayGatewayFlag) " + " VALUES(" + txtAcaSession1.Text.Trim() + "," + objCCWeb.ReturnDateorNull(txtSessionStart.Text.Trim()) + "," + objCCWeb.ReturnDateorNull(txtSessionEnd.Text.Trim()) + "," + " " + Session["UID"].ToString() + ",GETDATE(),'" + strShowFlag + "','" + PayGatewayFlag + "')"); strResult = objCCWeb.ExecuteQuery("INSERT INTO UserUpdateDetails(UID,SessionID,UpdateDate,FormName,Details) VALUES(" + Session["UID"] + ",'" + Session.SessionID + "',GETDATE(),'mnuAcademicSession','Academic Session: " + txtAcaSession1.Text.Trim() + " - " + (Convert.ToInt32(txtAcaSession1.Text.Trim()) + 1) + " ,Is Added')"); } else { strResult = objCCWeb.ExecuteQuery("UPDATE MTAcademicSessionMaster SET AcaStartDate=" + objCCWeb.ReturnDateorNull(txtSessionStart.Text.Trim()) + "," + "AcaEndDate=" + objCCWeb.ReturnDateorNull(txtSessionEnd.Text.Trim()) + ",UpdateUserID=" + Session["UID"].ToString() + ",UpdateDate=GETDATE()," + "ShowFlag='" + strShowFlag + "',PayGatewayFlag='" + PayGatewayFlag + "' WHERE AcaStart=" + gvAcademicSession.Rows[Convert.ToInt32(strArray[1])].Cells[1].Text); strResult = objCCWeb.ExecuteQuery("INSERT INTO UserUpdateDetails(UID,SessionID,UpdateDate,FormName,Details) VALUES(" + Session["UID"] + ",'" + Session.SessionID + "',GETDATE(),'mnuAcademicSession','Academic Session: " + txtAcaSession1.Text.Trim() + " - " + (Convert.ToInt32(txtAcaSession1.Text.Trim()) + 1) + " ,Is Modified')"); } if (strResult == "") { if (strArray[0] == "N") { strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "1", ""); } else { strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "2", ""); } ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language=javascript>alert('" + strResult + "')</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language=javascript>alert('" + strResult + "')</script>"); } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language=javascript>alert('" + ex.Message + "')</script>"); } BindDDL(); }