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