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 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) { 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(); } }
public int GetSectionID(dalCommon objCommonPara) { CCWeb objCCWeb = new CCWeb(); int SectionID = 0; string SQLQuery = "Select SectionID From SistudentyearwiseDetails where StudentID=" + objCommonPara.StudEmp + " and AcaStart=" + objCommonPara.AcaStart + ""; try { SectionID = objCCWeb.ReturnNumericValue(SQLQuery); return(SectionID); } catch (Exception) { throw; } finally { objCCWeb = null; } }
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 int sendSMS(string phoneno, string smsmessage, string strUID) { int messageSendSuccessfully = 0; try { if (phoneno.Trim() == "" || smsmessage.Trim() == "") { return(messageSendSuccessfully); } List <string> lstArray = new List <string>(); int intCreditAvailable = 0; string[] strCheckNumber; string strPhoneNumber = phoneno.Trim(); CreditAvailable(); SqlDataReader sqlRdr = objCCWeb.BindReader("SELECT SMSURL,UserName,Password,NumberPerSMS,CreditAvailable,TotalSMSSend,SenderNo FROM EMSMSSettingsMaster Where TransactionType='T'"); if (sqlRdr.Read()) { smsmessage = "Dear Parents, " + smsmessage.Trim() + " Regards " + sqlRdr.GetValue(6).ToString(); intCreditAvailable = 0; strCheckNumber = strPhoneNumber.Split(','); for (int i = 0; i < strCheckNumber.Length; i++) { if (strCheckNumber[i].Trim() != "" && strCheckNumber[i].Trim().Length == 12) { strPhoneNumber = strCheckNumber[i]; if (intCreditAvailable >= objCCWeb.ReturnNumericValue("SELECT CreditAvailable FROM EMSMSSettingsMaster Where TransactionType='T'")) { return(messageSendSuccessfully); } else { string DecodedMessage = smsmessage.Trim(); string req = "URL API"; req = sqlRdr.GetValue(0).ToString() + "?UserName="******"&Password="******"&Type=Individual&To=" + strPhoneNumber.Trim() + "&Mask=" + sqlRdr.GetValue(6).ToString() + "&Message=" + DecodedMessage + ""; try { HttpWebRequest myReq = (HttpWebRequest)WebRequest.Create(req); HttpWebResponse myResp = (HttpWebResponse)myReq.GetResponse(); System.IO.StreamReader respStreamReader = new System.IO.StreamReader(myResp.GetResponseStream()); string responseString = respStreamReader.ReadToEnd(); myResp.Close(); } catch { } objCCWeb.ExecuteQuery("INSERT INTO EMSMSSendDetails (SMSSendID,SMSTo,PRLEmployeeID,StudentID,Content,SMSTemplateID,SMSDate,EntryUserID,EntryDate)" + " SELECT ISNULL(MAX(SMSSendID),0)+1,'" + strPhoneNumber + "',0,0," + " '" + DecodedMessage.Replace("'", "''") + "',0,GETDATE()," + " " + strUID + ",GETDATE() FROM EMSMSSendDetails"); int msgCount = ((DecodedMessage.Length - 1) / 160) + 1; objCCWeb.ExecuteQuery("UPDATE EMSMSSettingsMaster SET TotalSMSSend=TotalSMSSend+" + msgCount + ",CreditAvailable=CreditAvailable-" + msgCount + " Where TransactionType='T'"); strPhoneNumber = ""; messageSendSuccessfully++; } } } } else { ClientScript.RegisterStartupScript(this.GetType(), "AlertMsg", "<script>alert('Please Enter Values In SMS Settings.'</script>"); return(messageSendSuccessfully); } } catch (Exception ex) { } return(messageSendSuccessfully); }
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) { 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(); }