protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["ParentID"] != null) { string[] strLogDetail = objCCWeb.ReturnSingleValue("DECLARE @VAR nvarchar(2000) " + " SET @VAR=ISNULL((SELECT TOP 1'Last Login :-'+ Convert(varchar,LoginTime,106)+' '+ ISNULL(CONVERT(VARCHAR, LoginTime,108),'') " + " FROM MDUserLoginDetails where UID=" + Session["UID"].ToString() + " AND SessionDetails<>'" + Session.SessionID.ToString() + "' AND LoginSuccessStatus='Y' ORDER BY LoginID DESC),ISNULL(Convert(varchar,GETDATE(),106),'')+' '+ ISNULL(CONVERT(VARCHAR, GETDATE(),108),'')) " + " SET @VAR=@VAR+'^'+ISNULL((SELECT 'Total Login:- '+CAST(COUNT(*)AS Varchar) FROM MDUserLoginDetails where UID=" + Session["UID"].ToString() + " AND LoginSuccessStatus='Y'),0) " + " SET @VAR=@VAR+'^'+ISNULL((SELECT TOP 1 'First Login :-'+ Convert(varchar,LoginTime,106)+' '+ ISNULL(CONVERT(VARCHAR, LoginTime,108),'') " + " FROM MDUserLoginDetails where UID=" + Session["UID"].ToString() + " AND LoginSuccessStatus='Y' ORDER BY LoginID ASC),ISNULL(Convert(varchar,GETDATE(),106),'')+' '+ ISNULL(CONVERT(VARCHAR, GETDATE(),108),'')) " + " SELECT @VAR").Split('^'); ltrlLastlogin.Text = ""; ltrlLastlogin.Text += "<li id='log1'>" + strLogDetail[2] + "</li>"; ltrlLastlogin.Text += "<li id='log2'>" + strLogDetail[0] + "</li>"; ltrlLastlogin.Text += "<li id='log3'>" + strLogDetail[1] + "</li>"; } if (Session["UID"] != null) { string[] strLogDetail = objCCWeb.ReturnSingleValue("DECLARE @VAR nvarchar(2000) " + " SET @VAR=ISNULL((SELECT TOP 1'Last Login :-'+ Convert(varchar,LoginTime,106)+' '+ ISNULL(CONVERT(VARCHAR, LoginTime,108),'') " + " FROM MDUserLoginDetails where UID=" + Session["UID"].ToString() + " AND SessionDetails<>'" + Session.SessionID.ToString() + "' AND LoginSuccessStatus='Y' ORDER BY LoginID DESC),ISNULL(Convert(varchar,GETDATE(),106),'')+' '+ ISNULL(CONVERT(VARCHAR, GETDATE(),108),'')) " + " SET @VAR=@VAR+'^'+ISNULL((SELECT 'Total Login:- '+CAST(COUNT(*)AS Varchar) FROM MDUserLoginDetails where UID=" + Session["UID"].ToString() + " AND LoginSuccessStatus='Y'),0) " + " SET @VAR=@VAR+'^'+ISNULL((SELECT TOP 1 'First Login :-'+ Convert(varchar,LoginTime,106)+' '+ ISNULL(CONVERT(VARCHAR, LoginTime,108),'') " + " FROM MDUserLoginDetails where UID=" + Session["UID"].ToString() + " AND LoginSuccessStatus='Y' ORDER BY LoginID ASC),ISNULL(Convert(varchar,GETDATE(),106),'')+' '+ ISNULL(CONVERT(VARCHAR, GETDATE(),108),'')) " + " SELECT @VAR").Split('^'); ltrlLastlogin.Text = ""; ltrlLastlogin.Text += "<li id='log1'>" + strLogDetail[2] + "</li>"; ltrlLastlogin.Text += "<li id='log2'>" + strLogDetail[0] + "</li>"; ltrlLastlogin.Text += "<li id='log3'>" + strLogDetail[1] + "</li>"; } } }
protected void BindDropDownStudent() { SchoolName = ObjccWeb.ReturnSingleValue("select SchoolName1 from MTClientCompany"); if (ObjccWeb.ReturnNumericValue("Select UserTypeID from MTUserMaster Where UID=" + Session["UID"] + "") == 3) { ObjccWeb.FillDDLs(ddlStudent, "Select Distinct SM.StudentID As StudentID,FirstName From SIStudentMaster SM Inner Join SIStudentYearWiseDetails SYD on SYD.StudentID=SM.StudentID where " + "ParentID=" + Session["ParentID"] + " AND StudentStatus='S' order by SM.StudentID", "StudentID", "Firstname", ""); ObjccWeb.FillDDLs(ddlAcademic, "SELECT SYD.AcaStart AS AcaStart,CAST(SYD.AcaStart AS VARCHAR)+' - '+CAST(SYD.AcaStart+1 AS VARCHAR) AS AcademicSession From SIStudentYearwiseDetails SYD INNER JOIN MTAcademicSessionMaster ASM ON ASM.AcaStart=SYD.AcaStart" + " WHERE SYD.AcaStart<>0 and StudentID=" + Session["StudentID"] + " AND ShowFlag='Y' ORDER BY SYD.AcaStart DESC", "AcaStart", "AcademicSession", ""); } }
protected void Page_Load(object sender, EventArgs e) { string ip = System.Net.Dns.GetHostAddresses(System.Net.Dns.GetHostName()).GetValue(0).ToString(); System.Web.HttpBrowserCapabilities browser = Request.Browser; ((Button)Login1.FindControl("loginButton")).Enabled = true; hidBrsr.Value = ""; hidBrsr.Value = "Type = " + browser.Type + "\n" + "Name = " + browser.Browser + "\n" + "Version = " + browser.Version + "\n" + "Major Version = " + browser.MajorVersion + "\n" + "Minor Version = " + browser.MinorVersion + "\n" + "Platform = " + browser.Platform + "\n" + "Is Beta = " + browser.Beta + "\n" + "Is Crawler = " + browser.Crawler + "\n" + "Is AOL = " + browser.AOL + "\n" + "Is Win16 = " + browser.Win16 + "\n" + "Is Wind32 = " + browser.Win32 + "\n" + "Support JavaScript = " + browser.EcmaScriptVersion.ToString() + "\n" + "Support JavaScript Verion = " + browser["JavaScriptVersion"] + ""; brsrCheck(); if (!IsPostBack) { if (Session["UID"] != null) { Session.Clear(); } ((TextBox)Login1.FindControl("UserName")).Focus(); ((TextBox)Login1.FindControl("UserName")).Attributes.Add("onpaste", "javascript:return false;"); ((TextBox)Login1.FindControl("Password")).Attributes.Add("onpaste", "javascript:return false;"); // ((TextBox)Login1.FindControl("txtCapText")).Attributes.Add("onpaste", "javascript:return false;"); ((TextBox)Login1.FindControl("UserName")).Attributes.Add("AutoComplete", "off"); ((TextBox)Login1.FindControl("Password")).Attributes.Add("AutoComplete", "off"); // ((TextBox)Login1.FindControl("txtCapText")).Attributes.Add("AutoComplete", "off"); objCCWeb.FillDDLs(((DropDownList)Login1.FindControl("ddlAcademicYear")), "SELECT AcaStart AS AcaStart,CAST(AcaStart AS VARCHAR)+' - '+CAST(AcaStart+1 AS VARCHAR) AS AcademicSession" + " FROM MTAcademicSessionMaster WHERE AcaStart<>0 ORDER BY AcaStart DESC", "AcaStart", "AcademicSession", ""); string strAcaStart = objCCWeb.ReturnSingleValue("SELECT AcaStart FROM MTAcademicSessionMaster WHERE AcaEndDate>=CONVERT(VARCHAR,GETDATE(),111) AND AcaStartDate<=CONVERT(VARCHAR,GETDATE(),111)"); try { ((DropDownList)Login1.FindControl("ddlAcademicYear")).Items.FindByValue(strAcaStart).Selected = true; } catch { } //btnAbout.Attributes.Add("onmouseover", "javascript:return fMouseOver(this)"); //btnAbout.Attributes.Add("onmouseout", "javascript:return fMouseOut(this)"); hid.Value = CreateSalt(6); //Creating a Salt and Sending to Client. hdnFlag.Value = ""; } }
protected void calendarAttentance_DayRender(object sender, DayRenderEventArgs e) { e.Cell.ID = "Cell/" + e.Day.Date.ToString("dd/MM/yyyy"); if (e.Day.IsOtherMonth) { e.Cell.Text = ""; } else { string strdate1 = e.Day.Date.ToString("dd/MM/yyyy"); string strDate2 = objCCWeb.ReturnSingleValue("SELECT CASE WHEN SAED.SIAttRemarkID=1 THEN 'Present' WHEN SAED.SIAttRemarkID=3 THEN 'HalfDay' WHEN SAED.SIAttRemarkID=4 THEN " + " 'SportDay' ELSE 'Absent' END AS Attendance FROM SIStudentMaster SIM INNER JOIN SIStudentYearWiseDetails SYD ON SYD.StudentID=SIM.StudentID AND SYD.AcaStart=" + Session["AcaStart"] + " INNER JOIN SIStudentAttEntry SAE ON SAE.StudentID=SIM.StudentID " + " INNER JOIN SIStudentAttEntryDetails SAED ON SAED.AttEntryID=SAE.AttEntryID WHERE SIM.StudentID=" + Session["StudentID"] + " AND SYD.AcaStart=" + Session["AcaStart"] + " AND PeriodWiseEntry='0' AND SAED.PeriodID='0' AND Convert(varchar,SAE.AttDate,103)='" + strdate1 + "' "); e.Cell.ToolTip = strdate1; if (strDate2 == "Present") { //e.Cell.BackColor = System.Drawing.Color.Green; e.Cell.Style.Add("background-image", "url(Images/Present.png)");//background-repeat :no-repeat ;background-position: center center; e.Cell.Style.Add("background-color", "#093"); e.Cell.Style.Add("background-repeat", "no-repeat"); e.Cell.Style.Add("background-position", "center"); e.Cell.ToolTip = "Present"; } else if (strDate2 == "HalfDay") { //e.Cell.BackColor = System.Drawing.Color.Maroon; e.Cell.Style.Add("background-image", "url(Images/HalfDay.png)");//background-repeat :no-repeat ;background-position: center center; e.Cell.Style.Add("background-color", "rgba(0, 0, 102, 0.4)"); e.Cell.Style.Add("background-repeat", "no-repeat"); e.Cell.Style.Add("background-position", "center"); e.Cell.ToolTip = "HalfDay"; } else if (strDate2 == "Absent") { e.Cell.Style.Add("background-image", "url(Images/Absent.png)");//background-repeat :no-repeat ;background-position: center center; e.Cell.Style.Add("background-color", "red"); e.Cell.Style.Add("background-repeat", "no-repeat"); e.Cell.Style.Add("background-position", "center"); e.Cell.ToolTip = "Absent"; } if ((alSelectDate.Contains(e.Day.Date.ToString("dd.MM.yyyy")) && (dtDate.Month == e.Day.Date.Month)) || (e.Day.Date.DayOfWeek.ToString() == "Sunday")) { //e.Cell.BackColor = System.Drawing.Color.FromName("#889999"); hidSunday.Value = hidSunday.Value + '~' + e.Day.Date.ToString("dd.MM.yyyy"); } } }
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 || Session["StudentID"] == null) { Response.Write("<script>window.close();window.open('Logon.aspx','_parent');</script>"); return; } if (Session["TOUserID"] != null) { HidUserToID.Value = Session["TOUserID"].ToString(); txtMailTo.Text = Session["TOUserID"].ToString(); Session["TOUserID"] = null; } if (Request.QueryString["Flag"] != null) { string strQuery = ""; if (Request.QueryString["Flag"] == "Read") { // strQuery = "Update MessageSendDetails set ReadUnread='R' where MessageID in (" + Request.QueryString["Value"] + ")"; } string strResult = ObjccWeb.ReturnSingleValue(strQuery); Response.Clear(); Response.ContentType = "text/xml"; Response.Write(strResult); Response.End(); } if (!IsPostBack) { HidType.Value = "I"; btnMailCancel_Click(sender, e); if (gvDetails.Rows.Count > 10) { Blank.Style.Add("display", "none"); } else { Blank.Style.Add("display", "block"); } } }
protected void btnOK_Click(object sender, EventArgs e) { string strCPwd = objCCWeb.ReturnSingleValue("SELECT UserPassword FROM MTUserMaster WHERE UID=" + Session["UID"]); if (strCPwd != FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassword.Text.Trim(), "SHA1")) { intCount = intCount + 1; if (intCount <= 3) { //ClientScript.RegisterStartupScript(this.GetType(), "disp", "<script>alert('Incorrect Password');</script>"); string strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "128_1", ""); ClientScript.RegisterStartupScript(this.GetType(), "disp", "<script>alert('" + strResult + "');</script>"); } else { Response.Redirect("~/MainForm.aspx"); } txtPassword.Focus(); } else { Session["ConfirmPassword"] = "******"; Response.Redirect(strMenuName); } }
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=1 AND MenuName='mnuAcademicSession'") == 0) || (objCCWeb.ReturnSingleValue("SELECT ISNULL(VisibleOption,'N') FROM MTUserLimitMaster WHERE UID=" + Session["UID"] + " AND ModuleID=1 AND MenuName='mnuAcademicSession'") == "N")) { Session.Clear(); Response.Redirect("Logon.aspx"); return; } if (objCCWeb.pCheckText(frmMTAcademicSessionMaster) == true) { Response.Write("<script>window.close();window.open('Logon.aspx','_parent');</script>"); return; } if ((Session["Type"] == null) || (Session["Type"].ToString() == "1")) { strType = "ltr"; } else { strType = "rtl"; } if (!IsPostBack) { hidCache.Value = ""; gvAcademicSession.Attributes.Add("bordercolor", "#FFC1A4"); txtAcaSession1.Attributes.Add("onkeypress", "javascript:return Restrict_Pincode(event);"); txtAcaSession2.Attributes.Add("onkeypress", "javascript:return Restrict_Pincode(event);"); txtSessionStart.Attributes.Add("onkeypress", "javascript:return Restrict_Date(event);"); txtSessionEnd.Attributes.Add("onkeypress", "javascript:return Restrict_Date(event);"); txtAcaSession1.Attributes.Add("onkeyup", "javascript:return f_OnChangeAcademicSession(event);"); pGetOption(); txtAcaSession1.Attributes.Add("AutoComplete", "off"); txtAcaSession2.Attributes.Add("AutoComplete", "off"); txtSessionEnd.Attributes.Add("AutoComplete", "off"); txtSessionStart.Attributes.Add("AutoComplete", "off"); BindDDL(); } }
protected void Page_Load(object sender, EventArgs e) { ClientScript.RegisterStartupScript(this.GetType(), "disScript", "<script language='javascript'>" + strHideID + "</script>"); 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=1 AND MenuName='mnuInstitutionMaster'") == 0) || (objCCWeb.ReturnSingleValue("SELECT ISNULL(VisibleOption,'N') FROM MTUserLimitMaster WHERE UID=" + Session["UID"] + " AND ModuleID=1 AND MenuName='mnuInstitutionMaster'") == "N")) { Session.Clear(); Response.Redirect("Logon.aspx"); return; } if (objCCWeb.pCheckText(frmMTClientCompany) == true) { Response.Write("<script>window.close();window.open('Logon.aspx','_parent');</script>"); return; } //if ((Session["Type"] == null) || (Session["Type"].ToString() == "1")) //{ // strType = "ltr"; //} //else //{ // strType = "rtl"; //} if (!IsPostBack) { hidCache.Value = ""; strAddPhoto = "Add Photo"; strRemovePhoto = "Remove Photo"; strChangePhoto = "Change Photo"; gvInstitute.Attributes.Add("bordercolor", "#FFC1A4"); txtInstitution1.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtInstitution2.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); txtEmail.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtPincode.Attributes.Add("onkeypress", "javascript:return Restrict_Pincode(event);"); //if (Session["Type"]== "1") //{ txtAddress.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtReportHeader.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtCity.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtState.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtTelephone.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtFax.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtAffiliation.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtMedium.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtEstablishedOn.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtEstablishmentCode.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtBankACNo.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtMotto.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtDirector.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtDirPhone.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtPrincipal.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtPriPhone.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtVicePrincipal.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtVicePriPhone.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtAdministrator.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); txtAdmPhone.Attributes.Add("onkeypress", "javascript:return Restrict_Address(event);"); //txtAffiliation.Attributes.Add("onkeyup", "javascript:return fFillListBox('FillAffiCode',event)"); AutoCompleteExtender.CompletionSetCount = Convert.ToInt32(Session["SchoolID"].ToString() + "000" + Session["AcaStart"].ToString()); //} //else //{ // txtAddress.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtReportHeader.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtCity.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtState.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtTelephone.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtFax.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtAffiliation.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtMedium.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtEstablishedOn.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtEstablishmentCode.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtBankACNo.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtMotto.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtDirector.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtDirPhone.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtPrincipal.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtPriPhone.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtVicePrincipal.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtVicePriPhone.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtAdministrator.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); // txtAdmPhone.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event);"); //} PGetOption(); BindDDL(); foreach (Control C in frmMTClientCompany.Controls) { if (C.GetType().FullName == "System.Web.UI.WebControls.TextBox") { ((TextBox)C).Attributes.Add("AutoComplete", "off"); } } btnCancel_Click(sender, e); pDisplayType(); } }
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) { if (Session["UID"] == null) { Response.Write("<script>window.close();window.open('Logon.aspx','_parent');</script>"); return; } GetMenuData(); int intUserTypeID = objCCWeb.ReturnNumericValue("Select UserTypeiD From MTUserMaster Where UID=" + Session["UID"] + " ");//AND UserTypeiD NOT in(0,1,4) if (intUserTypeID == 3 || intUserTypeID == 2) { Response.Write("<script>window.open('PlParentLoginForm.aspx','_parent');</script>"); return; } if (intUserTypeID == 6) { string UserID = objCCWeb.ReturnSingleValue("Select Case when UserId like 'SE%' then 'SE' else 'SR' end as UserID from MTUserMaster Where UID=" + Session["UID"] + " AND UserTypeID=6"); if (UserID == "SE") { Response.Write("<script>window.open('SRStudentonlineRegistration11.aspx','_parent');</script>"); } else { Response.Write("<script>window.open('SRStudentonlineRegistration.aspx','_parent');</script>"); } return; } if (Request.QueryString["Flag"] != null) { string strQuery = ""; if (Request.QueryString["Flag"] == "DisplayID") { strQuery = "Declare @VarMinMark as Varchar(2000);SET @VarMinMark=''; Select @VarMinMark=@VarMinMark+Cast (DisplayID as varchar)+'^'from MTDisplayMaster ORDER BY DisplayID " + " Select CASE WHEN LEN(@VarMinMark)>1 THEN SubString(@VarMinMark,1,LEN(@VarMinMark)-1) ELSE '0' END as MinMark"; } if (Request.QueryString["Flag"] == "OutTime") { strQuery = "UPDATE MDUserLoginDetails SET LoggedOutTime=GETDATE() WHERE LoggedOutTime IS NULL AND SessionDetails='" + Session["UserLogin"] + "'"; } string strResult = objCCWeb.ReturnSingleValue(strQuery); Response.Clear(); Response.ContentType = "text/xml"; Response.Write(strResult); Response.End(); } if (!IsPostBack) { if (Session["CollegeName"] != null) { Session["CollegeName"] = Session["CollegeName"].ToString().Replace(" ", " "); } else { Session["CollegeName"] = "Campus Care"; } if (Session["EmployeeID"] == null) { lnkPortal.Visible = false; } Session["Date"] = DateTime.Now.Date.ToString("yyyy/MM/dd"); lblDate.Text = DateTime.Now.Date.ToString("dd/MM/yyyy"); lblDate.Style.Add("text-align", "right"); //imgbtnExpand.Attributes.Add("onclick", "javascript:return fResize()"); btnAbout.Attributes.Add("onmouseover", "javascript:return fMouseOver(this)"); btnAbout.Attributes.Add("onmouseout", "javascript:return fMouseOut(this)"); lblUser.Text = "WELCOME " + Session["UserName"].ToString(); DataList1.DataSource = objCCWeb.BindReader("EXEC spBindCaption " + Session["SchoolID"] + "," + Session["AcaStart"] + ",'" + DateTime.Now.Date.ToString("yyyy/MM/dd") + "',1," + Session["UID"] + " "); DataList1.DataBind(); objCCWeb.FillDDLs(ddlSession, "SELECT AcaStart AS AcaStart,CAST(AcaStart AS VARCHAR)+' - '+CAST(AcaStart+1 AS VARCHAR) AS AcademicSession" + " FROM MTAcademicSessionMaster WHERE AcaStart<>0 ORDER BY AcaStart", "AcaStart", "AcademicSession", ""); objCCWeb.FillDDLs(ddlSchools, "SELECT SchoolID,SchoolName1 AS SchoolName FROM MTClientCompany WHERE SchoolID IN (SELECT SchoolID FROM MTUserInstitutionMaster WHERE UID=" + Convert.ToInt32(Session["UID"]) + ") ORDER BY SchoolName1", "SchoolID", "SchoolName", ""); if (ddlSchools.Items.Count > 0) { ddlSchools.Visible = true; string q = Session["SchoolID"].ToString(); ddlSchools.SelectedValue = Session["SchoolID"].ToString(); q = ddlSchools.SelectedItem.ToString(); } else { ddlSchools.Visible = false; } if (ddlSession.Items.Count > 0) { ddlSession.Visible = true; string q = Session["AcaStart"].ToString(); ddlSession.SelectedValue = Session["AcaStart"].ToString(); q = ddlSession.SelectedItem.ToString(); } else { ddlSession.Visible = false; } lblSchoolName.Text = Session["SchoolName"].ToString(); } }
//protected static string strHideID = " document.getElementById('trReportGroup').style.display='none';" + // "if (document.getElementById('gvReportGroup')!=null){if (document.getElementById('gvReportGroup').rows.length>1) {for(var intForLoop=0;intForLoop<document.getElementById('gvReportGroup').rows.length;intForLoop++)" + // " { document.getElementById('gvReportGroup').rows[intForLoop].cells[1].style.display='none'; " + // // " document.getElementById('gvReportGroup').rows[intForLoop].cells[4].style.display='none'; " + // "document.getElementById('divSelectDeSelect').style.display='none';}}}"; //protected static string strHidepriority = "if(document.getElementById('gvReportGroup')!=null) " + // " if(document.getElementById('gvReportGroup').rows.length>1) " + // " for(var varLoop= 0 ; varLoop<document.getElementById('gvReportGroup').rows.length;varLoop++) { " + // " document.getElementById('gvReportGroup').rows[varLoop].cells[5].style.display='none'; }"; protected void Page_Load(object sender, EventArgs e) { //ClientScript.RegisterStartupScript(this.GetType(), "disScript", "<script language='javascript'>" + strHideID + "</script>"); 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=1 AND MenuName='mnuReportGroupMaster'") == 0) || (objCCWeb.ReturnSingleValue("SELECT ISNULL(VisibleOption,'N') FROM MTUserLimitMaster WHERE UID=" + Session["UID"] + " AND ModuleID=1 AND MenuName='mnuReportGroupMaster'") == "N")) { Session.Clear(); Response.Redirect("Logon.aspx"); return; } if (objCCWeb.pCheckText(frmReportGroupMaster) == true) { Response.Write("<script>window.close();window.open('Logon.aspx','_Parent');</script>"); return; } if ((Session["Type"] == null) || (Session["Type"].ToString() == "1")) { strType = "ltr"; } else { strType = "rtl"; pnlClassSection.HorizontalAlign = HorizontalAlign.Right; } if (!IsPostBack) { hidCache.Value = ""; pGetOption(); gvReportGroup.Attributes.Add("bordercolor", "#FFC1A4"); txtReportGroupName1.Attributes.Add("onkeypress", "javascript:return Restrict_Name(event)"); txtReportGroupName2.Attributes.Add("onkeypress", "javascript:return Restrict_NameArabic(event)"); txtpriority.Attributes.Add("onkeypress", "javascript:return Restrict_Priority(event)"); txtReportGroupName2.Style.Add("text-align", "right"); txtReportGroupName1.Attributes.Add("AutoComplete", "off"); txtReportGroupName2.Attributes.Add("AutoComplete", "off"); gvReportGroup.Attributes.Add("onkeypress", "javascript:return searchName(event,'gvReportGroup',2)"); objCCWeb.FillDDLs(ddlModuleID, "SELECT 0 AS ModuleID,'' AS ModuleName" + Session["Type"] + " UNION Select Distinct MTRM.ModuleID,MTUMM.ModuleNAME From MTReportMaster MTRM Inner JOIN MTUserModuleMaster MTUMM ON MTRM.ModuleID=MTUMM.ModuleID WHERE MTRM.ModuleID>'0' ORDER BY ModuleID ", "ModuleID", "ModuleName" + Session["Type"].ToString() + "", ""); //objCCWeb.FillCheckedBoxList(chkReportName, "SELECT ReportID,ReportName" + Session["Type"] + " FROM MTReportMaster WHERE ReportID>0 ORDER BY ReportID, ReportName" + Session["Type"] + " ", "ReportID", "ReportName" + Session["Type"].ToString() + "", ""); btnCancel_Click(sender, e); //pDisplayType(); gvReportGroup.EmptyDataText = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "1023", ""); btnSelectAll.Attributes.Add("onclick", "javascript:return fClassSubject(1);"); btnDeSelect.Attributes.Add("onclick", "javascript:return fClassSubject(0);"); chkReportName.Attributes.Add("oncontextmenu", "javascript:return fSelectDeSelect(event)"); if (ddlModuleID.Items.Count > 0) { ddlModuleID.Items[0].Text = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "6", lblReportModuleID.Text); } ClientScript.RegisterStartupScript(this.GetType(), "DisplayScript", "<script language='javascript'>" + strHideID + "</script>"); chkReportName.Items.Add(new ListItem("", "")); } }
protected void Page_Load(object sender, EventArgs e) { string[] strImageFile = Directory.GetFiles(Server.MapPath("animate\\SlidePhoto"), "*.*"); string[] strFile; string strFileName; for (int fileCount = 0; fileCount < strImageFile.Length; fileCount++) { strFile = strImageFile[fileCount].ToString().Split('\\'); strFileName = strFile[strFile.Length - 1]; if ((strFileName.Split('.')[1].ToUpper() == "JPG") || (strFileName.Split('.')[1].ToUpper() == "GIF") || (strFileName.Split('.')[1].ToUpper() == "JPEG") || (strFileName.Split('.')[1].ToUpper() == "PNG")) { strImates.Append(" <div data-iview:image=\"animate/SlidePhoto/" + strFileName + "\"> </div>"); } } if (!IsPostBack) { if (Session["ParentID"] != null) { string[] strLogDetail = objCCWeb.ReturnSingleValue("DECLARE @VAR nvarchar(2000) " + " SET @VAR=ISNULL((SELECT TOP 1'Last Login :-'+ Convert(varchar,LoginTime,106)+' '+ ISNULL(CONVERT(VARCHAR, LoginTime,108),'') " + " FROM MDUserLoginDetails where UID=" + Session["UID"].ToString() + " AND SessionDetails<>'" + Session.SessionID.ToString() + "' AND LoginSuccessStatus='Y' ORDER BY LoginID DESC),ISNULL(Convert(varchar,GETDATE(),106),'')+' '+ ISNULL(CONVERT(VARCHAR, GETDATE(),108),'')) " + " SET @VAR=@VAR+'^'+ISNULL((SELECT 'Total Login:- '+CAST(COUNT(*)AS Varchar) FROM MDUserLoginDetails where UID=" + Session["UID"].ToString() + " AND LoginSuccessStatus='Y'),0) " + " SET @VAR=@VAR+'^'+ISNULL((SELECT TOP 1 'First Login :-'+ Convert(varchar,LoginTime,106)+' '+ ISNULL(CONVERT(VARCHAR, LoginTime,108),'') " + " FROM MDUserLoginDetails where UID=" + Session["UID"].ToString() + " AND LoginSuccessStatus='Y' ORDER BY LoginID ASC),ISNULL(Convert(varchar,GETDATE(),106),'')+' '+ ISNULL(CONVERT(VARCHAR, GETDATE(),108),'')) " + " SELECT @VAR").Split('^'); lblShowLoginDetail.Text = strLogDetail[2] + " " + strLogDetail[0] + " " + strLogDetail[1];; } if (Session["UID"] != null) { string[] strLogDetail = objCCWeb.ReturnSingleValue("DECLARE @VAR nvarchar(2000) " + " SET @VAR=ISNULL((SELECT TOP 1'Last Login :-'+ Convert(varchar,LoginTime,106)+' '+ ISNULL(CONVERT(VARCHAR, LoginTime,108),'') " + " FROM MDUserLoginDetails where UID=" + Session["UID"].ToString() + " AND SessionDetails<>'" + Session.SessionID.ToString() + "' AND LoginSuccessStatus='Y' ORDER BY LoginID DESC),ISNULL(Convert(varchar,GETDATE(),106),'')+' '+ ISNULL(CONVERT(VARCHAR, GETDATE(),108),'')) " + " SET @VAR=@VAR+'^'+ISNULL((SELECT 'Total Login:- '+CAST(COUNT(*)AS Varchar) FROM MDUserLoginDetails where UID=" + Session["UID"].ToString() + " AND LoginSuccessStatus='Y'),0) " + " SET @VAR=@VAR+'^'+ISNULL((SELECT TOP 1 'First Login :-'+ Convert(varchar,LoginTime,106)+' '+ ISNULL(CONVERT(VARCHAR, LoginTime,108),'') " + " FROM MDUserLoginDetails where UID=" + Session["UID"].ToString() + " AND LoginSuccessStatus='Y' ORDER BY LoginID ASC),ISNULL(Convert(varchar,GETDATE(),106),'')+' '+ ISNULL(CONVERT(VARCHAR, GETDATE(),108),'')) " + " SELECT @VAR").Split('^'); lblShowLoginDetail.Text = strLogDetail[2] + " " + strLogDetail[0] + " " + strLogDetail[1];; } //lblSchoolName.Text = objCCWeb.ReturnSingleValue("SELECt SchoolName1 from MTClientCompany where SchoolID=" + Session["SchoolID"] + " "); } /*------------------------- From DATABASE------------------------------ * * * string[] strFile; * string strFileName; * SqlDataReader rdr = objCCWeb.BindReader("SELECT SchoolHeaderID,SchoolHeaderText,SchoolImageFile From SchoolHeader"); * while(rdr.Read()) * { * if (File.Exists(Server.MapPath("animate\\SlidePhoto\\"+ rdr.GetValue(2).ToString()+"")) == true) * { * strFile = Server.MapPath("animate\\SlidePhoto\\" + rdr.GetValue(2).ToString() + "").ToString().Split('\\'); * strFileName = rdr.GetValue(2).ToString(); * * if ((strFileName.Split('.')[1].ToUpper() == "JPG") || (strFileName.Split('.')[1].ToUpper() == "GIF") || (strFileName.Split('.')[1].ToUpper() == "JPEG") || (strFileName.Split('.')[1].ToUpper() == "PNG")) * { * if (rdr.GetValue(1).ToString() != "") * { * strImates.Append(" <div data-iview:image=\"animate/SlidePhoto/" + strFileName + "\"><div class=\"iview-caption caption3\" data-x=\"10\" data-y=\"60\" data-transition=\"expandLeft\">" + rdr.GetValue(1).ToString() + "</div> </div>"); * } * else * { * strImates.Append(" <div data-iview:image=\"animate/SlidePhoto/" + strFileName + "\"></div>"); * } * * } * } * } * */ }
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) { Response.Write("<script>window.close();window.open('Logon.aspx','_parent');</script>"); return; } if (Request.QueryString["Status"] != null) { ClientScript.RegisterStartupScript(this.GetType(), "disScript", "<script>ChangeSchool('" + Session["SchoolName"].ToString() + "');</script>"); } if (Request.QueryString["LinkPage"] != null) { ClientScript.RegisterStartupScript(this.GetType(), "disScript", "<script>ChangeSchool(\"" + Session["SchoolName"].ToString().Replace("'", "\'") + "\");</script>"); strLink = Request.QueryString["LinkPage"].ToString(); strCompany = Session["CompanyName"].ToString(); } if (!IsPostBack) { if (Session["CompanyName"] != null) { strCompany = Session["CompanyName"].ToString(); } imgPhoto.Attributes.Add("onError", "javascript:return AssignError();"); imgPhoto.ImageUrl = "EmployeePhotos/NoImage.JPG"; if (Session["SchoolID"] == null) { if (objCCWeb.ReturnNumericValue("SELECT Count(SchoolID) FROM MTUserInstitutionMaster WHERE UID=" + Session["UID"] + "") > 1) { Session["SchoolID"] = "0"; Response.Redirect("MTChangeSchool.aspx"); } else { //Login1.DestinationPageUrl = "~/Default.aspx"; Session["SchoolID"] = objCCWeb.ReturnNumericValue("SELECT ISNULL(MAX(SchoolID),1) FROM MTUserInstitutionMaster WHERE UID=" + Session["UID"] + ""); } } string strDate = DateTime.Now.Date.ToString("yyyy/MM/dd"); string strdateLastWeek = Convert.ToString(objCCWeb.ReturnSingleValue("Select convert(varchar,DateAdd(dd,-7,getdate()),111)")); // DLHeader.DataSource = objCCWeb.BindDataSet("SELECT Header,Detail,Remark FROM MTUserAppointmentMaster WHERE ApDate='" + strDate + "' AND EntryUserID=" + Session["UID"] + ""); DLHeader.DataSource = objCCWeb.BindDataSet("SELECT Header,Detail,Remark FROM MTUserAppointmentMaster WHERE Display=1 AND EntryUserID=" + Session["UID"] + ""); DLHeader.DataBind(); //DLDetails.DataSource = objCCWeb.BindDataSet("SELECT Detail FROM MTUserAppointmentMaster WHERE ApID>1"); //DLDetails.DataBind(); DLCaption.DataSource = objCCWeb.BindDataSet("SELECT MenuCaption1 FROM MTuserMEnuMaster UM INNER JOIN MTUserPriorityMaster UP ON UM.ModuleID=UP.ModuleID " + " AND UM.RollNumber=UP.RollNumber AND UID=" + Session["UID"] + ""); DLCaption.DataBind(); ////////int NATodayFollowupCount = objCCWeb.ReturnNumericValue("SELECT COUNT(*) FROM SRStudentEnquiry WHERE FollowupUID=0 AND DateofEnquiry='" + strDate + "' AND ACASTART=" + Session["AcaStart"].ToString()); ////////lblTodayEnquiry.Text = NATodayFollowupCount + " Today Enquiry"; ////////int NALastWeekFollowupCount = objCCWeb.ReturnNumericValue("SELECT COUNT(*) FROM SRStudentEnquiry WHERE FollowupUID=0 AND DateofEnquiry>='" + strdateLastWeek + "' AND DateofEnquiry<='"+strDate+"' AND ACASTART=" + Session["AcaStart"].ToString()); ////////lblLastWeekEnquiry.Text = NALastWeekFollowupCount + " Last Week Enquiry"; ////////int NATodayRegFollowupCount = objCCWeb.ReturnNumericValue("SELECT COUNT(*) FROM SRStudentmaster WHERE FollowupUID=0 AND Convert(Varchar,DateOfSubmission,111)='" + strDate + "' AND ACASTART=" + Session["AcaStart"].ToString()); ////////lblTodayRegistration.Text = NATodayRegFollowupCount + " Today Registration"; ////////int NALastWeekRegFollowupCount = objCCWeb.ReturnNumericValue("SELECT COUNT(*) FROM SRStudentmaster WHERE FollowupUID=0 AND Convert(Varchar,DateOfSubmission,111)>='" + strdateLastWeek + "' AND Convert(Varchar,DateOfSubmission,111)<='" + strDate + "' AND ACASTART=" + Session["AcaStart"].ToString()); ////////lblLastWeekRegistration.Text = NALastWeekRegFollowupCount + " Last Week Registration"; int intEmpEnrolleeID = objCCWeb.ReturnNumericValue("SELECT EmployeeIDStudentID FROM MTuserMaster WHERE UID=" + Session["UID"] + ""); int intUserType = objCCWeb.ReturnNumericValue("SELECT UserTypeID FROM MTUserMaster WHERE UID=" + Session["UID"] + ""); int inEmployeeID = objCCWeb.ReturnNumericValue("SELECT EmployeeIDStudentID FROM MTuserMaster WHERE UID=" + Session["UID"] + " AND UserTypeID=1"); int intStudentID = objCCWeb.ReturnNumericValue("SELECT EmployeeIDStudentID FROM MTuserMaster WHERE UID=" + Session["UID"] + " AND UserTypeID=2"); if (intUserType == 1) { strEmployeeCode = objCCWeb.ReturnSingleValue("SELECT Employeecode From PRLEmployeeMaster where PRLEmployeeID in(SELECT EmployeeIDStudentID FROM MTuserMaster WHERE UID=" + Session["UID"] + " AND UserTypeID=1)"); } string strusertype = objCCWeb.ReturnSingleValue("Select Usertype from MDMessageDetails Where Usertype='A'"); if (intEmpEnrolleeID == 0) { //DLMessageList.DataSource = objCCWeb.BindDataSet("SELECT ISNULL(MessageTitle,'') AS MessageTitle,Message,ISNULL(NewsFileName,'') as NewsFileName,MessageDate AS Message from MTMessageMaster WHERE MessageStatus='Y' AND '" + strDate + "' between MessageDate And MessageTillDate AND SchoolID=" + Session["SchoolID"].ToString() + " ORDER BY MessageDate desc"); //DLMessageList.DataBind(); //int unreadMessagesCount = objCCWeb.ReturnNumericValue("SELECT COUNT(*) FROM MESSAGESENDDETAILS WHERE TOUID=" + Session["UID"].ToString() + " AND READUNREAD='UR' AND ACASTART=" + Session["AcaStart"].ToString()); //lblInboxStatus.Text = unreadMessagesCount + " Unread Messages"; } else if (intEmpEnrolleeID > 0 && intUserType == 1 && strusertype == "A") { //DLMessageList.DataSource = objCCWeb.BindDataSet("SELECT distinct ISNULL(MessageTitle,'') AS MessageTitle," + //" Message AS Message,ISNULL(NewsFileName,'') as NewsFileName,MessageDate from MTMessageMaster MM INNER JOIN MDMessageDetails MD ON MD.MessageID=MM.MessageID " + //" WHERE (EmployeeID=" + intEmpEnrolleeID + " AND UserType='E') OR UserType='A' AND MessageStatus='Y' AND '" + strDate + "' between MessageDate And MessageTillDate AND SchoolID=" + Session["SchoolID"].ToString() + " ORDER BY MessageDate desc"); //DLMessageList.DataBind(); imgPhoto.ImageUrl = "EmployeePhotos/E" + intEmpEnrolleeID + ".jpg?" + DateTime.Now.ToFileTimeUtc(); //int unreadMessagesCount = objCCWeb.ReturnNumericValue("SELECT COUNT(*) FROM MESSAGESENDDETAILS WHERE TOUID=" + Session["UID"].ToString() + " AND READUNREAD='UR' AND ACASTART=" + Session["AcaStart"].ToString()); //lblInboxStatus.Text = unreadMessagesCount + " Unread Messages"; //int unreadMessagesCount = objCCWeb.ReturnNumericValue("SELECT COUNT(*) FROM MESSAGESENDDETAILS WHERE TOUID="+ Session["UID"].ToString() +" AND READUNREAD='UR'"); } else if (intEmpEnrolleeID > 0 && intUserType == 1 && strusertype == "") { //DLMessageList.DataSource = objCCWeb.BindDataSet("SELECT distinct ISNULL(MessageTitle,'') AS MessageTitle," + //" Message AS Message,ISNULL(NewsFileName,'') as NewsFileName,MessageDate from MTMessageMaster MM INNER JOIN MDMessageDetails MD ON MD.MessageID=MM.MessageID " + //" WHERE EmployeeID=" + intEmpEnrolleeID + " AND UserType='E' OR UserType='A' AND MessageStatus='Y' AND '" + strDate + "' between MessageDate And MessageTillDate AND SchoolID=" + Session["SchoolID"].ToString() + " ORDER BY MessageDate desc"); //DLMessageList.DataBind(); imgPhoto.ImageUrl = "EmployeePhotos/E" + intEmpEnrolleeID + ".jpg?" + DateTime.Now.ToFileTimeUtc(); //int unreadMessagesCount = objCCWeb.ReturnNumericValue("SELECT COUNT(*) FROM MESSAGESENDDETAILS WHERE TOUID=" + Session["UID"].ToString() + " AND READUNREAD='UR' AND ACASTART=" + Session["AcaStart"].ToString()); //lblInboxStatus.Text = unreadMessagesCount + " Unread Messages"; //int unreadMessagesCount = objCCWeb.ReturnNumericValue("SELECT COUNT(*) FROM MESSAGESENDDETAILS WHERE TOUID="+ Session["UID"].ToString() +" AND READUNREAD='UR'"); } else if (intEmpEnrolleeID > 0 && intUserType == 2 && strusertype == "A") { //DLMessageList.DataSource = objCCWeb.BindDataSet("SELECT distinct ISNULL(MessageTitle,'') AS MessageTitle," + //" Message AS Message,ISNULL(NewsFileName,'') as NewsFileName,MessageDate from MTMessageMaster MM INNER JOIN MDMessageDetails MD ON MD.MessageID=MM.MessageID" + //" WHERE StudentID=" + intEmpEnrolleeID + " AND UserType='S' OR UserType='A' AND MessageStatus='Y' AND '" + strDate + "' between MessageDate And MessageTillDate AND SchoolID=" + Session["SchoolID"].ToString() + " ORDER BY MessageDate desc"); //DLMessageList.DataBind(); imgPhoto.ImageUrl = "StudentPhoto/S" + intEmpEnrolleeID + ".jpg?" + DateTime.Now.ToFileTimeUtc(); } else if (intEmpEnrolleeID > 0 && intUserType == 2 && strusertype == "") { //DLMessageList.DataSource = objCCWeb.BindDataSet("SELECT distinct ISNULL(MessageTitle,'') AS MessageTitle," + //" Message AS Message,ISNULL(NewsFileName,'') as NewsFileName,MessageDate from MTMessageMaster MM INNER JOIN MDMessageDetails MD ON MD.MessageID=MM.MessageID" + //" WHERE StudentID=" + intEmpEnrolleeID + " AND UserType='S' OR UserType='A' AND MessageStatus='Y' AND '" + strDate + "' between MessageDate And MessageTillDate AND SchoolID=" + Session["SchoolID"].ToString() + " ORDER BY MessageDate desc"); //DLMessageList.DataBind(); imgPhoto.ImageUrl = "StudentPhoto/S" + intEmpEnrolleeID + ".jpg?" + DateTime.Now.ToFileTimeUtc(); } int unreadMessagesCount = 0;//objCCWeb.ReturnNumericValue("exec [spMsgGrid] " + Session["UID"].ToString() + ", " + Session["AcaStart"] + ", " + Session["SchoolID"].ToString() + ", 'EMPLOYEECOUNT',0 "); lblInboxStatus.Text = unreadMessagesCount + " Unread Messages"; //MainImage.Attributes.Add("GALLERYIMG", "no"); } }
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(); }