public List <Car_Leasings_Guarator> getAllGuarantors(string Leasing_id, string Cust_id, string Cust_idcard)
{
MySqlConnection con = MySQLConnection.connectionMySQL();
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand("g_car_leasings_guarantor", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@i_Leasing_id", Leasing_id);
cmd.Parameters.AddWithValue("@i_Cust_id", Cust_id);
cmd.Parameters.AddWithValue("@i_Cust_idcard", Cust_idcard);
MySqlDataReader reader = cmd.ExecuteReader();
List <Car_Leasings_Guarator> list_cls_grt = new List <Car_Leasings_Guarator>();
while (reader.Read())
{
Car_Leasings_Guarator cls_grt = new Car_Leasings_Guarator();
int defaultNum = 0;
string defaultString = "";
cls_grt.cls = new Car_Leasings();
cls_grt.cls.Leasing_id = reader.IsDBNull(0) ? defaultString : reader.GetString(0);
cls_grt.Guarantor_no = reader.IsDBNull(1) ? defaultNum : reader.GetInt32(1);
cls_grt.ctm = new Customers();
cls_grt.ctm.Cust_id = reader.IsDBNull(2) ? defaultString : reader.GetString(2);
cls_grt.ctm.Cust_Idcard = reader.IsDBNull(3) ? defaultString : reader.GetString(3);
cls_grt.ctm.Cust_Fname = reader.IsDBNull(4) ? defaultString : reader.GetString(4);
cls_grt.ctm.Cust_LName = reader.IsDBNull(5) ? defaultString : reader.GetString(5);
cls_grt.ctm.Cust_B_date = reader.IsDBNull(6) ? defaultString : reader.GetString(6);
cls_grt.ctm.Cust_Age = reader.IsDBNull(7) ? defaultNum : reader.GetInt32(7);
cls_grt.ctm.Cust_Idcard_without = reader.IsDBNull(8) ? defaultString : reader.GetString(8);
cls_grt.ctm.Cust_Idcard_start = reader.IsDBNull(9) ? defaultString : reader.GetString(9);
cls_grt.ctm.Cust_Idcard_expire = reader.IsDBNull(10) ? defaultString : reader.GetString(10);
cls_grt.ctm.ctm_ntnlt = new Base_Nationalitys();
cls_grt.ctm.ctm_ntnlt.Nationality_id = reader.IsDBNull(11) ? defaultNum : reader.GetInt32(11);
cls_grt.ctm.ctm_ntnlt.Nationality_name_ENG = reader.IsDBNull(12) ? defaultString : reader.GetString(12);
cls_grt.ctm.ctm_ntnlt.Nationality_name_TH = reader.IsDBNull(13) ? defaultString : reader.GetString(13);
cls_grt.ctm.ctm_org = new Base_Origins();
cls_grt.ctm.ctm_org.Origin_id = reader.IsDBNull(14) ? defaultNum : reader.GetInt32(14);
cls_grt.ctm.ctm_org.Origin_name_ENG = reader.IsDBNull(15) ? defaultString : reader.GetString(15);
cls_grt.ctm.ctm_org.Origin_name_TH = reader.IsDBNull(16) ? defaultString : reader.GetString(16);
cls_grt.ctm.Cust_Tel = reader.IsDBNull(17) ? defaultString : reader.GetString(17);
cls_grt.ctm.Cust_Email = reader.IsDBNull(18) ? defaultString : reader.GetString(18);
cls_grt.ctm.ctm_pstt = new Base_Person_Status();
cls_grt.ctm.ctm_pstt.person_status_id = reader.IsDBNull(19) ? defaultNum : reader.GetInt32(19);
cls_grt.ctm.ctm_pstt.person_status_name = reader.IsDBNull(20) ? defaultString : reader.GetString(20);
cls_grt.ctm.Cust_Marry_idcard = reader.IsDBNull(21) ? defaultString : reader.GetString(21);
cls_grt.ctm.Cust_Marry_Fname = reader.IsDBNull(22) ? defaultString : reader.GetString(22);
cls_grt.ctm.Cust_Marry_Lname = reader.IsDBNull(23) ? defaultString : reader.GetString(23);
cls_grt.ctm.ctm_marry_ntnlt = new Base_Nationalitys();
cls_grt.ctm.ctm_marry_ntnlt.Nationality_id = reader.IsDBNull(24) ? defaultNum : reader.GetInt32(24);
cls_grt.ctm.ctm_marry_ntnlt.Nationality_name_ENG = reader.IsDBNull(25) ? defaultString : reader.GetString(25);
cls_grt.ctm.ctm_marry_ntnlt.Nationality_name_TH = reader.IsDBNull(26) ? defaultString : reader.GetString(26);
cls_grt.ctm.ctm_marry_org = new Base_Origins();
cls_grt.ctm.ctm_marry_org.Origin_id = reader.IsDBNull(27) ? defaultNum : reader.GetInt32(27);
cls_grt.ctm.ctm_marry_org.Origin_name_ENG = reader.IsDBNull(28) ? defaultString : reader.GetString(28);
cls_grt.ctm.ctm_marry_org.Origin_name_TH = reader.IsDBNull(29) ? defaultString : reader.GetString(29);
cls_grt.ctm.Cust_Marry_Address_no = reader.IsDBNull(30) ? defaultString : reader.GetString(30);
cls_grt.ctm.Cust_Marry_vilage = reader.IsDBNull(31) ? defaultString : reader.GetString(31);
cls_grt.ctm.Cust_Marry_vilage_no = reader.IsDBNull(32) ? defaultString : reader.GetString(32);
cls_grt.ctm.Cust_Marry_alley = reader.IsDBNull(33) ? defaultString : reader.GetString(33);
cls_grt.ctm.Cust_Marry_road = reader.IsDBNull(34) ? defaultString : reader.GetString(34);
cls_grt.ctm.Cust_Marry_subdistrict = reader.IsDBNull(35) ? defaultString : reader.GetString(35);
cls_grt.ctm.Cust_Marry_district = reader.IsDBNull(36) ? defaultString : reader.GetString(36);
cls_grt.ctm.Cust_Marry_province = reader.IsDBNull(37) ? defaultString : reader.GetString(37);
cls_grt.ctm.Cust_Marry_country = reader.IsDBNull(38) ? defaultString : reader.GetString(38);
cls_grt.ctm.Cust_Marry_zipcode = reader.IsDBNull(39) ? defaultString : reader.GetString(39);
cls_grt.ctm.Cust_Marry_tel = reader.IsDBNull(40) ? defaultString : reader.GetString(40);
cls_grt.ctm.Cust_Marry_email = reader.IsDBNull(41) ? defaultString : reader.GetString(41);
cls_grt.ctm.Cust_Marry_job = reader.IsDBNull(42) ? defaultString : reader.GetString(42);
cls_grt.ctm.Cust_Marry_job_position = reader.IsDBNull(43) ? defaultString : reader.GetString(43);
cls_grt.ctm.Cust_Marry_job_long = reader.IsDBNull(44) ? defaultNum : reader.GetInt32(44);
cls_grt.ctm.Cust_Marry_job_salary = reader.IsDBNull(45) ? defaultNum : reader.GetDouble(45);
cls_grt.ctm.Cust_Marry_job_local_name = reader.IsDBNull(46) ? defaultString : reader.GetString(46);
cls_grt.ctm.Cust_Marry_job_address_no = reader.IsDBNull(47) ? defaultString : reader.GetString(47);
cls_grt.ctm.Cust_Marry_job_vilage = reader.IsDBNull(48) ? defaultString : reader.GetString(48);
cls_grt.ctm.Cust_Marry_job_vilage_no = reader.IsDBNull(49) ? defaultString : reader.GetString(49);
cls_grt.ctm.Cust_Marry_job_alley = reader.IsDBNull(50) ? defaultString : reader.GetString(50);
cls_grt.ctm.Cust_Marry_job_road = reader.IsDBNull(51) ? defaultString : reader.GetString(51);
cls_grt.ctm.Cust_Marry_job_subdistrict = reader.IsDBNull(52) ? defaultString : reader.GetString(52);
cls_grt.ctm.Cust_Marry_job_district = reader.IsDBNull(53) ? defaultString : reader.GetString(53);
cls_grt.ctm.Cust_Marry_job_province = reader.IsDBNull(54) ? defaultString : reader.GetString(54);
cls_grt.ctm.Cust_Marry_job_country = reader.IsDBNull(55) ? defaultString : reader.GetString(55);
cls_grt.ctm.Cust_Marry_job_zipcode = reader.IsDBNull(56) ? defaultString : reader.GetString(56);
cls_grt.ctm.Cust_Marry_job_tel = reader.IsDBNull(57) ? defaultString : reader.GetString(57);
cls_grt.ctm.Cust_Job = reader.IsDBNull(58) ? defaultString : reader.GetString(58);
cls_grt.ctm.Cust_Job_position = reader.IsDBNull(59) ? defaultString : reader.GetString(59);
cls_grt.ctm.Cust_Job_long = reader.IsDBNull(60) ? defaultNum : reader.GetInt32(60);
cls_grt.ctm.Cust_Job_salary = reader.IsDBNull(61) ? defaultNum : reader.GetDouble(61);
cls_grt.ctm.Cust_Job_local_name = reader.IsDBNull(62) ? defaultString : reader.GetString(62);
cls_grt.ctm.Cust_Job_address_no = reader.IsDBNull(63) ? defaultString : reader.GetString(63);
cls_grt.ctm.Cust_Job_vilage = reader.IsDBNull(64) ? defaultString : reader.GetString(64);
cls_grt.ctm.Cust_Job_vilage_no = reader.IsDBNull(65) ? defaultString : reader.GetString(65);
cls_grt.ctm.Cust_Job_alley = reader.IsDBNull(66) ? defaultString : reader.GetString(66);
cls_grt.ctm.Cust_Job_road = reader.IsDBNull(67) ? defaultString : reader.GetString(67);
cls_grt.ctm.Cust_Job_subdistrict = reader.IsDBNull(68) ? defaultString : reader.GetString(68);
cls_grt.ctm.Cust_Job_district = reader.IsDBNull(69) ? defaultString : reader.GetString(69);
cls_grt.ctm.Cust_Job_province = reader.IsDBNull(70) ? defaultString : reader.GetString(70);
cls_grt.ctm.Cust_Job_country = reader.IsDBNull(71) ? defaultString : reader.GetString(71);
cls_grt.ctm.Cust_Job_zipcode = reader.IsDBNull(72) ? defaultString : reader.GetString(72);
cls_grt.ctm.Cust_Job_tel = reader.IsDBNull(73) ? defaultString : reader.GetString(73);
cls_grt.ctm.Cust_Job_email = reader.IsDBNull(74) ? defaultString : reader.GetString(74);
cls_grt.ctm.Cust_Home_address_no = reader.IsDBNull(75) ? defaultString : reader.GetString(75);
cls_grt.ctm.Cust_Home_vilage = reader.IsDBNull(76) ? defaultString : reader.GetString(76);
cls_grt.ctm.Cust_Home_vilage_no = reader.IsDBNull(77) ? defaultString : reader.GetString(77);
cls_grt.ctm.Cust_Home_alley = reader.IsDBNull(78) ? defaultString : reader.GetString(78);
cls_grt.ctm.Cust_Home_road = reader.IsDBNull(79) ? defaultString : reader.GetString(79);
cls_grt.ctm.Cust_Home_subdistrict = reader.IsDBNull(80) ? defaultString : reader.GetString(80);
cls_grt.ctm.Cust_Home_district = reader.IsDBNull(81) ? defaultString : reader.GetString(81);
cls_grt.ctm.Cust_Home_province = reader.IsDBNull(82) ? defaultString : reader.GetString(82);
cls_grt.ctm.Cust_Home_country = reader.IsDBNull(83) ? defaultString : reader.GetString(83);
cls_grt.ctm.Cust_Home_zipcode = reader.IsDBNull(84) ? defaultString : reader.GetString(84);
cls_grt.ctm.Cust_Home_tel = reader.IsDBNull(85) ? defaultString : reader.GetString(85);
cls_grt.ctm.Cust_Home_GPS_Latitude = reader.IsDBNull(86) ? defaultString : reader.GetString(86);
cls_grt.ctm.Cust_Home_GPS_Longitude = reader.IsDBNull(87) ? defaultString : reader.GetString(87);
cls_grt.ctm.ctm_home_stt = new Base_Home_Status();
cls_grt.ctm.ctm_home_stt.Home_status_id = reader.IsDBNull(88) ? defaultNum : reader.GetInt32(88);
cls_grt.ctm.ctm_home_stt.Home_status_name = reader.IsDBNull(89) ? defaultString : reader.GetString(89);
cls_grt.ctm.Cust_Idcard_address_no = reader.IsDBNull(90) ? defaultString : reader.GetString(90);
cls_grt.ctm.Cust_Idcard_vilage = reader.IsDBNull(91) ? defaultString : reader.GetString(91);
cls_grt.ctm.Cust_Idcard_vilage_no = reader.IsDBNull(92) ? defaultString : reader.GetString(92);
cls_grt.ctm.Cust_Idcard_alley = reader.IsDBNull(93) ? defaultString : reader.GetString(93);
cls_grt.ctm.Cust_Idcard_road = reader.IsDBNull(94) ? defaultString : reader.GetString(94);
cls_grt.ctm.Cust_Idcard_subdistrict = reader.IsDBNull(95) ? defaultString : reader.GetString(95);
cls_grt.ctm.Cust_Idcard_district = reader.IsDBNull(96) ? defaultString : reader.GetString(96);
cls_grt.ctm.Cust_Idcard_province = reader.IsDBNull(97) ? defaultString : reader.GetString(97);
cls_grt.ctm.Cust_Idcard_country = reader.IsDBNull(98) ? defaultString : reader.GetString(98);
cls_grt.ctm.Cust_Idcard_zipcode = reader.IsDBNull(99) ? defaultString : reader.GetString(99);
cls_grt.ctm.Cust_Idcard_tel = reader.IsDBNull(100) ? defaultString : reader.GetString(100);
cls_grt.ctm.ctm_idcard_stt = new Base_Home_Status();
cls_grt.ctm.ctm_idcard_stt.Home_status_id = reader.IsDBNull(101) ? defaultNum : reader.GetInt32(101);
cls_grt.ctm.ctm_idcard_stt.Home_status_name = reader.IsDBNull(102) ? defaultString : reader.GetString(102);
cls_grt.ctm.Cust_Current_address_no = reader.IsDBNull(103) ? defaultString : reader.GetString(103);
cls_grt.ctm.Cust_Current_vilage = reader.IsDBNull(104) ? defaultString : reader.GetString(104);
cls_grt.ctm.Cust_Current_vilage_no = reader.IsDBNull(105) ? defaultString : reader.GetString(105);
cls_grt.ctm.Cust_Current_alley = reader.IsDBNull(106) ? defaultString : reader.GetString(106);
cls_grt.ctm.Cust_Current_road = reader.IsDBNull(107) ? defaultString : reader.GetString(107);
cls_grt.ctm.Cust_Current_subdistrict = reader.IsDBNull(108) ? defaultString : reader.GetString(108);
cls_grt.ctm.Cust_Current_district = reader.IsDBNull(109) ? defaultString : reader.GetString(109);
cls_grt.ctm.Cust_Current_province = reader.IsDBNull(110) ? defaultString : reader.GetString(110);
cls_grt.ctm.Cust_Current_country = reader.IsDBNull(111) ? defaultString : reader.GetString(111);
cls_grt.ctm.Cust_Current_zipcode = reader.IsDBNull(112) ? defaultString : reader.GetString(112);
cls_grt.ctm.Cust_Current_tel = reader.IsDBNull(113) ? defaultString : reader.GetString(113);
cls_grt.ctm.ctm_current_stt = new Base_Home_Status();
cls_grt.ctm.ctm_current_stt.Home_status_id = reader.IsDBNull(114) ? defaultNum : reader.GetInt32(114);
cls_grt.ctm.ctm_current_stt.Home_status_name = reader.IsDBNull(115) ? defaultString : reader.GetString(115);
cls_grt.ctm.Cust_save_date = reader.IsDBNull(116) ? defaultString : reader.GetString(116);
list_cls_grt.Add(cls_grt);
}
return(list_cls_grt);
}
catch (MySqlException ex)
{
error = "MysqlException ==> Managers_Leasings --> Car_Leasings_Guarantor_Manager --> getAllGuarantors() ";
Log_Error._writeErrorFile(error, ex);
return(null);
}
catch (Exception ex)
{
error = "Exception ==> Managers_Leasings --> Car_Leasings_Guarantor_Manager --> getAllGuarantors() ";
Log_Error._writeErrorFile(error, ex);
return(null);
}
finally
{
con.Close();
}
}
public bool editGuarantorsLeasing(Car_Leasings_Guarator cls_grt)
{
MySqlConnection con = MySQLConnection.connectionMySQL();
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand("u_car_leasings_guarantor", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@i_Leasing_id", cls_grt.cls.Leasing_id);
cmd.Parameters.AddWithValue("@i_Guarantor_no", cls_grt.Guarantor_no);
cmd.Parameters.AddWithValue("@i_Cust_id", cls_grt.ctm.Cust_id);
cmd.Parameters.AddWithValue("@i_Cust_Idcard", cls_grt.ctm.Cust_Idcard);
cmd.Parameters.AddWithValue("@i_Cust_Fname", cls_grt.ctm.Cust_Fname);
cmd.Parameters.AddWithValue("@i_Cust_LName", cls_grt.ctm.Cust_LName);
cmd.Parameters.AddWithValue("@i_Cust_B_date", cls_grt.ctm.Cust_B_date);
cmd.Parameters.AddWithValue("@i_Cust_Age", cls_grt.ctm.Cust_Age);
cmd.Parameters.AddWithValue("@i_Cust_Idcard_without", cls_grt.ctm.Cust_Idcard_without);
cmd.Parameters.AddWithValue("@i_Cust_Idcard_start", cls_grt.ctm.Cust_Idcard_start);
cmd.Parameters.AddWithValue("@i_Cust_Idcard_expire", cls_grt.ctm.Cust_Idcard_expire);
cmd.Parameters.AddWithValue("@i_Cust_Nationality_id", cls_grt.ctm.ctm_ntnlt.Nationality_id);
cmd.Parameters.AddWithValue("@i_Cust_Origin_id", cls_grt.ctm.ctm_org.Origin_id);
cmd.Parameters.AddWithValue("@i_Cust_Tel", cls_grt.ctm.Cust_Tel);
cmd.Parameters.AddWithValue("@i_Cust_Email", cls_grt.ctm.Cust_Email);
cmd.Parameters.AddWithValue("@i_Cust_Status_id", cls_grt.ctm.ctm_pstt.person_status_id);
cmd.Parameters.AddWithValue("@i_Cust_Marry_idcard", cls_grt.ctm.Cust_Marry_idcard);
cmd.Parameters.AddWithValue("@i_Cust_Marry_Fname", cls_grt.ctm.Cust_Marry_Fname);
cmd.Parameters.AddWithValue("@i_Cust_Marry_Lname", cls_grt.ctm.Cust_Marry_Lname);
cmd.Parameters.AddWithValue("@i_Cust_Marry_Nationality", cls_grt.ctm.ctm_marry_ntnlt.Nationality_id);
cmd.Parameters.AddWithValue("@i_Cust_Marry_Origin", cls_grt.ctm.ctm_marry_org.Origin_id);
cmd.Parameters.AddWithValue("@i_Cust_Marry_Address_no", cls_grt.ctm.Cust_Marry_Address_no);
cmd.Parameters.AddWithValue("@i_Cust_Marry_vilage", cls_grt.ctm.Cust_Marry_vilage);
cmd.Parameters.AddWithValue("@i_Cust_Marry_vilage_no", cls_grt.ctm.Cust_Marry_vilage_no);
cmd.Parameters.AddWithValue("@i_Cust_Marry_alley", cls_grt.ctm.Cust_Marry_alley);
cmd.Parameters.AddWithValue("@i_Cust_Marry_road", cls_grt.ctm.Cust_Marry_road);
cmd.Parameters.AddWithValue("@i_Cust_Marry_subdistrict", cls_grt.ctm.Cust_Marry_subdistrict);
cmd.Parameters.AddWithValue("@i_Cust_Marry_district", cls_grt.ctm.Cust_Marry_district);
cmd.Parameters.AddWithValue("@i_Cust_Marry_province", cls_grt.ctm.Cust_Marry_province);
cmd.Parameters.AddWithValue("@i_Cust_Marry_country", cls_grt.ctm.Cust_Marry_country);
cmd.Parameters.AddWithValue("@i_Cust_Marry_zipcode", cls_grt.ctm.Cust_Marry_zipcode);
cmd.Parameters.AddWithValue("@i_Cust_Marry_tel", cls_grt.ctm.Cust_Marry_tel);
cmd.Parameters.AddWithValue("@i_Cust_Marry_email", cls_grt.ctm.Cust_Marry_email);
cmd.Parameters.AddWithValue("@i_Cust_Marry_job", cls_grt.ctm.Cust_Marry_job);
cmd.Parameters.AddWithValue("@i_Cust_Marry_job_position", cls_grt.ctm.Cust_Marry_job_position);
cmd.Parameters.AddWithValue("@i_Cust_Marry_job_long", cls_grt.ctm.Cust_Marry_job_long);
cmd.Parameters.AddWithValue("@i_Cust_Marry_job_salary", cls_grt.ctm.Cust_Marry_job_salary);
cmd.Parameters.AddWithValue("@i_Cust_Marry_job_local_name", cls_grt.ctm.Cust_Marry_job_local_name);
cmd.Parameters.AddWithValue("@i_Cust_Marry_job_address_no", cls_grt.ctm.Cust_Marry_job_address_no);
cmd.Parameters.AddWithValue("@i_Cust_Marry_job_vilage", cls_grt.ctm.Cust_Marry_job_vilage);
cmd.Parameters.AddWithValue("@i_Cust_Marry_job_vilage_no", cls_grt.ctm.Cust_Marry_job_vilage_no);
cmd.Parameters.AddWithValue("@i_Cust_Marry_job_alley", cls_grt.ctm.Cust_Marry_job_alley);
cmd.Parameters.AddWithValue("@i_Cust_Marry_job_road", cls_grt.ctm.Cust_Marry_job_road);
cmd.Parameters.AddWithValue("@i_Cust_Marry_job_subdistrict", cls_grt.ctm.Cust_Marry_job_subdistrict);
cmd.Parameters.AddWithValue("@i_Cust_Marry_job_district", cls_grt.ctm.Cust_Marry_job_district);
cmd.Parameters.AddWithValue("@i_Cust_Marry_job_province", cls_grt.ctm.Cust_Marry_job_province);
cmd.Parameters.AddWithValue("@i_Cust_Marry_job_country", cls_grt.ctm.Cust_Marry_job_country);
cmd.Parameters.AddWithValue("@i_Cust_Marry_job_zipcode", cls_grt.ctm.Cust_Marry_job_zipcode);
cmd.Parameters.AddWithValue("@i_Cust_Marry_job_tel", cls_grt.ctm.Cust_Marry_job_tel);
cmd.Parameters.AddWithValue("@i_Cust_Job", cls_grt.ctm.Cust_Job);
cmd.Parameters.AddWithValue("@i_Cust_Job_position", cls_grt.ctm.Cust_Job_position);
cmd.Parameters.AddWithValue("@i_Cust_Job_long", cls_grt.ctm.Cust_Job_long);
cmd.Parameters.AddWithValue("@i_Cust_Job_salary", cls_grt.ctm.Cust_Job_salary);
cmd.Parameters.AddWithValue("@i_Cust_Job_local_name", cls_grt.ctm.Cust_Job_local_name);
cmd.Parameters.AddWithValue("@i_Cust_Job_address_no", cls_grt.ctm.Cust_Job_address_no);
cmd.Parameters.AddWithValue("@i_Cust_Job_vilage", cls_grt.ctm.Cust_Job_vilage);
cmd.Parameters.AddWithValue("@i_Cust_Job_vilage_no", cls_grt.ctm.Cust_Job_vilage_no);
cmd.Parameters.AddWithValue("@i_Cust_Job_alley", cls_grt.ctm.Cust_Job_alley);
cmd.Parameters.AddWithValue("@i_Cust_Job_road", cls_grt.ctm.Cust_Job_road);
cmd.Parameters.AddWithValue("@i_Cust_Job_subdistrict", cls_grt.ctm.Cust_Job_subdistrict);
cmd.Parameters.AddWithValue("@i_Cust_Job_district", cls_grt.ctm.Cust_Job_district);
cmd.Parameters.AddWithValue("@i_Cust_Job_province", cls_grt.ctm.Cust_Job_province);
cmd.Parameters.AddWithValue("@i_Cust_Job_country", cls_grt.ctm.Cust_Job_country);
cmd.Parameters.AddWithValue("@i_Cust_Job_zipcode", cls_grt.ctm.Cust_Job_zipcode);
cmd.Parameters.AddWithValue("@i_Cust_Job_tel", cls_grt.ctm.Cust_Job_tel);
cmd.Parameters.AddWithValue("@i_Cust_Job_email", cls_grt.ctm.Cust_Job_email);
cmd.Parameters.AddWithValue("@i_Cust_Home_address_no", cls_grt.ctm.Cust_Home_address_no);
cmd.Parameters.AddWithValue("@i_Cust_Home_vilage", cls_grt.ctm.Cust_Home_vilage);
cmd.Parameters.AddWithValue("@i_Cust_Home_vilage_no", cls_grt.ctm.Cust_Home_vilage_no);
cmd.Parameters.AddWithValue("@i_Cust_Home_alley", cls_grt.ctm.Cust_Home_alley);
cmd.Parameters.AddWithValue("@i_Cust_Home_road", cls_grt.ctm.Cust_Home_road);
cmd.Parameters.AddWithValue("@i_Cust_Home_subdistrict", cls_grt.ctm.Cust_Home_subdistrict);
cmd.Parameters.AddWithValue("@i_Cust_Home_district", cls_grt.ctm.Cust_Home_district);
cmd.Parameters.AddWithValue("@i_Cust_Home_province", cls_grt.ctm.Cust_Home_province);
cmd.Parameters.AddWithValue("@i_Cust_Home_country", cls_grt.ctm.Cust_Home_country);
cmd.Parameters.AddWithValue("@i_Cust_Home_zipcode", cls_grt.ctm.Cust_Home_zipcode);
cmd.Parameters.AddWithValue("@i_Cust_Home_tel", cls_grt.ctm.Cust_Home_tel);
cmd.Parameters.AddWithValue("@i_Cust_Home_GPS_Latitude", cls_grt.ctm.Cust_Home_GPS_Latitude);
cmd.Parameters.AddWithValue("@i_Cust_Home_GPS_Longitude", cls_grt.ctm.Cust_Home_GPS_Longitude);
cmd.Parameters.AddWithValue("@i_Cust_Home_Status_id", cls_grt.ctm.ctm_home_stt.Home_status_id);
cmd.Parameters.AddWithValue("@i_Cust_Idcard_address_no", cls_grt.ctm.Cust_Idcard_address_no);
cmd.Parameters.AddWithValue("@i_Cust_Idcard_vilage", cls_grt.ctm.Cust_Idcard_vilage);
cmd.Parameters.AddWithValue("@i_Cust_Idcard_vilage_no", cls_grt.ctm.Cust_Idcard_vilage_no);
cmd.Parameters.AddWithValue("@i_Cust_Idcard_alley", cls_grt.ctm.Cust_Idcard_alley);
cmd.Parameters.AddWithValue("@i_Cust_Idcard_road", cls_grt.ctm.Cust_Idcard_road);
cmd.Parameters.AddWithValue("@i_Cust_Idcard_subdistrict", cls_grt.ctm.Cust_Idcard_subdistrict);
cmd.Parameters.AddWithValue("@i_Cust_Idcard_district", cls_grt.ctm.Cust_Idcard_district);
cmd.Parameters.AddWithValue("@i_Cust_Idcard_province", cls_grt.ctm.Cust_Idcard_province);
cmd.Parameters.AddWithValue("@i_Cust_Idcard_country", cls_grt.ctm.Cust_Idcard_country);
cmd.Parameters.AddWithValue("@i_Cust_Idcard_zipcode", cls_grt.ctm.Cust_Idcard_zipcode);
cmd.Parameters.AddWithValue("@i_Cust_Idcard_tel", cls_grt.ctm.Cust_Idcard_tel);
cmd.Parameters.AddWithValue("@i_Cust_Idcard_Status_id", cls_grt.ctm.ctm_idcard_stt.Home_status_id);
cmd.Parameters.AddWithValue("@i_Cust_Current_address_no", cls_grt.ctm.Cust_Current_address_no);
cmd.Parameters.AddWithValue("@i_Cust_Current_vilage", cls_grt.ctm.Cust_Current_vilage);
cmd.Parameters.AddWithValue("@i_Cust_Current_vilage_no", cls_grt.ctm.Cust_Current_vilage_no);
cmd.Parameters.AddWithValue("@i_Cust_Current_alley", cls_grt.ctm.Cust_Current_alley);
cmd.Parameters.AddWithValue("@i_Cust_Current_road", cls_grt.ctm.Cust_Current_road);
cmd.Parameters.AddWithValue("@i_Cust_Current_subdistrict", cls_grt.ctm.Cust_Current_subdistrict);
cmd.Parameters.AddWithValue("@i_Cust_Current_district", cls_grt.ctm.Cust_Current_district);
cmd.Parameters.AddWithValue("@i_Cust_Current_province", cls_grt.ctm.Cust_Current_province);
cmd.Parameters.AddWithValue("@i_Cust_Current_country", cls_grt.ctm.Cust_Current_country);
cmd.Parameters.AddWithValue("@i_Cust_Current_zipcode", cls_grt.ctm.Cust_Current_zipcode);
cmd.Parameters.AddWithValue("@i_Cust_Current_tel", cls_grt.ctm.Cust_Current_tel);
cmd.Parameters.AddWithValue("@i_Cust_Current_Status_id", cls_grt.ctm.ctm_current_stt.Home_status_id);
cmd.ExecuteNonQuery();
return(true);
}
catch (MySqlException ex)
{
error = "MysqlException ==> Managers_Leasings --> Car_Leasings_Guarantor_Manager --> editGuarantorsLeasing() ";
Log_Error._writeErrorFile(error, ex);
return(false);
}
catch (Exception ex)
{
error = "Exception ==> Managers_Leasings --> Car_Leasings_Guarantor_Manager --> editGuarantorsLeasing() ";
Log_Error._writeErrorFile(error, ex);
return(false);
}
finally
{
con.Close();
}
}
