public static List <DayCarePL.ProgClassCategoryProperties> LoadProgClassCategory(Guid SchoolProgramId, Guid SchoolId)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clProgClassCategory, "LoadProgClassCategory", "Execute LoadProgClassCategory 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.clProgClassCategory, "LoadProgClassCategory", "Debug LoadProgClassCategory Method", DayCarePL.Common.GUID_DEFAULT);
List <DayCarePL.ProgClassCategoryProperties> lstProgClassCategory = new List <DayCarePL.ProgClassCategoryProperties>();
DayCarePL.ProgClassCategoryProperties objProgClassCategory;
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "spGetProgClassCategory";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.Add(new SqlParameter("@SchoolProgramId", SchoolProgramId));
cmd.Parameters.Add(new SqlParameter("@SchoolId", SchoolId));
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
objProgClassCategory = new DayCarePL.ProgClassCategoryProperties();
//objProgClassCategory.Id = new Guid(dr["pccId"].ToString());
objProgClassCategory.Id = new Guid(dr["Id"].ToString());
objProgClassCategory.ClassCategoryName = dr["Name"].ToString();
objProgClassCategory.Assign = new Guid(dr["Assign"].ToString());
objProgClassCategory.Active = Convert.ToBoolean(dr["Active"].ToString());
//objProgClassCategory.pActive = Convert.ToBoolean(dr["AssignActive"].ToString());
lstProgClassCategory.Add(objProgClassCategory);
}
return(lstProgClassCategory);
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clProgClassCategory, "LoadProgClassCategory", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
return(null);
}
finally
{
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
}
}
public static bool Save(DayCarePL.ProgClassCategoryProperties objProgClassCategory, Guid SchoolProgramId)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clProgClassCategory, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
SqlConnection conn = clConnection.CreateConnection();
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clProgClassCategory, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
clConnection.OpenConnection(conn);
SqlCommand cmd;
if (objProgClassCategory.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
cmd = clConnection.CreateCommand("spAddProgClassCategory", conn);
cmd.Parameters.Add(clConnection.GetInputParameter("@CreatedDateTime", DateTime.Now));
cmd.Parameters.Add(clConnection.GetInputParameter("@CreatedById", objProgClassCategory.CreatedById));
}
else
{
cmd = clConnection.CreateCommand("spUpdateProgClassCategory", conn);
}
if (!objProgClassCategory.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
cmd.Parameters.Add(clConnection.GetInputParameter("@Id", objProgClassCategory.Id));
}
cmd.Parameters.Add(clConnection.GetInputParameter("@SchoolProgramId", objProgClassCategory.SchoolProgramId));
cmd.Parameters.Add(clConnection.GetInputParameter("@ClassCategoryId", objProgClassCategory.ClassCategoryId));
cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedDateTime", DateTime.Now));
cmd.Parameters.Add(clConnection.GetInputParameter("@LastModifiedById", objProgClassCategory.LastModifiedById));
cmd.Parameters.Add(clConnection.GetInputParameter("@Active", objProgClassCategory.Active));
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.clProgClassCategory, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
return(false);
}
finally
{
clConnection.CloseConnection(conn);
}
}
protected void Assign_CheckedChanged(object sender, EventArgs e)
{
try
{
DayCareBAL.ProgClassCategoryService proxyProgClassCategory = new DayCareBAL.ProgClassCategoryService();
DayCarePL.ProgClassCategoryProperties objProgClassCategory = new DayCarePL.ProgClassCategoryProperties();
List <DayCarePL.ProgClassCategoryProperties> lstProgClassCategory = new List <DayCarePL.ProgClassCategoryProperties>();
if (ViewState["SchoolProgramId"] != null)
{
CheckBox chkAssign = (CheckBox)sender;
GridDataItem dataItem = (GridDataItem)chkAssign.NamingContainer;
chkAssign = dataItem["Assign"].FindControl("Assign") as CheckBox;
Label lblId = dataItem["Id"].FindControl("lblClassCategoryId") as Label;
Label lblProgClassCatId = dataItem["ProgClassCatId"].FindControl("lblProgClassCatId") as Label;
objProgClassCategory.ClassCategoryId = new Guid(lblId.Text);
if (Session["StaffId"] != null)
{
objProgClassCategory.CreatedById = new Guid(Session["StaffId"].ToString());
objProgClassCategory.LastModifiedById = new Guid(Session["StaffId"].ToString());
objProgClassCategory.Active = chkAssign.Checked;
objProgClassCategory.Id = new Guid(lblProgClassCatId.Text);
}
objProgClassCategory.SchoolProgramId = new Guid(ViewState["SchoolProgramId"].ToString());
lstProgClassCategory.Add(objProgClassCategory);
if (proxyProgClassCategory.Save(objProgClassCategory, new Guid(ViewState["SchoolProgramId"].ToString())))
{
MasterAjaxManager = this.Page.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Saved Successfully", "false"));
rgProgClassCategory.MasterTableView.Rebind();
return;
}
else
{
MasterAjaxManager = this.Page.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Internal Error.!", "false"));
return;
}
}
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.ProgClassCategory, "btnSave_Click", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
}
}
protected void rgProgClassCategory_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem)
{
DayCarePL.ProgClassCategoryProperties dataOfClassCategory = e.Item.DataItem as DayCarePL.ProgClassCategoryProperties;
CheckBox chkAssign = e.Item.FindControl("Assign") as CheckBox;
if (dataOfClassCategory != null)
{
//if (!dataOfClassCategory.Assign.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
if (dataOfClassCategory.Active == true)
{
chkAssign.Checked = true;
}
if (dataOfClassCategory.Assign.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
chkAssign.Enabled = true;
}
}
}
}
public bool Save(DayCarePL.ProgClassCategoryProperties objProgClassCategory, Guid SchoolProgramId)
{
return(DayCareDAL.clProgClassCategory.Save(objProgClassCategory, SchoolProgramId));
}
