public Boolean Update(disaster id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_DISASTER", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@disaster_id", id.disaster_id);
cmd.Parameters.AddWithValue("@disaster_name", id.disaster_name);
cmd.Parameters.AddWithValue("@disaster_type", id.disaster_type);
cmd.Parameters.AddWithValue("@disaster_start_date", id.disaster_start_date);
cmd.Parameters.AddWithValue("@disaster_end_date", id.disaster_end_date);
cmd.Parameters.AddWithValue("@disaster_north_latitude", id.disaster_north_latitude);
cmd.Parameters.AddWithValue("@disaster_north_longitude", id.disaster_north_longitude);
cmd.Parameters.AddWithValue("@disaster_south_latitude", id.disaster_south_latitude);
cmd.Parameters.AddWithValue("@disaster_south_longitude", id.disaster_south_longitude);
cmd.Parameters.AddWithValue("@disaster_east_latitude", id.disaster_east_latitude);
cmd.Parameters.AddWithValue("@disaster_east_longitude", id.disaster_east_longitude);
cmd.Parameters.AddWithValue("@disaster_west_latitude", id.disaster_west_latitude);
cmd.Parameters.AddWithValue("@disaster_west_longitude", id.disaster_west_longitude);
cmd.ExecuteReader();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
con.Close();
}
}
public Boolean Delete(int id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_DELETE_EVACUATION_ENCOUNTER_SHELTER_EMPLOYEE", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Evacuation_Encounter_Shelter_Employee_ID", id);
cmd.ExecuteReader();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
con.Close();
}
}
public DataTable Select(string whereclause)
{
DataTable alrows = new DataTable();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_INCOME_SOURCE_WC", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@wareclause", whereclause);
SqlDataReader rdr = cmd.ExecuteReader();
alrows.Load(rdr);
return alrows;
}
catch (Exception ex)
{
return alrows;
}
finally
{
con.Close();
}
}
public Boolean Delete(int id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_DELETE_PRO_REQUIRE_TASK_RES", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Proj_Require_Task_Res_ID", id);
cmd.ExecuteReader();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
con.Close();
}
}
public Boolean Delete(int id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_DELETE_DISASTER_PROJECT_TASK_LOCATION", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@disaster_project_task_location_id", id);
cmd.ExecuteReader();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
con.Close();
}
}
public Boolean Update(locationDMCS id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_LOCATIONDMCS", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@locationdmcs_id", id.locationdmcs_id);
cmd.Parameters.AddWithValue("@city", id.city);
cmd.Parameters.AddWithValue("@county", id.county);
cmd.Parameters.AddWithValue("@e_lat", id.e_lat);
cmd.Parameters.AddWithValue("@e_long", id.e_long);
cmd.Parameters.AddWithValue("@location_desc", id.location_desc);
cmd.Parameters.AddWithValue("@n_lat", id.n_lat);
cmd.Parameters.AddWithValue("@n_long", id.n_long);
cmd.Parameters.AddWithValue("@state", id.state);
cmd.Parameters.AddWithValue("@type", id.type);
cmd.Parameters.AddWithValue("@w_lat", id.w_lat);
cmd.Parameters.AddWithValue("@w_long", id.w_long);
cmd.Parameters.AddWithValue("@zip", id.zip);
cmd.ExecuteReader();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
con.Close();
}
}
public tier_req Insert(tier_req id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_TIER_REQ", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@req_id", id.req_id);
cmd.Parameters.AddWithValue("@tier_id", id.tier_id);
cmd.ExecuteReader();
con.Close();
con.Open();
cmd = new SqlCommand("SP_DMCS_GET_TIER_REQ", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@req_id", id.req_id);
cmd.Parameters.AddWithValue("@tier_id", id.tier_id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
id.tier_req_id = rdr.GetInt32(0);
}
}
catch (Exception ex)
{
id.SetColumnDefaults();
}
finally
{
con.Close();
}
return(id);
}
public Boolean Update(job id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_JOB", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@job_id", id.job_id);
cmd.Parameters.AddWithValue("@address_id", id.address_id);
cmd.Parameters.AddWithValue("@company_id", id.company_id);
cmd.Parameters.AddWithValue("@job_cat_id", id.job_cat_id);
cmd.Parameters.AddWithValue("@job_posted_date", id.job_posted_date);
cmd.Parameters.AddWithValue("@job_status", id.job_status);
cmd.Parameters.AddWithValue("@job_title", id.job_title);
cmd.Parameters.AddWithValue("@Work_Classification_Full_time", id.Work_Classification_Full_time);
cmd.Parameters.AddWithValue("@Work_Classification_Part_time", id.Work_Classification_Part_time);
cmd.Parameters.AddWithValue("@Work_Payment_Freq_Weekly", id.Work_Payment_Freq_Weekly);
cmd.Parameters.AddWithValue("@Work_Payment_Freq_Bi_Weekly", id.Work_Payment_Freq_Bi_Weekly);
cmd.Parameters.AddWithValue("@Work_Payment_Freq_Monthly", id.Work_Payment_Freq_Monthly);
cmd.Parameters.AddWithValue("@Work_Payment_Freq_Bi_Monthly", id.Work_Payment_Freq_Bi_Monthly);
cmd.ExecuteReader();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
con.Close();
}
}
public call_center_employee Insert(call_center_employee id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_CALL_CENTER_EMPLOYEE", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@call_center_id", id.call_center_id);
cmd.Parameters.AddWithValue("@employee_id", id.employee_id);
cmd.ExecuteReader();
con.Close();
con.Open();
cmd = new SqlCommand("SP_DMCS_GET_CALL_CENTER_EMPLOYEE", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@call_center_id", id.call_center_id);
cmd.Parameters.AddWithValue("@employee_id", id.employee_id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
id.call_center_employee_id = rdr.GetInt32(0);
}
}
catch (Exception ex)
{
id.SetColumnDefaults();
}
finally
{
con.Close();
}
return(id);
}
public Boolean Update(demobilization id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_DEMOBILIZATION", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@demo_id", id.demo_id);
cmd.ExecuteReader();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
con.Close();
}
}
public disaster_project_task Insert(disaster_project_task id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_DISASTER_PROJECT_TASK", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@skills_id", id.skills_id);
cmd.Parameters.AddWithValue("@disaster_project_task_description", id.disaster_project_task_description);
cmd.ExecuteReader();
con.Close();
con.Open();
cmd = new SqlCommand("SP_DMCS_GET_DISASTER_PROJECT_TASK", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@skills_id", id.skills_id);
cmd.Parameters.AddWithValue("@disaster_project_task_description", id.disaster_project_task_description);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
id.disaster_project_task_id = rdr.GetInt32(0);
}
}
catch (Exception ex)
{
id.SetColumnDefaults();
}
finally
{
con.Close();
}
return(id);
}
public Boolean Delete(int id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_DELETE_VACCINE", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@vaccine_id", id);
cmd.ExecuteReader();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
con.Close();
}
}
public DataTable SelectPet()
{
DataTable alrows = new DataTable();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_XML_DATASOURCE_SEARCH_PET", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader();
alrows.Load(rdr);
return(alrows);
}
catch (Exception ex)
{
return(alrows);
}
finally
{
con.Close();
}
}
public Boolean Update(products id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_PRODUCTS", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@product_id", id.product_id);
cmd.Parameters.AddWithValue("@Resource_ID", id.Resource_ID);
cmd.Parameters.AddWithValue("@product_name", id.product_name);
cmd.Parameters.AddWithValue("@product_type", id.product_type);
cmd.Parameters.AddWithValue("@product_qty", id.product_qty);
cmd.Parameters.AddWithValue("@product_desc", id.product_desc);
cmd.Parameters.AddWithValue("@product_color", id.product_color);
cmd.Parameters.AddWithValue("@product_size", id.product_size);
cmd.Parameters.AddWithValue("@product_cost", id.product_cost);
cmd.Parameters.AddWithValue("@Product_exp_date", id.Product_exp_date);
cmd.Parameters.AddWithValue("@Product_Alergy_info", id.Product_Alergy_info);
cmd.Parameters.AddWithValue("@Product_refrigde", id.Product_refrigde);
cmd.Parameters.AddWithValue("@Product_Flammable", id.Product_Flammable);
cmd.Parameters.AddWithValue("@Product_Hazard", id.Product_Hazard);
cmd.Parameters.AddWithValue("@Product_Other", id.Product_Other);
cmd.Parameters.AddWithValue("@Product_Min_Inv", id.Product_Min_Inv);
cmd.Parameters.AddWithValue("@Product_Barcode", id.Product_Barcode);
cmd.Parameters.AddWithValue("@Product_subtype", id.Product_subtype);
cmd.Parameters.AddWithValue("@Make", id.Make);
cmd.Parameters.AddWithValue("@Model", id.Model);
cmd.Parameters.AddWithValue("@FEMA_Description", id.FEMA_Description);
cmd.Parameters.AddWithValue("@Year", id.Year);
cmd.Parameters.AddWithValue("@RFID", id.RFID);
cmd.Parameters.AddWithValue("@GPS", id.GPS);
cmd.Parameters.AddWithValue("@Serial_Number", id.Serial_Number);
cmd.Parameters.AddWithValue("@Height", id.Height);
cmd.Parameters.AddWithValue("@Length", id.Length);
cmd.Parameters.AddWithValue("@Depth", id.Depth);
cmd.Parameters.AddWithValue("@Weight", id.Weight);
cmd.Parameters.AddWithValue("@OAI", id.OAI);
cmd.Parameters.AddWithValue("@OAI_Type", id.OAI_Type);
cmd.Parameters.AddWithValue("@Use", id.Use);
cmd.Parameters.AddWithValue("@Brand", id.Brand);
cmd.Parameters.AddWithValue("@Power_Supply", id.Power_Supply);
cmd.Parameters.AddWithValue("@Gas_Type", id.Gas_Type);
cmd.Parameters.AddWithValue("@Needs_Gas", id.Needs_Gas);
cmd.Parameters.AddWithValue("@Needs_Electricity", id.Needs_Electricity);
cmd.Parameters.AddWithValue("@Availability", id.Availability);
cmd.Parameters.AddWithValue("@Datetime", id.Datetime);
cmd.Parameters.AddWithValue("@OpenStatus", id.OpenStatus);
cmd.ExecuteReader();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
con.Close();
}
}
public products Select(int id)
{
products products = new products();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_PRODUCTS", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@product_id", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
products.product_id = rdr.GetInt32(0);
}
else
{
products.product_id = 0;
}
if (!rdr.IsDBNull(1))
{
products.Resource_ID = rdr.GetInt32(1);
}
else
{
products.Resource_ID = 0;
}
if (!rdr.IsDBNull(2))
{
products.product_name = rdr.GetString(2);
}
else
{
products.product_name = " ";
}
if (!rdr.IsDBNull(3))
{
products.product_type = rdr.GetString(3);
}
else
{
products.product_type = " ";
}
if (!rdr.IsDBNull(4))
{
products.product_qty = rdr.GetInt32(4);
}
else
{
products.product_qty = 0;
}
if (!rdr.IsDBNull(5))
{
products.product_desc = rdr.GetString(5);
}
else
{
products.product_desc = " ";
}
if (!rdr.IsDBNull(6))
{
products.product_color = rdr.GetString(6);
}
else
{
products.product_color = " ";
}
if (!rdr.IsDBNull(7))
{
products.product_size = rdr.GetString(7);
}
else
{
products.product_size = " ";
}
if (!rdr.IsDBNull(8))
{
products.product_cost = rdr.GetDecimal(8);
}
else
{
products.product_cost = 0;
}
if (!rdr.IsDBNull(9))
{
products.Product_exp_date = rdr.GetDateTime(9);
}
else
{
products.Product_exp_date = DateTime.Now;
}
if (!rdr.IsDBNull(10))
{
products.Product_Alergy_info = rdr.GetString(10);
}
else
{
products.Product_Alergy_info = " ";
}
if (!rdr.IsDBNull(11))
{
products.Product_refrigde = rdr.GetString(11);
}
else
{
products.Product_refrigde = " ";
}
if (!rdr.IsDBNull(12))
{
products.Product_Flammable = rdr.GetString(12);
}
else
{
products.Product_Flammable = " ";
}
if (!rdr.IsDBNull(13))
{
products.Product_Hazard = rdr.GetString(13);
}
else
{
products.Product_Hazard = " ";
}
if (!rdr.IsDBNull(14))
{
products.Product_Other = rdr.GetString(14);
}
else
{
products.Product_Other = " ";
}
if (!rdr.IsDBNull(15))
{
products.Product_Min_Inv = rdr.GetInt32(15);
}
else
{
products.Product_Min_Inv = 0;
}
if (!rdr.IsDBNull(16))
{
products.Product_Barcode = rdr.GetString(16);
}
else
{
products.Product_Barcode = " ";
}
if (!rdr.IsDBNull(17))
{
products.Product_subtype = rdr.GetString(17);
}
else
{
products.Product_subtype = " ";
}
if (!rdr.IsDBNull(18))
{
products.Make = rdr.GetString(18);
}
else
{
products.Make = " ";
}
if (!rdr.IsDBNull(19))
{
products.Model = rdr.GetString(19);
}
else
{
products.Model = " ";
}
if (!rdr.IsDBNull(20))
{
products.FEMA_Description = rdr.GetString(20);
}
else
{
products.FEMA_Description = " ";
}
if (!rdr.IsDBNull(21))
{
products.Year = rdr.GetString(21);
}
else
{
products.Year = " ";
}
if (!rdr.IsDBNull(22))
{
products.RFID = rdr.GetString(22);
}
else
{
products.RFID = " ";
}
if (!rdr.IsDBNull(23))
{
products.GPS = rdr.GetString(23);
}
else
{
products.GPS = " ";
}
if (!rdr.IsDBNull(24))
{
products.Serial_Number = rdr.GetString(24);
}
else
{
products.Serial_Number = " ";
}
if (!rdr.IsDBNull(25))
{
products.Height = rdr.GetString(25);
}
else
{
products.Height = " ";
}
if (!rdr.IsDBNull(26))
{
products.Length = rdr.GetString(26);
}
else
{
products.Length = " ";
}
if (!rdr.IsDBNull(27))
{
products.Depth = rdr.GetString(27);
}
else
{
products.Depth = " ";
}
if (!rdr.IsDBNull(28))
{
products.Weight = rdr.GetString(28);
}
else
{
products.Weight = " ";
}
if (!rdr.IsDBNull(29))
{
products.OAI = rdr.GetString(29);
}
else
{
products.OAI = " ";
}
if (!rdr.IsDBNull(30))
{
products.OAI_Type = rdr.GetString(30);
}
else
{
products.OAI_Type = " ";
}
if (!rdr.IsDBNull(31))
{
products.Use = rdr.GetString(31);
}
else
{
products.Use = " ";
}
if (!rdr.IsDBNull(32))
{
products.Brand = rdr.GetString(32);
}
else
{
products.Brand = " ";
}
if (!rdr.IsDBNull(33))
{
products.Power_Supply = rdr.GetString(33);
}
else
{
products.Power_Supply = " ";
}
if (!rdr.IsDBNull(34))
{
products.Gas_Type = rdr.GetString(34);
}
else
{
products.Gas_Type = " ";
}
if (!rdr.IsDBNull(35))
{
products.Needs_Gas = rdr.GetBoolean(35);
}
else
{
products.Needs_Gas = false;
}
if (!rdr.IsDBNull(36))
{
products.Needs_Electricity = rdr.GetBoolean(36);
}
else
{
products.Needs_Electricity = false;
}
if (!rdr.IsDBNull(37))
{
products.Availability = rdr.GetString(37);
}
else
{
products.Availability = " ";
}
if (!rdr.IsDBNull(38))
{
products.Datetime = rdr.GetDateTime(38);
}
else
{
products.Datetime = DateTime.Now;
}
if (!rdr.IsDBNull(39))
{
products.OpenStatus = rdr.GetString(39);
}
else
{
products.OpenStatus = " ";
}
}
else
{
products.SetColumnDefaults();
}
}
catch (Exception ex)
{
products.SetColumnDefaults();
return(products);
}
finally
{
con.Close();
}
return(products);
}
public ClientWPets Select(int id)
{
ClientWPets ClientWPets = new ClientWPets();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_CLIENTWPETS", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CLIENTWPETS_ID", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
ClientWPets.CLIENTWPETS_ID = rdr.GetInt32(0);
}
else
{
ClientWPets.CLIENTWPETS_ID = 0;
}
if (!rdr.IsDBNull(1))
{
ClientWPets.Pet_Record_ID = rdr.GetInt32(1);
}
else
{
ClientWPets.Pet_Record_ID = 0;
}
if (!rdr.IsDBNull(2))
{
ClientWPets.Client_id = rdr.GetInt32(2);
}
else
{
ClientWPets.Client_id = 0;
}
if (!rdr.IsDBNull(3))
{
ClientWPets.Location_ID = rdr.GetInt32(3);
}
else
{
ClientWPets.Location_ID = 0;
}
if (!rdr.IsDBNull(4))
{
ClientWPets.cp_Date = rdr.GetDateTime(4);
}
else
{
ClientWPets.cp_Date = DateTime.Now;
}
if (!rdr.IsDBNull(5))
{
ClientWPets.ownership = rdr.GetString(5);
}
else
{
ClientWPets.ownership = " ";
}
}
else
{
ClientWPets.SetColumnDefaults();
}
}
catch (Exception ex)
{
ClientWPets.SetColumnDefaults();
return(ClientWPets);
}
finally
{
con.Close();
}
return(ClientWPets);
}
public warehouse Select(int id)
{
warehouse warehouse = new warehouse();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_WAREHOUSE", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@warehouse_id", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
warehouse.warehouse_id = rdr.GetInt32(0);
}
else
{
warehouse.warehouse_id = 0;
}
if (!rdr.IsDBNull(1))
{
warehouse.warehouse_name = rdr.GetString(1);
}
else
{
warehouse.warehouse_name = " ";
}
if (!rdr.IsDBNull(2))
{
warehouse.address_id = rdr.GetInt32(2);
}
else
{
warehouse.address_id = 0;
}
if (!rdr.IsDBNull(3))
{
warehouse.warehouse_type = rdr.GetString(3);
}
else
{
warehouse.warehouse_type = " ";
}
if (!rdr.IsDBNull(4))
{
warehouse.Location_ID = rdr.GetInt32(4);
}
else
{
warehouse.Location_ID = 0;
}
}
else
{
warehouse.SetColumnDefaults();
}
}
catch (Exception ex)
{
warehouse.SetColumnDefaults();
return(warehouse);
}
finally
{
con.Close();
}
return(warehouse);
}
public vaccine Select(int id)
{
vaccine vaccine = new vaccine();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_VACCINE", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@vaccine_id", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
vaccine.vaccine_id = rdr.GetInt32(0);
}
else
{
vaccine.vaccine_id = 0;
}
if (!rdr.IsDBNull(1))
{
vaccine.medicine_id = rdr.GetInt32(1);
}
else
{
vaccine.medicine_id = 0;
}
if (!rdr.IsDBNull(2))
{
vaccine.Num_of_reg_doses = rdr.GetInt32(2);
}
else
{
vaccine.Num_of_reg_doses = 0;
}
if (!rdr.IsDBNull(3))
{
vaccine.vaccine_name = rdr.GetString(3);
}
else
{
vaccine.vaccine_name = " ";
}
}
else
{
vaccine.SetColumnDefaults();
}
}
catch (Exception ex)
{
vaccine.SetColumnDefaults();
return(vaccine);
}
finally
{
con.Close();
}
return(vaccine);
}
public personDMCS Insert(personDMCS id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_PERSONDMCS", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Resource_ID", id.Resource_ID);
cmd.Parameters.AddWithValue("@f_name", id.f_name);
cmd.Parameters.AddWithValue("@l_name", id.l_name);
cmd.Parameters.AddWithValue("@address", id.address);
cmd.Parameters.AddWithValue("@city", id.city);
cmd.Parameters.AddWithValue("@state", id.state);
cmd.Parameters.AddWithValue("@zipcode", id.zipcode);
cmd.Parameters.AddWithValue("@phone_primary", id.phone_primary);
cmd.Parameters.AddWithValue("@email", id.email);
cmd.Parameters.AddWithValue("@creditcard", id.creditcard);
cmd.Parameters.AddWithValue("@availability_date", id.availability_date);
cmd.Parameters.AddWithValue("@availability_hours", id.availability_hours);
cmd.Parameters.AddWithValue("@birthdate", id.birthdate);
cmd.Parameters.AddWithValue("@marital_status", id.marital_status);
cmd.Parameters.AddWithValue("@gender", id.gender);
cmd.Parameters.AddWithValue("@jobtitle", id.jobtitle);
cmd.Parameters.AddWithValue("@workdate", id.workdate);
cmd.Parameters.AddWithValue("@regpay", id.regpay);
cmd.Parameters.AddWithValue("@OT", id.OT);
cmd.Parameters.AddWithValue("@OT_rate", id.OT_rate);
cmd.Parameters.AddWithValue("@hourly_rate", id.hourly_rate);
cmd.ExecuteReader();
con.Close();
con.Open();
cmd = new SqlCommand("SP_DMCS_GET_PERSONDMCS", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Resource_ID", id.Resource_ID);
cmd.Parameters.AddWithValue("@f_name", id.f_name);
cmd.Parameters.AddWithValue("@l_name", id.l_name);
cmd.Parameters.AddWithValue("@address", id.address);
cmd.Parameters.AddWithValue("@city", id.city);
cmd.Parameters.AddWithValue("@state", id.state);
cmd.Parameters.AddWithValue("@zipcode", id.zipcode);
cmd.Parameters.AddWithValue("@phone_primary", id.phone_primary);
cmd.Parameters.AddWithValue("@email", id.email);
cmd.Parameters.AddWithValue("@creditcard", id.creditcard);
cmd.Parameters.AddWithValue("@availability_date", id.availability_date);
cmd.Parameters.AddWithValue("@availability_hours", id.availability_hours);
cmd.Parameters.AddWithValue("@birthdate", id.birthdate);
cmd.Parameters.AddWithValue("@marital_status", id.marital_status);
cmd.Parameters.AddWithValue("@gender", id.gender);
cmd.Parameters.AddWithValue("@jobtitle", id.jobtitle);
cmd.Parameters.AddWithValue("@workdate", id.workdate);
cmd.Parameters.AddWithValue("@regpay", id.regpay);
cmd.Parameters.AddWithValue("@OT", id.OT);
cmd.Parameters.AddWithValue("@OT_rate", id.OT_rate);
cmd.Parameters.AddWithValue("@hourly_rate", id.hourly_rate);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
id.Person_ID = rdr.GetInt32(0);
}
}
catch (Exception ex)
{
id.SetColumnDefaults();
}
finally
{
con.Close();
}
return(id);
}
public FEMA Select(int id)
{
FEMA FEMA = new FEMA();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_FEMA", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FEMA_ID", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
FEMA.FEMA_ID = rdr.GetInt32(0);
}
else
{
FEMA.FEMA_ID = 0;
}
if (!rdr.IsDBNull(1))
{
FEMA.Cost_Code = rdr.GetInt32(1);
}
else
{
FEMA.Cost_Code = 0;
}
if (!rdr.IsDBNull(2))
{
FEMA.Equipment = rdr.GetString(2);
}
else
{
FEMA.Equipment = " ";
}
if (!rdr.IsDBNull(3))
{
FEMA.Specification = rdr.GetString(3);
}
else
{
FEMA.Specification = " ";
}
if (!rdr.IsDBNull(4))
{
FEMA.Capacity_Size = rdr.GetString(4);
}
else
{
FEMA.Capacity_Size = " ";
}
if (!rdr.IsDBNull(5))
{
FEMA.HP = rdr.GetString(5);
}
else
{
FEMA.HP = " ";
}
if (!rdr.IsDBNull(6))
{
FEMA.Notes = rdr.GetString(6);
}
else
{
FEMA.Notes = " ";
}
if (!rdr.IsDBNull(7))
{
FEMA.Unit = rdr.GetString(7);
}
else
{
FEMA.Unit = " ";
}
if (!rdr.IsDBNull(8))
{
FEMA.Rate = rdr.GetString(8);
}
else
{
FEMA.Rate = " ";
}
}
else
{
FEMA.SetColumnDefaults();
}
}
catch (Exception ex)
{
FEMA.SetColumnDefaults();
return(FEMA);
}
finally
{
con.Close();
}
return(FEMA);
}
public military Select(int id)
{
military military = new military();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_MILITARY", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@military_id", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
military.military_id = rdr.GetInt32(0);
}
else
{
military.military_id = 0;
}
if (!rdr.IsDBNull(1))
{
military.case_id = rdr.GetInt32(1);
}
else
{
military.case_id = 0;
}
if (!rdr.IsDBNull(2))
{
military.client_id = rdr.GetInt32(2);
}
else
{
military.client_id = 0;
}
if (!rdr.IsDBNull(3))
{
military.discharge_date = rdr.GetDateTime(3);
}
else
{
military.discharge_date = DateTime.Now;
}
if (!rdr.IsDBNull(4))
{
military.enlistment_date = rdr.GetDateTime(4);
}
else
{
military.enlistment_date = DateTime.Now;
}
if (!rdr.IsDBNull(5))
{
military.military_branch = rdr.GetString(5);
}
else
{
military.military_branch = " ";
}
if (!rdr.IsDBNull(6))
{
military.serial_num = rdr.GetInt32(6);
}
else
{
military.serial_num = 0;
}
}
else
{
military.SetColumnDefaults();
}
}
catch (Exception ex)
{
military.SetColumnDefaults();
return(military);
}
finally
{
con.Close();
}
return(military);
}
public debt Select(int id)
{
debt debt = new debt();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_DEBT", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@debt_id", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
debt.debt_id = rdr.GetInt32(0);
}
else
{
debt.debt_id = 0;
}
if (!rdr.IsDBNull(1))
{
debt.amt_paid = rdr.GetDecimal(1);
}
else
{
debt.amt_paid = 0;
}
if (!rdr.IsDBNull(2))
{
debt.case_id = rdr.GetInt32(2);
}
else
{
debt.case_id = 0;
}
if (!rdr.IsDBNull(3))
{
debt.client_id = rdr.GetInt32(3);
}
else
{
debt.client_id = 0;
}
if (!rdr.IsDBNull(4))
{
debt.creditor_name = rdr.GetString(4);
}
else
{
debt.creditor_name = " ";
}
if (!rdr.IsDBNull(5))
{
debt.debt_amt = rdr.GetDecimal(5);
}
else
{
debt.debt_amt = 0;
}
if (!rdr.IsDBNull(6))
{
debt.item_purchased = rdr.GetString(6);
}
else
{
debt.item_purchased = " ";
}
if (!rdr.IsDBNull(7))
{
debt.last_payment_date = rdr.GetDateTime(7);
}
else
{
debt.last_payment_date = DateTime.Now;
}
if (!rdr.IsDBNull(8))
{
debt.purchase_date = rdr.GetDateTime(8);
}
else
{
debt.purchase_date = DateTime.Now;
}
if (!rdr.IsDBNull(9))
{
debt.value_amt = rdr.GetDecimal(9);
}
else
{
debt.value_amt = 0;
}
}
else
{
debt.SetColumnDefaults();
}
}
catch (Exception ex)
{
debt.SetColumnDefaults();
return(debt);
}
finally
{
con.Close();
}
return(debt);
}
public medicine Select(int id)
{
medicine medicine = new medicine();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_MEDICINE", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Medicine_Id", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
medicine.Medicine_Id = rdr.GetInt32(0);
}
else
{
medicine.Medicine_Id = 0;
}
if (!rdr.IsDBNull(1))
{
medicine.Medication_type = rdr.GetString(1);
}
else
{
medicine.Medication_type = " ";
}
if (!rdr.IsDBNull(2))
{
medicine.Medication_name = rdr.GetString(2);
}
else
{
medicine.Medication_name = " ";
}
if (!rdr.IsDBNull(3))
{
medicine.Clients_Served = rdr.GetInt32(3);
}
else
{
medicine.Clients_Served = 0;
}
}
else
{
medicine.SetColumnDefaults();
}
}
catch (Exception ex)
{
medicine.SetColumnDefaults();
return(medicine);
}
finally
{
con.Close();
}
return(medicine);
}
public encounter_services Select(int id)
{
encounter_services encounter_services = new encounter_services();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_ENCOUNTER_SERVICES", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@encounter_serv_id", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
encounter_services.encounter_serv_id = rdr.GetInt32(0);
}
else
{
encounter_services.encounter_serv_id = 0;
}
if (!rdr.IsDBNull(1))
{
encounter_services.encounter_id = rdr.GetInt32(1);
}
else
{
encounter_services.encounter_id = 0;
}
if (!rdr.IsDBNull(2))
{
encounter_services.mobile_unit_id = rdr.GetInt32(2);
}
else
{
encounter_services.mobile_unit_id = 0;
}
if (!rdr.IsDBNull(3))
{
encounter_services.service_id = rdr.GetInt32(3);
}
else
{
encounter_services.service_id = 0;
}
if (!rdr.IsDBNull(4))
{
encounter_services.service_date = rdr.GetDateTime(4);
}
else
{
encounter_services.service_date = DateTime.Now;
}
if (!rdr.IsDBNull(5))
{
encounter_services.service_completed = rdr.GetDateTime(5);
}
else
{
encounter_services.service_completed = DateTime.Now;
}
}
else
{
encounter_services.SetColumnDefaults();
}
}
catch (Exception ex)
{
encounter_services.SetColumnDefaults();
return(encounter_services);
}
finally
{
con.Close();
}
return(encounter_services);
}
public warehouse_product_Location Select_By_Product_ID(int wplid)
{
warehouse_product_Location warehouse_product_Location = new warehouse_product_Location();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_Select_warehouse_product_location_By_Product_ID", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@product_id", wplid);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
warehouse_product_Location.warehouse_product_location_id = rdr.GetInt32(0);
}
else
{
warehouse_product_Location.warehouse_product_location_id = 0;
}
if (!rdr.IsDBNull(1))
{
warehouse_product_Location.warehouse_id = rdr.GetInt32(1);
}
else
{
warehouse_product_Location.warehouse_id = 0;
}
if (!rdr.IsDBNull(2))
{
warehouse_product_Location.product_id = rdr.GetInt32(2);
}
else
{
warehouse_product_Location.product_id = 0;
}
if (!rdr.IsDBNull(3))
{
warehouse_product_Location.Location_ID = rdr.GetInt32(3);
}
else
{
warehouse_product_Location.Location_ID = 0;
}
if (!rdr.IsDBNull(4))
{
warehouse_product_Location.service_id = rdr.GetInt32(4);
}
else
{
warehouse_product_Location.service_id = 0;
}
if (!rdr.IsDBNull(5))
{
warehouse_product_Location.Time_Date_MIA = rdr.GetDateTime(5);
}
else
{
warehouse_product_Location.Time_Date_MIA = DateTime.Now;
}
if (!rdr.IsDBNull(6))
{
warehouse_product_Location.Experiation_Date = rdr.GetDateTime(6);
}
else
{
warehouse_product_Location.Experiation_Date = DateTime.Now;
}
if (!rdr.IsDBNull(7))
{
warehouse_product_Location.min_inv = rdr.GetInt32(7);
}
else
{
warehouse_product_Location.min_inv = 0;
}
if (!rdr.IsDBNull(8))
{
warehouse_product_Location.status = rdr.GetString(8);
}
else
{
warehouse_product_Location.status = " ";
}
if (!rdr.IsDBNull(9))
{
warehouse_product_Location.Exp_delivery_date = rdr.GetDateTime(9);
}
else
{
warehouse_product_Location.Exp_delivery_date = DateTime.Now;
}
if (!rdr.IsDBNull(10))
{
warehouse_product_Location.qty_onhand = rdr.GetInt32(10);
}
else
{
warehouse_product_Location.qty_onhand = 0;
}
if (!rdr.IsDBNull(11))
{
warehouse_product_Location.qty_commit = rdr.GetInt32(11);
}
else
{
warehouse_product_Location.qty_commit = 0;
}
if (!rdr.IsDBNull(12))
{
warehouse_product_Location.qty_order = rdr.GetInt32(12);
}
else
{
warehouse_product_Location.qty_order = 0;
}
if (!rdr.IsDBNull(13))
{
warehouse_product_Location.encounter_id = rdr.GetInt32(13);
}
else
{
warehouse_product_Location.encounter_id = 0;
}
if (!rdr.IsDBNull(14))
{
warehouse_product_Location.address_id = rdr.GetInt32(14);
}
else
{
warehouse_product_Location.address_id = 0;
}
}
else
{
warehouse_product_Location.SetColumnDefaults();
}
}
catch (Exception ex)
{
warehouse_product_Location.SetColumnDefaults();
return(warehouse_product_Location);
}
finally
{
con.Close();
}
return(warehouse_product_Location);
}
public transportation Select(int id)
{
transportation transportation = new transportation();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_TRANSPORTATION", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@transport_id", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
transportation.transport_id = rdr.GetInt32(0);
}
else
{
transportation.transport_id = 0;
}
if (!rdr.IsDBNull(1))
{
transportation.location_from = rdr.GetString(1);
}
else
{
transportation.location_from = " ";
}
if (!rdr.IsDBNull(2))
{
transportation.location_to = rdr.GetString(2);
}
else
{
transportation.location_to = " ";
}
if (!rdr.IsDBNull(3))
{
transportation.no_of_passangers = rdr.GetInt32(3);
}
else
{
transportation.no_of_passangers = 0;
}
if (!rdr.IsDBNull(4))
{
transportation.pickup_date = rdr.GetDateTime(4);
}
else
{
transportation.pickup_date = DateTime.Now;
}
if (!rdr.IsDBNull(5))
{
transportation.trans_type = rdr.GetString(5);
}
else
{
transportation.trans_type = " ";
}
if (!rdr.IsDBNull(6))
{
transportation.Vehicle_id = rdr.GetInt32(6);
}
else
{
transportation.Vehicle_id = 0;
}
}
else
{
transportation.SetColumnDefaults();
}
}
catch (Exception ex)
{
transportation.SetColumnDefaults();
return(transportation);
}
finally
{
con.Close();
}
return(transportation);
}
public personDMCS Select(int id)
{
personDMCS personDMCS = new personDMCS();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_PERSONDMCS", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Person_ID", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
personDMCS.Person_ID = rdr.GetInt32(0);
}
else
{
personDMCS.Person_ID = 0;
}
if (!rdr.IsDBNull(1))
{
personDMCS.Resource_ID = rdr.GetInt32(1);
}
else
{
personDMCS.Resource_ID = 0;
}
if (!rdr.IsDBNull(2))
{
personDMCS.f_name = rdr.GetString(2);
}
else
{
personDMCS.f_name = " ";
}
if (!rdr.IsDBNull(3))
{
personDMCS.l_name = rdr.GetString(3);
}
else
{
personDMCS.l_name = " ";
}
if (!rdr.IsDBNull(4))
{
personDMCS.address = rdr.GetString(4);
}
else
{
personDMCS.address = " ";
}
if (!rdr.IsDBNull(5))
{
personDMCS.city = rdr.GetString(5);
}
else
{
personDMCS.city = " ";
}
if (!rdr.IsDBNull(6))
{
personDMCS.state = rdr.GetString(6);
}
else
{
personDMCS.state = " ";
}
if (!rdr.IsDBNull(7))
{
personDMCS.zipcode = rdr.GetInt32(7);
}
else
{
personDMCS.zipcode = 0;
}
if (!rdr.IsDBNull(8))
{
personDMCS.phone_primary = rdr.GetString(8);
}
else
{
personDMCS.phone_primary = " ";
}
if (!rdr.IsDBNull(9))
{
personDMCS.email = rdr.GetString(9);
}
else
{
personDMCS.email = " ";
}
if (!rdr.IsDBNull(10))
{
personDMCS.creditcard = rdr.GetString(10);
}
else
{
personDMCS.creditcard = " ";
}
if (!rdr.IsDBNull(11))
{
personDMCS.availability_date = rdr.GetDateTime(11);
}
else
{
personDMCS.availability_date = DateTime.Now;
}
if (!rdr.IsDBNull(12))
{
personDMCS.availability_hours = rdr.GetInt32(12);
}
else
{
personDMCS.availability_hours = 0;
}
if (!rdr.IsDBNull(13))
{
personDMCS.birthdate = rdr.GetDateTime(13);
}
else
{
personDMCS.birthdate = DateTime.Now;
}
if (!rdr.IsDBNull(14))
{
personDMCS.marital_status = rdr.GetString(14);
}
else
{
personDMCS.marital_status = " ";
}
if (!rdr.IsDBNull(15))
{
personDMCS.gender = rdr.GetString(15);
}
else
{
personDMCS.gender = " ";
}
if (!rdr.IsDBNull(16))
{
personDMCS.jobtitle = rdr.GetString(16);
}
else
{
personDMCS.jobtitle = " ";
}
if (!rdr.IsDBNull(17))
{
personDMCS.workdate = rdr.GetDateTime(17);
}
else
{
personDMCS.workdate = DateTime.Now;
}
if (!rdr.IsDBNull(18))
{
personDMCS.regpay = rdr.GetDecimal(18);
}
else
{
personDMCS.regpay = 0;
}
if (!rdr.IsDBNull(19))
{
personDMCS.OT = rdr.GetInt32(19);
}
else
{
personDMCS.OT = 0;
}
if (!rdr.IsDBNull(20))
{
personDMCS.OT_rate = rdr.GetDecimal(20);
}
else
{
personDMCS.OT_rate = 0;
}
if (!rdr.IsDBNull(21))
{
personDMCS.hourly_rate = rdr.GetDecimal(21);
}
else
{
personDMCS.hourly_rate = 0;
}
}
else
{
personDMCS.SetColumnDefaults();
}
}
catch (Exception ex)
{
personDMCS.SetColumnDefaults();
return(personDMCS);
}
finally
{
con.Close();
}
return(personDMCS);
}
public encounter_client_vaccine Select(int id)
{
encounter_client_vaccine encounter_client_vaccine = new encounter_client_vaccine();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_ENCOUNTER_CLIENT_VACCINE", 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_client_vaccine.encounter_id = rdr.GetInt32(0);
}
else
{
encounter_client_vaccine.encounter_id = 0;
}
if (!rdr.IsDBNull(1))
{
encounter_client_vaccine.vaccine_id = rdr.GetInt32(1);
}
else
{
encounter_client_vaccine.vaccine_id = 0;
}
if (!rdr.IsDBNull(2))
{
encounter_client_vaccine.current_client_medicine = rdr.GetString(2);
}
else
{
encounter_client_vaccine.current_client_medicine = " ";
}
if (!rdr.IsDBNull(3))
{
encounter_client_vaccine.assistance = rdr.GetString(3);
}
else
{
encounter_client_vaccine.assistance = " ";
}
if (!rdr.IsDBNull(4))
{
encounter_client_vaccine.quantity = rdr.GetInt32(4);
}
else
{
encounter_client_vaccine.quantity = 0;
}
if (!rdr.IsDBNull(5))
{
encounter_client_vaccine.Under_six_months_old = rdr.GetString(5);
}
else
{
encounter_client_vaccine.Under_six_months_old = " ";
}
if (!rdr.IsDBNull(6))
{
encounter_client_vaccine.pregnant = rdr.GetString(6);
}
else
{
encounter_client_vaccine.pregnant = " ";
}
if (!rdr.IsDBNull(7))
{
encounter_client_vaccine.children = rdr.GetInt32(7);
}
else
{
encounter_client_vaccine.children = 0;
}
if (!rdr.IsDBNull(8))
{
encounter_client_vaccine.occupation = rdr.GetString(8);
}
else
{
encounter_client_vaccine.occupation = " ";
}
if (!rdr.IsDBNull(9))
{
encounter_client_vaccine.chronic_disease = rdr.GetString(9);
}
else
{
encounter_client_vaccine.chronic_disease = " ";
}
if (!rdr.IsDBNull(10))
{
encounter_client_vaccine.qualify = rdr.GetString(10);
}
else
{
encounter_client_vaccine.qualify = " ";
}
if (!rdr.IsDBNull(11))
{
encounter_client_vaccine.dose_date1 = rdr.GetDateTime(11);
}
else
{
encounter_client_vaccine.dose_date1 = DateTime.Now;
}
if (!rdr.IsDBNull(12))
{
encounter_client_vaccine.dose_date2 = rdr.GetDateTime(12);
}
else
{
encounter_client_vaccine.dose_date2 = DateTime.Now;
}
if (!rdr.IsDBNull(13))
{
encounter_client_vaccine.adult_consent = (byte[])rdr["adult_consent"];
}
else
{
encounter_client_vaccine.adult_consent = null;
}
if (!rdr.IsDBNull(14))
{
encounter_client_vaccine.guardian_consent = (byte[])rdr["guardian_consent"];
}
else
{
encounter_client_vaccine.guardian_consent = null;
}
if (!rdr.IsDBNull(15))
{
encounter_client_vaccine.vaccine_admin = rdr.GetDateTime(15);
}
else
{
encounter_client_vaccine.vaccine_admin = DateTime.Now;
}
if (!rdr.IsDBNull(16))
{
encounter_client_vaccine.guardian_f_name = rdr.GetString(16);
}
else
{
encounter_client_vaccine.guardian_f_name = " ";
}
if (!rdr.IsDBNull(17))
{
encounter_client_vaccine.guardian_l_name = rdr.GetString(17);
}
else
{
encounter_client_vaccine.guardian_l_name = " ";
}
if (!rdr.IsDBNull(18))
{
encounter_client_vaccine.guardian_mi = rdr.GetString(18);
}
else
{
encounter_client_vaccine.guardian_mi = " ";
}
if (!rdr.IsDBNull(19))
{
encounter_client_vaccine.guardian_phone = rdr.GetString(19);
}
else
{
encounter_client_vaccine.guardian_phone = " ";
}
if (!rdr.IsDBNull(20))
{
encounter_client_vaccine.adult_consent_date = rdr.GetDateTime(20);
}
else
{
encounter_client_vaccine.adult_consent_date = DateTime.Now;
}
if (!rdr.IsDBNull(21))
{
encounter_client_vaccine.guard_consent_date = rdr.GetDateTime(21);
}
else
{
encounter_client_vaccine.guard_consent_date = DateTime.Now;
}
if (!rdr.IsDBNull(22))
{
encounter_client_vaccine.dose_form1 = rdr.GetString(22);
}
else
{
encounter_client_vaccine.dose_form1 = " ";
}
if (!rdr.IsDBNull(23))
{
encounter_client_vaccine.dose_form2 = rdr.GetString(23);
}
else
{
encounter_client_vaccine.dose_form2 = " ";
}
}
else
{
encounter_client_vaccine.SetColumnDefaults();
}
}
catch (Exception ex)
{
encounter_client_vaccine.SetColumnDefaults();
return(encounter_client_vaccine);
}
finally
{
con.Close();
}
return(encounter_client_vaccine);
}
public property Select(int id)
{
property property = new property();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_PROPERTY", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@property_id", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
property.property_id = rdr.GetInt32(0);
}
else
{
property.property_id = 0;
}
if (!rdr.IsDBNull(1))
{
property.approx_mrkt_value = rdr.GetDecimal(1);
}
else
{
property.approx_mrkt_value = 0;
}
if (!rdr.IsDBNull(2))
{
property.address_id = rdr.GetInt32(2);
}
else
{
property.address_id = 0;
}
if (!rdr.IsDBNull(3))
{
property.case_id = rdr.GetInt32(3);
}
else
{
property.case_id = 0;
}
if (!rdr.IsDBNull(4))
{
property.client_id = rdr.GetInt32(4);
}
else
{
property.client_id = 0;
}
if (!rdr.IsDBNull(5))
{
property.Homeowners_Insurance_Payment = rdr.GetDecimal(5);
}
else
{
property.Homeowners_Insurance_Payment = 0;
}
if (!rdr.IsDBNull(6))
{
property.monthly_property_payment = rdr.GetDecimal(6);
}
else
{
property.monthly_property_payment = 0;
}
if (!rdr.IsDBNull(7))
{
property.mortg_comp = rdr.GetString(7);
}
else
{
property.mortg_comp = " ";
}
if (!rdr.IsDBNull(8))
{
property.Property_Tax_Payment = rdr.GetDecimal(8);
}
else
{
property.Property_Tax_Payment = 0;
}
if (!rdr.IsDBNull(9))
{
property.own_prop = rdr.GetString(9);
}
else
{
property.own_prop = " ";
}
if (!rdr.IsDBNull(10))
{
property.rent_prop = rdr.GetString(10);
}
else
{
property.rent_prop = " ";
}
if (!rdr.IsDBNull(11))
{
property.date_purchased = rdr.GetInt32(11);
}
else
{
property.date_purchased = 0;
}
}
else
{
property.SetColumnDefaults();
}
}
catch (Exception ex)
{
property.SetColumnDefaults();
return(property);
}
finally
{
con.Close();
}
return(property);
}
public encounter_client_vaccine Insert(encounter_client_vaccine id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_ENCOUNTER_CLIENT_VACCINE", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@encounter_id", id.encounter_id);
cmd.Parameters.AddWithValue("@vaccine_id", id.vaccine_id);
cmd.Parameters.AddWithValue("@current_client_medicine", id.current_client_medicine);
cmd.Parameters.AddWithValue("@assistance", id.assistance);
cmd.Parameters.AddWithValue("@quantity", id.quantity);
cmd.Parameters.AddWithValue("@Under_six_months_old", id.Under_six_months_old);
cmd.Parameters.AddWithValue("@pregnant", id.pregnant);
cmd.Parameters.AddWithValue("@children", id.children);
cmd.Parameters.AddWithValue("@occupation", id.occupation);
cmd.Parameters.AddWithValue("@chronic_disease", id.chronic_disease);
cmd.Parameters.AddWithValue("@qualify", id.qualify);
cmd.Parameters.AddWithValue("@dose_date1", id.dose_date1);
cmd.Parameters.AddWithValue("@dose_date2", id.dose_date2);
cmd.Parameters.AddWithValue("@adult_consent", id.adult_consent);
cmd.Parameters.AddWithValue("@guardian_consent", id.guardian_consent);
cmd.Parameters.AddWithValue("@vaccine_admin", id.vaccine_admin);
cmd.Parameters.AddWithValue("@guardian_f_name", id.guardian_f_name);
cmd.Parameters.AddWithValue("@guardian_l_name", id.guardian_l_name);
cmd.Parameters.AddWithValue("@guardian_mi", id.guardian_mi);
cmd.Parameters.AddWithValue("@guardian_phone", id.guardian_phone);
cmd.Parameters.AddWithValue("@adult_consent_date", id.adult_consent_date);
cmd.Parameters.AddWithValue("@guard_consent_date", id.guard_consent_date);
cmd.Parameters.AddWithValue("@dose_form1", id.dose_form1);
cmd.Parameters.AddWithValue("@dose_form2", id.dose_form2);
cmd.ExecuteReader();
con.Close();
con.Open();
cmd = new SqlCommand("SP_DMCS_GET_ENCOUNTER_CLIENT_VACCINE", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@vaccine_id", id.vaccine_id);
cmd.Parameters.AddWithValue("@current_client_medicine", id.current_client_medicine);
cmd.Parameters.AddWithValue("@assistance", id.assistance);
cmd.Parameters.AddWithValue("@quantity", id.quantity);
cmd.Parameters.AddWithValue("@Under_six_months_old", id.Under_six_months_old);
cmd.Parameters.AddWithValue("@pregnant", id.pregnant);
cmd.Parameters.AddWithValue("@children", id.children);
cmd.Parameters.AddWithValue("@occupation", id.occupation);
cmd.Parameters.AddWithValue("@chronic_disease", id.chronic_disease);
cmd.Parameters.AddWithValue("@qualify", id.qualify);
cmd.Parameters.AddWithValue("@dose_date1", id.dose_date1);
cmd.Parameters.AddWithValue("@dose_date2", id.dose_date2);
cmd.Parameters.AddWithValue("@adult_consent", id.adult_consent);
cmd.Parameters.AddWithValue("@guardian_consent", id.guardian_consent);
cmd.Parameters.AddWithValue("@vaccine_admin", id.vaccine_admin);
cmd.Parameters.AddWithValue("@guardian_f_name", id.guardian_f_name);
cmd.Parameters.AddWithValue("@guardian_l_name", id.guardian_l_name);
cmd.Parameters.AddWithValue("@guardian_mi", id.guardian_mi);
cmd.Parameters.AddWithValue("@guardian_phone", id.guardian_phone);
cmd.Parameters.AddWithValue("@adult_consent_date", id.adult_consent_date);
cmd.Parameters.AddWithValue("@guard_consent_date", id.guard_consent_date);
cmd.Parameters.AddWithValue("@dose_form1", id.dose_form1);
cmd.Parameters.AddWithValue("@dose_form2", id.dose_form2);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
id.encounter_id = rdr.GetInt32(0);
}
}
catch (Exception ex)
{
id.SetColumnDefaults();
}
finally
{
con.Close();
}
return(id);
}