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);
}
