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