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