protected void rgChildEnrollmentStatus_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e) { if (e.Item.ItemType == Telerik.Web.UI.GridItemType.EditItem) { DropDownList ddlEnrollmentStatus = e.Item.FindControl("ddlEnrollmentStatus") as DropDownList; RadDatePicker rdpEnrollmentDate = e.Item.FindControl("rdpEnrollmentDate") as RadDatePicker; if (ddlEnrollmentStatus != null) { Common.BindEnrollmentStatus(ddlEnrollmentStatus, new Guid(Session["SchoolId"].ToString())); if (e.Item.ItemIndex != -1) { DayCarePL.ChildEnrollmentStatusProperties dataItem = e.Item.DataItem as DayCarePL.ChildEnrollmentStatusProperties; ddlEnrollmentStatus.SelectedValue = dataItem.EnrollmentStatusId.ToString(); } } if (rdpEnrollmentDate != null) { DayCarePL.ChildEnrollmentStatusProperties dataItem = e.Item.DataItem as DayCarePL.ChildEnrollmentStatusProperties; if (dataItem != null) { rdpEnrollmentDate.SelectedDate = dataItem.EnrollmentDate; } } } }
public static List <DayCarePL.ChildEnrollmentStatusProperties> LoadChildEnrollmentStatus(Guid SchoolId, Guid ChildSchoolYearId) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clChildEnrollmentStatus, "LoadChildEnrollmentStatus", "Execute LoadChildEnrollmentStatus Method", DayCarePL.Common.GUID_DEFAULT); DayCareDataContext db = new DayCareDataContext(); List <DayCarePL.ChildEnrollmentStatusProperties> lstChildEnrollmentStatus = new List <DayCarePL.ChildEnrollmentStatusProperties>(); DayCarePL.ChildEnrollmentStatusProperties objChildEnrollmentStatus = null; try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clChildEnrollmentStatus, "LoadChildEnrollmentStatus", "Debug LoadChildEnrollmentStatus Method", DayCarePL.Common.GUID_DEFAULT); var data = db.spGetChildEnrollmentStatus(SchoolId, ChildSchoolYearId); foreach (var d in data) { objChildEnrollmentStatus = new DayCarePL.ChildEnrollmentStatusProperties(); objChildEnrollmentStatus.Id = d.Id; objChildEnrollmentStatus.EnrollmentStatusId = d.EnrollmentStatusId; objChildEnrollmentStatus.EnrollmentStatus = d.Status; objChildEnrollmentStatus.ChildSchoolYearId = d.ChildSchoolYearId; objChildEnrollmentStatus.EnrollmentDate = d.EnrollmentDate; objChildEnrollmentStatus.Comments = d.Comments; lstChildEnrollmentStatus.Add(objChildEnrollmentStatus); objChildEnrollmentStatus = null; } } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clChildEnrollmentStatus, "LoadChildEnrollmentStatus", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); } return(lstChildEnrollmentStatus); }
public static bool Save(DayCarePL.ChildEnrollmentStatusProperties objChildEnrollment) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clChildEnrollmentStatus, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT); SqlConnection conn = clConnection.CreateConnection(); try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clChildEnrollmentStatus, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT); clConnection.OpenConnection(conn); SqlCommand cmd; if (objChildEnrollment.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT)) { cmd = clConnection.CreateCommand("spAddChildEnrollmentStatus", conn); cmd.Parameters.Add(clConnection.GetInputParameter("@CreatedDateTime", DateTime.Now)); cmd.Parameters.Add(clConnection.GetInputParameter("@CreatedById", objChildEnrollment.CreatedById)); } else { cmd = clConnection.CreateCommand("spUpdateChildEnrollmentStatus", conn); cmd.Parameters.Add(clConnection.GetInputParameter("@Id", objChildEnrollment.Id)); } cmd.Parameters.Add(clConnection.GetInputParameter("@ChildSchoolYearId", objChildEnrollment.ChildSchoolYearId)); cmd.Parameters.Add(clConnection.GetInputParameter("@EnrollmentStatusId", objChildEnrollment.EnrollmentStatusId)); cmd.Parameters.Add(clConnection.GetInputParameter("@EnrollmentDate", objChildEnrollment.EnrollmentDate)); cmd.Parameters.Add(clConnection.GetInputParameter("@Comments", objChildEnrollment.Comments)); cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedDateTime", DateTime.Now)); cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedById", objChildEnrollment.LastModifiedById)); 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.clChildEnrollmentStatus, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); return(false); } finally { clConnection.CloseConnection(conn); } }
public bool SubmitRecord(object source, Telerik.Web.UI.GridCommandEventArgs e) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.ChildEnrollmentStatus, "SubmitRecord", "Submit record method called", DayCarePL.Common.GUID_DEFAULT); bool result = false; try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.ChildEnrollmentStatus, "SubmitRecord", " Debug Submit record method called of ChildEnrollmentStatus", DayCarePL.Common.GUID_DEFAULT); DayCareBAL.ChildEnrollmentStatusService proxyChildEnrollmentStatus = new DayCareBAL.ChildEnrollmentStatusService(); DayCarePL.ChildEnrollmentStatusProperties objChildEnrollmentStatus = new DayCarePL.ChildEnrollmentStatusProperties(); 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 "Enrollmentstatus": { objChildEnrollmentStatus.EnrollmentStatusId = new Guid((e.Item.FindControl("ddlEnrollmentStatus") as DropDownList).SelectedValue); break; } case "EnrollmentDate": { objChildEnrollmentStatus.EnrollmentDate = Convert.ToDateTime((e.Item.FindControl("rdpEnrollmentDate") as RadDatePicker).SelectedDate); break; } case "Comments": { objChildEnrollmentStatus.Comments = (e.Item.FindControl("txtComments") as TextBox).Text; break; } } } } } if (e.CommandName != "PerformInsert") { if (Session["StaffId"] != null) { objChildEnrollmentStatus.LastModifiedById = new Guid(Session["StaffId"].ToString()); } objChildEnrollmentStatus.Id = new Guid(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["Id"].ToString()); } hdnName.Value = ""; Guid ChildSchoolYearId = Common.GetChildSchoolYearId(new Guid(ViewState["ChildDataId"].ToString()), new Guid(Session["CurrentSchoolYearId"].ToString())); objChildEnrollmentStatus.ChildSchoolYearId = ChildSchoolYearId; if (Session["StaffId"] != null) { objChildEnrollmentStatus.CreatedById = new Guid(Session["StaffId"].ToString()); } if (objChildEnrollmentStatus.EnrollmentStatusId != null && objChildEnrollmentStatus.EnrollmentDate != null) { bool check = proxyChildEnrollmentStatus.CheckDuplicateChildEnrollmentStatus(ChildSchoolYearId, objChildEnrollmentStatus.EnrollmentStatusId.Value, objChildEnrollmentStatus.EnrollmentDate.Value, objChildEnrollmentStatus.Id); if (check == false) { result = proxyChildEnrollmentStatus.Save(objChildEnrollmentStatus); if (result == true) { 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}')", "Already Assigned", "false")); } } } } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.ChildEnrollmentStatus, "SubmitRecord", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); result = false; } return(result); }
public bool Save(DayCarePL.ChildEnrollmentStatusProperties objChildEnrollment) { return(DayCareDAL.clChildEnrollmentStatus.Save(objChildEnrollment)); }