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