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