public static DayCarePL.ProgScheduleProperties CheckBeginTimeAndEndTime(Guid SchoolId, Int32 DayIndex, DateTime BeginTime, DateTime EndTime) { bool result = false; DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clProgSchedule, "CheckBeginTimeAndEndTime", "Execute CheckBeginTimeAndEndTime Method", DayCarePL.Common.GUID_DEFAULT); clConnection.DoConnection(); DayCarePL.ProgScheduleProperties objProgSchedule = null; DayCareDataContext db = new DayCareDataContext(); try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clProgSchedule, "CheckBeginTimeAndEndTime", "Debug CheckBeginTimeAndEndTime Method", DayCarePL.Common.GUID_DEFAULT); var data = db.spGetCheckBeginTimeAndEndTimeInHoursOfOpration(DayIndex, SchoolId, BeginTime, EndTime); foreach (var c in data) { result = true; objProgSchedule = new DayCarePL.ProgScheduleProperties(); break; } return(objProgSchedule); } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clProgSchedule, "CheckBeginTimeAndEndTime", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); return(null); } }
public static DayCarePL.ProgScheduleProperties CheckDuplicateProgClassRoom(Guid ClassRoomId, DateTime BeginTime, DateTime EndTime, Int32 DayIndex, Guid Id) { bool result = false; DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clProgSchedule, "CheckDuplicateProgClassRoom", "Execute CheckDuplicateProgClassRoom Method", DayCarePL.Common.GUID_DEFAULT); clConnection.DoConnection(); DayCarePL.ProgScheduleProperties objProgSchedule = null; DayCareDataContext db = new DayCareDataContext(); try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clProgSchedule, "CheckDuplicateProgClassRoom", "Debug CheckDuplicateProgClassRoom Method", DayCarePL.Common.GUID_DEFAULT); var data = db.spGetCheckDuplicateProgClassRoomId(ClassRoomId, BeginTime, EndTime, DayIndex, Id); foreach (var c in data) { result = true; objProgSchedule = new DayCarePL.ProgScheduleProperties(); objProgSchedule.SchoolProgramTitle = c.Program; objProgSchedule.ProgClassRoomTitle = c.ClassRoomTitle; objProgSchedule.BeginTime = c.BeginTime; objProgSchedule.EndTime = c.EndTime; objProgSchedule.Day = c.Day; break; } return(objProgSchedule); } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clProgSchedule, "CheckDuplicateProgClassRoom", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); return(null); } }
public static bool Save(DayCarePL.ProgScheduleProperties objProgSchedule) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clProgSchedule, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT); SqlConnection conn = clConnection.CreateConnection(); try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clProgSchedule, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT); clConnection.OpenConnection(conn); SqlCommand cmd; if (objProgSchedule.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT)) { cmd = clConnection.CreateCommand("spAddProgSchedule", conn); cmd.Parameters.Add(clConnection.GetInputParameter("@CreatedDateTime", DateTime.Now)); cmd.Parameters.Add(clConnection.GetInputParameter("@CreatedById", objProgSchedule.CreatedById)); } else { cmd = clConnection.CreateCommand("spUpdateProgSchedule", conn); } if (!objProgSchedule.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT)) { cmd.Parameters.Add(clConnection.GetInputParameter("@Id", objProgSchedule.Id)); } cmd.Parameters.Add(clConnection.GetInputParameter("@ProgClassRoomId", objProgSchedule.ProgClassRoomId)); cmd.Parameters.Add(clConnection.GetInputParameter("@SchoolProgramId", objProgSchedule.SchoolProgramId)); cmd.Parameters.Add(clConnection.GetInputParameter("@Day", objProgSchedule.Day)); cmd.Parameters.Add(clConnection.GetInputParameter("@BeginTime", objProgSchedule.BeginTime)); cmd.Parameters.Add(clConnection.GetInputParameter("@EndTime", objProgSchedule.EndTime)); cmd.Parameters.Add(clConnection.GetInputParameter("@Active", objProgSchedule.Active)); cmd.Parameters.Add(clConnection.GetInputParameter("@DayIndex", objProgSchedule.DayIndex)); cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedById", objProgSchedule.LastModifiedById)); cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedDateTime", DateTime.Now)); cmd.Parameters.Add(clConnection.GetOutputParameter("@status", SqlDbType.Bit)); cmd.ExecuteNonQuery(); if (Convert.ToBoolean(cmd.Parameters["@status"].Value)) { return(true); } return(false); } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clProgSchedule, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); return(false); } finally { clConnection.CloseConnection(conn); } }
protected void rgProgSchedule_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e) { if (e.Item.ItemType == GridItemType.AlternatingItem || e.Item.ItemType == GridItemType.Item) { Label lblSchoolProgram = e.Item.FindControl("lblSchoolProgram") as Label; } if (e.Item.ItemType == GridItemType.EditItem) { GridEditableItem itm = e.Item as GridEditableItem; DayCarePL.ProgScheduleProperties objProgSchedule = e.Item.DataItem as DayCarePL.ProgScheduleProperties; DropDownList ddlDay = itm["Day"].Controls[1] as DropDownList; // Label lblay = e.Item.FindControl("lblDay") as Label; DropDownList ddlSchoolProgram = e.Item.FindControl("ddlSchoolProgram") as DropDownList; Guid SchoolId = new Guid(); RadTimePicker rdOpenTp = e.Item.FindControl("rdBiginTp") as RadTimePicker; RadTimePicker rdCloseTp = e.Item.FindControl("rdCloseTp") as RadTimePicker; Label lblSchoolProgram = e.Item.FindControl("lblSchoolProgram") as Label; DropDownList ddlProgClassRoom = itm["ProgClassRoom"].Controls[1] as DropDownList; if (ddlProgClassRoom != null) { Common.BindProgClassRoom(ddlProgClassRoom, new Guid(ViewState["SchoolProgramId"].ToString())); if (e.Item.ItemIndex != -1) { DayCarePL.ProgScheduleProperties dataItem = e.Item.DataItem as DayCarePL.ProgScheduleProperties; ddlProgClassRoom.SelectedValue = dataItem.ProgClassRoomId.ToString(); } } if (ddlSchoolProgram != null) { ddlSchoolProgram.Items.Add(new ListItem("--select--", DayCarePL.Common.GUID_DEFAULT)); } if (objProgSchedule != null) { if (ddlDay != null && ddlDay.Items.Count > 0) { ddlDay.SelectedValue = objProgSchedule.DayIndex.ToString(); } if (rdOpenTp != null) { rdOpenTp.SelectedDate = objProgSchedule.BeginTime; } if (rdCloseTp != null) { rdCloseTp.SelectedDate = objProgSchedule.EndTime; } } } }
public static List <DayCarePL.ProgScheduleProperties> LoadProgScheduleForChildSchedule(Guid SchoolId, Guid SchoolProgramId) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clProgSchedule, "LoadProgScheduleForChildSchedule", "Execute LoadProgScheduleForChildSchedule Method", DayCarePL.Common.GUID_DEFAULT); clConnection.DoConnection(); DayCareDataContext db = new DayCareDataContext(); try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clProgSchedule, "LoadProgScheduleForChildSchedule", "Debug LoadProgScheduleForChildSchedule Method", DayCarePL.Common.GUID_DEFAULT); List <DayCarePL.ProgScheduleProperties> lstProgSchedule = new List <DayCarePL.ProgScheduleProperties>(); DayCarePL.ProgScheduleProperties objProgSchedule; var data = db.spGetProgScheduleForChildSchedule(SchoolProgramId); foreach (var d in data) { objProgSchedule = new DayCarePL.ProgScheduleProperties(); objProgSchedule.Id = d.Id; objProgSchedule.Day = d.Day; objProgSchedule.BeginTime = d.BeginTime; if (d.EndTime != null) { objProgSchedule.EndTime = d.EndTime; } objProgSchedule.ClassRoomName = d.ClassRoomName; objProgSchedule.FullName = d.FullName; objProgSchedule.ProgClassRoomId = d.ProgClassRoomId.Value; lstProgSchedule.Add(objProgSchedule); } return(lstProgSchedule); } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clProgSchedule, "LoadProgScheduleForChildSchedule", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); return(null); } }
public static List <DayCarePL.ProgScheduleProperties> LoadProgClassRoom(Guid SchoolProgramId) { DayCareDataContext db = new DayCareDataContext(); List <DayCarePL.ProgScheduleProperties> lstProgSchedule = new List <DayCarePL.ProgScheduleProperties>(); DayCarePL.ProgScheduleProperties objProgSchedule = null; try { var data = db.spGetProgClassRoomIdAndClassRoomName(SchoolProgramId); foreach (var d in data) { objProgSchedule = new DayCarePL.ProgScheduleProperties(); objProgSchedule.Id = d.Id; objProgSchedule.ProgClassRoomTitle = d.ClassRoomTitle; objProgSchedule.ClassRoomId = d.ClassRoomId; lstProgSchedule.Add(objProgSchedule); //objProgSchedule = null; } } catch (Exception ex) { } return(lstProgSchedule); }
public bool Save(DayCarePL.ProgScheduleProperties objProgSchedule) { return(DayCareDAL.clProgSchedule.Save(objProgSchedule)); }
public bool SubmitRecord(object source, Telerik.Web.UI.GridCommandEventArgs e) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.ClassRoom, "SubmitRecord", "Submit record method called", DayCarePL.Common.GUID_DEFAULT); bool result = false; try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.ClassRoom, "SubmitRecord", " Debug Submit record method called of ClassRoom", DayCarePL.Common.GUID_DEFAULT); DayCareBAL.ProgScheduleService proxyProgSchedule = new DayCareBAL.ProgScheduleService(); DayCarePL.ProgScheduleProperties objProgSchedule = new DayCarePL.ProgScheduleProperties(); GridDataItem item = (GridDataItem)e.Item; var InsertItem = e.Item as Telerik.Web.UI.GridEditableItem; Telerik.Web.UI.GridEditManager editMan = InsertItem.EditManager; if (InsertItem != null) { foreach (GridColumn column in e.Item.OwnerTableView.RenderColumns) { if (column is GridEditableColumn) { IGridEditableColumn editTableColumn = (column as IGridEditableColumn); if (editTableColumn.IsEditable) { IGridColumnEditor editor = editMan.GetColumnEditor(editTableColumn); switch (column.UniqueName) { case "SchoolProgram": { objProgSchedule.SchoolProgramId = new Guid(ViewState["SchoolProgramId"].ToString()); break; } case "Day": { objProgSchedule.Day = (item["Day"].Controls[1] as DropDownList).SelectedItem.ToString(); objProgSchedule.DayIndex = Convert.ToInt32((item["Day"].Controls[1] as DropDownList).SelectedValue); break; } case "BeginTime": { if ((e.Item.FindControl("rdBiginTp") as RadTimePicker).SelectedDate != null) { objProgSchedule.BeginTime = (e.Item.FindControl("rdBiginTp") as RadTimePicker).SelectedDate; } break; } case "CloseTime": { if ((e.Item.FindControl("rdCloseTp") as RadTimePicker).SelectedDate != null) { objProgSchedule.EndTime = (e.Item.FindControl("rdCloseTp") as RadTimePicker).SelectedDate; } break; } case "Active": { objProgSchedule.Active = (editor as GridCheckBoxColumnEditor).Value; break; } case "ProgClassRoom": { objProgSchedule.ProgClassRoomId = new Guid((item["ProgClassRoom"].Controls[1] as DropDownList).SelectedValue); DayCareBAL.ProgClassRoomService proxyClassroom = new DayCareBAL.ProgClassRoomService(); objProgSchedule.ClassRoomId = proxyClassroom.LoadProgClassRoom(new Guid(Session["SchoolId"].ToString()), new Guid(ViewState["SchoolProgramId"].ToString())).FirstOrDefault(u => u.Id.Equals(objProgSchedule.ProgClassRoomId)).ClassRoomId.Value; break; } } } } } if (objProgSchedule.BeginTime != null && objProgSchedule.EndTime != null) { if (objProgSchedule.BeginTime > objProgSchedule.BeginTime) { MasterAjaxManager = this.Page.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Begin Time must be less than End Time.", "false")); return(false); } } else { MasterAjaxManager = this.Page.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Begin Time/End Time is not valid.", "false")); return(false); } if (e.CommandName != "PerformInsert") { if (Session["StaffId"] != null) { objProgSchedule.LastModifiedById = new Guid(Session["StaffId"].ToString()); } objProgSchedule.Id = new Guid(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["Id"].ToString()); } else { if (Session["StaffId"] != null) { objProgSchedule.CreatedById = new Guid(Session["StaffId"].ToString()); objProgSchedule.LastModifiedById = new Guid(Session["StaffId"].ToString()); } } DropDownList ddlClassRoom = e.Item.FindControl("ddlProgClassRoom") as DropDownList; if (ddlClassRoom.SelectedIndex == 0) { MasterAjaxManager = this.Page.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Select ClassRoom.", "false")); return(false); } else { hdnName.Value = ""; DayCarePL.ProgScheduleProperties objCheck = proxyProgSchedule.CheckDuplicateProgClassRoom(objProgSchedule.ClassRoomId, Convert.ToDateTime(objProgSchedule.BeginTime), Convert.ToDateTime(objProgSchedule.EndTime), Convert.ToInt32(objProgSchedule.DayIndex), objProgSchedule.Id); DayCarePL.ProgScheduleProperties objResult = proxyProgSchedule.CheckBeginTimeAndEndTime(new Guid(Session["SchoolId"].ToString()), objProgSchedule.DayIndex, Convert.ToDateTime(objProgSchedule.BeginTime), Convert.ToDateTime(objProgSchedule.EndTime)); if (objResult == null) { MasterAjaxManager = this.Page.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "BeginTime And EndTime Does not Match Hours Of Opration OpenTime And CloseTime", "false")); return(false); } if (objCheck != null) { MasterAjaxManager = this.Page.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "" + objCheck.SchoolProgramTitle + " (program) already assigned to " + objCheck.ProgClassRoomTitle + " (class room) from " + Convert.ToDateTime(objCheck.BeginTime).ToShortTimeString() + " to " + Convert.ToDateTime(objCheck.EndTime).ToShortTimeString() + ".", "false")); return(false); } else { result = proxyProgSchedule.Save(objProgSchedule); if (result == true) { MasterAjaxManager = this.Page.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Saved Successfully", "false")); } } } } } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.HoursOfOperation, "SubmitRecord", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); result = false; } return(result); }
public static List <DayCarePL.ProgScheduleProperties> LoadProgSchedule(Guid SchoolId, Guid SchoolProgramId) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clProgSchedule, "LoadProgSchedule", "Execute LoadProgSchedule Method", DayCarePL.Common.GUID_DEFAULT); SqlConnection conn = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["daycareConnectionString"].ToString()); try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clProgSchedule, "LoadProgSchedule", "Debug LoadProgSchedule Method", DayCarePL.Common.GUID_DEFAULT); List <DayCarePL.ProgScheduleProperties> lstProgSchedule = new List <DayCarePL.ProgScheduleProperties>(); DayCarePL.ProgScheduleProperties objProgSchedule; if (conn.State == System.Data.ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand(); cmd.CommandText = "spGetProgScheduleList"; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Connection = conn; cmd.Parameters.Add(new SqlParameter("@SchoolId", SqlDbType.UniqueIdentifier)).Value = SchoolId; cmd.Parameters.Add(new SqlParameter("@SchoolProgramId", SqlDbType.UniqueIdentifier)).Value = SchoolProgramId; SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { objProgSchedule = new DayCarePL.ProgScheduleProperties(); objProgSchedule.Id = new Guid(dr["Id"].ToString()); objProgSchedule.SchoolProgramId = new Guid(dr["SchoolProgramId"].ToString()); objProgSchedule.SchoolProgramTitle = dr["Title"].ToString(); objProgSchedule.Day = dr["Day"].ToString(); objProgSchedule.DayIndex = Convert.ToInt16(dr["DayIndex"].ToString()); objProgSchedule.BeginTime = Convert.ToDateTime(dr["BeginTime"].ToString()); objProgSchedule.ClassRoomName = Convert.ToString(dr["ClasroomTitle"]); objProgSchedule.ProgClassRoomId = new Guid(dr["ProgClassRoomId"].ToString()); if (dr["EndTime"] != DBNull.Value) { objProgSchedule.EndTime = Convert.ToDateTime(dr["EndTime"].ToString()); } objProgSchedule.Active = Convert.ToBoolean(dr["Active"].ToString()); if (dr["CreatedById"] != DBNull.Value) { objProgSchedule.CreatedById = new Guid(dr["CreatedById"].ToString()); } if (dr["CreatedDateTime"] != DBNull.Value) { objProgSchedule.CreatedDateTime = Convert.ToDateTime(dr["CreatedDateTime"].ToString()); } if (dr["LastModifiedById"] != DBNull.Value) { objProgSchedule.LastModifiedById = new Guid(dr["LastModifiedById"].ToString()); } if (dr["LastModifiedDatetime"] != DBNull.Value) { objProgSchedule.LastModifiedDatetime = Convert.ToDateTime(dr["LastModifiedDatetime"].ToString()); } lstProgSchedule.Add(objProgSchedule); } return(lstProgSchedule); } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clProgSchedule, "LoadProgSchedule", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); return(null); } }