public static bool Save(DayCarePL.ClassRoomProperties objClassRoom) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clClassRoom, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT); clConnection.DoConnection(); bool result = false; DayCareDataContext db = new DayCareDataContext(); ClassRoom DBClassRoom = null; try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clClassRoom, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT); if (objClassRoom.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT)) { DBClassRoom = new ClassRoom(); DBClassRoom.Id = System.Guid.NewGuid(); } else { DBClassRoom = db.ClassRooms.SingleOrDefault(D => D.Id.Equals(objClassRoom.Id)); } DBClassRoom.LastModifiedById = objClassRoom.LastModifiedById; DBClassRoom.LastModifiedDatetime = DateTime.Now; DBClassRoom.Name = objClassRoom.Name; DBClassRoom.SchoolId = objClassRoom.SchoolId; DBClassRoom.MaxSize = objClassRoom.MaxSize; DBClassRoom.Active = objClassRoom.Active; DBClassRoom.StaffId = objClassRoom.StaffId; if (objClassRoom.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT)) { db.ClassRooms.InsertOnSubmit(DBClassRoom); } db.SubmitChanges(); result = true; } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clClassRoom, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); result = false; } finally { } return(result); }
protected void rgClassRoom_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e) { if (e.Item.ItemType == GridItemType.EditItem) { DayCarePL.ClassRoomProperties objClassRoom = e.Item.DataItem as DayCarePL.ClassRoomProperties; DropDownList ddlStaff = e.Item.FindControl("ddlStaff") as DropDownList; 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()); } if (ddlStaff != null) { Common.BindStaff(ddlStaff, SchoolId, CurrentSchoolYearId); } if (objClassRoom != null) { if (ddlStaff != null && ddlStaff.Items.Count > 0) { ddlStaff.SelectedValue = Convert.ToString(objClassRoom.StaffId); } } if (e.Item.ItemIndex != -1) { GridEditableItem itm = e.Item as GridEditableItem; CheckBox chkActive = itm["Active"].Controls[0] as CheckBox; DayCareBAL.ClassRoomService proxyClassRoom = new DayCareBAL.ClassRoomService(); if (proxyClassRoom.CheckClassRoomAssignedSchoolProgramm(new Guid(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["Id"].ToString()))) { chkActive.Enabled = false; chkActive.ToolTip = "Class is already assigned to program"; } } } if (e.Item.ItemIndex == -1) { if (e.Item.Edit == true) { GridEditableItem dataItem = e.Item as Telerik.Web.UI.GridEditableItem; CheckBox chkActive = dataItem["Active"].Controls[0] as CheckBox; chkActive.Checked = true; } } }
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.ClassRoomService proxySave = new DayCareBAL.ClassRoomService(); DayCarePL.ClassRoomProperties objClassRoom = new DayCarePL.ClassRoomProperties(); Telerik.Web.UI.GridDataItem item = (Telerik.Web.UI.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 IGridEditableColumn) { IGridEditableColumn editableCol = (column as IGridEditableColumn); if (editableCol.IsEditable) { IGridColumnEditor editor = editMan.GetColumnEditor(editableCol); switch (column.UniqueName) { case "Name": { objClassRoom.Name = (editor as GridTextBoxColumnEditor).Text.Trim().ToString(); ViewState["Name"] = objClassRoom.Name; break; } case "MaxSize": { if (!string.IsNullOrEmpty((e.Item.FindControl("txtMaxSize") as TextBox).Text)) { objClassRoom.MaxSize = Convert.ToInt32((e.Item.FindControl("txtMaxSize") as TextBox).Text); ViewState["MaxSize"] = objClassRoom.MaxSize; } else { objClassRoom.MaxSize = 0; } break; } case "Active": { objClassRoom.Active = (editor as GridCheckBoxColumnEditor).Value; break; } case "FullName": { objClassRoom.StaffId = new Guid((e.Item.FindControl("ddlStaff") as DropDownList).SelectedValue); break; } } } } } if (Session["SchoolId"] != null) { objClassRoom.SchoolId = new Guid(Session["SchoolId"].ToString()); } if (e.CommandName != "PerformInsert") { if (Session["StaffId"] != null) { objClassRoom.LastModifiedById = new Guid(Session["StaffId"].ToString()); } objClassRoom.Id = new Guid(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["Id"].ToString()); // objClassRoom.StaffId = new Guid(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["FullName"].ToString()); if (!objClassRoom.Id.ToString().Equals(hdnName.Value.Trim())) { // bool ans = Common.CheckDuplicate("ClassRoom", "Name", objClassRoom.Name, "update", objClassRoom.Id.ToString()); bool ans = proxySave.CheckDuplicateClassRoomName(objClassRoom.Name, objClassRoom.Id, objClassRoom.SchoolId, objClassRoom.StaffId.Value, new Guid(Session["CurrentSchoolYearId"].ToString())); if (ans) { MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Already Exist", "false")); return(false); } } } else { // bool ans = Common.CheckDuplicate("ClassRoom", "Name", objClassRoom.Name, "insert", objClassRoom.Id.ToString()); bool ans = proxySave.CheckDuplicateClassRoomName(objClassRoom.Name, objClassRoom.Id, objClassRoom.SchoolId, objClassRoom.StaffId.Value, new Guid(Session["CurrentSchoolYearId"].ToString())); if (ans) { MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Already Exist", "false")); return(false); } } hdnName.Value = ""; //result = proxySave.Save(objClassRoom); if (Session["StaffId"] == null) { Response.Redirect("~/Login.aspx"); } else { objClassRoom.LastModifiedById = new Guid(Session["StaffId"].ToString()); } result = proxySave.SaveClassRoomYearWise(objClassRoom, new Guid(Session["CurrentSchoolYearId"].ToString())); 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")); } } } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.ClassRoom, "SubmitRecord", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); result = false; } return(result); }
public static bool SaveClassRoomYearWise(DayCarePL.ClassRoomProperties objClassRoom, Guid SchoolYearId) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clClassRoom, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT); clConnection.DoConnection(); bool result = false; //declare trans variable System.Data.Common.DbTransaction trans = null; DayCareDataContext db = new DayCareDataContext(); ClassRoom DBClassRoom = null; ClassRoomSchoolYear DBClassRoomSchoolYear = null; try { // Open the connection db.Connection.Open(); // Begin the transaction trans = db.Connection.BeginTransaction(); // Assign transaction to context class // All the database operation perform by this object will now use //transaction db.Transaction = trans; DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clClassRoom, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT); if (objClassRoom.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT)) { DBClassRoom = new ClassRoom(); DBClassRoom.Id = System.Guid.NewGuid(); DBClassRoomSchoolYear = new ClassRoomSchoolYear(); DBClassRoomSchoolYear.Id = System.Guid.NewGuid(); DBClassRoomSchoolYear.ClassRoomName = objClassRoom.Name; DBClassRoomSchoolYear.CreatedById = objClassRoom.LastModifiedById; DBClassRoomSchoolYear.CreatedDateTime = DateTime.Now; } else { DBClassRoom = db.ClassRooms.SingleOrDefault(D => D.Id.Equals(objClassRoom.Id)); DBClassRoomSchoolYear = db.ClassRoomSchoolYears.FirstOrDefault(u => u.ClassRoomId.Equals(objClassRoom.Id) && u.SchoolYearId.Equals(SchoolYearId)); } DBClassRoom.LastModifiedById = objClassRoom.LastModifiedById; DBClassRoom.LastModifiedDatetime = DateTime.Now; DBClassRoom.Name = objClassRoom.Name; DBClassRoom.SchoolId = objClassRoom.SchoolId; DBClassRoom.MaxSize = objClassRoom.MaxSize; DBClassRoom.Active = objClassRoom.Active; DBClassRoom.StaffId = objClassRoom.StaffId; //class school year DBClassRoomSchoolYear.ClassRoomId = DBClassRoom.Id; DBClassRoomSchoolYear.SchoolYearId = SchoolYearId; DBClassRoomSchoolYear.Active = objClassRoom.Active; DBClassRoomSchoolYear.StaffId = objClassRoom.StaffId; DBClassRoomSchoolYear.ClassRoomName = objClassRoom.Name; DBClassRoomSchoolYear.LastModifiedById = objClassRoom.LastModifiedById; DBClassRoomSchoolYear.LastModifiedDateTime = DateTime.Now; if (objClassRoom.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT)) { db.ClassRooms.InsertOnSubmit(DBClassRoom); db.ClassRoomSchoolYears.InsertOnSubmit(DBClassRoomSchoolYear); } db.SubmitChanges(); // Commit transaction trans.Commit(); result = true; } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clClassRoom, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); result = false; // Rollback transaction if (trans != null) { trans.Rollback(); } } finally { // Close the connection if (db.Connection.State == ConnectionState.Open) { db.Connection.Close(); } } return(result); }
public bool SaveClassRoomYearWise(DayCarePL.ClassRoomProperties objClassRoom, Guid SchoolYearId) { return(DayCareDAL.clClassRoom.SaveClassRoomYearWise(objClassRoom, SchoolYearId)); }
public bool Save(DayCarePL.ClassRoomProperties objClassRoom) { return(DayCareDAL.clClassRoom.Save(objClassRoom)); }