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