protected void rgFamilyLedger_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
if (e.Item is GridPagerItem)
{
RadComboBox PageSizeCombo = (RadComboBox)e.Item.FindControl("PageSizeComboBox");
PageSizeCombo.Items.Clear();
PageSizeCombo.Items.Add(new RadComboBoxItem("25"));
PageSizeCombo.FindItemByText("25").Attributes.Add("ownerTableViewId", rgFamilyLedger.MasterTableView.ClientID);
PageSizeCombo.Items.Add(new RadComboBoxItem("50"));
PageSizeCombo.FindItemByText("50").Attributes.Add("ownerTableViewId", rgFamilyLedger.MasterTableView.ClientID);
//PageSizeCombo.Items[0].Text = "25";
//PageSizeCombo.Items[1].Text = "50";
PageSizeCombo.FindItemByText(e.Item.OwnerTableView.PageSize.ToString()).Selected = true;
}
if (e.Item.ItemType == GridItemType.AlternatingItem || e.Item.ItemType == GridItemType.Item)
{
DayCarePL.ChildFamilyProperties objChildFamily = e.Item.DataItem as DayCarePL.ChildFamilyProperties;
HyperLink hlLateFees = e.Item.FindControl("hlLateFees") as HyperLink;
hlLateFees.Attributes.Add("onclick", "ShowLateFee('" + objChildFamily.Id + "','" + objChildFamily.FamilyTitle + "'); return false;");
decimal LateFee = 0;
if (ViewState["LateFee"] != null)
{
LateFee = Convert.ToDecimal(ViewState["LateFee"].ToString());
}
if (objChildFamily.Balance >= LateFee && LateFee > 0)
{
hlLateFees.Visible = true;
}
else
{
hlLateFees.Visible = false;
}
}
}
public static List <DayCarePL.ChildFamilyProperties> GetFamiliesWithChild(Guid SchoolId, Guid SchoolYearId)
{
DayCareDataContext db = new DayCareDataContext();
clConnection.DoConnection();
try
{
List <DayCarePL.ChildFamilyProperties> lstFamilies = new List <DayCarePL.ChildFamilyProperties>();
DayCarePL.ChildFamilyProperties objFamily;
var data = db.spGetFamiliesWithChild(SchoolId, SchoolYearId);
foreach (var d in data)
{
objFamily = new DayCarePL.ChildFamilyProperties();
objFamily.Id = d.Id;
objFamily.FamilyTitle = d.FamilyTitle;
string ChildName = d.ChildName;
if (!string.IsNullOrEmpty(ChildName))
{
objFamily.FamilyTitle += " [ " + ChildName.Substring(0, ChildName.LastIndexOf(", ")) + " ]";
}
lstFamilies.Add(objFamily);
}
return(lstFamilies);
}
catch (Exception ex)
{
return(null);
}
}
protected void rgLateFee_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem)
{
DayCarePL.ChildFamilyProperties objChildFamily = e.Item.DataItem as DayCarePL.ChildFamilyProperties;
TextBox txtFamilyLateFee = e.Item.FindControl("txtFamilyLateFee") as TextBox;
txtFamilyLateFee.Text = txtLateCharge.Text;
}
}
public static List <DayCarePL.ChildFamilyProperties> LoadChildFamily(Guid SchoolId, Guid SchoolYearId)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clLedgerOfFamily, "LoadChildFamily", "Execute LoadChildFamily Method", DayCarePL.Common.GUID_DEFAULT);
clConnection.DoConnection();
DayCareDataContext db = new DayCareDataContext();
DayCarePL.ChildFamilyProperties objChildFamily;
List <DayCarePL.ChildFamilyProperties> lstChildFamily = new List <DayCarePL.ChildFamilyProperties>();
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clLedgerOfFamily, "LoadChildFamily", "Debug LoadChildFamily Method", DayCarePL.Common.GUID_DEFAULT);
var data = db.spGetChildFamilyForLEdgerOfFammily(SchoolId, SchoolYearId);
foreach (var d in data)
{
objChildFamily = new DayCarePL.ChildFamilyProperties();
objChildFamily.Id = d.Id;
objChildFamily.Email = d.Email;
objChildFamily.FamilyTitle = d.FamilyTitle;
objChildFamily.HomePhone = d.HomePhone;
if (d.ChildName.Length > 0)
{
objChildFamily.ChildName = "[ " + d.ChildName.Substring(0, d.ChildName.LastIndexOf(", ")) + " ]";
}
objChildFamily.Debit = d.Debit;
objChildFamily.Credit = d.Credit;
try
{
objChildFamily.OpBal = d.OpBal.HasValue ? d.OpBal.Value : 0;
}
catch
{
objChildFamily.OpBal = 0;
}
objChildFamily.Balance = d.Balance + objChildFamily.OpBal;// d.Debit - d.Credit;
try
{
objChildFamily.Active = d.Active == null ? false : d.Active.Value;
}
catch
{
objChildFamily.Active = false;
}
lstChildFamily.Add(objChildFamily);
}
return(lstChildFamily);
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clLedgerOfFamily, "LoadChildFamily", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
return(null);
}
}
protected void Fillddlfamily()
{
DayCareBAL.LedgerOfFamilyService proxyChildFamily = new DayCareBAL.LedgerOfFamilyService();
List <DayCarePL.ChildFamilyProperties> lstFamily = new List <DayCarePL.ChildFamilyProperties>();
DayCarePL.ChildFamilyProperties ChildFamilyProperties = new DayCarePL.ChildFamilyProperties();
lstFamily = proxyChildFamily.LoadChildFamily(new Guid(Session["SchoolId"].ToString()), new Guid(Session["CurrentSchoolYearId"].ToString())).Where(c => c.Active.Equals(true)).ToList();
//if (lstFamily.Count > 0)
//{
ChildFamilyProperties.Id = new Guid("00000000-0000-0000-0000-000000000000");
ChildFamilyProperties.FamilyTitle = "--Select All--";
lstFamily.Insert(0, ChildFamilyProperties);
rcbfamilyList.DataSource = lstFamily;
rcbfamilyList.DataTextField = "FamilyTitle";
rcbfamilyList.DataValueField = "Id";
rcbfamilyList.DataBind();
rcbfamilyList.EmptyMessage = "---Select---";
//.IsPostBack.rcbfamilyList.Items.Insert(0, new ListItem("--Select--", DayCarePL.Common.GUID_DEFAULT));
//}
}
public Guid Save(DayCarePL.ChildFamilyProperties objChildFamily)
{
return(DayCareDAL.clChildFamily.Save(objChildFamily));
}
public void LoadFamilyData(Guid ChildFamilyId)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.FamilyInfo, "LoadFamilyData", "LoadFamilyData method called", DayCarePL.Common.GUID_DEFAULT);
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.FamilyInfo, "LoadFamilyData", "Debug LoadFamilyData", DayCarePL.Common.GUID_DEFAULT);
DayCareBAL.ChildFamilyService proxyChildFamily = new DayCareBAL.ChildFamilyService();
DayCarePL.ChildFamilyProperties objChildFamily = proxyChildFamily.LoadChildFamilyById(ChildFamilyId, new Guid(Session["CurrentSchoolYearId"].ToString()));
if (objChildFamily != null)
{
txtFamilyTitle.Text = objChildFamily.FamilyTitle;
txtUserName.Text = objChildFamily.UserName;
txtPassword.Text = objChildFamily.Password;
txtPassword.Attributes.Add("value", txtPassword.Text);
txtCode.Text = objChildFamily.Code;
txtCode.Attributes.Add("value", objChildFamily.Code);
txtAddress1.Text = objChildFamily.Address1;
txtAddress2.Text = objChildFamily.Address2;
txtCity.Text = objChildFamily.City;
txtZip.Text = objChildFamily.Zip;
if (ddlState.Items != null && ddlState.Items.Count > 0)
{
ddlState.SelectedValue = objChildFamily.StateId.ToString();
}
txtHomePhone.Text = objChildFamily.HomePhone;
chkMsgActive.Checked = objChildFamily.MsgActive.Value;
if (objChildFamily.MsgStartDate != null)
{
rdpMsgStartDate.SelectedDate = objChildFamily.MsgStartDate;
}
if (objChildFamily.MsgEndDate != null)
{
rdpMsgEndDate.SelectedDate = objChildFamily.MsgEndDate;
}
txtMessage.Text = objChildFamily.MsgDisplayed;
txtComments.Text = objChildFamily.Comments;
chkActive.Checked = objChildFamily.Active;
foreach (DayCarePL.FamilyDataProperties objFamilyData in objChildFamily.lstFamily)
{
if (objFamilyData.GuardianIndex == 1)
{
lblGuardian1FamilyId.Text = objFamilyData.Id.ToString();
txtFirstNameGuardian1.Text = objFamilyData.FirstName;
txtLastNameGuardian1.Text = objFamilyData.LastName;
ddlRelationshipGuardian1.SelectedValue = objFamilyData.RelationShipId.ToString();
txtEmailGuardian1.Text = objFamilyData.Email;
ddlPhoneType1Guardian1.SelectedValue = objFamilyData.Phone1Type;
txtPhone1Guardian1.Text = objFamilyData.Phone1;
ddPhoneType2Guardian1.SelectedValue = objFamilyData.Phone2Type;
txtPhone2Guardian1.Text = objFamilyData.Phone2;
lblImageGuardian1.Text = objFamilyData.Photo;
if (!string.IsNullOrEmpty(objFamilyData.Photo))
{
imgFamilyGuardian1.ImageUrl = "../FamilyImages/" + objFamilyData.Photo;
}
else
{
imgFamilyGuardian1.ImageUrl = "../FamilyImages/male_photo.png";
}
}
if (objFamilyData.GuardianIndex == 2)
{
lblGuardian2FamilyId.Text = objFamilyData.Id.ToString();
txtFirstNameGuardian2.Text = objFamilyData.FirstName;
txtLastNameGuardian2.Text = objFamilyData.LastName;
ddlRelationshipGuardian2.SelectedValue = objFamilyData.RelationShipId.ToString();
txtEmailGuardian2.Text = objFamilyData.Email;
ddlPhoneType1Guardian2.SelectedValue = objFamilyData.Phone1Type;
txtPhone1Guardian2.Text = objFamilyData.Phone1;
ddlPhoneType2Guardian2.SelectedValue = objFamilyData.Phone2Type;
txtPhone2Guardian2.Text = objFamilyData.Phone2;
lblImageGuardian2.Text = objFamilyData.Photo;
if (!string.IsNullOrEmpty(objFamilyData.Photo))
{
imgFamilyGuardian2.ImageUrl = "../FamilyImages/" + objFamilyData.Photo;
}
else
{
imgFamilyGuardian2.ImageUrl = "../FamilyImages/male_photo.png";
}
}
}
hdnName.Value = objChildFamily.UserName;
hdnCode.Value = objChildFamily.Code;
}
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.FamilyInfo, "LoadFamilyData", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.FamilyInfo, "btnSave_Click", "Submit btnSave_Click called", DayCarePL.Common.GUID_DEFAULT);
try
{
string err_msg = string.Empty;
if (txtFirstNameGuardian1.Text.Trim() == "")
{
err_msg = "- Please enter Guardian 1 First Name.\\n";
}
if (txtLastNameGuardian1.Text.Trim() == "")
{
err_msg += "- Please enter Guardian 1 Last Name.";
}
if (err_msg.Length > 0)
{
MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", err_msg, "false"));
return;
}
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.FamilyInfo, "btnSave_Click", "Debug btnSave_Click ", DayCarePL.Common.GUID_DEFAULT);
DayCareBAL.FamilyDataService proxyFamilyData = new DayCareBAL.FamilyDataService();
DayCareBAL.ChildFamilyService proxyChildFamily = new DayCareBAL.ChildFamilyService();
DayCarePL.FamilyDataProperties objFamilyData = null;
DayCarePL.ChildFamilyProperties objChildFamily = new DayCarePL.ChildFamilyProperties();
Guid ChildFamilyId;
objChildFamily.SchoolId = GetSchoolId();
txtPassword.Attributes.Add("value", txtPassword.Text);
txtCode.Attributes.Add("value", txtCode.Text);
if (!string.IsNullOrEmpty(txtUserName.Text.Trim()))
{
if (!hdnName.Value.ToLower().Equals(txtUserName.Text.ToLower().Trim()))
{
bool result = proxyFamilyData.CheckDuplicateUserName(txtUserName.Text.Trim(), objChildFamily.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;
}
}
}
bool IsCodeRequire = proxyFamilyData.CheckCodeRequire(objChildFamily.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;
}
else
{
//if (txtCode.Text.Length < 4)
//{
// MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
// MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Passcode require 4 digit number.", "false"));
// return;
//}
}
//if (!txtCode.Text.Trim().Equals(hdnCode.Value))
//{
// bool IsCodeDuplicate = proxyFamilyData.CheckDuplicateCode(txtCode.Text.Trim(), GetSchoolId());
// if (IsCodeDuplicate)
// {
// MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
// MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Code Already Exist", "false"));
// return;
// }
//}
}
if (rdpMsgEndDate.SelectedDate != null)
{
if (rdpMsgStartDate.SelectedDate == null)
{
MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Start date require", "false"));
return;
}
}
if (rdpMsgStartDate.SelectedDate != null && rdpMsgEndDate.SelectedDate != null)
{
if (rdpMsgStartDate.SelectedDate > rdpMsgEndDate.SelectedDate)
{
MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Start date must be less than End date", "false"));
return;
}
}
if (fupImageGuardian1.HasFile)
{
string Extention = Path.GetExtension(fupImageGuardian1.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 (fupImageGuardian2.HasFile)
{
string Extention = Path.GetExtension(fupImageGuardian2.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;
}
}
string Guardian1FamilyId = "", Guardian2FamilyId = "";
if (ViewState["ChildFamilyId"] != null)
{
objChildFamily.Id = new Guid(ViewState["ChildFamilyId"].ToString());
Guardian1FamilyId = lblGuardian1FamilyId.Text;
Guardian2FamilyId = lblGuardian2FamilyId.Text;
}
else
{
if (Session["StaffId"] != null)
{
objChildFamily.CreatedById = new Guid(Session["StaffId"].ToString());
}
}
//Child Family
objChildFamily.FamilyTitle = txtLastNameGuardian1.Text + ", " + txtFirstNameGuardian1.Text;//txtFamilyTitle.Text.Trim();
objChildFamily.UserName = txtUserName.Text.Trim();
objChildFamily.Password = txtPassword.Text.Trim();
objChildFamily.Code = txtCode.Text.Trim();
objChildFamily.Address1 = txtAddress1.Text.Trim();
objChildFamily.Address2 = txtAddress2.Text.Trim();
objChildFamily.City = txtCity.Text.Trim();
objChildFamily.Zip = txtZip.Text.Trim();
if (!ddlState.SelectedValue.Equals(DayCarePL.Common.GUID_DEFAULT))
{
objChildFamily.StateId = new Guid(ddlState.SelectedValue);
}
objChildFamily.HomePhone = txtHomePhone.Text.Trim();
objChildFamily.MsgActive = chkMsgActive.Checked;
if (rdpMsgStartDate.SelectedDate != null)
{
objChildFamily.MsgStartDate = rdpMsgStartDate.SelectedDate.Value;
}
if (rdpMsgEndDate.SelectedDate != null)
{
objChildFamily.MsgEndDate = rdpMsgEndDate.SelectedDate.Value;
}
objChildFamily.MsgDisplayed = txtMessage.Text.Trim();
objChildFamily.Comments = txtComments.Text.Trim();
objChildFamily.Active = chkActive.Checked;
if (Session["StaffId"] != null)
{
objChildFamily.LastModifiedById = new Guid(Session["StaffId"].ToString());
}
objChildFamily.lstFamily = new List <DayCarePL.FamilyDataProperties>();
//Family Data Guardian 1
objFamilyData = new DayCarePL.FamilyDataProperties();
if (!string.IsNullOrEmpty(Guardian1FamilyId))
{
objFamilyData.Id = new Guid(Guardian1FamilyId);
}
objFamilyData.FirstName = txtFirstNameGuardian1.Text.Trim();
objFamilyData.LastName = txtLastNameGuardian1.Text.Trim();
if (!ddlRelationshipGuardian1.SelectedValue.Equals(DayCarePL.Common.GUID_DEFAULT))
{
objFamilyData.RelationShipId = new Guid(ddlRelationshipGuardian1.SelectedValue);
}
objFamilyData.Email = txtEmailGuardian1.Text.Trim();
if (fupImageGuardian1.HasFile)
{
objFamilyData.Photo = Path.GetExtension(fupImageGuardian1.FileName);
}
else
{
if (!string.IsNullOrEmpty(lblImageGuardian1.Text))
{
objFamilyData.Photo = Path.GetExtension(lblImageGuardian1.Text);
}
else
{
objFamilyData.Photo = string.Empty;
}
}
if (!string.IsNullOrEmpty(txtPhone1Guardian1.Text.Trim()))
{
objFamilyData.Phone1Type = ddlPhoneType1Guardian1.SelectedValue;
objFamilyData.Phone1 = txtPhone1Guardian1.Text.Trim();
}
if (!string.IsNullOrEmpty(txtPhone2Guardian1.Text.Trim()))
{
objFamilyData.Phone2Type = ddPhoneType2Guardian1.SelectedValue;
objFamilyData.Phone2 = txtPhone2Guardian1.Text.Trim();
}
objFamilyData.GuardianIndex = 1;
if (Session["StaffId"] != null)
{
objFamilyData.LastModifiedById = new Guid(Session["StaffId"].ToString());
}
objChildFamily.lstFamily.Add(objFamilyData);
//Family Data Guardian 2
//if (!string.IsNullOrEmpty(txtFirstNameGuardian2.Text.Trim()) && !string.IsNullOrEmpty(txtEmailGuardian2.Text.Trim()) && ddlRelationshipGuardian2.SelectedIndex > 0 && !string.IsNullOrEmpty(txtLastNameGuardian2.Text.Trim()))
if (!string.IsNullOrEmpty(txtFirstNameGuardian2.Text.Trim()) && !string.IsNullOrEmpty(txtLastNameGuardian2.Text.Trim()))
{
objFamilyData = new DayCarePL.FamilyDataProperties();
if (!string.IsNullOrEmpty(Guardian2FamilyId))
{
objFamilyData.Id = new Guid(Guardian2FamilyId);
}
objFamilyData.FirstName = txtFirstNameGuardian2.Text.Trim();
objFamilyData.LastName = txtLastNameGuardian2.Text.Trim();
if (!ddlRelationshipGuardian2.SelectedValue.Equals(DayCarePL.Common.GUID_DEFAULT))
{
objFamilyData.RelationShipId = new Guid(ddlRelationshipGuardian2.SelectedValue);
}
objFamilyData.Email = txtEmailGuardian2.Text.Trim();
if (fupImageGuardian1.HasFile)
{
objFamilyData.Photo = Path.GetExtension(fupImageGuardian2.FileName);
}
else
{
if (!string.IsNullOrEmpty(lblImageGuardian2.Text))
{
objFamilyData.Photo = Path.GetExtension(lblImageGuardian2.Text);
}
else
{
objFamilyData.Photo = string.Empty;
}
}
if (!string.IsNullOrEmpty(txtPhone1Guardian2.Text.Trim()))
{
objFamilyData.Phone1Type = ddlPhoneType1Guardian2.SelectedValue;
objFamilyData.Phone1 = txtPhone1Guardian2.Text.Trim();
}
if (!string.IsNullOrEmpty(txtPhone2Guardian2.Text.Trim()))
{
objFamilyData.Phone2Type = ddlPhoneType2Guardian2.SelectedValue;
objFamilyData.Phone2 = txtPhone2Guardian2.Text.Trim();
}
objFamilyData.GuardianIndex = 2;
if (Session["StaffId"] != null)
{
objFamilyData.LastModifiedById = new Guid(Session["StaffId"].ToString());
}
objChildFamily.lstFamily.Add(objFamilyData);
}
else
{
string ErrorMsg = "";
if (!string.IsNullOrEmpty(txtFirstNameGuardian2.Text.Trim()))
{
if (string.IsNullOrEmpty(txtLastNameGuardian2.Text.Trim()))
{
ErrorMsg = "- Please enter Guardian 2 Last Name\\n";
//MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
//MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Please enter Guardian 2 Last Name", "false"));
//return;
}
//if (ddlRelationshipGuardian2.SelectedIndex == 0)
//{
// ErrorMsg += "- Please enter Guardian 2 Relationship\\n";
// //MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
// //MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Please enter Guardian 2 Relationship", "false"));
// //return;
//}
//if (string.IsNullOrEmpty(txtEmailGuardian2.Text))
//{
// ErrorMsg += "- Please enter Guardian 2 Email\\n";
//}
if (!string.IsNullOrEmpty(ErrorMsg))
{
MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", ErrorMsg, "false"));
return;
}
}
}
objChildFamily.SchoolYearId = new Guid(Session["CurrentSchoolYearId"].ToString());
ChildFamilyId = proxyChildFamily.Save(objChildFamily);
if (!ChildFamilyId.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
if (fupImageGuardian1.HasFile)
{
fupImageGuardian1.SaveAs(Server.MapPath("~/FamilyImages/" + ChildFamilyId + "_1" + Path.GetExtension(fupImageGuardian1.FileName)));
}
if (fupImageGuardian2.HasFile)
{
fupImageGuardian2.SaveAs(Server.MapPath("~/FamilyImages/" + ChildFamilyId + "_2" + Path.GetExtension(fupImageGuardian2.FileName)));
}
MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Saved Successfully", "false"));
if (ViewState["ChildFamilyId"] == null)
{
Session["FamilyInfoMessage"] = true;
Response.Redirect("FamilyInfo.aspx?ChildFamilyId=" + ChildFamilyId + "", false);
}
else
{
rgChildData.Rebind();
LoadFamilyData(new Guid(ViewState["ChildFamilyId"].ToString()));
}
//else
//{
// Response.Redirect("ChildFamily.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.FamilyInfo, "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 static DayCarePL.ChildFamilyProperties LoadChildFamilyById(Guid Id, Guid CurrentSchoolyearId)
{
clConnection.DoConnection();
DayCareDataContext db = new DayCareDataContext();
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clChildFamily, "LoadChildFamilyById", "Execute LoadChildFamilyById Method", DayCarePL.Common.GUID_DEFAULT);
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clChildFamily, "LoadChildFamilyById", "Debug LoadChildFamilyById Method", DayCarePL.Common.GUID_DEFAULT);
DayCarePL.ChildFamilyProperties objChildFamilyId = null;
SortedList sl = new SortedList();
sl.Add("@Id", Id);
sl.Add("@CurrentSchoolyearId", CurrentSchoolyearId);
objChildFamilyId = new DayCarePL.ChildFamilyProperties();
objChildFamilyId.lstFamily = new List <DayCarePL.FamilyDataProperties>();
DayCarePL.FamilyDataProperties objFamilyData;
var data = db.spGetChildFamilyById(Id, CurrentSchoolyearId);
foreach (var d in data)
{
if (objChildFamilyId.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
objChildFamilyId.Id = d.ChildFamilyId;
objChildFamilyId.SchoolId = d.SchoolId;
objChildFamilyId.FamilyTitle = d.FamilyTitle;
objChildFamilyId.UserName = d.UserName;
objChildFamilyId.Password = d.Password;
objChildFamilyId.Code = d.Code;
objChildFamilyId.Address1 = d.Address1;
objChildFamilyId.Address2 = d.Address2;
objChildFamilyId.City = d.City;
objChildFamilyId.StateId = d.StateId;
objChildFamilyId.Zip = d.Zip;
objChildFamilyId.HomePhone = d.HomePhone;
objChildFamilyId.Comments = d.Comments;
objChildFamilyId.Active = d.Active;
objChildFamilyId.MsgDisplayed = d.MsgDisplayed;
objChildFamilyId.MsgStartDate = d.MsgStartDate;
objChildFamilyId.MsgEndDate = d.MsgEndDate;
objChildFamilyId.MsgActive = d.MsgActive;
objChildFamilyId.CreatedById = d.ChildFamilyCreatedById;
objChildFamilyId.CreatedDateTime = d.ChildFamilyCreateDateTime;
objChildFamilyId.LastModifiedById = d.ChildFamilyLastModifiedById;
objChildFamilyId.LastModifiedDatetime = d.ChildFamilyLastModifiedDateTime;
}
objFamilyData = new DayCarePL.FamilyDataProperties();
objFamilyData.Id = d.FamilyDataId;
objFamilyData.RelationShipId = d.RelationShipId;
objFamilyData.FirstName = d.FamilyFirstName;
objFamilyData.LastName = d.FamilyLastName;
objFamilyData.Email = d.Email;
objFamilyData.Phone1Type = d.FamilyPhone1Type;
objFamilyData.Phone1 = d.FamilyPhone1;
objFamilyData.Phone2Type = d.FamilyPhone2Type;
objFamilyData.Phone2 = d.FamilyPhone2;
objFamilyData.Photo = d.Photo;
objFamilyData.GuardianIndex = d.Guardian;
objFamilyData.CreatedById = d.FamilyCreatedById;
objFamilyData.CreatedDateTime = d.FamilyCreateDateTime;
objFamilyData.LastModifiedById = d.FamilyLastModifiedById;
objFamilyData.LastModifiedDatetime = d.FamilyLastModifiedDateTime;
objChildFamilyId.lstFamily.Add(objFamilyData);
}
return(objChildFamilyId);
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clChildFamily, "LoadChildFamilyById", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
return(null);
}
}
public static List <DayCarePL.ChildFamilyProperties> LoadChildFamily(Guid SchoolId, Guid SchoolYearId)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clChildFamily, "LoadChildFamily", "Execute LoadChildFamily Method", DayCarePL.Common.GUID_DEFAULT);
try
{
clConnection.DoConnection();
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clChildFamily, "LoadChildFamily", "Debug LoadChildFamily Method", DayCarePL.Common.GUID_DEFAULT);
DayCarePL.ChildFamilyProperties objChildFamily = null;
List <DayCarePL.ChildFamilyProperties> lstChildFamily = new List <DayCarePL.ChildFamilyProperties>();
SortedList sl = new SortedList();
sl.Add("@SchoolID", SchoolId);
sl.Add("@SchoolYearId", SchoolYearId);
DataSet ds = clConnection.GetDataSet("spGetChildFamily", sl);
if (ds != null && ds.Tables.Count > 0)
{
for (int iRow = 0; iRow < ds.Tables[0].Rows.Count; iRow++)
{
objChildFamily = new DayCarePL.ChildFamilyProperties();
objChildFamily.Id = new Guid(ds.Tables[0].Rows[iRow]["Id"].ToString());
objChildFamily.ChildFamilyId = objChildFamily.Id;
objChildFamily.FamilyTitle = ds.Tables[0].Rows[iRow]["FamilyTitle"].ToString();
objChildFamily.UserName = Convert.ToString(ds.Tables[0].Rows[iRow]["UserName"]);
if (Convert.ToString(ds.Tables[0].Rows[iRow]["ChildName"]).Length > 0)
{
objChildFamily.ChildName = "[ " + Convert.ToString(ds.Tables[0].Rows[iRow]["ChildName"]).Substring(0, ds.Tables[0].Rows[iRow]["ChildName"].ToString().LastIndexOf(", ")) + " ]";
}
objChildFamily.Password = Convert.ToString(ds.Tables[0].Rows[iRow]["Password"]);
objChildFamily.Code = Convert.ToString(ds.Tables[0].Rows[iRow]["Code"]);
objChildFamily.Address1 = Convert.ToString(ds.Tables[0].Rows[iRow]["Address1"]);
objChildFamily.Address2 = Convert.ToString(ds.Tables[0].Rows[iRow]["Address2"]);
objChildFamily.City = Convert.ToString(ds.Tables[0].Rows[iRow]["City"]);
objChildFamily.StateId = Convert.ToString(ds.Tables[0].Rows[iRow]["StateId"]).Trim() == "" ? new Guid(DayCarePL.Common.GUID_DEFAULT) : new Guid(Convert.ToString(ds.Tables[0].Rows[iRow]["StateId"]));
objChildFamily.Zip = Convert.ToString(ds.Tables[0].Rows[iRow]["Zip"]);
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[iRow]["HomePhone"].ToString()))
{
objChildFamily.HomePhone = Convert.ToString(ds.Tables[0].Rows[iRow]["HomePhone"]);
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[iRow]["Email"].ToString()))
{
objChildFamily.Email = Convert.ToString(ds.Tables[0].Rows[iRow]["Email"]);
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[iRow]["ChildFamilyActive"].ToString()))
{
objChildFamily.Active = Convert.ToBoolean(ds.Tables[0].Rows[iRow]["ChildFamilyActive"]);
}
objChildFamily.Comments = Convert.ToString(ds.Tables[0].Rows[iRow]["Comments"]);
objChildFamily.MsgDisplayed = ds.Tables[0].Rows[iRow]["MsgDisplayed"].ToString();
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[iRow]["MsgStartDate"].ToString()))
{
objChildFamily.MsgStartDate = Convert.ToDateTime(ds.Tables[0].Rows[iRow]["MsgStartDate"].ToString());
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[iRow]["MsgEndDate"].ToString()))
{
objChildFamily.MsgEndDate = Convert.ToDateTime(ds.Tables[0].Rows[iRow]["MsgEndDate"].ToString());
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[iRow]["MsgActive"].ToString()))
{
objChildFamily.MsgActive = Convert.ToBoolean(ds.Tables[0].Rows[iRow]["MsgActive"].ToString());
}
lstChildFamily.Add(objChildFamily);
objChildFamily = null;
}
}
return(lstChildFamily);
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clChildFamily, "LoadChildFamily", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
return(null);
}
}
public static Guid Save(DayCarePL.ChildFamilyProperties objChildFamily)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clChildFamily, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
clConnection.DoConnection();
SqlConnection conn = clConnection.CreateConnection();
SqlTransaction tran = null;
Guid result = new Guid();
bool FamilyResult = false;
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clChildFamily, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
clConnection.OpenConnection(conn);
tran = conn.BeginTransaction();
SqlCommand cmd;
if (objChildFamily.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
cmd = clConnection.CreateCommand("spAddChildFamily", conn);
cmd.Parameters.Add(clConnection.GetInputParameter("@CreatedDateTime", DateTime.Now));
cmd.Parameters.Add(clConnection.GetInputParameter("@CreatedById", objChildFamily.CreatedById));
cmd.Parameters.Add(clConnection.GetInputParameter("@SchoolYearId", objChildFamily.SchoolYearId));
}
else
{
cmd = clConnection.CreateCommand("spUpdateChildFamily", conn);
cmd.Parameters.Add(clConnection.GetInputParameter("@Id", objChildFamily.Id));
cmd.Parameters.Add(clConnection.GetInputParameter("@SchoolYearId", objChildFamily.SchoolYearId));
//cmd.Parameters.Add(clConnection.GetInputParameter("@ChildFamilyId", objFamilyData.ChildFamilyId));
}
//ChildFamily
cmd.Transaction = tran;
cmd.Parameters.Add(clConnection.GetInputParameter("@SchoolId", objChildFamily.SchoolId));
cmd.Parameters.Add(clConnection.GetInputParameter("@FamilyTitle", objChildFamily.FamilyTitle));
cmd.Parameters.Add(clConnection.GetInputParameter("@UserName", objChildFamily.UserName));
cmd.Parameters.Add(clConnection.GetInputParameter("@Password", objChildFamily.Password));
cmd.Parameters.Add(clConnection.GetInputParameter("@Code", objChildFamily.Code));
cmd.Parameters.Add(clConnection.GetInputParameter("@Address1", objChildFamily.Address1));
cmd.Parameters.Add(clConnection.GetInputParameter("@Address2", objChildFamily.Address2));
cmd.Parameters.Add(clConnection.GetInputParameter("@City", objChildFamily.City));
cmd.Parameters.Add(clConnection.GetInputParameter("@StateId", objChildFamily.StateId));
cmd.Parameters.Add(clConnection.GetInputParameter("@Zip", objChildFamily.Zip));
cmd.Parameters.Add(clConnection.GetInputParameter("@HomePhone", objChildFamily.HomePhone));
cmd.Parameters.Add(clConnection.GetInputParameter("@Comments", objChildFamily.Comments));
cmd.Parameters.Add(clConnection.GetInputParameter("@Active", objChildFamily.Active));
cmd.Parameters.Add(clConnection.GetInputParameter("@MsgDisplayed", objChildFamily.MsgDisplayed));
cmd.Parameters.Add(clConnection.GetInputParameter("@MsgStartDate", objChildFamily.MsgStartDate));
cmd.Parameters.Add(clConnection.GetInputParameter("@MsgEndDate", objChildFamily.MsgEndDate));
cmd.Parameters.Add(clConnection.GetInputParameter("@MsgActive", objChildFamily.MsgActive));
cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedDatetime", DateTime.Now));
cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedById", objChildFamily.LastModifiedById));
cmd.Parameters.Add(clConnection.GetOutputParameter("@status", SqlDbType.Bit));
if (objChildFamily.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
cmd.Parameters.Add(clConnection.GetOutputParameter("@Id", SqlDbType.UniqueIdentifier));
}
cmd.ExecuteNonQuery();
if (Convert.ToBoolean(cmd.Parameters["@status"].Value))
{
if (objChildFamily.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
if (!cmd.Parameters["@Id"].Value.Equals(DayCarePL.Common.GUID_DEFAULT))
{
result = new Guid(cmd.Parameters["@Id"].Value.ToString());
}
else
{
result = new Guid(DayCarePL.Common.GUID_DEFAULT);
}
}
else
{
result = objChildFamily.Id;
}
}
else
{
result = new Guid(DayCarePL.Common.GUID_DEFAULT);
}
//FamilyData
if (!result.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
foreach (DayCarePL.FamilyDataProperties objFamilyData in objChildFamily.lstFamily)
{
if (objFamilyData.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
cmd = clConnection.CreateCommand("spAddFamilyData", conn);
cmd.Parameters.Add(clConnection.GetInputParameter("@CreatedDateTime", DateTime.Now));
cmd.Parameters.Add(clConnection.GetInputParameter("@CreatedById", objChildFamily.CreatedById));
}
else
{
cmd = clConnection.CreateCommand("spUpdateFamilyData", conn);
cmd.Parameters.Add(clConnection.GetInputParameter("@Id", objFamilyData.Id));
}
cmd.Transaction = tran;
cmd.Parameters.Add(clConnection.GetInputParameter("@RelationShipId", objFamilyData.RelationShipId));
cmd.Parameters.Add(clConnection.GetInputParameter("@ChildFamilyId", result));
cmd.Parameters.Add(clConnection.GetInputParameter("@FirstName", objFamilyData.FirstName));
cmd.Parameters.Add(clConnection.GetInputParameter("@LastName", objFamilyData.LastName));
cmd.Parameters.Add(clConnection.GetInputParameter("@Phone1", objFamilyData.Phone1));
cmd.Parameters.Add(clConnection.GetInputParameter("@Phone1Type", objFamilyData.Phone1Type));
cmd.Parameters.Add(clConnection.GetInputParameter("@Phone2", objFamilyData.Phone2));
cmd.Parameters.Add(clConnection.GetInputParameter("@Phone2Type", objFamilyData.Phone2Type));
cmd.Parameters.Add(clConnection.GetInputParameter("@Email", objFamilyData.Email));
cmd.Parameters.Add(clConnection.GetInputParameter("@Photo", objFamilyData.Photo));
cmd.Parameters.Add(clConnection.GetInputParameter("@Guardian", objFamilyData.GuardianIndex));
cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedDatetime", DateTime.Now));
cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedById", objFamilyData.LastModifiedById));
cmd.Parameters.Add(clConnection.GetOutputParameter("@status", SqlDbType.Bit));
cmd.ExecuteNonQuery();
if (!Convert.ToBoolean(cmd.Parameters["@status"].Value))
{
// tran.Rollback();
FamilyResult = false;
break;
}
else
{
FamilyResult = true;
}
}
if (FamilyResult)
{
tran.Commit();
}
else
{
result = new Guid(DayCarePL.Common.GUID_DEFAULT);
tran.Rollback();
}
}
else
{
result = new Guid(DayCarePL.Common.GUID_DEFAULT);
tran.Rollback();
}
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clChildFamily, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
result = new Guid(DayCarePL.Common.GUID_DEFAULT);
if (tran != null)
{
tran.Rollback();
}
}
finally
{
clConnection.CloseConnection(conn);
}
return(result);
}
