public resource Insert(resource id)
 {
     string ConnectionString = IDManager.connection();
     SqlConnection con = new SqlConnection(ConnectionString);
     try
     {
     con.Open();
     SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_RESOURCE", con);
     cmd.CommandType = System.Data.CommandType.StoredProcedure;
     cmd.Parameters.AddWithValue("@Location_ID", id.Location_ID);
     cmd.Parameters.AddWithValue("@Resource_Type", id.Resource_Type);
     cmd.Parameters.AddWithValue("@Date_Requested", id.Date_Requested);
     cmd.ExecuteReader();
     con.Close();
     con.Open();
     cmd = new SqlCommand("SP_DMCS_GET_RESOURCE", con);
     cmd.CommandType = System.Data.CommandType.StoredProcedure;
     cmd.Parameters.AddWithValue("@Location_ID", id.Location_ID);
     cmd.Parameters.AddWithValue("@Resource_Type", id.Resource_Type);
     cmd.Parameters.AddWithValue("@Date_Requested", id.Date_Requested);
     SqlDataReader rdr = cmd.ExecuteReader();
     if (rdr.HasRows)
     {
         rdr.Read();
         id.Resource_ID = rdr.GetInt32(0);
     }
     }
     catch (Exception ex)
     {
     id.SetColumnDefaults();
     }
     finally
     {
     con.Close();
     }
     return id;
 }
 public Boolean Update(resource id)
 {
     string ConnectionString = IDManager.connection();
     SqlConnection con = new SqlConnection(ConnectionString);
     try
     {
     con.Open();
     SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_RESOURCE", con);
     cmd.CommandType = System.Data.CommandType.StoredProcedure;
     cmd.Parameters.AddWithValue("@Resource_ID", id.Resource_ID);
     cmd.Parameters.AddWithValue("@Location_ID", id.Location_ID);
     cmd.Parameters.AddWithValue("@Resource_Type", id.Resource_Type);
     cmd.Parameters.AddWithValue("@Date_Requested", id.Date_Requested);
     cmd.ExecuteReader();
     con.Close();
     return true;
     }
     catch (Exception ex)
     {
     return false;
     }
     finally
     {
     con.Close();
     }
 }
 public resource Select(int id)
 {
     resource resource = new resource();
     string ConnectionString = IDManager.connection();
     SqlConnection con = new SqlConnection(ConnectionString);
     try
     {
     con.Open();
     SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_RESOURCE", con);
     cmd.CommandType = System.Data.CommandType.StoredProcedure;
     cmd.Parameters.AddWithValue("@Resource_ID", id);
     SqlDataReader rdr = cmd.ExecuteReader();
     if (rdr.HasRows)
     {
         rdr.Read();
         if (!rdr.IsDBNull(0))
         {
             resource.Resource_ID = rdr.GetInt32(0);
         }
         else
         {
             resource.Resource_ID = 0;
         }
         if (!rdr.IsDBNull(1))
         {
             resource.Location_ID = rdr.GetInt32(1);
         }
         else
         {
             resource.Location_ID = 0;
         }
         if (!rdr.IsDBNull(2))
         {
             resource.Resource_Type = rdr.GetString(2);
         }
         else
         {
             resource.Resource_Type = " ";
         }
         if (!rdr.IsDBNull(3))
         {
             resource.Date_Requested = rdr.GetDateTime(3);
         }
         else
         {
             resource.Date_Requested = DateTime.Now;
         }
         }
         else
         {
             resource.SetColumnDefaults();
         }
     }
     catch (Exception ex)
     {
     resource.SetColumnDefaults();
     return resource;
     }
     finally
     {
     con.Close();
     }
     return resource;
 }