public emergency_medical Insert(emergency_medical id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_EMERGENCY_MEDICAL", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@client_id", id.client_id);
cmd.Parameters.AddWithValue("@ambulance_company_name", id.ambulance_company_name);
cmd.Parameters.AddWithValue("@ambulance_identification", id.ambulance_identification);
cmd.Parameters.AddWithValue("@appointment_date", id.appointment_date);
cmd.Parameters.AddWithValue("@area_of_specialty", id.area_of_specialty);
cmd.Parameters.AddWithValue("@assistance_order", id.assistance_order);
cmd.Parameters.AddWithValue("@date_of_service", id.date_of_service);
cmd.Parameters.AddWithValue("@degree_certifications", id.degree_certifications);
cmd.Parameters.AddWithValue("@doctor_appointments", id.doctor_appointments);
cmd.Parameters.AddWithValue("@doctor_id", id.doctor_id);
cmd.Parameters.AddWithValue("@doctor_start_date", id.doctor_start_date);
cmd.Parameters.AddWithValue("@driver_id", id.driver_id);
cmd.Parameters.AddWithValue("@educational_institution_name", id.educational_institution_name);
cmd.Parameters.AddWithValue("@external_examination", id.external_examination);
cmd.Parameters.AddWithValue("@hospital_name", id.hospital_name);
cmd.Parameters.AddWithValue("@internal_examination", id.internal_examination);
cmd.Parameters.AddWithValue("@lights_sirens_to_scene", id.lights_sirens_to_scene);
cmd.Parameters.AddWithValue("@location_type", id.location_type);
cmd.Parameters.AddWithValue("@number_of_days_admitted", id.number_of_days_admitted);
cmd.Parameters.AddWithValue("@office_location", id.office_location);
cmd.Parameters.AddWithValue("@other_remarks", id.other_remarks);
cmd.Parameters.AddWithValue("@prescription_medicines", id.prescription_medicines);
cmd.Parameters.AddWithValue("@time_of_service", id.time_of_service);
cmd.Parameters.AddWithValue("@total_cost", id.total_cost);
cmd.Parameters.AddWithValue("@deceased_id", id.deceased_id);
cmd.ExecuteReader();
con.Close();
con.Open();
cmd = new SqlCommand("SP_DMCS_GET_EMERGENCY_MEDICAL", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@client_id", id.client_id);
cmd.Parameters.AddWithValue("@ambulance_company_name", id.ambulance_company_name);
cmd.Parameters.AddWithValue("@ambulance_identification", id.ambulance_identification);
cmd.Parameters.AddWithValue("@appointment_date", id.appointment_date);
cmd.Parameters.AddWithValue("@area_of_specialty", id.area_of_specialty);
cmd.Parameters.AddWithValue("@assistance_order", id.assistance_order);
cmd.Parameters.AddWithValue("@date_of_service", id.date_of_service);
cmd.Parameters.AddWithValue("@degree_certifications", id.degree_certifications);
cmd.Parameters.AddWithValue("@doctor_appointments", id.doctor_appointments);
cmd.Parameters.AddWithValue("@doctor_id", id.doctor_id);
cmd.Parameters.AddWithValue("@doctor_start_date", id.doctor_start_date);
cmd.Parameters.AddWithValue("@driver_id", id.driver_id);
cmd.Parameters.AddWithValue("@educational_institution_name", id.educational_institution_name);
cmd.Parameters.AddWithValue("@external_examination", id.external_examination);
cmd.Parameters.AddWithValue("@hospital_name", id.hospital_name);
cmd.Parameters.AddWithValue("@internal_examination", id.internal_examination);
cmd.Parameters.AddWithValue("@lights_sirens_to_scene", id.lights_sirens_to_scene);
cmd.Parameters.AddWithValue("@location_type", id.location_type);
cmd.Parameters.AddWithValue("@number_of_days_admitted", id.number_of_days_admitted);
cmd.Parameters.AddWithValue("@office_location", id.office_location);
cmd.Parameters.AddWithValue("@other_remarks", id.other_remarks);
cmd.Parameters.AddWithValue("@prescription_medicines", id.prescription_medicines);
cmd.Parameters.AddWithValue("@time_of_service", id.time_of_service);
cmd.Parameters.AddWithValue("@total_cost", id.total_cost);
cmd.Parameters.AddWithValue("@deceased_id", id.deceased_id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
id.em_id = rdr.GetInt32(0);
}
}
catch (Exception ex)
{
id.SetColumnDefaults();
}
finally
{
con.Close();
}
return(id);
}
public emergency_medical Select(int id)
{
emergency_medical emergency_medical = new emergency_medical();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_EMERGENCY_MEDICAL", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@em_id", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
emergency_medical.em_id = rdr.GetInt32(0);
}
else
{
emergency_medical.em_id = 0;
}
if (!rdr.IsDBNull(1))
{
emergency_medical.client_id = rdr.GetInt32(1);
}
else
{
emergency_medical.client_id = 0;
}
if (!rdr.IsDBNull(2))
{
emergency_medical.ambulance_company_name = rdr.GetString(2);
}
else
{
emergency_medical.ambulance_company_name = " ";
}
if (!rdr.IsDBNull(3))
{
emergency_medical.ambulance_identification = rdr.GetString(3);
}
else
{
emergency_medical.ambulance_identification = " ";
}
if (!rdr.IsDBNull(4))
{
emergency_medical.appointment_date = rdr.GetDateTime(4);
}
else
{
emergency_medical.appointment_date = DateTime.Now;
}
if (!rdr.IsDBNull(5))
{
emergency_medical.area_of_specialty = rdr.GetString(5);
}
else
{
emergency_medical.area_of_specialty = " ";
}
if (!rdr.IsDBNull(6))
{
emergency_medical.assistance_order = rdr.GetString(6);
}
else
{
emergency_medical.assistance_order = " ";
}
if (!rdr.IsDBNull(7))
{
emergency_medical.date_of_service = rdr.GetDateTime(7);
}
else
{
emergency_medical.date_of_service = DateTime.Now;
}
if (!rdr.IsDBNull(8))
{
emergency_medical.degree_certifications = rdr.GetString(8);
}
else
{
emergency_medical.degree_certifications = " ";
}
if (!rdr.IsDBNull(9))
{
emergency_medical.doctor_appointments = rdr.GetString(9);
}
else
{
emergency_medical.doctor_appointments = " ";
}
if (!rdr.IsDBNull(10))
{
emergency_medical.doctor_id = rdr.GetInt32(10);
}
else
{
emergency_medical.doctor_id = 0;
}
if (!rdr.IsDBNull(11))
{
emergency_medical.doctor_start_date = rdr.GetDateTime(11);
}
else
{
emergency_medical.doctor_start_date = DateTime.Now;
}
if (!rdr.IsDBNull(12))
{
emergency_medical.driver_id = rdr.GetInt32(12);
}
else
{
emergency_medical.driver_id = 0;
}
if (!rdr.IsDBNull(13))
{
emergency_medical.educational_institution_name = rdr.GetString(13);
}
else
{
emergency_medical.educational_institution_name = " ";
}
if (!rdr.IsDBNull(14))
{
emergency_medical.external_examination = rdr.GetString(14);
}
else
{
emergency_medical.external_examination = " ";
}
if (!rdr.IsDBNull(15))
{
emergency_medical.hospital_name = rdr.GetString(15);
}
else
{
emergency_medical.hospital_name = " ";
}
if (!rdr.IsDBNull(16))
{
emergency_medical.internal_examination = rdr.GetString(16);
}
else
{
emergency_medical.internal_examination = " ";
}
if (!rdr.IsDBNull(17))
{
emergency_medical.lights_sirens_to_scene = rdr.GetString(17);
}
else
{
emergency_medical.lights_sirens_to_scene = " ";
}
if (!rdr.IsDBNull(18))
{
emergency_medical.location_type = rdr.GetString(18);
}
else
{
emergency_medical.location_type = " ";
}
if (!rdr.IsDBNull(19))
{
emergency_medical.number_of_days_admitted = rdr.GetInt32(19);
}
else
{
emergency_medical.number_of_days_admitted = 0;
}
if (!rdr.IsDBNull(20))
{
emergency_medical.office_location = rdr.GetString(20);
}
else
{
emergency_medical.office_location = " ";
}
if (!rdr.IsDBNull(21))
{
emergency_medical.other_remarks = rdr.GetString(21);
}
else
{
emergency_medical.other_remarks = " ";
}
if (!rdr.IsDBNull(22))
{
emergency_medical.prescription_medicines = rdr.GetString(22);
}
else
{
emergency_medical.prescription_medicines = " ";
}
if (!rdr.IsDBNull(23))
{
emergency_medical.time_of_service = rdr.GetDateTime(23);
}
else
{
emergency_medical.time_of_service = DateTime.Now;
}
if (!rdr.IsDBNull(24))
{
emergency_medical.total_cost = rdr.GetDecimal(24);
}
else
{
emergency_medical.total_cost = 0;
}
if (!rdr.IsDBNull(25))
{
emergency_medical.deceased_id = rdr.GetInt32(25);
}
else
{
emergency_medical.deceased_id = 0;
}
}
else
{
emergency_medical.SetColumnDefaults();
}
}
catch (Exception ex)
{
emergency_medical.SetColumnDefaults();
return emergency_medical;
}
finally
{
con.Close();
}
return emergency_medical;
}
public emergency_medical Select(int id)
{
emergency_medical emergency_medical = new emergency_medical();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_EMERGENCY_MEDICAL", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@em_id", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
emergency_medical.em_id = rdr.GetInt32(0);
}
else
{
emergency_medical.em_id = 0;
}
if (!rdr.IsDBNull(1))
{
emergency_medical.client_id = rdr.GetInt32(1);
}
else
{
emergency_medical.client_id = 0;
}
if (!rdr.IsDBNull(2))
{
emergency_medical.ambulance_company_name = rdr.GetString(2);
}
else
{
emergency_medical.ambulance_company_name = " ";
}
if (!rdr.IsDBNull(3))
{
emergency_medical.ambulance_identification = rdr.GetString(3);
}
else
{
emergency_medical.ambulance_identification = " ";
}
if (!rdr.IsDBNull(4))
{
emergency_medical.appointment_date = rdr.GetDateTime(4);
}
else
{
emergency_medical.appointment_date = DateTime.Now;
}
if (!rdr.IsDBNull(5))
{
emergency_medical.area_of_specialty = rdr.GetString(5);
}
else
{
emergency_medical.area_of_specialty = " ";
}
if (!rdr.IsDBNull(6))
{
emergency_medical.assistance_order = rdr.GetString(6);
}
else
{
emergency_medical.assistance_order = " ";
}
if (!rdr.IsDBNull(7))
{
emergency_medical.date_of_service = rdr.GetDateTime(7);
}
else
{
emergency_medical.date_of_service = DateTime.Now;
}
if (!rdr.IsDBNull(8))
{
emergency_medical.degree_certifications = rdr.GetString(8);
}
else
{
emergency_medical.degree_certifications = " ";
}
if (!rdr.IsDBNull(9))
{
emergency_medical.doctor_appointments = rdr.GetString(9);
}
else
{
emergency_medical.doctor_appointments = " ";
}
if (!rdr.IsDBNull(10))
{
emergency_medical.doctor_id = rdr.GetInt32(10);
}
else
{
emergency_medical.doctor_id = 0;
}
if (!rdr.IsDBNull(11))
{
emergency_medical.doctor_start_date = rdr.GetDateTime(11);
}
else
{
emergency_medical.doctor_start_date = DateTime.Now;
}
if (!rdr.IsDBNull(12))
{
emergency_medical.driver_id = rdr.GetInt32(12);
}
else
{
emergency_medical.driver_id = 0;
}
if (!rdr.IsDBNull(13))
{
emergency_medical.educational_institution_name = rdr.GetString(13);
}
else
{
emergency_medical.educational_institution_name = " ";
}
if (!rdr.IsDBNull(14))
{
emergency_medical.external_examination = rdr.GetString(14);
}
else
{
emergency_medical.external_examination = " ";
}
if (!rdr.IsDBNull(15))
{
emergency_medical.hospital_name = rdr.GetString(15);
}
else
{
emergency_medical.hospital_name = " ";
}
if (!rdr.IsDBNull(16))
{
emergency_medical.internal_examination = rdr.GetString(16);
}
else
{
emergency_medical.internal_examination = " ";
}
if (!rdr.IsDBNull(17))
{
emergency_medical.lights_sirens_to_scene = rdr.GetString(17);
}
else
{
emergency_medical.lights_sirens_to_scene = " ";
}
if (!rdr.IsDBNull(18))
{
emergency_medical.location_type = rdr.GetString(18);
}
else
{
emergency_medical.location_type = " ";
}
if (!rdr.IsDBNull(19))
{
emergency_medical.number_of_days_admitted = rdr.GetInt32(19);
}
else
{
emergency_medical.number_of_days_admitted = 0;
}
if (!rdr.IsDBNull(20))
{
emergency_medical.office_location = rdr.GetString(20);
}
else
{
emergency_medical.office_location = " ";
}
if (!rdr.IsDBNull(21))
{
emergency_medical.other_remarks = rdr.GetString(21);
}
else
{
emergency_medical.other_remarks = " ";
}
if (!rdr.IsDBNull(22))
{
emergency_medical.prescription_medicines = rdr.GetString(22);
}
else
{
emergency_medical.prescription_medicines = " ";
}
if (!rdr.IsDBNull(23))
{
emergency_medical.time_of_service = rdr.GetDateTime(23);
}
else
{
emergency_medical.time_of_service = DateTime.Now;
}
if (!rdr.IsDBNull(24))
{
emergency_medical.total_cost = rdr.GetDecimal(24);
}
else
{
emergency_medical.total_cost = 0;
}
if (!rdr.IsDBNull(25))
{
emergency_medical.deceased_id = rdr.GetInt32(25);
}
else
{
emergency_medical.deceased_id = 0;
}
}
else
{
emergency_medical.SetColumnDefaults();
}
}
catch (Exception ex)
{
emergency_medical.SetColumnDefaults();
return(emergency_medical);
}
finally
{
con.Close();
}
return(emergency_medical);
}
public emergency_medical Insert(emergency_medical id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_EMERGENCY_MEDICAL", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@client_id", id.client_id);
cmd.Parameters.AddWithValue("@ambulance_company_name", id.ambulance_company_name);
cmd.Parameters.AddWithValue("@ambulance_identification", id.ambulance_identification);
cmd.Parameters.AddWithValue("@appointment_date", id.appointment_date);
cmd.Parameters.AddWithValue("@area_of_specialty", id.area_of_specialty);
cmd.Parameters.AddWithValue("@assistance_order", id.assistance_order);
cmd.Parameters.AddWithValue("@date_of_service", id.date_of_service);
cmd.Parameters.AddWithValue("@degree_certifications", id.degree_certifications);
cmd.Parameters.AddWithValue("@doctor_appointments", id.doctor_appointments);
cmd.Parameters.AddWithValue("@doctor_id", id.doctor_id);
cmd.Parameters.AddWithValue("@doctor_start_date", id.doctor_start_date);
cmd.Parameters.AddWithValue("@driver_id", id.driver_id);
cmd.Parameters.AddWithValue("@educational_institution_name", id.educational_institution_name);
cmd.Parameters.AddWithValue("@external_examination", id.external_examination);
cmd.Parameters.AddWithValue("@hospital_name", id.hospital_name);
cmd.Parameters.AddWithValue("@internal_examination", id.internal_examination);
cmd.Parameters.AddWithValue("@lights_sirens_to_scene", id.lights_sirens_to_scene);
cmd.Parameters.AddWithValue("@location_type", id.location_type);
cmd.Parameters.AddWithValue("@number_of_days_admitted", id.number_of_days_admitted);
cmd.Parameters.AddWithValue("@office_location", id.office_location);
cmd.Parameters.AddWithValue("@other_remarks", id.other_remarks);
cmd.Parameters.AddWithValue("@prescription_medicines", id.prescription_medicines);
cmd.Parameters.AddWithValue("@time_of_service", id.time_of_service);
cmd.Parameters.AddWithValue("@total_cost", id.total_cost);
cmd.Parameters.AddWithValue("@deceased_id", id.deceased_id);
cmd.ExecuteReader();
con.Close();
con.Open();
cmd = new SqlCommand("SP_DMCS_GET_EMERGENCY_MEDICAL", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@client_id", id.client_id);
cmd.Parameters.AddWithValue("@ambulance_company_name", id.ambulance_company_name);
cmd.Parameters.AddWithValue("@ambulance_identification", id.ambulance_identification);
cmd.Parameters.AddWithValue("@appointment_date", id.appointment_date);
cmd.Parameters.AddWithValue("@area_of_specialty", id.area_of_specialty);
cmd.Parameters.AddWithValue("@assistance_order", id.assistance_order);
cmd.Parameters.AddWithValue("@date_of_service", id.date_of_service);
cmd.Parameters.AddWithValue("@degree_certifications", id.degree_certifications);
cmd.Parameters.AddWithValue("@doctor_appointments", id.doctor_appointments);
cmd.Parameters.AddWithValue("@doctor_id", id.doctor_id);
cmd.Parameters.AddWithValue("@doctor_start_date", id.doctor_start_date);
cmd.Parameters.AddWithValue("@driver_id", id.driver_id);
cmd.Parameters.AddWithValue("@educational_institution_name", id.educational_institution_name);
cmd.Parameters.AddWithValue("@external_examination", id.external_examination);
cmd.Parameters.AddWithValue("@hospital_name", id.hospital_name);
cmd.Parameters.AddWithValue("@internal_examination", id.internal_examination);
cmd.Parameters.AddWithValue("@lights_sirens_to_scene", id.lights_sirens_to_scene);
cmd.Parameters.AddWithValue("@location_type", id.location_type);
cmd.Parameters.AddWithValue("@number_of_days_admitted", id.number_of_days_admitted);
cmd.Parameters.AddWithValue("@office_location", id.office_location);
cmd.Parameters.AddWithValue("@other_remarks", id.other_remarks);
cmd.Parameters.AddWithValue("@prescription_medicines", id.prescription_medicines);
cmd.Parameters.AddWithValue("@time_of_service", id.time_of_service);
cmd.Parameters.AddWithValue("@total_cost", id.total_cost);
cmd.Parameters.AddWithValue("@deceased_id", id.deceased_id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
id.em_id = rdr.GetInt32(0);
}
}
catch (Exception ex)
{
id.SetColumnDefaults();
}
finally
{
con.Close();
}
return id;
}