protected void chkClassRoom_CheckedChanged(object sender, EventArgs e)
{
try
{
DayCareBAL.ProgClassRoomService proxyProgClassRoom = new DayCareBAL.ProgClassRoomService();
DayCarePL.ProgClassRoomProperties objProgClassRoom = new DayCarePL.ProgClassRoomProperties();
CheckBox chkClassRoom = sender as CheckBox;
GridDataItem item = chkClassRoom.NamingContainer as GridDataItem;
if (ViewState["SchoolProgramId"] != null)
{
if (item.ItemIndex > -1)
{
objProgClassRoom.Id = new Guid(item.GetDataKeyValue("Id").ToString());
//objProgClassRoom.ProgStaffId = new Guid((item.FindControl("ddlProgStaff") as DropDownList).SelectedValue);
objProgClassRoom.SchoolProgramId = new Guid(ViewState["SchoolProgramId"].ToString());
objProgClassRoom.Active = chkClassRoom.Checked;
objProgClassRoom.ClassRoomId = new Guid((item.FindControl("lblClassRoomId") as Label).Text);
if (Session["StaffId"] != null)
{
objProgClassRoom.CreatedById = new Guid(Session["StaffId"].ToString());
objProgClassRoom.LastModifiedById = new Guid(Session["StaffId"].ToString());
}
}
if (proxyProgClassRoom.Save(objProgClassRoom))
{
//MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
//MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Saved Successfully.!", "false"));
//if (chkClassRoom.Checked == false)
//{
// chkClassRoom.Checked = false;
//(item.FindControl("ddlProgStaff") as DropDownList).SelectedValue = DayCarePL.Common.GUID_DEFAULT;
//}
//MasterAjaxManager = this.Page.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
//MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Saved Successfully", "false"));
rgProgClassRoom.Rebind();
}
else
{
MasterAjaxManager = this.Page.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Internal Error!", "false"));
chkClassRoom.Checked = false;
//(item.FindControl("ddlProgStaff") as DropDownList).SelectedValue = DayCarePL.Common.GUID_DEFAULT;
return;
}
}
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.ProgClassRoom, "chkClassRoom_CheckedChanged", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
}
}
public static bool Save(DayCarePL.ProgClassRoomProperties objProgClassRoom)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clProgClassRoom, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
SqlConnection conn = clConnection.CreateConnection();// new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["daycareConnectionString"].ToString());
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clProgClassRoom, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
//var data = db.spGetProgStaffList(SchoolId);
clConnection.OpenConnection(conn);
SqlCommand cmd;
if (objProgClassRoom.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
cmd = clConnection.CreateCommand("spAddProgClassRoom", conn);
cmd.Parameters.Add(clConnection.GetInputParameter("@CreatedById", objProgClassRoom.CreatedById));
cmd.Parameters.Add(clConnection.GetInputParameter("@CreatedDateTime", DateTime.Now));
}
else
{
cmd = clConnection.CreateCommand("spUpdateProgClassRoom", conn);
}
if (!objProgClassRoom.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
cmd.Parameters.Add(clConnection.GetInputParameter("@Id", objProgClassRoom.Id));
}
cmd.Parameters.Add(clConnection.GetInputParameter("@SchoolProgramId", objProgClassRoom.SchoolProgramId));
cmd.Parameters.Add(clConnection.GetInputParameter("@ClassRoomId", objProgClassRoom.ClassRoomId));
//cmd.Parameters.Add(clConnection.GetInputParameter("@ProgStaffId", objProgClassRoom.ProgStaffId));
cmd.Parameters.Add(clConnection.GetInputParameter("@Active", objProgClassRoom.Active));
cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedDatetime", DateTime.Now));
cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedById", objProgClassRoom.LastModifiedById));
cmd.Parameters.Add(clConnection.GetOutputParameter("@status", SqlDbType.Bit));
cmd.ExecuteNonQuery();
if (Convert.ToBoolean(cmd.Parameters["@status"].Value))
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clProgClassRoom, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
return(false);
}
finally
{
clConnection.CloseConnection(conn);
}
}
public static List <DayCarePL.ProgClassRoomProperties> LoadProgClassRoomForChildSchedule(Guid SchoolId, Guid SchoolProgramId)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clProgClassRoom, "LoadProgClassRoomForChildSchedule", "Execute LoadProgClassRoomForChildSchedule 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.clProgClassRoom, "LoadProgClassRoomForChildSchedule", "Debug LoadProgClassRoomForChildSchedule Method", DayCarePL.Common.GUID_DEFAULT);
List <DayCarePL.ProgClassRoomProperties> lstProgClassRoom = new List <DayCarePL.ProgClassRoomProperties>();
DayCarePL.ProgClassRoomProperties objProgClassRoom;
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "spGetProgClassRoomForChildSchedule";
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())
{
objProgClassRoom = new DayCarePL.ProgClassRoomProperties();
objProgClassRoom.Id = new Guid(dr["Id"].ToString());
objProgClassRoom.ClassRoomName = dr["ClassRoomName"].ToString();
lstProgClassRoom.Add(objProgClassRoom);
}
return(lstProgClassRoom);
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clProgClassRoom, "LoadProgClassRoomForChildSchedule", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
return(null);
}
finally
{
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
}
}
protected void rgProgClassRoom_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
if (e.Item.ItemType == GridItemType.AlternatingItem || e.Item.ItemType == GridItemType.Item)
{
CheckBox chkClassRoom = e.Item.FindControl("chkClassRoom") as CheckBox;
//CheckBox chkActive = e.Item.FindControl("chkActive") as CheckBox;
//DropDownList ddlProgStaff = e.Item.FindControl("ddlProgStaff") as DropDownList;
DayCarePL.ProgClassRoomProperties objProgClassRoom = e.Item.DataItem as DayCarePL.ProgClassRoomProperties;
if (objProgClassRoom != null)
{
//if (ddlProgStaff != null)
//{
//Guid SchoolId = new Guid();
//if (Session["SchoolId"] != null)
//{
// SchoolId = new Guid(Session["SchoolId"].ToString());
//}
//if (ViewState["SchoolProgramId"] != null)
//{
// Common.BindStaffFromProgStaff(ddlProgStaff, new Guid(ViewState["SchoolProgramId"].ToString()));
//}
if (objProgClassRoom.Active)
{
chkClassRoom.Checked = true;
//if (ddlProgStaff != null && ddlProgStaff.Items.Count > 0)
//{
// ddlProgStaff.SelectedValue = Convert.ToString(objProgClassRoom.ProgStaffId);
//}
}
// }
//if (objProgStaff.Active == true)
//{
// chkActive.Checked = true;
//}
}
}
}
public bool Save(DayCarePL.ProgClassRoomProperties objProgClassRoom)
{
return(DayCareDAL.clProgClassRoom.Save(objProgClassRoom));
}
