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