public void InsertListOfDateTime(List <RequestDateTime> dateTimeList) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Date", SqlDbType.NVarChar, 10, "Date"), new SqlParameter("@StartTime", SqlDbType.BigInt, 1, "StartTime"), new SqlParameter("@EndTime", SqlDbType.BigInt, 1, "EndTime"), new SqlParameter("@RequestId", SqlDbType.Int, 1, "RequestId"), new SqlParameter("@ResourceId", SqlDbType.Int, 1, "ResourceId"), new SqlParameter("@MayConflict", SqlDbType.Bit, 1, "MayConflict"), }; SqlDBHelper.ExecuteNonQueryList("[Resource_Control].[sp_InsertRequestDateTime]", CommandType.StoredProcedure, parameters, dateTimeList); }
public int UpdateListOfDateTimeForDefence(List <RequestDateTime> dateTimeList) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@DateTimeId", SqlDbType.NVarChar, 10, "DateTimeId"), new SqlParameter("@Date", SqlDbType.NVarChar, 10, "Date"), new SqlParameter("@StartTime", SqlDbType.BigInt, 1, "StartTime"), new SqlParameter("@EndTime", SqlDbType.BigInt, 1, "EndTime"), new SqlParameter("@RequestId", SqlDbType.Int, 1, "RequestId"), new SqlParameter("@ResourceId", SqlDbType.Int, 1, "ResourceId"), new SqlParameter("@MayConflict", SqlDbType.Bit, 1, "MayConflict"), }; return(SqlDBHelper.ExecuteNonQueryList("[Resource_Control].[SP_UpdateRequestDateTimeForDefence]", CommandType.StoredProcedure, parameters, dateTimeList)); }