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) { Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.Cache.SetExpires(DateTime.UtcNow.AddMinutes(-1)); Response.Cache.SetNoStore(); Response.AddHeader("Cache-control", "no-store,must-revalidate,private,no-cache,no-store,pre-check=0,post-check=0,max-stale=0"); Response.AddHeader("Pragma", "no-cache"); Response.AddHeader("Expires", "0"); if (Session["UID"] == null || Session["SchoolID"] == null) { Response.Write("<script>window.close();window.open('Logon.aspx','_Parent');</script>"); return; } if ((objCCWeb.ReturnNumericValue("SELECT Count(*) FROM MTUserLimitMaster WHERE UID=" + Session["UID"] + " AND ModuleID=26 AND MenuName='mnuEventAssigner'") == 0) || (objCCWeb.ReturnSingleValue("SELECT ISNULL(VisibleOption,'N') FROM MTUserLimitMaster WHERE UID=" + Session["UID"] + " AND ModuleID=26 AND MenuName='mnuEventAssigner'") == "N")) { Session.Clear(); Response.Redirect("Logon.aspx"); return; } if (objCCWeb.pCheckText(form1) == true) { Response.Write("<script>window.close();window.open('Logon.aspx','_parent');</script>"); return; } if (Request.QueryString["StrQuery"] != null) { string strResult = ""; string strQuery = ""; if (Request.QueryString["StrQuery"] == "Event") { strQuery = " EXEC spEvent '" + objCCWeb.ChangeYYYYMMDD(Request.QueryString["Value"].ToString()) + "'"; } SqlDataReader sqlRdr = objCCWeb.BindReader(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(); } if (Request.QueryString["ControlID"] != null) { string strResult = ""; string strQuery = ""; string strControl = Request.QueryString["ControlID"].ToString(); if (strControl == "chkClassSection") { strQuery = "SELECT ClassID,ClassName,EventClassID From(select DISTINCT CM.PriorityNo, CAST(CM.ClassID AS NVARCHAR)+'^'+CAST(SM.SectionID AS NVARCHAR) AS ClassID,CM.ClassName1+'-'+SM.SectionName1 AS ClassName,ISNULL(CAST(ECD.ClassID AS NVARCHAR)+'^'+CAST(ECD.SectionID AS NVARCHAR),'') AS EventClassID " + " FROM SISTudentYearWiseDetails SYD " + " INNER JOIN MTClassMaster CM On SYD.ClassID= CM.ClassID " + " INNER JOIN MTSectionMAster SM ON SYD.SectionID= SM.SectionID " + " LEFT JOIN EventClassDetail ECD ON ECD.classID=SYD.ClassID AND ECD.SectionID=SYD.SectionID " + " AND ECD.EventID IN(SELECT Top 1 EventID From EventMaster Where EventDate='" + objCCWeb.ChangeYYYYMMDD(Request["Value"].ToString()) + "') " + " WHERE SYD.SchoolID=" + Session["SchoolID"] + " AND SYD.AcaStart=" + Session["AcaStart"] + " AND CM.PriorityNo<>0)SUB ORDER BY PriorityNo"; } SqlDataReader rdrVal = objCCWeb.BindReader(strQuery); while (rdrVal.Read()) { strResult = strResult + rdrVal.GetValue(0).ToString() + "," + rdrVal.GetValue(1).ToString() + "," + rdrVal.GetValue(2).ToString() + "~"; } if (strResult != "") { strResult = strResult.Remove(strResult.Length - 1); } rdrVal.Close(); Response.Clear(); Response.ContentType = "text/xml"; Response.Write(strResult); Response.End(); } if (Request.QueryString["Flag"] != null) { string strQuery = ""; if (Request.QueryString["Flag"] == "Report") { strQuery = "DECLARE @Var nvarchar(200) SET @Var='' " + " Select @Var=@Var+ Class+',' From ( SELECT Distinct CAST(ECD.ClassID AS NVARCHAR)+'^'+CAST(ECD.SectionID AS NVARCHAR) AS Class " + " FROM SISTudentYearWiseDetails SYD " + " INNER JOIN EventClassDetail ECD ON ECD.classID=SYD.ClassID AND ECD.SectionID=SYD.SectionID " + " AND ECD.EventID IN(SELECT Top 1 EventID From EventMaster " + " Where EventDate='" + objCCWeb.ChangeYYYYMMDD(Request.QueryString["Value"].ToString()) + "'))SUB " + " SELECT CASE WHEN LEN(@Var )>1 THEN SUBSTRING(@Var,1,LEN(@Var)-1) ELSE '' END"; } string strResult = objCCWeb.ReturnSingleValue(strQuery); Response.Clear(); Response.ContentType = "text/xml"; Response.Write(strResult); Response.End(); } if (!IsPostBack) { hidCache.Value = ""; gvEventDetails.Attributes.Add("bordercolor", "#FFC1A4"); btnSelectAll.Attributes.Add("onclick", "javascript:return fClassSubject(1);"); btnDeSelect.Attributes.Add("onclick", "javascript:return fClassSubject(0);"); chkClassSection.Attributes.Add("oncontextmenu", "javascript:return fSelectDeSelect(event)"); btnDoubleClick_Click(sender, e); ClientScript.RegisterStartupScript(this.GetType(), "dis", "<script language=javascript>fBindCheckBoxList('chkClassSection','" + DateTime.Now.ToString("dd/MM/yyyy") + "');</script>"); //fBindCheckBoxList('chkClassSection',varDate); } pGetOption(); }