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