public static bool Update(HolidayInfo holiday)
{
SqlParameter[] parameters = new SqlParameter[6];
parameters[0] = new SqlParameter("@Name", SqlDbType.VarChar, 20);
parameters[0].Value = holiday.Name;
parameters[1] = new SqlParameter("@StartDate", SqlDbType.VarChar, 20);
parameters[1].Value = holiday.StartDate;
parameters[2] = new SqlParameter("@EndDate", SqlDbType.VarChar, 20);
parameters[2].Value = holiday.EndDate;
parameters[3] = new SqlParameter("@Flag", SqlDbType.Int);
parameters[3].Value = holiday.Active ? 1 : 0;
parameters[4] = new SqlParameter("@Days", SqlDbType.Int);
parameters[4].Value = holiday.Days;
parameters[5] = new SqlParameter("@ID", SqlDbType.Int);
parameters[5].Value = holiday.ID;
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE HolidayInfo SET holidayName = @Name, startDate = @StartDate, endDate = @EndDate, flag = @Flag, days = @Days");
sql.AppendLine("WHERE ID = @ID");
int rowCount = helper.ExecuteNonQuery(sql.ToString(), parameters.ToArray());
return rowCount > 0;
}
public static int Add(HolidayInfo holiday)
{
SqlParameter[] parameters = new SqlParameter[5];
parameters[0] = new SqlParameter("@Name", SqlDbType.VarChar, 20);
parameters[0].Value = holiday.Name;
parameters[1] = new SqlParameter("@StartDate", SqlDbType.VarChar, 20);
parameters[1].Value = holiday.StartDate;
parameters[2] = new SqlParameter("@EndDate", SqlDbType.VarChar, 20);
parameters[2].Value = holiday.EndDate;
parameters[3] = new SqlParameter("@Flag", SqlDbType.Int);
parameters[3].Value = holiday.Active ? 1:0;
parameters[4] = new SqlParameter("@Days", SqlDbType.Int);
parameters[4].Value = holiday.Days;
StringBuilder sql = new StringBuilder();
sql.AppendLine("DECLARE @ID int");
sql.AppendLine("INSERT INTO HolidayInfo (holidayName, startDate, endDate, flag, days)");
sql.AppendLine("VALUES (@Name, @StartDate, @EndDate, @Flag, @Days)");
sql.AppendLine("SET @ID = SCOPE_IDENTITY()");
sql.AppendLine("SELECT @ID");
int newID = (int)helper.ExecuteScalar(sql.ToString(), parameters);
return newID;
}
