public Shelter Insert(Shelter id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_SHELTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Address_ID", id.Address_ID); cmd.Parameters.AddWithValue("@Shelter_Type", id.Shelter_Type); cmd.Parameters.AddWithValue("@Max_Capacity", id.Max_Capacity); cmd.Parameters.AddWithValue("@AllowsPets", id.AllowsPets); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_SHELTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Address_ID", id.Address_ID); cmd.Parameters.AddWithValue("@Shelter_Type", id.Shelter_Type); cmd.Parameters.AddWithValue("@Max_Capacity", id.Max_Capacity); cmd.Parameters.AddWithValue("@AllowsPets", id.AllowsPets); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.Shelter_ID = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return id; }
public Shelter Select(int id) { Shelter Shelter = new Shelter(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_SHELTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Shelter_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Shelter.Shelter_ID = rdr.GetInt32(0); } else { Shelter.Shelter_ID = 0; } if (!rdr.IsDBNull(1)) { Shelter.Address_ID = rdr.GetInt32(1); } else { Shelter.Address_ID = 0; } if (!rdr.IsDBNull(2)) { Shelter.Shelter_Type = rdr.GetString(2); } else { Shelter.Shelter_Type = " "; } if (!rdr.IsDBNull(3)) { Shelter.Max_Capacity = rdr.GetInt32(3); } else { Shelter.Max_Capacity = 0; } if (!rdr.IsDBNull(4)) { Shelter.AllowsPets = rdr.GetString(4); } else { Shelter.AllowsPets = " "; } } else { Shelter.SetColumnDefaults(); } } catch (Exception ex) { Shelter.SetColumnDefaults(); return Shelter; } finally { con.Close(); } return Shelter; }
public Boolean Update(Shelter id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_SHELTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Shelter_ID", id.Shelter_ID); cmd.Parameters.AddWithValue("@Address_ID", id.Address_ID); cmd.Parameters.AddWithValue("@Shelter_Type", id.Shelter_Type); cmd.Parameters.AddWithValue("@Max_Capacity", id.Max_Capacity); cmd.Parameters.AddWithValue("@AllowsPets", id.AllowsPets); cmd.ExecuteReader(); con.Close(); return true; } catch (Exception ex) { return false; } finally { con.Close(); } }
public Shelter Select(int id) { Shelter Shelter = new Shelter(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_SHELTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Shelter_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Shelter.Shelter_ID = rdr.GetInt32(0); } else { Shelter.Shelter_ID = 0; } if (!rdr.IsDBNull(1)) { Shelter.Address_ID = rdr.GetInt32(1); } else { Shelter.Address_ID = 0; } if (!rdr.IsDBNull(2)) { Shelter.Shelter_Type = rdr.GetString(2); } else { Shelter.Shelter_Type = " "; } if (!rdr.IsDBNull(3)) { Shelter.Max_Capacity = rdr.GetInt32(3); } else { Shelter.Max_Capacity = 0; } if (!rdr.IsDBNull(4)) { Shelter.AllowsPets = rdr.GetString(4); } else { Shelter.AllowsPets = " "; } } else { Shelter.SetColumnDefaults(); } } catch (Exception ex) { Shelter.SetColumnDefaults(); return(Shelter); } finally { con.Close(); } return(Shelter); }