public int IsSourceUsed(int resourceId) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@resourceId", resourceId), }; return(SqlDBHelper.ExecuteScalar("[Resource_Control].[SP_IsSourceUsed]", CommandType.StoredProcedure, parameters)); }
public int CheckOneDateTimeWithResourceIdPlus(int dateTimeId, int resourceId) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@dateTimeId", dateTimeId), new SqlParameter("@ResourceId", resourceId), }; return(SqlDBHelper.ExecuteScalar("[Resource_Control].[SP_CheckOneDateTimeWithResourceIdPlus]", CommandType.StoredProcedure, parameters)); }
public int InsertNewDateTimeForDefenceV2(RequestDateTime dateTime, int collegeId) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Date", dateTime.Date), new SqlParameter("@StartTime", dateTime.StartTime), new SqlParameter("@EndTime", dateTime.EndTime), new SqlParameter("@RequestId", dateTime.RequestId), new SqlParameter("@collegeId", collegeId), }; return(SqlDBHelper.ExecuteScalar("[Resource_Control].[sp_InsertRequestDateTimeForDefenceAddRequest]", CommandType.StoredProcedure, parameters));; }
public int AddNewResource(Resource resource) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@name", resource.Name), new SqlParameter("@location", resource.Location), new SqlParameter("@description", resource.Description), new SqlParameter("@categoryID", resource.CategoryID), new SqlParameter("@capacity", resource.Capacity) }; return(SqlDBHelper.ExecuteScalar("[Resource_Control].[sp_ResourceInsert]", CommandType.StoredProcedure, parameters)); }
public int UpdateOneDateTimeRequest(RequestDateTime reqDateTime) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@dateTimeId", reqDateTime.DateTimeId), new SqlParameter("@Date", reqDateTime.Date), new SqlParameter("@StartTime", reqDateTime.StartTime), new SqlParameter("@EndTime", reqDateTime.EndTime), new SqlParameter("@ResourceId", reqDateTime.ResourceId) }; return(SqlDBHelper.ExecuteScalar("[Resource_Control].[SP_UpdateOneDateTimeRequest]", CommandType.StoredProcedure, parameters)); }