private void DeleteHoliday(PlannedHoliday holiday, SqlConnection connection) { SqlCommand cmd = new SqlCommand("DeleteHoliday", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@HolidayID", SqlDbType.Int).Value = holiday.HolidayID; cmd.ExecuteNonQuery(); }
private void UpdateHoliday(PlannedHoliday holiday, SqlConnection connection) { SqlCommand cmd = new SqlCommand("UpdateHoliday", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@HolidayID", SqlDbType.Int).Value = holiday.HolidayID; cmd.Parameters.Add("@FromDate", SqlDbType.DateTime).Value = holiday.FromDate; cmd.Parameters.Add("@ToDate", SqlDbType.DateTime).Value = holiday.ToDate; cmd.Parameters.Add("@IsActioned", SqlDbType.Bit).Value = holiday.IsActioned; cmd.ExecuteNonQuery(); }
public void DeletePlannedHolidayStartingOn(DateTime date) { PlannedHoliday plh = currentState.GetHolidayStartingOn(date); if (plh != null) { SqlConnection con = new SqlConnection(LocalSettings.SqlConnectionString); con.Open(); DeleteHoliday(plh, con); con.Close(); RefreshPlannedHolidays(); } }
public void AddHoliday(DateTime fromDate, DateTime toDate) { PlannedHoliday holiday = new PlannedHoliday(); holiday.FromDate = fromDate; holiday.ToDate = toDate; SqlConnection connection = new SqlConnection(LocalSettings.SqlConnectionString); connection.Open(); UpdateHoliday(holiday, connection); connection.Close(); RefreshPlannedHolidays(); }
public void SetHolidayAsActioned(PlannedHoliday holiday) { SqlConnection connection = new SqlConnection(LocalSettings.SqlConnectionString); connection.Open(); SqlCommand cmd = new SqlCommand("SetHolidayAsActioned", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@HolidayID", SqlDbType.Int).Value = holiday.HolidayID; cmd.ExecuteNonQuery(); connection.Close(); RefreshPlannedHolidays(); }