public void Insert(HolidayEntity entity) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_InsertHoliday", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Title", entity.Title); cmd.Parameters.AddWithValue("@HolidayGroupId", entity.HolidayGroupId); cmd.Parameters.AddWithValue("@StartDate", entity.StartDate); cmd.Parameters.AddWithValue("@EndDate", entity.EndDate); cmd.Parameters.AddWithValue("@Description", entity.Description); entity.Id = Convert.ToInt32(cmd.ExecuteScalar()); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
protected void AddPaymentTypeButton_Click(object sender, EventArgs e) { HolidayEntity entity = new HolidayEntity(); HolidayMapper mapper = new HolidayMapper(); entity.HolidayGroupId = Convert.ToInt32(Request.QueryString["HolidayGroupId"]); DateTime dt; if (DateTime.TryParseExact(StartDateTextBox.Text, "dd.MM.yyyy", null, System.Globalization.DateTimeStyles.None, out dt)) { entity.StartDate = dt; } if (DateTime.TryParseExact(EndDateTextBox.Text, "dd.MM.yyyy", null, System.Globalization.DateTimeStyles.None, out dt)) { entity.EndDate = dt; } entity.Title = HolidayTitleTextBox.Text; entity.Status = StatusEnum.Active; entity.Description = ""; mapper.Insert(entity); HolidayTitleTextBox.Text = ""; StartDateTextBox.Text = ""; EndDateTextBox.Text = ""; LeaveTypeGridView.DataBind(); }
public List<HolidayEntity> List(int HolidayGroupId) { SqlConnection conn = null; SqlCommand cmd = null; try { conn = DALHelper.CreateSqlDbConnection(); cmd = new SqlCommand("usp_ListHolidays", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HolidayGroupId", HolidayGroupId); SqlDataReader rdr = cmd.ExecuteReader(); List<HolidayEntity> list = new List<HolidayEntity>(); while (rdr.Read()) { HolidayEntity entity = new HolidayEntity(); entity.Id = Convert.ToInt32(rdr["Id"]); entity.Title = Convert.ToString(rdr["Title"]); entity.StartDate = Convert.ToDateTime(rdr["StartDate"]); entity.EndDate = Convert.ToDateTime(rdr["EndDate"]); list.Add(entity); } return list; } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }
public void Update(HolidayEntity 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("@Title", entity.Title); cmd.Parameters.AddWithValue("@HolidayGroupId", entity.HolidayGroupId); cmd.Parameters.AddWithValue("@StartDate", entity.StartDate); cmd.Parameters.AddWithValue("@EndDate", entity.EndDate); cmd.Parameters.AddWithValue("@Description", entity.Description); cmd.Parameters.AddWithValue("@Status", entity.Status); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { conn.Close(); cmd.Dispose(); conn.Dispose(); } }