public static DayCarePL.SchoolProperties LoadSchoolInfo(Guid SchoolId) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clSchool, "LoadSchoolInfo", "LoadSchoolInfo method called", DayCarePL.Common.GUID_DEFAULT); clConnection.DoConnection(); DayCareDataContext db = new DayCareDataContext(); try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clSchool, "LoadSchoolInfo", "Debug LoadSchoolInfo called", DayCarePL.Common.GUID_DEFAULT); DayCarePL.SchoolProperties objSchool = null; objSchool = (from s in db.Schools join st in db.States on s.StateId equals st.Id into state join c in db.Countries on s.CountryId equals c.Id into country from ctry in country.DefaultIfEmpty() where s.Id.Equals(SchoolId) select new DayCarePL.SchoolProperties() { Id = s.Id, Name = s.Name, Address1 = s.Address1, Address2 = s.Address2, City = s.City, Zip = s.Zip, StateId = s.StateId, CountryId = s.CountryId, StateName = s.Name, CountryName = ctry.Name, MainPhone = s.MainPhone, SecondaryPhone = s.SecondaryPhone, Fax = s.Fax, Email = s.Email, WebSite = s.WebSite, TimeZoneId = s.TimeZoneId, CodeRequired = s.CodeRequired, LateFeeAmount = s.LateFeeAmount.HasValue == true ? s.LateFeeAmount.Value : 0, Comments = s.Comments, iPadHeader = s.iPadHeader, iPadHeaderFont = s.iPadHeaderFont, iPadHeaderFontSize = s.iPadHeaderFontSize, iPadHeaderColor = s.iPadHeaderColor, iPadMessage = s.iPadMessage, iPadMessageFont = s.iPadMessageFont, iPadMessageFontSize = s.iPadMessageFontSize, iPadBackgroundImage = s.iPadBackgroundImage, iPadMessageColor = s.iPadMessageColor, CreatedDateTime = s.CreatedDateTime, LastModifiedDatetime = s.LastModifiedDatetime, CreatedById = s.CreatedById, LastModifiedById = s.LastModifiedById }).FirstOrDefault(); return(objSchool); } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clSchool, "LoadSchoolInfo", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); return(null); } }
public static bool Save(DayCarePL.SchoolProperties objSchool) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clSchool, "LoadSchoolInfo", "LoadSchoolInfo method called", DayCarePL.Common.GUID_DEFAULT); clConnection.DoConnection(); DayCareDataContext db = new DayCareDataContext(); School DBSchool = new School(); try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clSchool, "LoadSchoolInfo", "Debug LoadSchoolInfo called", DayCarePL.Common.GUID_DEFAULT); DBSchool = db.Schools.FirstOrDefault(id => id.Id.Equals(objSchool.Id)); DBSchool.Id = objSchool.Id; DBSchool.Name = objSchool.Name; DBSchool.Address1 = objSchool.Address1; DBSchool.Address2 = objSchool.Address2; DBSchool.City = objSchool.City; DBSchool.Zip = objSchool.Zip; if (!objSchool.CountryId.ToString().Equals(DayCarePL.Common.GUID_DEFAULT)) { DBSchool.CountryId = objSchool.CountryId; } if (!objSchool.StateId.ToString().Equals(DayCarePL.Common.GUID_DEFAULT)) { DBSchool.StateId = objSchool.StateId; } DBSchool.MainPhone = objSchool.MainPhone; DBSchool.SecondaryPhone = objSchool.SecondaryPhone; DBSchool.Fax = objSchool.Fax; DBSchool.Email = objSchool.Email; DBSchool.WebSite = objSchool.WebSite; DBSchool.CodeRequired = objSchool.CodeRequired; DBSchool.LateFeeAmount = objSchool.LateFeeAmount; DBSchool.Comments = objSchool.Comments; DBSchool.iPadHeader = objSchool.iPadHeader; DBSchool.iPadHeaderFont = objSchool.iPadHeaderFont; DBSchool.iPadHeaderFontSize = objSchool.iPadHeaderFontSize; DBSchool.iPadHeaderColor = objSchool.iPadHeaderColor; DBSchool.iPadMessage = objSchool.iPadMessage; DBSchool.iPadMessageFont = objSchool.iPadMessageFont; DBSchool.iPadMessageFontSize = objSchool.iPadMessageFontSize; if (!string.IsNullOrEmpty(objSchool.iPadBackgroundImage)) { DBSchool.iPadBackgroundImage = DBSchool.Id + System.IO.Path.GetExtension(objSchool.iPadBackgroundImage); } else { DBSchool.iPadBackgroundImage = string.Empty; } DBSchool.iPadMessageColor = objSchool.iPadMessageColor; DBSchool.LastModifiedDatetime = DateTime.Now; DBSchool.CreatedById = objSchool.CreatedById; DBSchool.LastModifiedById = objSchool.LastModifiedById; db.SubmitChanges(); return(true); } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clSchool, "LoadSchoolInfo", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); return(false); } }
public bool Save(DayCarePL.SchoolProperties objSchool) { return(DayCareDAL.clSchool.Save(objSchool)); }
protected void Page_Load(object sender, EventArgs e) { if (Session["SchoolId"] == null || Session["CurrentSchoolYearId"] == null) { Response.Redirect("~/Login.aspx"); } if (Session["SchoolId"] != null) { SchoolId = new Guid(Session["SchoolId"].ToString()); } if (!IsPostBack) { try { this.Form.DefaultButton = btnSave.UniqueID; Common.BindUserGroupDropDown(ddlUserGroup, SchoolId); Common.BindStaffCategoryDropDown(ddlStaffCategory, SchoolId); Common.BindCountryDropDown(ddlCountry); //ddlState.Items.Insert(0, new ListItem("--Select--", "00000000-0000-0000-0000-000000000000")); if (!string.IsNullOrEmpty(Request.QueryString["Id"]))// != null && Request.QueryString["Id"] { ViewState["SelectedStaffId"] = Request.QueryString["Id"].ToString(); LoadStaffDetails(new Guid(ViewState["SelectedStaffId"].ToString()), new Guid(Session["CurrentSchoolYearId"].ToString())); } else { DayCareBAL.SchoolService proxySchool = new DayCareBAL.SchoolService(); DayCarePL.SchoolProperties objSchool = proxySchool.LoadSchoolInfo(new Guid(Session["SchoolId"].ToString())); if (objSchool != null) { if (ddlCountry != null && ddlCountry.Items.Count > 0) { if (ddlCountry.Items.IndexOf(ddlCountry.Items.FindByValue(objSchool.CountryId.ToString())) != -1) { ddlCountry.SelectedValue = objSchool.CountryId.ToString(); } } Common.BindStateDropDown(ddlState, ddlCountry.SelectedValue); if (ddlState != null && ddlState.Items.Count > 0) { if (ddlState.Items.IndexOf(ddlState.Items.FindByValue(objSchool.StateId.ToString())) != -1) { ddlState.SelectedValue = objSchool.StateId.ToString(); } } } } } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.Staff, "Page_Load", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); } } if (Session["CurrentSchoolYearId"] != null) { CurrentSchoolYearId = new Guid(Session["CurrentSchoolYearId"].ToString()); } //if (!Common.IsCurrentYear(CurrentSchoolYearId, SchoolId)) //{ // btnSave.Enabled = false; // btnCancel.Enabled = false; //} SetMenuLink(); }
protected void btnSave_Click(object sender, EventArgs e) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.School, "btnSave_Click", "btnSave_Click called", DayCarePL.Common.GUID_DEFAULT); bool result = false; try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.School, "btnSave_Click", "Debug btnSave_Click called", DayCarePL.Common.GUID_DEFAULT); DayCareBAL.SchoolService proxySchoolService = new DayCareBAL.SchoolService(); DayCarePL.SchoolProperties objSchool = new DayCarePL.SchoolProperties(); if (fupiPadBackgroundImage.HasFile) { string Extention = Path.GetExtension(fupiPadBackgroundImage.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 (Session["SchoolId"] != null) { objSchool.Id = new Guid(Session["SchoolId"].ToString()); objSchool.Name = txtName.Text; objSchool.Address1 = txtAddress1.Text; objSchool.Address2 = txtAddress2.Text; objSchool.City = txtCity.Text; objSchool.Zip = txtZip.Text; objSchool.CountryId = new Guid(ddlCountry.SelectedValue); objSchool.StateId = new Guid(ddlState.SelectedValue); objSchool.MainPhone = txtMainPhone.Text; objSchool.SecondaryPhone = txtSecondaryPhone.Text; objSchool.Fax = txtFax.Text; objSchool.Email = txtEmail.Text; objSchool.WebSite = txtWebSite.Text; objSchool.CodeRequired = chkCodeRequire.Checked; if (!string.IsNullOrEmpty(txtLateFee.Text.Trim())) { objSchool.LateFeeAmount = Convert.ToDecimal(txtLateFee.Text.Trim()); } else { objSchool.LateFeeAmount = 0; } objSchool.iPadHeader = txtiPadHeader.Text; if (ddliPadHeaderFont.SelectedValue != "-1") { objSchool.iPadHeaderFont = ddliPadHeaderFont.SelectedItem.Text; } if (ddliPadHeaderFontSize.SelectedValue != "-1") { objSchool.iPadHeaderFontSize = Convert.ToInt16(ddliPadHeaderFontSize.SelectedItem.Text); } if (rcpiPadHeaderColor.SelectedColor.Name != "0") { objSchool.iPadHeaderColor = "#" + rcpiPadHeaderColor.SelectedColor.Name; } objSchool.iPadMessage = txtiPadMessage.Text; if (ddliPadMessageFont.SelectedValue != "-1") { objSchool.iPadMessageFont = ddliPadMessageFont.SelectedItem.Text; } if (ddliPadMessageFontSize.SelectedValue != "-1") { objSchool.iPadMessageFontSize = Convert.ToInt16(ddliPadMessageFontSize.SelectedItem.Text); } if (fupiPadBackgroundImage.HasFile) { objSchool.iPadBackgroundImage = fupiPadBackgroundImage.FileName; } else { objSchool.iPadBackgroundImage = lbliPadBackgroundImage.Text; } if (rcpiPadMessageColor.SelectedColor.Name != "0") { objSchool.iPadMessageColor = "#" + rcpiPadMessageColor.SelectedColor.Name; } if (Session["StaffId"] != null) { objSchool.CreatedById = new Guid(Session["StaffId"].ToString()); objSchool.LastModifiedById = new Guid(Session["StaffId"].ToString()); } result = proxySchoolService.Save(objSchool); if (result) { if (fupiPadBackgroundImage.HasFile) { fupiPadBackgroundImage.SaveAs(Server.MapPath("~/StaffImages/" + objSchool.Id + Path.GetExtension(fupiPadBackgroundImage.FileName))); } LoadSchoolInfo(objSchool.Id); MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Saved Successfully", "false")); return; } 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; } } 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.School, "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 LoadSchoolInfo(Guid SchoolId) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.School, "LoadSchoolInfo", "LoadSchoolInfo called", DayCarePL.Common.GUID_DEFAULT); try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.School, "LoadSchoolInfo", "Debug LoadSchoolInfo Of Role", DayCarePL.Common.GUID_DEFAULT); DayCareBAL.SchoolService proxySchoolService = new DayCareBAL.SchoolService(); DayCarePL.SchoolProperties objSchool = proxySchoolService.LoadSchoolInfo(SchoolId); DayCareBAL.FontService proxyFontService = new DayCareBAL.FontService(); DayCarePL.FontProperties[] lstFont = proxyFontService.LoadFont(); if (objSchool != null) { if (!string.IsNullOrEmpty(objSchool.iPadBackgroundImage)) { imgSchholImage.ImageUrl = "../StaffImages/" + objSchool.iPadBackgroundImage; } else { imgSchholImage.ImageUrl = "../StaffImages/Filetype-Blank-Alt-icon.png"; } txtName.Text = objSchool.Name; txtAddress1.Text = objSchool.Address1; txtAddress2.Text = objSchool.Address2; txtCity.Text = objSchool.City; txtZip.Text = objSchool.Zip; ddlCountry.SelectedValue = objSchool.CountryId.ToString(); if (!objSchool.CountryId.ToString().Equals(DayCarePL.Common.GUID_DEFAULT)) { Common.BindStateDropDown(ddlState, objSchool.CountryId.ToString()); } if (ddlState.Items != null && ddlState.Items.Count > 0) { ddlState.SelectedValue = objSchool.StateId.ToString(); } txtMainPhone.Text = objSchool.MainPhone; txtSecondaryPhone.Text = objSchool.SecondaryPhone; txtFax.Text = objSchool.Fax; txtEmail.Text = objSchool.Email; txtWebSite.Text = objSchool.WebSite; chkCodeRequire.Checked = objSchool.CodeRequired; if (objSchool.LateFeeAmount != null) { txtLateFee.Text = objSchool.LateFeeAmount.ToString(); } txtiPadHeader.Text = objSchool.iPadHeader; //txtiPadHeaderFont.Text = objSchool.iPadHeaderFont; //txtiPadHeaderFontSize.Text = objSchool.iPadHeaderFontSize.HasValue ? objSchool.iPadHeaderFontSize.ToString() : "0"; lbliPadHeaderColor.BackColor = System.Drawing.ColorTranslator.FromHtml(objSchool.iPadHeaderColor); rcpiPadHeaderColor.SelectedColor = System.Drawing.ColorTranslator.FromHtml(objSchool.iPadHeaderColor); txtiPadMessage.Text = objSchool.iPadMessage; //txtiPadMessageFont.Text = objSchool.iPadMessageFont; //txtiPadMessageFontSize.Text = objSchool.iPadMessageFontSize.HasValue ? objSchool.iPadMessageFontSize.ToString() : "0"; ; lbliPadBackgroundImage.Text = objSchool.iPadBackgroundImage; lbliPadMessageColor.BackColor = System.Drawing.ColorTranslator.FromHtml(objSchool.iPadMessageColor); rcpiPadMessageColor.SelectedColor = System.Drawing.ColorTranslator.FromHtml(objSchool.iPadMessageColor); if (lstFont != null && lstFont.Count() > 0) { ddliPadHeaderFont.Items.Clear(); ddliPadMessageFont.Items.Clear(); foreach (DayCarePL.FontProperties objFont in lstFont) { ddliPadHeaderFont.Items.Add(new ListItem(objFont.Name, objFont.Name)); ddliPadMessageFont.Items.Add(new ListItem(objFont.Name, objFont.Name)); } ddliPadHeaderFont.Items.Insert(0, new ListItem("--Select--", "-1")); ddliPadMessageFont.Items.Insert(0, new ListItem("--Select--", "-1")); } if (!string.IsNullOrEmpty(objSchool.iPadHeaderFont)) { ddliPadHeaderFont.SelectedValue = objSchool.iPadHeaderFont; } else { ddliPadHeaderFont.SelectedIndex = 0; } if (objSchool.iPadHeaderFontSize != null) { ddliPadHeaderFontSize.SelectedValue = objSchool.iPadHeaderFontSize.ToString(); } else { ddliPadHeaderFontSize.SelectedIndex = 0; } if (!string.IsNullOrEmpty(objSchool.iPadMessageFont)) { ddliPadMessageFont.SelectedValue = objSchool.iPadMessageFont; } else { ddliPadMessageFont.SelectedIndex = 0; } if (objSchool.iPadMessageFontSize != null) { ddliPadMessageFontSize.SelectedValue = objSchool.iPadMessageFontSize.ToString(); } else { ddliPadMessageFontSize.SelectedIndex = 0; } } } catch (Exception ex) { } }
public static DayCarePL.iLoginStaffProperties ValidateUser(string UserName, string Password, Guid SchoolId) { clConnection.DoConnection(); DayCarePL.iLoginStaffProperties StaffData = null; try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clStaff, "ValidateUser", "ValidateUser function debug", DayCarePL.Common.GUID_DEFAULT); DayCareDataContext db = new DayCareDataContext(); Configuration myConfiguration = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~"); //get Staff details using match user name and password StaffData = (from s in db.Staffs join ssy in db.StaffSchoolYears on s.Id equals ssy.StaffId where ssy.active.Equals(true) join ug in db.UserGroups on s.UserGroupId equals ug.Id join r in db.Roles on ug.RoleId equals r.Id where s.UserName.Equals(UserName.Trim()) && s.Password.Equals(Password) && ug.SchoolId.Equals(SchoolId) select new DayCarePL.iLoginStaffProperties() { Id = s.Id, StaffFullName = s.FirstName + " " + s.LastName, FirstName = s.FirstName, LastName = s.LastName, UserGroupId = s.UserGroupId, UserGroupTitle = ug.GroupTitle, Active = ssy.active.Value, RoleId = Convert.ToString(r.Id), RoleOfUser = r.Name } ).FirstOrDefault(); if (StaffData != null) { string CurrentSchoolYearId = (from csy in db.SchoolYears where csy.SchoolId.Equals(SchoolId) && csy.CurrentId.Equals(true) select csy.Id == null ? "" : csy.Id.ToString()).FirstOrDefault(); string StaffSchoolYearId = ""; if (CurrentSchoolYearId.Length > 0) { StaffSchoolYearId = (from ssy in db.StaffSchoolYears where ssy.SchoolYearId.ToString().Equals(CurrentSchoolYearId) && ssy.StaffId.Equals(StaffData.Id) select ssy.Id.ToString()).FirstOrDefault(); StaffData.CurrentSchoolYearId = CurrentSchoolYearId; StaffData.StaffSchoolYearId = StaffSchoolYearId; } if (StaffSchoolYearId.Length > 1) { DayCarePL.SchoolProperties schoolData = (from s in db.Schools where s.Id.Equals(SchoolId) && s.active.Equals(true) select new DayCarePL.SchoolProperties() { Name = s.Name, iPadBackgroundImage = s.iPadBackgroundImage == null ? "" : myConfiguration.AppSettings.Settings["StaffPhoto"].Value + "/StaffImages/" + s.iPadBackgroundImage, iPadHeader = s.iPadHeader, iPadHeaderColor = s.iPadHeaderColor, iPadHeaderFont = s.iPadHeaderFont, iPadHeaderFontSize = s.iPadHeaderFontSize, iPadMessage = s.iPadMessage, iPadMessageColor = s.iPadMessageColor, iPadMessageFont = s.iPadMessageFont, iPadMessageFontSize = s.iPadMessageFontSize, LastModifiedDatetime = s.LastModifiedDatetime, CodeRequired = s.CodeRequired }).FirstOrDefault(); StaffData.SchoolName = schoolData.Name; StaffData.iPadBackgroundImage = schoolData.iPadBackgroundImage; StaffData.iPadHeader = schoolData.iPadHeader; StaffData.iPadHeaderColor = schoolData.iPadHeaderColor; StaffData.iPadHeaderFont = schoolData.iPadHeaderFont; StaffData.iPadHeaderFontSize = schoolData.iPadHeaderFontSize == null ? 0 : schoolData.iPadHeaderFontSize.Value; StaffData.iPadMessage = schoolData.iPadMessage; StaffData.iPadMessageColor = schoolData.iPadMessageColor; StaffData.iPadMessageFont = schoolData.iPadMessageFont; StaffData.CodeRequired = schoolData.CodeRequired.ToString(); StaffData.SchoolModifiedDateTime = string.Format("{0:M/d/yyyy hh:mm tt}", schoolData.LastModifiedDatetime); StaffData.Validate = "true"; } else { StaffData.Validate = "false"; } } else { StaffData = new DayCarePL.iLoginStaffProperties(); StaffData.Validate = "false"; } } catch (Exception ex) { StaffData = null; DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clStaff, "ValidateUser", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); } return(StaffData); }