public Obstruction Select(int id) { Obstruction Obstruction = new Obstruction(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_OBSTRUCTION", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Obstruction_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Obstruction.Obstruction_ID = rdr.GetInt32(0); } else { Obstruction.Obstruction_ID = 0; } if (!rdr.IsDBNull(1)) { Obstruction.Evacuation_Area_ID = rdr.GetInt32(1); } else { Obstruction.Evacuation_Area_ID = 0; } if (!rdr.IsDBNull(2)) { Obstruction.Location_ID = rdr.GetInt32(2); } else { Obstruction.Location_ID = 0; } if (!rdr.IsDBNull(3)) { Obstruction.Date_Reported = rdr.GetDateTime(3); } else { Obstruction.Date_Reported = DateTime.Now; } if (!rdr.IsDBNull(4)) { Obstruction.Expected_Recovery_Date = rdr.GetDateTime(4); } else { Obstruction.Expected_Recovery_Date = DateTime.Now; } if (!rdr.IsDBNull(5)) { Obstruction.Type = rdr.GetString(5); } else { Obstruction.Type = " "; } if (!rdr.IsDBNull(6)) { Obstruction.Severity = rdr.GetString(6); } else { Obstruction.Severity = " "; } } else { Obstruction.SetColumnDefaults(); } } catch (Exception ex) { Obstruction.SetColumnDefaults(); return(Obstruction); } finally { con.Close(); } return(Obstruction); }
public Mobile_Product Select(int id) { Mobile_Product Mobile_Product = new Mobile_Product(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_MOBILE_PRODUCT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Mobile_Product_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Mobile_Product.Mobile_Product_id = rdr.GetInt32(0); } else { Mobile_Product.Mobile_Product_id = 0; } if (!rdr.IsDBNull(1)) { Mobile_Product.Mobile_Unit_id = rdr.GetInt32(1); } else { Mobile_Product.Mobile_Unit_id = 0; } if (!rdr.IsDBNull(2)) { Mobile_Product.Product_id = rdr.GetInt32(2); } else { Mobile_Product.Product_id = 0; } if (!rdr.IsDBNull(3)) { Mobile_Product.Case_id = rdr.GetInt32(3); } else { Mobile_Product.Case_id = 0; } if (!rdr.IsDBNull(4)) { Mobile_Product.Lot_id = rdr.GetInt32(4); } else { Mobile_Product.Lot_id = 0; } if (!rdr.IsDBNull(5)) { Mobile_Product.Min_inv = rdr.GetInt32(5); } else { Mobile_Product.Min_inv = 0; } if (!rdr.IsDBNull(6)) { Mobile_Product.Quantity = rdr.GetInt32(6); } else { Mobile_Product.Quantity = 0; } if (!rdr.IsDBNull(7)) { Mobile_Product.Experiation_Date = rdr.GetDateTime(7); } else { Mobile_Product.Experiation_Date = DateTime.Now; } } else { Mobile_Product.SetColumnDefaults(); } } catch (Exception ex) { Mobile_Product.SetColumnDefaults(); return(Mobile_Product); } finally { con.Close(); } return(Mobile_Product); }
public receipt Select(int id) { receipt receipt = new receipt(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_RECEIPT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Receipt_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { receipt.Receipt_ID = rdr.GetInt32(0); } else { receipt.Receipt_ID = 0; } if (!rdr.IsDBNull(1)) { receipt.Account_ID = rdr.GetInt32(1); } else { receipt.Account_ID = 0; } if (!rdr.IsDBNull(2)) { receipt.Check_Num = rdr.GetInt32(2); } else { receipt.Check_Num = 0; } if (!rdr.IsDBNull(3)) { receipt.DLN = rdr.GetInt32(3); } else { receipt.DLN = 0; } if (!rdr.IsDBNull(4)) { receipt.Phone = rdr.GetInt32(4); } else { receipt.Phone = 0; } if (!rdr.IsDBNull(5)) { receipt.Pay_Type = rdr.GetInt32(5); } else { receipt.Pay_Type = 0; } if (!rdr.IsDBNull(6)) { receipt.Amount = rdr.GetInt32(6); } else { receipt.Amount = 0; } if (!rdr.IsDBNull(7)) { receipt.Transfer = rdr.GetBoolean(7); } else { receipt.Transfer = false; } if (!rdr.IsDBNull(8)) { receipt.Recieve = rdr.GetBoolean(8); } else { receipt.Recieve = false; } } else { receipt.SetColumnDefaults(); } } catch (Exception ex) { receipt.SetColumnDefaults(); return(receipt); } finally { con.Close(); } return(receipt); }
public Evacuation_Encounter_Shelter_Client Select(int id) { Evacuation_Encounter_Shelter_Client Evacuation_Encounter_Shelter_Client = new Evacuation_Encounter_Shelter_Client(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_EVACUATION_ENCOUNTER_SHELTER_CLIENT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Evacuation_Encounter_Shelter_Client_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { Evacuation_Encounter_Shelter_Client.Evacuation_Encounter_Shelter_Client_ID = rdr.GetInt32(0); } else { Evacuation_Encounter_Shelter_Client.Evacuation_Encounter_Shelter_Client_ID = 0; } if (!rdr.IsDBNull(1)) { Evacuation_Encounter_Shelter_Client.Evacuation_Area_ID = rdr.GetInt32(1); } else { Evacuation_Encounter_Shelter_Client.Evacuation_Area_ID = 0; } if (!rdr.IsDBNull(2)) { Evacuation_Encounter_Shelter_Client.Encounter_Id = rdr.GetInt32(2); } else { Evacuation_Encounter_Shelter_Client.Encounter_Id = 0; } if (!rdr.IsDBNull(3)) { Evacuation_Encounter_Shelter_Client.Start_Date = rdr.GetDateTime(3); } else { Evacuation_Encounter_Shelter_Client.Start_Date = DateTime.Now; } if (!rdr.IsDBNull(4)) { Evacuation_Encounter_Shelter_Client.End_Date = rdr.GetDateTime(4); } else { Evacuation_Encounter_Shelter_Client.End_Date = DateTime.Now; } if (!rdr.IsDBNull(5)) { Evacuation_Encounter_Shelter_Client.Shelter_ID = rdr.GetInt32(5); } else { Evacuation_Encounter_Shelter_Client.Shelter_ID = 0; } if (!rdr.IsDBNull(6)) { Evacuation_Encounter_Shelter_Client.Client_ID = rdr.GetInt32(6); } else { Evacuation_Encounter_Shelter_Client.Client_ID = 0; } } else { Evacuation_Encounter_Shelter_Client.SetColumnDefaults(); } } catch (Exception ex) { Evacuation_Encounter_Shelter_Client.SetColumnDefaults(); return(Evacuation_Encounter_Shelter_Client); } finally { con.Close(); } return(Evacuation_Encounter_Shelter_Client); }
public employer Select(int id) { employer employer = new employer(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_EMPLOYER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@emplr_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { employer.emplr_id = rdr.GetInt32(0); } else { employer.emplr_id = 0; } if (!rdr.IsDBNull(1)) { employer.case_id = rdr.GetInt32(1); } else { employer.case_id = 0; } if (!rdr.IsDBNull(2)) { employer.client_id = rdr.GetInt32(2); } else { employer.client_id = 0; } if (!rdr.IsDBNull(3)) { employer.address_id = rdr.GetInt32(3); } else { employer.address_id = 0; } if (!rdr.IsDBNull(4)) { employer.emplr_name = rdr.GetString(4); } else { employer.emplr_name = " "; } if (!rdr.IsDBNull(5)) { employer.emplr_phone = rdr.GetString(5); } else { employer.emplr_phone = " "; } if (!rdr.IsDBNull(6)) { employer.end_date = rdr.GetDateTime(6); } else { employer.end_date = DateTime.Now; } if (!rdr.IsDBNull(7)) { employer.strt_date = rdr.GetDateTime(7); } else { employer.strt_date = DateTime.Now; } if (!rdr.IsDBNull(8)) { employer.term_reason = rdr.GetString(8); } else { employer.term_reason = " "; } } else { employer.SetColumnDefaults(); } } catch (Exception ex) { employer.SetColumnDefaults(); return(employer); } finally { con.Close(); } return(employer); }
public employee Select(int id) { employee employee = new employee(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_EMPLOYEE", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@employee_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { employee.employee_id = rdr.GetInt32(0); } else { employee.employee_id = 0; } if (!rdr.IsDBNull(1)) { employee.employee_date_hired = rdr.GetDateTime(1); } else { employee.employee_date_hired = DateTime.Now; } if (!rdr.IsDBNull(2)) { employee.employee_department = rdr.GetString(2); } else { employee.employee_department = " "; } if (!rdr.IsDBNull(3)) { employee.employee_hours_worked = rdr.GetInt32(3); } else { employee.employee_hours_worked = 0; } if (!rdr.IsDBNull(4)) { employee.employee_leadership = rdr.GetString(4); } else { employee.employee_leadership = " "; } if (!rdr.IsDBNull(5)) { employee.employee_motivation = rdr.GetString(5); } else { employee.employee_motivation = " "; } if (!rdr.IsDBNull(6)) { employee.employee_notes = rdr.GetString(6); } else { employee.employee_notes = " "; } if (!rdr.IsDBNull(7)) { employee.employee_overall = rdr.GetString(7); } else { employee.employee_overall = " "; } if (!rdr.IsDBNull(8)) { employee.employee_payrate = rdr.GetDecimal(8); } else { employee.employee_payrate = 0; } if (!rdr.IsDBNull(9)) { employee.employee_performance = rdr.GetString(9); } else { employee.employee_performance = " "; } if (!rdr.IsDBNull(10)) { employee.employee_quality = rdr.GetString(10); } else { employee.employee_quality = " "; } if (!rdr.IsDBNull(11)) { employee.employee_timeliness = rdr.GetString(11); } else { employee.employee_timeliness = " "; } if (!rdr.IsDBNull(12)) { employee.username = rdr.GetString(12); } else { employee.username = "******"; } if (!rdr.IsDBNull(13)) { employee.pswd = rdr.GetString(13); } else { employee.pswd = " "; } } else { employee.SetColumnDefaults(); } } catch (Exception ex) { employee.SetColumnDefaults(); return(employee); } finally { con.Close(); } return(employee); }
public account Select(int id) { account account = new account(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_ACCOUNT", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Account_ID", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { account.Account_ID = rdr.GetInt32(0); } else { account.Account_ID = 0; } if (!rdr.IsDBNull(1)) { account.Bank_ID = rdr.GetInt32(1); } else { account.Bank_ID = 0; } if (!rdr.IsDBNull(2)) { account.Account_Num = rdr.GetString(2); } else { account.Account_Num = " "; } if (!rdr.IsDBNull(3)) { account.Type = rdr.GetString(3); } else { account.Type = " "; } } else { account.SetColumnDefaults(); } } catch (Exception ex) { account.SetColumnDefaults(); return(account); } finally { con.Close(); } return(account); }
public demobilization_location Select(int id) { demobilization_location demobilization_location = new demobilization_location(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_DEMOBILIZATION_LOCATION", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@demo_location_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { demobilization_location.demo_location_id = rdr.GetInt32(0); } else { demobilization_location.demo_location_id = 0; } if (!rdr.IsDBNull(1)) { demobilization_location.demo_id = rdr.GetInt32(1); } else { demobilization_location.demo_id = 0; } if (!rdr.IsDBNull(2)) { demobilization_location.location_id = rdr.GetInt32(2); } else { demobilization_location.location_id = 0; } if (!rdr.IsDBNull(3)) { demobilization_location.location_description = rdr.GetString(3); } else { demobilization_location.location_description = " "; } } else { demobilization_location.SetColumnDefaults(); } } catch (Exception ex) { demobilization_location.SetColumnDefaults(); return(demobilization_location); } finally { con.Close(); } return(demobilization_location); }
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 encounter Select(int id) { encounter encounter = new encounter(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_ENCOUNTER", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@encounter_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { encounter.encounter_id = rdr.GetInt32(0); } else { encounter.encounter_id = 0; } if (!rdr.IsDBNull(1)) { encounter.case_id = rdr.GetInt32(1); } else { encounter.case_id = 0; } if (!rdr.IsDBNull(2)) { encounter.agency_id = rdr.GetInt32(2); } else { encounter.agency_id = 0; } if (!rdr.IsDBNull(3)) { encounter.call_center_id = rdr.GetInt32(3); } else { encounter.call_center_id = 0; } if (!rdr.IsDBNull(4)) { encounter.client_id = rdr.GetInt32(4); } else { encounter.client_id = 0; } if (!rdr.IsDBNull(5)) { encounter.create_date = rdr.GetDateTime(5); } else { encounter.create_date = DateTime.Now; } if (!rdr.IsDBNull(6)) { encounter.close_date = rdr.GetDateTime(6); } else { encounter.close_date = DateTime.Now; } if (!rdr.IsDBNull(7)) { encounter.disaster_id = rdr.GetInt32(7); } else { encounter.disaster_id = 0; } if (!rdr.IsDBNull(8)) { encounter.Location_ID = rdr.GetInt32(8); } else { encounter.Location_ID = 0; } if (!rdr.IsDBNull(9)) { encounter.Pet_Record_ID = rdr.GetInt32(9); } else { encounter.Pet_Record_ID = 0; } } else { encounter.SetColumnDefaults(); } } catch (Exception ex) { encounter.SetColumnDefaults(); return(encounter); } finally { con.Close(); } return(encounter); }
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 vehicle Insert(vehicle id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_VEHICLE", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@case_id", id.case_id); cmd.Parameters.AddWithValue("@client_id", id.client_id); cmd.Parameters.AddWithValue("@vehicle_make", id.vehicle_make); cmd.Parameters.AddWithValue("@vehicle_model", id.vehicle_model); cmd.Parameters.AddWithValue("@vehicle_type", id.vehicle_type); cmd.Parameters.AddWithValue("@vehicle_year", id.vehicle_year); cmd.Parameters.AddWithValue("@vehicle_desc", id.vehicle_desc); cmd.Parameters.AddWithValue("@vin", id.vin); cmd.Parameters.AddWithValue("@start_mileage", id.start_mileage); cmd.Parameters.AddWithValue("@first_service_date", id.first_service_date); cmd.Parameters.AddWithValue("@last_service_date", id.last_service_date); cmd.Parameters.AddWithValue("@PLATENUMBER", id.PLATENUMBER); cmd.Parameters.AddWithValue("@FUELTYPE", id.FUELTYPE); cmd.Parameters.AddWithValue("@MPH", id.MPH); cmd.Parameters.AddWithValue("@INSURED", id.INSURED); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_VEHICLE", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@case_id", id.case_id); cmd.Parameters.AddWithValue("@client_id", id.client_id); cmd.Parameters.AddWithValue("@vehicle_make", id.vehicle_make); cmd.Parameters.AddWithValue("@vehicle_model", id.vehicle_model); cmd.Parameters.AddWithValue("@vehicle_type", id.vehicle_type); cmd.Parameters.AddWithValue("@vehicle_year", id.vehicle_year); cmd.Parameters.AddWithValue("@vehicle_desc", id.vehicle_desc); cmd.Parameters.AddWithValue("@vin", id.vin); cmd.Parameters.AddWithValue("@start_mileage", id.start_mileage); cmd.Parameters.AddWithValue("@first_service_date", id.first_service_date); cmd.Parameters.AddWithValue("@last_service_date", id.last_service_date); cmd.Parameters.AddWithValue("@PLATENUMBER", id.PLATENUMBER); cmd.Parameters.AddWithValue("@FUELTYPE", id.FUELTYPE); cmd.Parameters.AddWithValue("@MPH", id.MPH); cmd.Parameters.AddWithValue("@INSURED", id.INSURED); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.vehicle_id = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return(id); }
public vehicle Select(int id) { vehicle vehicle = new vehicle(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_VEHICLE", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@vehicle_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { vehicle.vehicle_id = rdr.GetInt32(0); } else { vehicle.vehicle_id = 0; } if (!rdr.IsDBNull(1)) { vehicle.case_id = rdr.GetInt32(1); } else { vehicle.case_id = 0; } if (!rdr.IsDBNull(2)) { vehicle.client_id = rdr.GetInt32(2); } else { vehicle.client_id = 0; } if (!rdr.IsDBNull(3)) { vehicle.vehicle_make = rdr.GetString(3); } else { vehicle.vehicle_make = " "; } if (!rdr.IsDBNull(4)) { vehicle.vehicle_model = rdr.GetString(4); } else { vehicle.vehicle_model = " "; } if (!rdr.IsDBNull(5)) { vehicle.vehicle_type = rdr.GetString(5); } else { vehicle.vehicle_type = " "; } if (!rdr.IsDBNull(6)) { vehicle.vehicle_year = rdr.GetInt32(6); } else { vehicle.vehicle_year = 0; } if (!rdr.IsDBNull(7)) { vehicle.vehicle_desc = rdr.GetString(7); } else { vehicle.vehicle_desc = " "; } if (!rdr.IsDBNull(8)) { vehicle.vin = rdr.GetString(8); } else { vehicle.vin = " "; } if (!rdr.IsDBNull(9)) { vehicle.start_mileage = rdr.GetInt32(9); } else { vehicle.start_mileage = 0; } if (!rdr.IsDBNull(10)) { vehicle.first_service_date = rdr.GetDateTime(10); } else { vehicle.first_service_date = DateTime.Now; } if (!rdr.IsDBNull(11)) { vehicle.last_service_date = rdr.GetDateTime(11); } else { vehicle.last_service_date = DateTime.Now; } if (!rdr.IsDBNull(12)) { vehicle.PLATENUMBER = rdr.GetString(12); } else { vehicle.PLATENUMBER = " "; } if (!rdr.IsDBNull(13)) { vehicle.FUELTYPE = rdr.GetString(13); } else { vehicle.FUELTYPE = " "; } if (!rdr.IsDBNull(14)) { vehicle.MPH = rdr.GetInt32(14); } else { vehicle.MPH = 0; } if (!rdr.IsDBNull(15)) { vehicle.INSURED = rdr.GetString(15); } else { vehicle.INSURED = " "; } } else { vehicle.SetColumnDefaults(); } } catch (Exception ex) { vehicle.SetColumnDefaults(); return(vehicle); } finally { con.Close(); } return(vehicle); }
public vendor Insert(vendor id) { string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_VENDOR", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@vendor_name", id.vendor_name); cmd.Parameters.AddWithValue("@phone_num", id.phone_num); cmd.Parameters.AddWithValue("@email", id.email); cmd.Parameters.AddWithValue("@address_id", id.address_id); cmd.Parameters.AddWithValue("@Vendor_address2", id.Vendor_address2); cmd.Parameters.AddWithValue("@vendor_job_assign", id.vendor_job_assign); cmd.Parameters.AddWithValue("@vendor_start_date", id.vendor_start_date); cmd.Parameters.AddWithValue("@vendor_end_date", id.vendor_end_date); cmd.Parameters.AddWithValue("@vendor_meth_of_contact", id.vendor_meth_of_contact); cmd.Parameters.AddWithValue("@vendor_status", id.vendor_status); cmd.Parameters.AddWithValue("@vendor_meth_of_pay", id.vendor_meth_of_pay); cmd.Parameters.AddWithValue("@vendor_type", id.vendor_type); cmd.Parameters.AddWithValue("@vendor_comments", id.vendor_comments); cmd.Parameters.AddWithValue("@primary_fName", id.primary_fName); cmd.Parameters.AddWithValue("@primary_lName", id.primary_lName); cmd.Parameters.AddWithValue("@primary_phone", id.primary_phone); cmd.Parameters.AddWithValue("@sec_fName", id.sec_fName); cmd.Parameters.AddWithValue("@sec_lName", id.sec_lName); cmd.Parameters.AddWithValue("@sec_phone", id.sec_phone); cmd.ExecuteReader(); con.Close(); con.Open(); cmd = new SqlCommand("SP_DMCS_GET_VENDOR", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@vendor_name", id.vendor_name); cmd.Parameters.AddWithValue("@phone_num", id.phone_num); cmd.Parameters.AddWithValue("@email", id.email); cmd.Parameters.AddWithValue("@address_id", id.address_id); cmd.Parameters.AddWithValue("@Vendor_address2", id.Vendor_address2); cmd.Parameters.AddWithValue("@vendor_job_assign", id.vendor_job_assign); cmd.Parameters.AddWithValue("@vendor_start_date", id.vendor_start_date); cmd.Parameters.AddWithValue("@vendor_end_date", id.vendor_end_date); cmd.Parameters.AddWithValue("@vendor_meth_of_contact", id.vendor_meth_of_contact); cmd.Parameters.AddWithValue("@vendor_status", id.vendor_status); cmd.Parameters.AddWithValue("@vendor_meth_of_pay", id.vendor_meth_of_pay); cmd.Parameters.AddWithValue("@vendor_type", id.vendor_type); cmd.Parameters.AddWithValue("@vendor_comments", id.vendor_comments); cmd.Parameters.AddWithValue("@primary_fName", id.primary_fName); cmd.Parameters.AddWithValue("@primary_lName", id.primary_lName); cmd.Parameters.AddWithValue("@primary_phone", id.primary_phone); cmd.Parameters.AddWithValue("@sec_fName", id.sec_fName); cmd.Parameters.AddWithValue("@sec_lName", id.sec_lName); cmd.Parameters.AddWithValue("@sec_phone", id.sec_phone); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); id.vendor_id = rdr.GetInt32(0); } } catch (Exception ex) { id.SetColumnDefaults(); } finally { con.Close(); } return(id); }
public vendor Select(int id) { vendor vendor = new vendor(); string ConnectionString = IDManager.connection(); SqlConnection con = new SqlConnection(ConnectionString); try { con.Open(); SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_VENDOR", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@vendor_id", id); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { rdr.Read(); if (!rdr.IsDBNull(0)) { vendor.vendor_id = rdr.GetInt32(0); } else { vendor.vendor_id = 0; } if (!rdr.IsDBNull(1)) { vendor.vendor_name = rdr.GetString(1); } else { vendor.vendor_name = " "; } if (!rdr.IsDBNull(2)) { vendor.phone_num = rdr.GetString(2); } else { vendor.phone_num = " "; } if (!rdr.IsDBNull(3)) { vendor.email = rdr.GetString(3); } else { vendor.email = " "; } if (!rdr.IsDBNull(4)) { vendor.address_id = rdr.GetInt32(4); } else { vendor.address_id = 0; } if (!rdr.IsDBNull(5)) { vendor.Vendor_address2 = rdr.GetInt32(5); } else { vendor.Vendor_address2 = 0; } if (!rdr.IsDBNull(6)) { vendor.vendor_job_assign = rdr.GetString(6); } else { vendor.vendor_job_assign = " "; } if (!rdr.IsDBNull(7)) { vendor.vendor_start_date = rdr.GetDateTime(7); } else { vendor.vendor_start_date = DateTime.Now; } if (!rdr.IsDBNull(8)) { vendor.vendor_end_date = rdr.GetDateTime(8); } else { vendor.vendor_end_date = DateTime.Now; } if (!rdr.IsDBNull(9)) { vendor.vendor_meth_of_contact = rdr.GetString(9); } else { vendor.vendor_meth_of_contact = " "; } if (!rdr.IsDBNull(10)) { vendor.vendor_status = rdr.GetString(10); } else { vendor.vendor_status = " "; } if (!rdr.IsDBNull(11)) { vendor.vendor_meth_of_pay = rdr.GetString(11); } else { vendor.vendor_meth_of_pay = " "; } if (!rdr.IsDBNull(12)) { vendor.vendor_type = rdr.GetString(12); } else { vendor.vendor_type = " "; } if (!rdr.IsDBNull(13)) { vendor.vendor_comments = rdr.GetString(13); } else { vendor.vendor_comments = " "; } if (!rdr.IsDBNull(14)) { vendor.primary_fName = rdr.GetString(14); } else { vendor.primary_fName = " "; } if (!rdr.IsDBNull(15)) { vendor.primary_lName = rdr.GetString(15); } else { vendor.primary_lName = " "; } if (!rdr.IsDBNull(16)) { vendor.primary_phone = rdr.GetString(16); } else { vendor.primary_phone = " "; } if (!rdr.IsDBNull(17)) { vendor.sec_fName = rdr.GetString(17); } else { vendor.sec_fName = " "; } if (!rdr.IsDBNull(18)) { vendor.sec_lName = rdr.GetString(18); } else { vendor.sec_lName = " "; } if (!rdr.IsDBNull(19)) { vendor.sec_phone = rdr.GetString(19); } else { vendor.sec_phone = " "; } } else { vendor.SetColumnDefaults(); } } catch (Exception ex) { vendor.SetColumnDefaults(); return(vendor); } finally { con.Close(); } return(vendor); }