public void Delete(HolidayGroupEntity entity) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_DeleteHolidayGroup", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", entity.Id); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
protected void AddLeaveType_Click(object sender, EventArgs e) { HolidayGroupEntity entity = new HolidayGroupEntity(); entity.Title = TitleTextBox.Text; entity.Description = DescriptionTextBox.Text; HolidayGroupMapper mapper = new HolidayGroupMapper(); mapper.Insert(entity); Response.Redirect(String.Format("Edit.aspx?HolidayGroupId={0}", entity.Id)); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["HolidayGroupId"] != null) { int HolidayGroupId; HolidayGroupEntity entity = new HolidayGroupEntity(); Int32.TryParse(Request.QueryString["HolidayGroupId"], out HolidayGroupId); entity.Id = HolidayGroupId; HolidayGroupMapper mapper = new HolidayGroupMapper(); entity = mapper.Get(entity); TitleTextBox.Text = entity.Title; DescriptionTextBox.Text = entity.Description; } } }
public HolidayGroupEntity Get(HolidayGroupEntity t) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_GetHolidayGroupById", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", t.Id); SqlDataReader rdr = cmd.ExecuteReader(); HolidayGroupEntity entity = new HolidayGroupEntity(); if (rdr.Read()) { entity.Id = Convert.ToInt32(rdr["Id"]); entity.Status = (StatusEnum)rdr["Status"]; entity.Title = Convert.ToString(rdr["Title"]); entity.Description = Convert.ToString(rdr["Description"]); } return entity; } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public void Update(HolidayGroupEntity entity) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_UpdateHolidayGroup", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", entity.Id); cmd.Parameters.AddWithValue("@Status", Convert.ToInt32(entity.Status)); cmd.Parameters.AddWithValue("@Title", entity.Title); cmd.Parameters.AddWithValue("@Description", entity.Description); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public List<HolidayGroupEntity> ListByContractTemplateId(int ContractTemplateId) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_ListHolidayGroupByContractTemplateId", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ContractTemplateId", ContractTemplateId); SqlDataReader rdr = cmd.ExecuteReader(); List<HolidayGroupEntity> list = new List<HolidayGroupEntity>(); while (rdr.Read()) { HolidayGroupEntity entity = new HolidayGroupEntity(); entity.Id = Convert.ToInt32(rdr["Id"]); entity.Title = Convert.ToString(rdr["Title"]); entity.Description = Convert.ToString(rdr["Description"]); entity.Status = (StatusEnum)Convert.ToInt32(rdr["Status"]); list.Add(entity); } return list; } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public void InsertForContractTemplate(HolidayGroupEntity entity, int ContractTemplateId) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_InsertHolidayGroupForContractTemplate", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HolidayGroupId", entity.Id); cmd.Parameters.AddWithValue("@ContractTemplateId", ContractTemplateId); cmd.Parameters.AddWithValue("@Status", StatusEnum.Active); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }