static void Main(string[] args) { DayCareBAL.StaffService proxyStaffService = new DayCareBAL.StaffService(); Guid SchoolId = new Guid("8CA767A0-5E36-4343-8B1D-5ECC40EB9E1B"); DayCarePL.StaffProperties objStaffDetails = proxyStaffService.LoadStaffDetailsByUserNameAndPassword("schooladmin", "schooladmin", SchoolId); GetChildProgEnrollmentFeeDetail(objStaffDetails.ScoolYearId); }
public void btnSave_Click(object sender, EventArgs e) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.Staff, "btnSave_Click", "Submit btnSave_Click called", DayCarePL.Common.GUID_DEFAULT); try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.Staff, "btnSave_Click", "Debug btnSave_Click ", DayCarePL.Common.GUID_DEFAULT); DayCareBAL.MyAccountService proxyMyAccount = new DayCareBAL.MyAccountService(); DayCareBAL.StaffService proxystaff = new DayCareBAL.StaffService(); DayCarePL.StaffProperties objStaff = new DayCarePL.StaffProperties(); objStaff.FirstName = txtFirstName.Text.Trim(); objStaff.LastName = txtLastName.Text.Trim(); objStaff.UserName = txtUserName.Text.Trim(); objStaff.Password = txtPassword.Text.Trim(); if (Session["StaffId"] != null) { objStaff.Id = new Guid(Session["StaffId"].ToString()); } //Check Duplicate Code if (hdnPassword.Value == txtOldPassword.Text.Trim()) { // bool check = proxystaff.CheckDuplicateCode("", objStaff.Id, new Guid(Session["SchoolId"].ToString())); bool check = false; if (check == false) { proxyMyAccount.Save(objStaff); txtFirstName.Text = ""; txtLastName.Text = ""; txtPassword.Text = ""; txtNewPassword.Text = ""; MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", " Saved Successfully", "false")); } else { MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", " Code Already Exist", "false")); } } else { MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Old Password Not Match", "false")); } } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.Staff, "btnSave_Click", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); } }
//if want to get primary staff than pass true and not primary than pass false.but if want all than pass "null" public static void BindStaff(DropDownList ddlStaff, Guid SchoolId, Guid SchoolYearId) { try { DayCareBAL.StaffService proxyStaff = new DayCareBAL.StaffService(); List <DayCarePL.StaffProperties> lstStaff = proxyStaff.LoadStaff(SchoolId, SchoolYearId); if (lstStaff != null && lstStaff.Count > 0) { lstStaff = lstStaff.FindAll(s => s.Active.Equals(true) && !s.StaffCategoryName.Equals(DayCarePL.Common.SCHOOL_ADMINISTRATOR) && !s.UserGroupTitle.Equals(DayCarePL.Common.SCHOOL_ADMINISTRATOR)); ddlStaff.DataSource = lstStaff; ddlStaff.DataTextField = "FullName"; ddlStaff.DataValueField = "Id"; ddlStaff.DataBind(); } ddlStaff.Items.Insert(0, new ListItem("--Select--", DayCarePL.Common.GUID_DEFAULT)); } catch { } }
protected void btnLogin_Click(object sender, EventArgs e) { DayCareBAL.StaffService proxyStaffService = new DayCareBAL.StaffService(); //Guid SchoolId = new Guid("8CA767A0-5E36-4343-8B1D-5ECC40EB9E1B"); //Guid SchoolId = new Guid("66E740A1-1202-45C9-9D4F-0493C8746EDD"); Guid SchoolId = new Guid(ddlSchool.SelectedValue); DayCarePL.StaffProperties objStaffDetails = proxyStaffService.LoadStaffDetailsByUserNameAndPassword(txtLoginName.Text.Trim(), txtLoginPassword.Text.Trim(), SchoolId); if (objStaffDetails != null) { Session["StaffId"] = objStaffDetails.Id; Session["StaffFullName"] = objStaffDetails.FullName; Session["SchoolId"] = objStaffDetails.SchoolId; Session["SchoolName"] = objStaffDetails.SchoolName; Session["UserGroupTitle"] = objStaffDetails.UserGroupTitle; Session["CurrentSchoolYearId"] = objStaffDetails.ScoolYearId; Session["Role_Id"] = objStaffDetails.RolId; if (RememberMe.Checked) { HttpCookie objCookiesUn = new HttpCookie("uid@DayCare", txtLoginName.Text.ToLower().Trim()); objCookiesUn.Expires = DateTime.Now.AddYears(100); Response.Cookies.Add(objCookiesUn); } else { if (Request.Cookies["uid@DayCare"] != null) { Response.Cookies["uid@DayCare"].Expires = DateTime.Now.AddYears(-100); } } Response.Redirect("UI/DashBoard.aspx"); } else { FailureText.Text = "UserName/Password is wrong please try again"; } }
public void GetStaff(bool Active) { DayCareBAL.StaffService proxyRole = new DayCareBAL.StaffService(); Guid SchoolId = new Guid(); if (Session["SchoolId"] != null) { SchoolId = new Guid(Session["SchoolId"].ToString()); } Guid CurrentSchoolYearId = new Guid(); if (Session["CurrentSchoolYearId"] != null) { CurrentSchoolYearId = new Guid(Session["CurrentSchoolYearId"].ToString()); } List <DayCarePL.StaffProperties> lstStaff = proxyRole.LoadStaff(SchoolId, CurrentSchoolYearId); if (lstStaff != null) { //rgStaffList.DataSource = lstStaff.FindAll(name => !name.StaffCategoryName.Equals(DayCarePL.Common.SCHOOL_ADMINISTRATOR) && !name.UserGroupTitle.Equals(DayCarePL.Common.SCHOOL_ADMINISTRATOR) && name.Active == Active); rgStaffList.DataSource = lstStaff.FindAll(name => !name.StaffCategoryName.Equals(DayCarePL.Common.SCHOOL_ADMINISTRATOR) && !name.UserGroupTitle.Equals(DayCarePL.Common.SCHOOL_ADMINISTRATOR)); } }
private void BindGrid() { try { if (Session["CurrentSchoolYearId"] == null) { Response.Redirect("~/Login.aspx"); } DayCareBAL.StaffService proxyAttendance = new DayCareBAL.StaffService(); string ReportFor = ""; if (ddlReportFor.SelectedItem.Text.Equals("Staff")) { ReportFor = "Staff"; string SearchText = ""; //SearchText = "ssy.schoolyearid='" + Session["CurrentSchoolYearId"].ToString() +"'"; if (rdpStartDate.SelectedDate != null) { SearchText += " sah.checkincheckoutdatetime>='" + rdpStartDate.SelectedDate.Value + "'"; } else if (rdpEndDate.SelectedDate != null && rdpStartDate.SelectedDate != null) { SearchText += " AND sah.checkincheckoutdatetime<='" + rdpEndDate.SelectedDate.Value + "'"; } else if (rdpEndDate.SelectedDate != null && rdpStartDate.SelectedDate == null) { SearchText += " sah.checkincheckoutdatetime<='" + rdpEndDate.SelectedDate.Value + "'"; } rgAttendanceReport.DataSource = proxyAttendance.LoadAttendanceHistory(ReportFor, SearchText).Where(u => u.SchoolYearId.Equals(new Guid(Session["CurrentSchoolYearId"].ToString()))); } else if (ddlReportFor.SelectedItem.Text.Equals("Student")) { ReportFor = "Student"; string SearchText = ""; //SearchText = "csy.schoolyearid='" + Session["CurrentSchoolYearId"].ToString() + "'"; if (rdpStartDate.SelectedDate != null) { SearchText += " cah.checkincheckoutdatetime>='" + rdpStartDate.SelectedDate.Value + "'"; } else if (rdpEndDate.SelectedDate != null && rdpStartDate.SelectedDate == null) { SearchText += " cah.checkincheckoutdatetime<='" + rdpEndDate.SelectedDate.Value + "'"; } else if (rdpEndDate.SelectedDate != null && rdpStartDate.SelectedDate != null) { SearchText += " And cah.checkincheckoutdatetime<='" + rdpEndDate.SelectedDate.Value + "'"; } rgAttendanceReport.DataSource = proxyAttendance.LoadAttendanceHistory(ReportFor, SearchText).Where(u => u.SchoolYearId.Equals(new Guid(Session["CurrentSchoolYearId"].ToString()))); } else { rgAttendanceReport.DataSource = null; } } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.AttendenceReport, "BindGrid", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); } }
protected void Page_Init(object sender, EventArgs e) { #region if (Session["CurrentSchoolYearId"] == null) { Response.Redirect("~/Login.aspx"); } crdata.Report = rpt; rpt1 = crdata.ReportDocument; DataSet dsReport = new xmlClassWiseStudentAttendTime(); DataSet ds = new DataSet(); if (Request.QueryString["RepId"] == "Staff") { if (!String.IsNullOrEmpty(Session["StaffResult"].ToString())) { rpt.FileName = Server.MapPath("rptStaffAttendanceReport.rpt"); DayCareBAL.StaffService proxyAttendance = new DayCareBAL.StaffService(); string ReportFor = ""; ReportFor = "Staff"; string SearchText = ""; string SearchStr = ""; string SchoolYear = ""; if (!String.IsNullOrEmpty(Request.QueryString["StartDate"]) && String.IsNullOrEmpty(Request.QueryString["EndDate"])) { SearchText += " sah.checkincheckoutdatetime>='" + Request.QueryString["StartDate"].ToString() + "'"; // SchoolYear += "and ssy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; if (Session["StaffResult"] != null) { SearchStr += "Name in(" + Session["StaffResult"].ToString() + ")"; } } else if (String.IsNullOrEmpty(Request.QueryString["StartDate"]) && !String.IsNullOrEmpty(Request.QueryString["EndDate"])) { SearchText += " sah.checkincheckoutdatetime<='" + Request.QueryString["EndDate"].ToString().Replace("00:00:00 PM", "11:59:58") + "'"; // SchoolYear += "and ssy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; if (Session["StaffResult"] != null) { SearchStr += "Name in(" + Session["StaffResult"].ToString() + ")"; } } else if (!String.IsNullOrEmpty(Request.QueryString["EndDate"]) && !String.IsNullOrEmpty(Request.QueryString["StartDate"])) { SearchText += " sah.checkincheckoutdatetime>='" + Request.QueryString["StartDate"].ToString() + "' and sah.checkincheckoutdatetime<='" + Request.QueryString["EndDate"].ToString().Replace("00:00:00", "11:59:58") + "'"; //SchoolYear += "and ssy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; if (!String.IsNullOrEmpty(Session["StaffResult"].ToString())) { SearchStr += "Name in(" + Session["StaffResult"].ToString() + ")"; } } if (String.IsNullOrEmpty(Request.QueryString["EndDate"]) && String.IsNullOrEmpty(Request.QueryString["StartDate"]) && !String.IsNullOrEmpty(Session["StaffResult"].ToString())) { SearchStr += "Name in(" + Session["StaffResult"].ToString() + ")"; } SearchStr = Session["StaffResult"].ToString().Replace("'--Select All--',", ""); string[] str = SearchStr.Remove(SearchStr.Length - 1).Remove(0, 1).Replace("','", "$").Split('$'); string strFinalSearhString = ""; foreach (string s in str) { string s1 = ""; s1 = s.Replace("'", "''"); s1 = "'" + s1 + "',"; strFinalSearhString += s1; } strFinalSearhString = "Name in(" + strFinalSearhString.Remove(strFinalSearhString.Length - 1) + ")"; ds = proxyAttendance.LoadAttendanceHistory1(SearchText, strFinalSearhString, new Guid(Session["CurrentSchoolYearId"].ToString())); dsReport.Tables["dtAttendance"].Merge(ds.Tables[0]); } else { rpt.FileName = Server.MapPath("rptStaffAttendanceReport.rpt"); DayCareBAL.StaffService proxyAttendance = new DayCareBAL.StaffService(); string ReportFor = ""; ReportFor = "Staff"; string SearchText = ""; string SearchStr = ""; string SchoolYear = ""; if (!String.IsNullOrEmpty(Request.QueryString["StartDate"]) && String.IsNullOrEmpty(Request.QueryString["EndDate"])) { SearchText += " sah.checkincheckoutdatetime>='" + Request.QueryString["StartDate"].ToString() + "'"; // SchoolYear += "and ssy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; } else if (String.IsNullOrEmpty(Request.QueryString["StartDate"]) && !String.IsNullOrEmpty(Request.QueryString["EndDate"])) { SearchText += " sah.checkincheckoutdatetime<='" + Request.QueryString["EndDate"].ToString().Replace("00:00:00 PM", "11:59:58") + "'"; // SchoolYear += "and ssy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; } else if (!String.IsNullOrEmpty(Request.QueryString["EndDate"]) && !String.IsNullOrEmpty(Request.QueryString["StartDate"])) { SearchText += " sah.checkincheckoutdatetime>='" + Request.QueryString["StartDate"].ToString() + "' and sah.checkincheckoutdatetime<='" + Request.QueryString["EndDate"].ToString().Replace("00:00:00", "11:59:58") + "'"; //SchoolYear += "and ssy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; } ds = proxyAttendance.LoadAttendanceHistory1(SearchText, SearchStr, new Guid(Session["CurrentSchoolYearId"].ToString())); dsReport.Tables["dtAttendance"].Merge(ds.Tables[0]); } CrystalDecisions.CrystalReports.Engine.TextObject titleText = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text7"]; CrystalDecisions.CrystalReports.Engine.TextObject titleTextSchool = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text8"]; CrystalDecisions.CrystalReports.Engine.TextObject footer = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["txtfooter"]; footer.Text = Common.GetSchoolWiseAddress(new Guid(Session["SchoolId"].ToString())); if (!String.IsNullOrEmpty(Request.QueryString["StartDate"]) && !String.IsNullOrEmpty(Request.QueryString["EndDate"])) { titleText.Text = "Staff Attendance Report From " + Convert.ToDateTime(Request.QueryString["StartDate"].ToString()).ToString("MM/dd/yyyy") + " To " + Convert.ToDateTime(Request.QueryString["EndDate"].ToString()).ToString("MM/dd/yyyy"); } titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper(); if (String.IsNullOrEmpty(Request.QueryString["EndDate"]) && !String.IsNullOrEmpty(Request.QueryString["StartDate"])) { titleText.Text = "Staff Attendance Report From " + Convert.ToDateTime(Request.QueryString["StartDate"].ToString()).ToString("MM/dd/yyyy"); } titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper(); if (!String.IsNullOrEmpty(Request.QueryString["EndDate"]) && String.IsNullOrEmpty(Request.QueryString["StartDate"])) { titleText.Text = "Staff Attendance Report To " + Convert.ToDateTime(Request.QueryString["EndDate"].ToString()).ToString("MM/dd/yyyy"); } titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper(); rpt1.SetDataSource(dsReport.Tables["dtAttendance"]); } if (Request.QueryString["RepId"] == "Student") { if (!String.IsNullOrEmpty(Session["Result"].ToString())) { rpt.FileName = Server.MapPath("rptStudentAttendanceReport.rpt"); DayCareBAL.StaffService proxyAttendance = new DayCareBAL.StaffService(); string ReportFor = ""; ReportFor = "Student"; string SearchText = ""; string SearchStr = ""; string SchoolYear = ""; if (!String.IsNullOrEmpty(Request.QueryString["StartDate"]) && String.IsNullOrEmpty(Request.QueryString["EndDate"])) { SearchText += " cah.checkincheckoutdatetime>='" + Request.QueryString["StartDate"].ToString() + "'"; // SchoolYear += "and csy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; if (Session["Result"] != null) { SearchStr += "Name in(" + Session["Result"].ToString() + ")"; } } else if (String.IsNullOrEmpty(Request.QueryString["StartDate"]) && !String.IsNullOrEmpty(Request.QueryString["EndDate"])) { SearchText += " cah.checkincheckoutdatetime<='" + Request.QueryString["EndDate"].ToString().Replace("00:00:00 PM", "11:59:58") + "'"; // SchoolYear += "and csy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; if (Session["Result"] != null) { SearchStr += "Name in(" + Session["Result"].ToString() + ")"; } } else if (!String.IsNullOrEmpty(Request.QueryString["EndDate"]) && !String.IsNullOrEmpty(Request.QueryString["StartDate"])) { SearchText += " cah.checkincheckoutdatetime>='" + Request.QueryString["StartDate"].ToString() + "' and cah.checkincheckoutdatetime<='" + Request.QueryString["EndDate"].ToString().Replace("00:00:00", "11:59:58") + "'"; //SchoolYear += "and csy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; if (Session["Result"] != null) { SearchStr += "Name in(" + Session["Result"].ToString() + ")"; } } if (String.IsNullOrEmpty(Request.QueryString["EndDate"]) && String.IsNullOrEmpty(Request.QueryString["StartDate"]) && !String.IsNullOrEmpty(Session["Result"].ToString())) { SearchStr += "Name in(" + Session["Result"].ToString() + ")"; } SearchStr = Session["Result"].ToString().Replace("'--Select All--',", ""); string[] str = SearchStr.Remove(SearchStr.Length - 1).Remove(0, 1).Replace("','", "$").Split('$'); string strFinalSearhString = ""; foreach (string s in str) { string s1 = ""; s1 = s.Replace("'", "''"); s1 = "'" + s1 + "',"; strFinalSearhString += s1; } strFinalSearhString = "Name in(" + strFinalSearhString.Remove(strFinalSearhString.Length - 1) + ")"; ds = proxyAttendance.LoadChildAttendanceHistory(SearchText, strFinalSearhString, new Guid(Session["CurrentSchoolYearId"].ToString())); if (ds.Tables.Count > 0) { dsReport.Tables["dtAttendance"].Merge(ds.Tables[0]); } } else { rpt.FileName = Server.MapPath("rptStudentAttendanceReport.rpt"); DayCareBAL.StaffService proxyAttendance = new DayCareBAL.StaffService(); string ReportFor = ""; ReportFor = "Student"; string SearchText = ""; string SearchStr = ""; string SchoolYear = ""; if (!String.IsNullOrEmpty(Request.QueryString["StartDate"]) && String.IsNullOrEmpty(Request.QueryString["EndDate"])) { SearchText += " cah.checkincheckoutdatetime>='" + Request.QueryString["StartDate"].ToString() + "'"; // SchoolYear += "and csy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; } else if (String.IsNullOrEmpty(Request.QueryString["StartDate"]) && !String.IsNullOrEmpty(Request.QueryString["EndDate"])) { SearchText += " cah.checkincheckoutdatetime<='" + Request.QueryString["EndDate"].ToString().Replace("00:00:00 PM", "11:59:58") + "'"; // SchoolYear += "and csy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; } else if (!String.IsNullOrEmpty(Request.QueryString["EndDate"]) && !String.IsNullOrEmpty(Request.QueryString["StartDate"])) { SearchText += " cah.checkincheckoutdatetime>='" + Request.QueryString["StartDate"].ToString() + "' and cah.checkincheckoutdatetime<='" + Request.QueryString["EndDate"].ToString().Replace("00:00:00", "11:59:58") + "'"; //SchoolYear += "and csy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; } ds = proxyAttendance.LoadChildAttendanceHistory(SearchText, SearchStr, new Guid(Session["CurrentSchoolYearId"].ToString())); dsReport.Tables["dtAttendance"].Merge(ds.Tables[0]); } CrystalDecisions.CrystalReports.Engine.TextObject titleText = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text7"]; CrystalDecisions.CrystalReports.Engine.TextObject titleTextSchool = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text4"]; CrystalDecisions.CrystalReports.Engine.TextObject footer = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["txtfooter"]; footer.Text = Common.GetSchoolWiseAddress(new Guid(Session["SchoolId"].ToString())); if (!String.IsNullOrEmpty(Request.QueryString["StartDate"]) && !String.IsNullOrEmpty(Request.QueryString["EndDate"])) { titleText.Text = "Student Attendance Report From " + Convert.ToDateTime(Request.QueryString["StartDate"].ToString()).ToString("MM/dd/yyyy") + " To " + Convert.ToDateTime(Request.QueryString["EndDate"].ToString()).ToString("MM/dd/yyyy"); } titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper(); if (String.IsNullOrEmpty(Request.QueryString["EndDate"]) && !String.IsNullOrEmpty(Request.QueryString["StartDate"])) { titleText.Text = "Student Attendance Report From " + Convert.ToDateTime(Request.QueryString["StartDate"].ToString()).ToString("MM/dd/yyyy"); } titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper(); if (!String.IsNullOrEmpty(Request.QueryString["EndDate"]) && String.IsNullOrEmpty(Request.QueryString["StartDate"])) { titleText.Text = "Student Attendance Report To " + Convert.ToDateTime(Request.QueryString["EndDate"].ToString()).ToString("MM/dd/yyyy"); } titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper(); rpt1.SetDataSource(dsReport.Tables["dtAttendance"]); } if (Request.QueryString["RepId"] == "StudentDate") { rpt.FileName = Server.MapPath("rptStudentAttendanceByDate.rpt"); DayCareBAL.StaffService proxyAttendance = new DayCareBAL.StaffService(); string ReportFor = ""; ReportFor = "Student"; string SearchText = ""; string SearchStr = ""; string SchoolYear = ""; if (!String.IsNullOrEmpty(Request.QueryString["StartDate"]) && String.IsNullOrEmpty(Request.QueryString["EndDate"])) { SearchText += " cah.checkincheckoutdatetime>='" + Request.QueryString["StartDate"].ToString() + "'"; // SchoolYear += "and csy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; } else if (String.IsNullOrEmpty(Request.QueryString["StartDate"]) && !String.IsNullOrEmpty(Request.QueryString["EndDate"])) { SearchText += " cah.checkincheckoutdatetime<='" + Request.QueryString["EndDate"].ToString().Replace("00:00:00 PM", "11:59:58") + "'"; // SchoolYear += "and csy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; } else if (!String.IsNullOrEmpty(Request.QueryString["EndDate"]) && !String.IsNullOrEmpty(Request.QueryString["StartDate"])) { SearchText += " cah.checkincheckoutdatetime>='" + Request.QueryString["StartDate"].ToString() + "' and cah.checkincheckoutdatetime<='" + Request.QueryString["EndDate"].ToString().Replace("00:00:00", "11:59:58") + "'"; //SchoolYear += "and csy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; } ds = proxyAttendance.LoadChildAttendanceHistory(SearchText, SearchStr, new Guid(Session["CurrentSchoolYearId"].ToString())); dsReport.Tables["dtAttendance"].Merge(ds.Tables[0]); CrystalDecisions.CrystalReports.Engine.TextObject titleText = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text2"]; CrystalDecisions.CrystalReports.Engine.TextObject titleTextSchool = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text8"]; CrystalDecisions.CrystalReports.Engine.TextObject footer = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["txtfooter"]; footer.Text = Common.GetSchoolWiseAddress(new Guid(Session["SchoolId"].ToString())); if (!String.IsNullOrEmpty(Request.QueryString["StartDate"]) && !String.IsNullOrEmpty(Request.QueryString["EndDate"])) { titleText.Text = "Student Attendance Report From " + Convert.ToDateTime(Request.QueryString["StartDate"].ToString()).ToString("MM/dd/yyyy") + " To " + Convert.ToDateTime(Request.QueryString["EndDate"].ToString()).ToString("MM/dd/yyyy"); } titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper(); if (String.IsNullOrEmpty(Request.QueryString["EndDate"]) && !String.IsNullOrEmpty(Request.QueryString["StartDate"])) { titleText.Text = "Student Attendance Report From " + Convert.ToDateTime(Request.QueryString["StartDate"].ToString()).ToString("MM/dd/yyyy"); } titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper(); if (!String.IsNullOrEmpty(Request.QueryString["EndDate"]) && String.IsNullOrEmpty(Request.QueryString["StartDate"])) { titleText.Text = "Student Attendance Report To " + Convert.ToDateTime(Request.QueryString["EndDate"].ToString()).ToString("MM/dd/yyyy"); } titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper(); rpt1.SetDataSource(dsReport.Tables["dtAttendance"]); } if (Request.QueryString["RepId"] == "StudentClass") { rpt.FileName = Server.MapPath("rptStudentAttendanceByClassName.rpt"); DayCareBAL.StaffService proxyAttendance = new DayCareBAL.StaffService(); string ReportFor = ""; ReportFor = "Student"; string SearchText = ""; string SearchStr = ""; string SchoolYear = ""; if (!String.IsNullOrEmpty(Request.QueryString["StartDate"]) && String.IsNullOrEmpty(Request.QueryString["EndDate"])) { SearchText += " cah.checkincheckoutdatetime>='" + Request.QueryString["StartDate"].ToString() + "'"; // SchoolYear += "and csy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; } else if (String.IsNullOrEmpty(Request.QueryString["StartDate"]) && !String.IsNullOrEmpty(Request.QueryString["EndDate"])) { SearchText += " cah.checkincheckoutdatetime<='" + Request.QueryString["EndDate"].ToString().Replace("00:00:00 PM", "11:59:58") + "'"; // SchoolYear += "and csy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; } else if (!String.IsNullOrEmpty(Request.QueryString["EndDate"]) && !String.IsNullOrEmpty(Request.QueryString["StartDate"])) { SearchText += " cah.checkincheckoutdatetime>='" + Request.QueryString["StartDate"].ToString() + "' and cah.checkincheckoutdatetime<='" + Request.QueryString["EndDate"].ToString().Replace("00:00:00", "11:59:58") + "'"; //SchoolYear += "and csy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; } ds = proxyAttendance.LoadChildAttendanceHistory(SearchText, SearchStr, new Guid(Session["CurrentSchoolYearId"].ToString())); dsReport.Tables["dtAttendance"].Merge(ds.Tables[0]); CrystalDecisions.CrystalReports.Engine.TextObject titleText = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text2"]; CrystalDecisions.CrystalReports.Engine.TextObject titleTextSchool = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text9"]; CrystalDecisions.CrystalReports.Engine.TextObject footer = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["txtfooter"]; footer.Text = Common.GetSchoolWiseAddress(new Guid(Session["SchoolId"].ToString())); if (!String.IsNullOrEmpty(Request.QueryString["StartDate"]) && !String.IsNullOrEmpty(Request.QueryString["EndDate"])) { titleText.Text = "Student Attendance Report From " + Convert.ToDateTime(Request.QueryString["StartDate"].ToString()).ToString("MM/dd/yyyy") + " To " + Convert.ToDateTime(Request.QueryString["EndDate"].ToString()).ToString("MM/dd/yyyy"); } titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper(); if (String.IsNullOrEmpty(Request.QueryString["EndDate"]) && !String.IsNullOrEmpty(Request.QueryString["StartDate"])) { titleText.Text = "Student Attendance Report From " + Convert.ToDateTime(Request.QueryString["StartDate"].ToString()).ToString("MM/dd/yyyy"); } titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper(); if (!String.IsNullOrEmpty(Request.QueryString["EndDate"]) && String.IsNullOrEmpty(Request.QueryString["StartDate"])) { titleText.Text = "Student Attendance Report To " + Convert.ToDateTime(Request.QueryString["EndDate"].ToString()).ToString("MM/dd/yyyy"); } titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper(); rpt1.SetDataSource(dsReport.Tables["dtAttendance"]); } if (Request.QueryString["RepId"] == "StaffDate") { rpt.FileName = Server.MapPath("rptStaffAttendanceByDate.rpt"); DayCareBAL.StaffService proxyAttendance = new DayCareBAL.StaffService(); string ReportFor = ""; ReportFor = "Staff"; string SearchText = ""; string SearchStr = ""; string SchoolYear = ""; if (!String.IsNullOrEmpty(Request.QueryString["StartDate"]) && String.IsNullOrEmpty(Request.QueryString["EndDate"])) { SearchText += " sah.checkincheckoutdatetime>='" + Request.QueryString["StartDate"].ToString() + "'"; // SchoolYear += "and ssy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; // } else if (String.IsNullOrEmpty(Request.QueryString["StartDate"]) && !String.IsNullOrEmpty(Request.QueryString["EndDate"])) { SearchText += " sah.checkincheckoutdatetime<='" + Request.QueryString["EndDate"].ToString().Replace("00:00:00 PM", "11:59:58") + "'"; // SchoolYear += "and ssy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; } else if (!String.IsNullOrEmpty(Request.QueryString["EndDate"]) && !String.IsNullOrEmpty(Request.QueryString["StartDate"])) { SearchText += " sah.checkincheckoutdatetime>='" + Request.QueryString["StartDate"].ToString() + "' and sah.checkincheckoutdatetime<='" + Request.QueryString["EndDate"].ToString().Replace("00:00:00", "11:59:58") + "'"; //SchoolYear += "and ssy.SchoolYearId='" + new Guid(Session["CurrentSchoolYearId"].ToString()) + "'"; } ds = proxyAttendance.LoadAttendanceHistory1(SearchText, SearchStr, new Guid(Session["CurrentSchoolYearId"].ToString())); dsReport.Tables["dtAttendance"].Merge(ds.Tables[0]); CrystalDecisions.CrystalReports.Engine.TextObject titleText = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text7"]; CrystalDecisions.CrystalReports.Engine.TextObject titleTextSchool = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text2"]; CrystalDecisions.CrystalReports.Engine.TextObject footer = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["txtfooter"]; footer.Text = Common.GetSchoolWiseAddress(new Guid(Session["SchoolId"].ToString())); if (!String.IsNullOrEmpty(Request.QueryString["StartDate"]) && !String.IsNullOrEmpty(Request.QueryString["EndDate"])) { titleText.Text = "Staff Attendance Report From " + Convert.ToDateTime(Request.QueryString["StartDate"].ToString()).ToString("MM/dd/yyyy") + " To " + Convert.ToDateTime(Request.QueryString["EndDate"].ToString()).ToString("MM/dd/yyyy"); } titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper(); if (String.IsNullOrEmpty(Request.QueryString["EndDate"]) && !String.IsNullOrEmpty(Request.QueryString["StartDate"])) { titleText.Text = "Staff Attendance Report From " + Convert.ToDateTime(Request.QueryString["StartDate"].ToString()).ToString("MM/dd/yyyy"); } titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper(); if (!String.IsNullOrEmpty(Request.QueryString["EndDate"]) && String.IsNullOrEmpty(Request.QueryString["StartDate"])) { titleText.Text = "Staff Attendance Report To " + Convert.ToDateTime(Request.QueryString["EndDate"].ToString()).ToString("MM/dd/yyyy"); } titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper(); rpt1.SetDataSource(dsReport.Tables["dtAttendance"]); } crp.DisplayGroupTree = false; crp.ReportSource = rpt1; crp.RefreshReport(); crp.DataBind(); #endregion }
protected void btnSave_Click(object sender, EventArgs e) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.Staff, "btnSave_Click", "Submit btnSave_Click called", DayCarePL.Common.GUID_DEFAULT); try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.Role, "btnSave_Click", "Debug btnSave_Click ", DayCarePL.Common.GUID_DEFAULT); DayCareBAL.StaffService proxyStaffService = new DayCareBAL.StaffService(); DayCarePL.StaffProperties objStaff = new DayCarePL.StaffProperties(); Guid StaffId; txtPassword.Attributes.Add("value", txtPassword.Text); txtCode.Attributes.Add("value", txtCode.Text); if (fupImage.HasFile) { string Extention = Path.GetExtension(fupImage.FileName).ToLower(); string[] Ext = { ".jpeg", ".jpg", ".png" }; if (Ext.ToList().FindAll(et => et.Equals(Extention)).Count == 0) { MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Please select .JPEG,.PNG file!", "false")); return; } } if (ViewState["SelectedStaffId"] != null) { objStaff.Id = new Guid(ViewState["SelectedStaffId"].ToString()); } else { if (Session["StaffId"] != null) { objStaff.CreatedById = new Guid(Session["StaffId"].ToString()); } } Guid SchoolId = new Guid(); if (Session["StaffId"] != null) { objStaff.LastModifiedById = new Guid(Session["StaffId"].ToString()); } if (!string.IsNullOrEmpty(txtUserName.Text.Trim())) { if (Session["SchoolId"] != null) { SchoolId = new Guid(Session["SchoolId"].ToString()); objStaff.SchoolId = SchoolId; objStaff.ScoolYearId = CurrentSchoolYearId; } bool result = proxyStaffService.CheckDuplicateUserName(txtUserName.Text.Trim(), objStaff.Id, SchoolId); if (result) { MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "User Name Already Exist", "false")); return; } } if (Session["SchoolId"] != null) { SchoolId = new Guid(Session["SchoolId"].ToString()); objStaff.SchoolId = SchoolId; objStaff.ScoolYearId = CurrentSchoolYearId; } bool IsCodeRequire = proxyStaffService.CheckCodeRequire(objStaff.SchoolId); if (IsCodeRequire) { if (string.IsNullOrEmpty(txtCode.Text.Trim())) { MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Please enter Passcode", "false")); txtCode.Focus(); return; } } //bool result = proxyStaffService.CheckDuplicateCode(txtCode.Text.Trim(), objStaff.Id, SchoolId); //if (result) //{ // MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; // MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Code Already Exist", "false")); // return; //} objStaff.UserGroupId = new Guid(ddlUserGroup.SelectedValue); objStaff.StaffCategoryId = new Guid(ddlStaffCategory.SelectedValue); objStaff.FirstName = txtFirstName.Text.Trim(); objStaff.LastName = txtLastName.Text.Trim(); objStaff.Address1 = txtAddress1.Text.Trim(); objStaff.Address2 = txtAddress2.Text.Trim(); objStaff.City = txtCity.Text.Trim(); objStaff.Zip = txtZip.Text.Trim(); objStaff.CountryId = new Guid(ddlCountry.SelectedValue); objStaff.StateId = new Guid(ddlState.SelectedValue); objStaff.MainPhone = txtMainPhone.Text.Trim(); objStaff.SecondaryPhone = txtSecondaryPhone.Text.Trim(); objStaff.Email = txtEmail.Text.Trim(); objStaff.UserName = txtUserName.Text.Trim(); objStaff.Password = txtPassword.Text.Trim(); objStaff.Code = txtCode.Text.Trim(); //if (rdMale.Checked == true) //{ // objStaff.Gender = true; //} //else //{ // objStaff.Gender = false; //} if (ddlGender.SelectedValue == "true") { objStaff.Gender = true; } else { objStaff.Gender = false; } objStaff.SecurityQuestion = txtSecurityQuestion.Text.Trim(); objStaff.SecurityAnswer = txtSecurityAnswer.Text.Trim(); if (fupImage.HasFile) { objStaff.Photo = fupImage.FileName; } else { objStaff.Photo = lblImage.Text; } if (rdActive.Checked == true) { objStaff.Active = true; } else { objStaff.Active = false; } objStaff.Comments = txtComment.Text.Trim(); objStaff.Message = txtMessage.Text; //objStaff.IsPrimary = chkIsPrimary.Checked; StaffId = proxyStaffService.Save(objStaff); if (!StaffId.ToString().Equals(DayCarePL.Common.GUID_DEFAULT)) { if (fupImage.HasFile) { #region "resize image" // Create a bitmap of the content of the fileUpload control in memory Bitmap originalBMP = new Bitmap(fupImage.FileContent); // Calculate the new image dimensions double origWidth = originalBMP.Width; double origHeight = originalBMP.Height; double sngRatio = origWidth / origHeight; int newWidth = 200; int newHeight = (int)(newWidth / sngRatio); //int newHeight =0; //if (sngRatio > 0) // newHeight = newWidth / sngRatio; //else // newHeight = 200; // Create a new bitmap which will hold the previous resized bitmap Bitmap newBMP = new Bitmap(originalBMP, newWidth, newHeight); // Create a graphic based on the new bitmap Graphics oGraphics = Graphics.FromImage(newBMP); // Set the properties for the new graphic file oGraphics.SmoothingMode = SmoothingMode.AntiAlias; oGraphics.InterpolationMode = InterpolationMode.HighQualityBicubic; // Draw the new graphic based on the resized bitmap oGraphics.DrawImage(originalBMP, 0, 0, newWidth, newHeight); // Save the new graphic file to the server newBMP.Save(Server.MapPath("~/StaffImages/" + StaffId + Path.GetExtension(fupImage.FileName))); // Once finished with the bitmap objects, we deallocate them. originalBMP.Dispose(); newBMP.Dispose(); oGraphics.Dispose(); #endregion //fupImage.SaveAs(Server.MapPath("~/StaffImages/" + StaffId + Path.GetExtension(fupImage.FileName))); } //MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; //MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Saved Successfully", "false")); Response.Redirect("StaffList.aspx", false); } else { MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Internal Error,Please try again.", "false")); return; } } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.Staff, "btnSave_Click", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Internal Error,Please try again", "false")); return; } }
public void LoadStaffDetails(Guid StaffId, Guid CurrentSchoolyearId) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.Staff, "SubmitRecord", "Submit record method called", DayCarePL.Common.GUID_DEFAULT); try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.Staff, "SubmitRecord", "Debug Submit Record Of Role", DayCarePL.Common.GUID_DEFAULT); DayCareBAL.StaffService proxyStaffService = new DayCareBAL.StaffService(); DayCarePL.StaffProperties objStaff = proxyStaffService.LoadStaffBystaffId(StaffId, CurrentSchoolyearId); if (objStaff != null) { if (!string.IsNullOrEmpty(objStaff.Photo)) { imgStaff.ImageUrl = "../StaffImages/" + objStaff.Photo; } else { if (objStaff.Gender == true) { imgStaff.ImageUrl = "../StaffImages/male_photo.png"; } else { imgStaff.ImageUrl = "../StaffImages/female_photo.png"; } } ddlUserGroup.SelectedValue = objStaff.UserGroupId.ToString(); ddlStaffCategory.SelectedValue = objStaff.StaffCategoryId.ToString(); txtFirstName.Text = objStaff.FirstName; txtLastName.Text = objStaff.LastName; txtAddress1.Text = objStaff.Address1; txtAddress2.Text = objStaff.Address2; txtCity.Text = objStaff.City; txtZip.Text = objStaff.Zip; ddlCountry.SelectedValue = objStaff.CountryId.ToString(); if (!objStaff.CountryId.ToString().Equals(DayCarePL.Common.GUID_DEFAULT)) { Common.BindStateDropDown(ddlState, objStaff.CountryId.ToString()); } if (ddlState.Items != null && ddlState.Items.Count > 0) { ddlState.SelectedValue = objStaff.StateId.ToString(); } txtMainPhone.Text = objStaff.MainPhone; txtSecondaryPhone.Text = objStaff.SecondaryPhone; txtEmail.Text = objStaff.Email; txtUserName.Text = objStaff.UserName; txtPassword.Text = objStaff.Password; txtPassword.Attributes.Add("value", txtPassword.Text); txtCode.Text = objStaff.Code; txtCode.Attributes.Add("value", objStaff.Code); if (objStaff.Gender == true) { ddlGender.SelectedValue = "true"; } else { ddlGender.SelectedValue = "false"; } txtSecurityQuestion.Text = objStaff.SecurityQuestion; txtSecurityAnswer.Text = objStaff.SecurityAnswer; if (objStaff.Active == true) { rdActive.Checked = true; } else { rdInactive.Checked = true; } txtComment.Text = objStaff.Comments; txtMessage.Text = objStaff.Message; //chkIsPrimary.Checked = objStaff.IsPrimary; lblImage.Text = objStaff.Photo; } } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.Staff, "LoadStaffDetails", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); } }