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