public Client_Shelter Select(int id) { Client_Shelter Client_Shelter = new Client_Shelter(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_CLIENT_SHELTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Client_Shelter_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Client_Shelter.Client_Shelter_ID = rdr.GetInt32(0); } else { Client_Shelter.Client_Shelter_ID = 0; } if (!rdr.IsDBNull(1)) { Client_Shelter.Shelter_ID = rdr.GetInt32(1); } else { Client_Shelter.Shelter_ID = 0; } if (!rdr.IsDBNull(2)) { Client_Shelter.Client_ID = rdr.GetInt32(2); } else { Client_Shelter.Client_ID = 0; } if (!rdr.IsDBNull(3)) { Client_Shelter.Current_address = rdr.GetString(3); } else { Client_Shelter.Current_address = " "; } if (!rdr.IsDBNull(4)) { Client_Shelter.Current_State = rdr.GetString(4); } else { Client_Shelter.Current_State = " "; } if (!rdr.IsDBNull(5)) { Client_Shelter.Current_City = rdr.GetString(5); } else { Client_Shelter.Current_City = " "; } if (!rdr.IsDBNull(6)) { Client_Shelter.Current_Zip = rdr.GetInt32(6); } else { Client_Shelter.Current_Zip = 0; } if (!rdr.IsDBNull(7)) { Client_Shelter.Client_registration_status = rdr.GetString(7); } else { Client_Shelter.Client_registration_status = " "; } if (!rdr.IsDBNull(8)) { Client_Shelter.Household_size = rdr.GetInt32(8); } else { Client_Shelter.Household_size = 0; } if (!rdr.IsDBNull(9)) { Client_Shelter.Shelter_supplies = rdr.GetString(9); } else { Client_Shelter.Shelter_supplies = " "; } if (!rdr.IsDBNull(10)) { Client_Shelter.Shelter_occupancy_current = rdr.GetString(10); } else { Client_Shelter.Shelter_occupancy_current = " "; } if (!rdr.IsDBNull(11)) { Client_Shelter.New_household_registered = rdr.GetString(11); } else { Client_Shelter.New_household_registered = " "; } if (!rdr.IsDBNull(12)) { Client_Shelter.New_Shelter_address = rdr.GetString(12); } else { Client_Shelter.New_Shelter_address = " "; } if (!rdr.IsDBNull(13)) { Client_Shelter.New_Shelter_city = rdr.GetString(13); } else { Client_Shelter.New_Shelter_city = " "; } if (!rdr.IsDBNull(14)) { Client_Shelter.New_Shelter_State = rdr.GetString(14); } else { Client_Shelter.New_Shelter_State = " "; } if (!rdr.IsDBNull(15)) { Client_Shelter.New_Shelter_Zip = rdr.GetInt32(15); } else { Client_Shelter.New_Shelter_Zip = 0; } if (!rdr.IsDBNull(16)) { Client_Shelter.New_Contact_Number = rdr.GetInt32(16); } else { Client_Shelter.New_Contact_Number = 0; } if (!rdr.IsDBNull(17)) { Client_Shelter.Current_household_members_safe = rdr.GetString(17); } else { Client_Shelter.Current_household_members_safe = " "; } if (!rdr.IsDBNull(18)) { Client_Shelter.CheckIn_Date = rdr.GetDateTime(18); } else { Client_Shelter.CheckIn_Date = DateTime.Now; } if (!rdr.IsDBNull(19)) { Client_Shelter.CheckOut_Date = rdr.GetDateTime(19); } else { Client_Shelter.CheckOut_Date = DateTime.Now; } } else { Client_Shelter.SetColumnDefaults(); } } catch (Exception ex) { Client_Shelter.SetColumnDefaults(); return Client_Shelter; } finally { con.Close(); } return Client_Shelter; }
public Client_Shelter Insert(Client_Shelter id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_CLIENT_SHELTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Shelter_ID", id.Shelter_ID); cmd.Parameters.AddWithValue("@Client_ID", id.Client_ID); cmd.Parameters.AddWithValue("@Current_address", id.Current_address); cmd.Parameters.AddWithValue("@Current_State", id.Current_State); cmd.Parameters.AddWithValue("@Current_City", id.Current_City); cmd.Parameters.AddWithValue("@Current_Zip", id.Current_Zip); cmd.Parameters.AddWithValue("@Client_registration_status", id.Client_registration_status); cmd.Parameters.AddWithValue("@Household_size", id.Household_size); cmd.Parameters.AddWithValue("@Shelter_supplies", id.Shelter_supplies); cmd.Parameters.AddWithValue("@Shelter_occupancy_current", id.Shelter_occupancy_current); cmd.Parameters.AddWithValue("@New_household_registered", id.New_household_registered); cmd.Parameters.AddWithValue("@New_Shelter_address", id.New_Shelter_address); cmd.Parameters.AddWithValue("@New_Shelter_city", id.New_Shelter_city); cmd.Parameters.AddWithValue("@New_Shelter_State", id.New_Shelter_State); cmd.Parameters.AddWithValue("@New_Shelter_Zip", id.New_Shelter_Zip); cmd.Parameters.AddWithValue("@New_Contact_Number", id.New_Contact_Number); cmd.Parameters.AddWithValue("@Current_household_members_safe", id.Current_household_members_safe); cmd.Parameters.AddWithValue("@CheckIn_Date", id.CheckIn_Date); cmd.Parameters.AddWithValue("@CheckOut_Date", id.CheckOut_Date); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_CLIENT_SHELTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Shelter_ID", id.Shelter_ID); cmd.Parameters.AddWithValue("@Client_ID", id.Client_ID); cmd.Parameters.AddWithValue("@Current_address", id.Current_address); cmd.Parameters.AddWithValue("@Current_State", id.Current_State); cmd.Parameters.AddWithValue("@Current_City", id.Current_City); cmd.Parameters.AddWithValue("@Current_Zip", id.Current_Zip); cmd.Parameters.AddWithValue("@Client_registration_status", id.Client_registration_status); cmd.Parameters.AddWithValue("@Household_size", id.Household_size); cmd.Parameters.AddWithValue("@Shelter_supplies", id.Shelter_supplies); cmd.Parameters.AddWithValue("@Shelter_occupancy_current", id.Shelter_occupancy_current); cmd.Parameters.AddWithValue("@New_household_registered", id.New_household_registered); cmd.Parameters.AddWithValue("@New_Shelter_address", id.New_Shelter_address); cmd.Parameters.AddWithValue("@New_Shelter_city", id.New_Shelter_city); cmd.Parameters.AddWithValue("@New_Shelter_State", id.New_Shelter_State); cmd.Parameters.AddWithValue("@New_Shelter_Zip", id.New_Shelter_Zip); cmd.Parameters.AddWithValue("@New_Contact_Number", id.New_Contact_Number); cmd.Parameters.AddWithValue("@Current_household_members_safe", id.Current_household_members_safe); cmd.Parameters.AddWithValue("@CheckIn_Date", id.CheckIn_Date); cmd.Parameters.AddWithValue("@CheckOut_Date", id.CheckOut_Date); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.Client_Shelter_ID = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return(id); }
public Client_Shelter Insert(Client_Shelter id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_CLIENT_SHELTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Shelter_ID", id.Shelter_ID); cmd.Parameters.AddWithValue("@Client_ID", id.Client_ID); cmd.Parameters.AddWithValue("@Current_address", id.Current_address); cmd.Parameters.AddWithValue("@Current_State", id.Current_State); cmd.Parameters.AddWithValue("@Current_City", id.Current_City); cmd.Parameters.AddWithValue("@Current_Zip", id.Current_Zip); cmd.Parameters.AddWithValue("@Client_registration_status", id.Client_registration_status); cmd.Parameters.AddWithValue("@Household_size", id.Household_size); cmd.Parameters.AddWithValue("@Shelter_supplies", id.Shelter_supplies); cmd.Parameters.AddWithValue("@Shelter_occupancy_current", id.Shelter_occupancy_current); cmd.Parameters.AddWithValue("@New_household_registered", id.New_household_registered); cmd.Parameters.AddWithValue("@New_Shelter_address", id.New_Shelter_address); cmd.Parameters.AddWithValue("@New_Shelter_city", id.New_Shelter_city); cmd.Parameters.AddWithValue("@New_Shelter_State", id.New_Shelter_State); cmd.Parameters.AddWithValue("@New_Shelter_Zip", id.New_Shelter_Zip); cmd.Parameters.AddWithValue("@New_Contact_Number", id.New_Contact_Number); cmd.Parameters.AddWithValue("@Current_household_members_safe", id.Current_household_members_safe); cmd.Parameters.AddWithValue("@CheckIn_Date", id.CheckIn_Date); cmd.Parameters.AddWithValue("@CheckOut_Date", id.CheckOut_Date); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_CLIENT_SHELTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Shelter_ID", id.Shelter_ID); cmd.Parameters.AddWithValue("@Client_ID", id.Client_ID); cmd.Parameters.AddWithValue("@Current_address", id.Current_address); cmd.Parameters.AddWithValue("@Current_State", id.Current_State); cmd.Parameters.AddWithValue("@Current_City", id.Current_City); cmd.Parameters.AddWithValue("@Current_Zip", id.Current_Zip); cmd.Parameters.AddWithValue("@Client_registration_status", id.Client_registration_status); cmd.Parameters.AddWithValue("@Household_size", id.Household_size); cmd.Parameters.AddWithValue("@Shelter_supplies", id.Shelter_supplies); cmd.Parameters.AddWithValue("@Shelter_occupancy_current", id.Shelter_occupancy_current); cmd.Parameters.AddWithValue("@New_household_registered", id.New_household_registered); cmd.Parameters.AddWithValue("@New_Shelter_address", id.New_Shelter_address); cmd.Parameters.AddWithValue("@New_Shelter_city", id.New_Shelter_city); cmd.Parameters.AddWithValue("@New_Shelter_State", id.New_Shelter_State); cmd.Parameters.AddWithValue("@New_Shelter_Zip", id.New_Shelter_Zip); cmd.Parameters.AddWithValue("@New_Contact_Number", id.New_Contact_Number); cmd.Parameters.AddWithValue("@Current_household_members_safe", id.Current_household_members_safe); cmd.Parameters.AddWithValue("@CheckIn_Date", id.CheckIn_Date); cmd.Parameters.AddWithValue("@CheckOut_Date", id.CheckOut_Date); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.Client_Shelter_ID = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return id; }
public Client_Shelter Select(int id) { Client_Shelter Client_Shelter = new Client_Shelter(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_CLIENT_SHELTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Client_Shelter_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Client_Shelter.Client_Shelter_ID = rdr.GetInt32(0); } else { Client_Shelter.Client_Shelter_ID = 0; } if (!rdr.IsDBNull(1)) { Client_Shelter.Shelter_ID = rdr.GetInt32(1); } else { Client_Shelter.Shelter_ID = 0; } if (!rdr.IsDBNull(2)) { Client_Shelter.Client_ID = rdr.GetInt32(2); } else { Client_Shelter.Client_ID = 0; } if (!rdr.IsDBNull(3)) { Client_Shelter.Current_address = rdr.GetString(3); } else { Client_Shelter.Current_address = " "; } if (!rdr.IsDBNull(4)) { Client_Shelter.Current_State = rdr.GetString(4); } else { Client_Shelter.Current_State = " "; } if (!rdr.IsDBNull(5)) { Client_Shelter.Current_City = rdr.GetString(5); } else { Client_Shelter.Current_City = " "; } if (!rdr.IsDBNull(6)) { Client_Shelter.Current_Zip = rdr.GetInt32(6); } else { Client_Shelter.Current_Zip = 0; } if (!rdr.IsDBNull(7)) { Client_Shelter.Client_registration_status = rdr.GetString(7); } else { Client_Shelter.Client_registration_status = " "; } if (!rdr.IsDBNull(8)) { Client_Shelter.Household_size = rdr.GetInt32(8); } else { Client_Shelter.Household_size = 0; } if (!rdr.IsDBNull(9)) { Client_Shelter.Shelter_supplies = rdr.GetString(9); } else { Client_Shelter.Shelter_supplies = " "; } if (!rdr.IsDBNull(10)) { Client_Shelter.Shelter_occupancy_current = rdr.GetString(10); } else { Client_Shelter.Shelter_occupancy_current = " "; } if (!rdr.IsDBNull(11)) { Client_Shelter.New_household_registered = rdr.GetString(11); } else { Client_Shelter.New_household_registered = " "; } if (!rdr.IsDBNull(12)) { Client_Shelter.New_Shelter_address = rdr.GetString(12); } else { Client_Shelter.New_Shelter_address = " "; } if (!rdr.IsDBNull(13)) { Client_Shelter.New_Shelter_city = rdr.GetString(13); } else { Client_Shelter.New_Shelter_city = " "; } if (!rdr.IsDBNull(14)) { Client_Shelter.New_Shelter_State = rdr.GetString(14); } else { Client_Shelter.New_Shelter_State = " "; } if (!rdr.IsDBNull(15)) { Client_Shelter.New_Shelter_Zip = rdr.GetInt32(15); } else { Client_Shelter.New_Shelter_Zip = 0; } if (!rdr.IsDBNull(16)) { Client_Shelter.New_Contact_Number = rdr.GetInt32(16); } else { Client_Shelter.New_Contact_Number = 0; } if (!rdr.IsDBNull(17)) { Client_Shelter.Current_household_members_safe = rdr.GetString(17); } else { Client_Shelter.Current_household_members_safe = " "; } if (!rdr.IsDBNull(18)) { Client_Shelter.CheckIn_Date = rdr.GetDateTime(18); } else { Client_Shelter.CheckIn_Date = DateTime.Now; } if (!rdr.IsDBNull(19)) { Client_Shelter.CheckOut_Date = rdr.GetDateTime(19); } else { Client_Shelter.CheckOut_Date = DateTime.Now; } } else { Client_Shelter.SetColumnDefaults(); } } catch (Exception ex) { Client_Shelter.SetColumnDefaults(); return(Client_Shelter); } finally { con.Close(); } return(Client_Shelter); }