public void printReportOutline() { if (Session["Company_Values"] != null) { try { string Company_Values = (string)Session["Company_Values"]; string[] Array_Company = Company_Values.Split('|'); Certified_Leasing_Outline rpt = new Certified_Leasing_Outline(); rpt.SetParameterValue("Company_Name", Array_Company[0]); rpt.SetParameterValue("Company_Address", Array_Company[1]); rpt.SetParameterValue("SubCompany_Address_1", Array_Company[2]); rpt.SetParameterValue("SubCompany_Address_2", Array_Company[3]); rpt.SetParameterValue("SubCompany_Address_3", Array_Company[4]); CRV_Display_Report.ReportSource = rpt; /// Export Report to PDF File with Save As Mode /// rpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "Payment_Schedule_" + cls.Deps_no); /// Response.End(); ExportReportOutline(rpt, Array_Company[0]); } catch (Exception ex) { error = "Exception ==> Certified_Leasing : Page --> printReportOutline() "; Log_Error._writeErrorFile(error, ex); } } GC.Collect(); }
public bool addZoneService(string i_Zone_code, string i_Zone_name) { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); MySqlCommand cmd = new MySqlCommand("i_base_zone_service", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_Zone_code", i_Zone_code); cmd.Parameters.AddWithValue("@i_Zone_name", i_Zone_name); cmd.ExecuteNonQuery(); return(true); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Base --> Base_Zone_Service_Manager --> addZoneService() "; Log_Error._writeErrorFile(error, ex); return(false); } catch (Exception ex) { error = "Exception ==> Managers_Base --> Base_Zone_Service_Manager --> addZoneService() "; Log_Error._writeErrorFile(error, ex); return(false); } finally { con.Close(); con.Dispose(); } }
public bool addNationality(string i_Nationality_name_ENG, string i_Nationality_name_TH) { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); MySqlCommand cmd = new MySqlCommand("i_base_nationalitys", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_Nationality_name_ENG", i_Nationality_name_ENG); cmd.Parameters.AddWithValue("@i_Nationality_name_TH", i_Nationality_name_TH); cmd.ExecuteNonQuery(); return(true); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Base --> Base_Nationalitys_Manager --> addNationality() "; Log_Error._writeErrorFile(error, ex); return(false); } catch (Exception ex) { error = "Exception ==> Managers_Base --> Base_Nationalitys_Manager --> addNationality() "; Log_Error._writeErrorFile(error, ex); return(false); } finally { con.Close(); con.Dispose(); } }
/******************************************************************************************************************************************************************************* **************************************************** Search Leasing Method ******************************************************** **************************************************** ******************************************************** *******************************************************************************************************************************************************************************/ private void _getData() { string date_str = string.IsNullOrEmpty(Log_Date_str_TBx.Text) ? "" : DateTimeUtility.convertDateToMYSQL(Log_Date_str_TBx.Text); string date_end = string.IsNullOrEmpty(Log_Date_end_TBx.Text) ? "" : DateTimeUtility.convertDateToMYSQL(Log_Date_end_TBx.Text); string account_id = (string)Session["Account_id_Log"]; List <Activity_Log> list_data_all = act_log_mng.listActivityLogs(date_str, date_end, account_id, "", 0, 0); try { int row = list_data_all.Count; _pageCount(row); List <Activity_Log> list_data = act_log_mng.listActivityLogs(date_str, date_end, account_id, "", 0, 20); Session["date_str"] = date_str; Session["date_end"] = date_str.Equals(date_end) ? "" : date_end; Session["row_str"] = 0; Session["List_Activity_Log"] = list_data; } catch (Exception ex) { error = "Exception ==> Activity_Log_Prv : Page --> _getData() "; Log_Error._writeErrorFile(error, ex); } }
public bool removeGuarantor(string Leasing_id, int Guarantor_no, string Cust_id) { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); MySqlCommand cmd = new MySqlCommand("d_car_leasings_guarantor", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_Leasing_id", Leasing_id); cmd.Parameters.AddWithValue("@i_Guarantor_no", Guarantor_no); cmd.Parameters.AddWithValue("@i_Cust_id", Cust_id); cmd.ExecuteNonQuery(); return(true); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Leasings --> Car_Leasings_Guarantor_Manager --> removeGuarantor() "; Log_Error._writeErrorFile(error, ex); return(false); } catch (Exception ex) { error = "Exception ==> Managers_Leasings --> Car_Leasings_Guarantor_Manager --> removeGuarantor() "; Log_Error._writeErrorFile(error, ex); return(false); } finally { con.Close(); } }
public bool removeAgent(string Leasing_id) { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); MySqlCommand cmd = new MySqlCommand("d_car_agents_commission", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_Leasing_id", Leasing_id);; cmd.ExecuteNonQuery(); return(true); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Agents --> Car_Agents_Manager --> removeAgent() "; Log_Error._writeErrorFile(error, ex); return(false); } catch (Exception ex) { error = "Exception ==> Managers_Agents --> Car_Agents_Manager --> removeAgent() "; Log_Error._writeErrorFile(error, ex); return(false); } finally { con.Close(); } }
public bool calculateAllPeriodFine() { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); MySqlCommand cmd = new MySqlCommand("cal_period_fine", con); cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); return(true); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Leasings --> Car_Leasing_Payment_Manager --> calculateAllPeriodFine() "; Log_Error._writeErrorFile(error, ex); return(false); } catch (Exception ex) { error = "Exception ==> Managers_Leasings --> Car_Leasings_Payment_Manager --> calculateAllPeriodFine() "; Log_Error._writeErrorFile(error, ex); return(false); } finally { con.Close(); } }
public bool editTotalPayment(int i_Total_payment_id, string i_Total_payment_name) { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); MySqlCommand cmd = new MySqlCommand("u_base_total_payment", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_Total_payment_id", i_Total_payment_id); cmd.Parameters.AddWithValue("@i_Total_payment_name", i_Total_payment_name); cmd.ExecuteNonQuery(); return(true); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Base --> Base_Total_Payment_Manager --> editTotalPayment() "; Log_Error._writeErrorFile(error, ex); return(false); } catch (Exception ex) { error = "Exception ==> Managers_Base --> Base_Total_Payment_Manager --> editTotalPayment() "; Log_Error._writeErrorFile(error, ex); return(false); } finally { con.Close(); con.Dispose(); } }
public bool removeCarBrand(int i_Car_brand_id) { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); MySqlCommand cmd = new MySqlCommand("d_base_car_brand", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_Car_brand_id", i_Car_brand_id); cmd.ExecuteNonQuery(); return(true); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Base --> Base_Car_Brand_Manager --> removeCarBrand() "; Log_Error._writeErrorFile(error, ex); return(false); } catch (Exception ex) { error = "Exception ==> Managers_Base --> Base_Car_Brand_Manager --> removeCarBrand() "; Log_Error._writeErrorFile(error, ex); return(false); } finally { con.Close(); con.Dispose(); } }
public Agents getAgentByIdCard(string i_Agent_Idcard) { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); MySqlCommand cmd = new MySqlCommand("g_car_agents_by_idcard", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_Agent_Idcard", i_Agent_Idcard); MySqlDataReader reader = cmd.ExecuteReader(); Agents cag = new Agents(); if (reader.Read()) { int defaultNum = 0; string defaultString = ""; cag.Agent_id = reader.IsDBNull(0) ? defaultString : reader.GetString(0); cag.Agent_Fname = reader.IsDBNull(1) ? defaultString : reader.GetString(1); cag.Agent_Lname = reader.IsDBNull(2) ? defaultString : reader.GetString(2); cag.Agent_Idcard = reader.IsDBNull(3) ? defaultString : reader.GetString(3); cag.Agent_Address_no = reader.IsDBNull(4) ? defaultString : reader.GetString(4); cag.Agent_Vilage = reader.IsDBNull(5) ? defaultString : reader.GetString(5); cag.Agent_Vilage_no = reader.IsDBNull(6) ? defaultString : reader.GetString(6); cag.Agent_Alley = reader.IsDBNull(7) ? defaultString : reader.GetString(7); cag.Agent_Road = reader.IsDBNull(8) ? defaultString : reader.GetString(8); cag.Agent_Subdistrict = reader.IsDBNull(9) ? defaultString : reader.GetString(9); cag.Agent_District = reader.IsDBNull(10) ? defaultString : reader.GetString(10); cag.Agent_Province = reader.IsDBNull(11) ? defaultString : reader.GetString(11); cag.Agent_Country = reader.IsDBNull(12) ? defaultString : reader.GetString(12); cag.Agent_Zipcode = reader.IsDBNull(13) ? defaultString : reader.GetString(13); cag.Agent_Status = reader.IsDBNull(14) ? defaultNum : reader.GetInt32(14); cag.Agent_Status_name = reader.IsDBNull(15) ? defaultString : reader.GetString(15); cag.Agent_save_date = reader.IsDBNull(16) ? defaultString : reader.GetString(16); } return(cag); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Agents --> Car_Agents_Manager --> getAgentByIdCard() "; Log_Error._writeErrorFile(error, ex); return(null); } catch (Exception ex) { error = "Exception ==> Managers_Agents --> Car_Agents_Manager --> getAgentByIdCard() "; Log_Error._writeErrorFile(error, ex); return(null); } finally { con.Close(); con.Dispose(); } }
private void _loadReport() { cls = (Car_Leasings)Session["Leasings"]; MySqlConnection con = MySQLConnection.connectionMySQL(); try { /* * :: StoredProcedure :: [ rpt_payment_schedule ] :: * rpt_payment_schedule (IN i_Leasing_id varchar(50)) * */ con.Open(); MySqlCommand cmd = new MySqlCommand("rpt_payment_schedule", con); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 0; cmd.Parameters.AddWithValue("@i_Leasing_id", cls.Leasing_id); MySqlDataReader reader = cmd.ExecuteReader(); Payment_Schedule_Ds pay_schd_ds = new Payment_Schedule_Ds(); pay_schd_ds.Clear(); pay_schd_ds.Tables["r_payment_schedule"].Load(reader); /*Payment_Schedule rpt = new Payment_Schedule(); * rpt.SetDataSource(pay_schd_ds);*/ Payment_Schedule_001 rpt = new Payment_Schedule_001(); rpt.SetDataSource(pay_schd_ds); CRV_Payment_Schedule.ReportSource = rpt; /// Export Report to PDF File with Save As Mode /// rpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "Payment_Schedule_" + cls.Deps_no); /// Response.End(); ExportReport(rpt); } catch (MySqlException ex) { error = "MysqlException ==> Payment_Schedule_Prv --> _loadReport() "; Log_Error._writeErrorFile(error, ex); } catch (Exception ex) { error = "Exception ==> Payment_Schedule_Prv --> _loadReport() "; Log_Error._writeErrorFile(error, ex); } finally { con.Close(); con.Dispose(); } GC.Collect(); }
public List <Car_Leasings_Payment> getPaymentSchedule(string Leasing_id) { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); MySqlCommand cmd = new MySqlCommand("g_car_leasings_payment", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_Leasing_id", Leasing_id); MySqlDataReader reader = cmd.ExecuteReader(); List <Car_Leasings_Payment> list_cls_pay = new List <Car_Leasings_Payment>(); while (reader.Read()) { Car_Leasings_Payment cls_pay = new Car_Leasings_Payment(); int defaultNum = 0; string defaultString = ""; cls_pay.Leasing_id = reader.IsDBNull(0) ? defaultString : reader.GetString(0); cls_pay.Period_no = reader.IsDBNull(1) ? defaultNum : reader.GetInt32(1); cls_pay.Period_schedule = reader.IsDBNull(2) ? defaultString : reader.GetString(2); cls_pay.Period_current = reader.IsDBNull(3) ? defaultNum : reader.GetDouble(3); cls_pay.Period_cash = reader.IsDBNull(4) ? defaultNum : reader.GetDouble(4); cls_pay.Period_value = reader.IsDBNull(5) ? defaultNum : reader.GetDouble(5); cls_pay.Period_principle = reader.IsDBNull(6) ? defaultNum : reader.GetDouble(6); cls_pay.Period_interst = reader.IsDBNull(7) ? defaultNum : reader.GetDouble(7); cls_pay.Period_vat = reader.IsDBNull(8) ? defaultNum : reader.GetDouble(8); cls_pay.Period_fine = reader.IsDBNull(9) ? defaultNum : reader.GetDouble(9); cls_pay.Total_Period_fine = reader.IsDBNull(10) ? defaultNum : reader.GetDouble(10); cls_pay.Total_Period_left = reader.IsDBNull(11) ? defaultNum : reader.GetDouble(11); cls_pay.Period_payment_status = reader.IsDBNull(12) ? defaultNum : reader.GetInt32(12); cls_pay.Period_Save_Date = reader.IsDBNull(13) ? defaultString : reader.GetString(13); list_cls_pay.Add(cls_pay); } return(list_cls_pay); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Leasings --> Car_Leasing_Payment_Manager --> getPaymentSchedule() "; Log_Error._writeErrorFile(error, ex); return(null); } catch (Exception ex) { error = "Exception ==> Managers_Leasings --> Car_Leasing_Payment_Manager --> getPaymentSchedule() "; Log_Error._writeErrorFile(error, ex); return(null); } finally { con.Close(); } }
public Base_Leasing_Code getLeasingCodeById(int Leasing_code_id) { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); string sql = "SELECT * FROM base_leasing_code WHERE Leasing_code_id = " + Leasing_code_id; MySqlCommand cmd = new MySqlCommand(sql, con); MySqlDataReader reader = cmd.ExecuteReader(); int defaultNum = 0; string defaultString = ""; Base_Leasing_Code bs_ls_code = new Base_Leasing_Code(); if (reader.Read()) { bs_ls_code.Leasing_code_id = reader.IsDBNull(0) ? defaultNum : reader.GetInt32(0); bs_ls_code.Leasing_code_name = reader.IsDBNull(1) ? defaultString : reader.GetString(1); bs_ls_code.Leasing_code_S_Name = reader.IsDBNull(2) ? defaultString : reader.GetString(2); bs_ls_code.Leasing_code_F_Name = reader.IsDBNull(3) ? defaultString : reader.GetString(3); bs_ls_code.Leasing_code_Tax_id = reader.IsDBNull(4) ? defaultString : reader.GetString(4); bs_ls_code.Leasing_code_Tax_subcode = reader.IsDBNull(5) ? defaultString : reader.GetString(5); bs_ls_code.Leasing_code_address_no = reader.IsDBNull(6) ? defaultString : reader.GetString(6); bs_ls_code.Leasing_code_vilage = reader.IsDBNull(7) ? defaultString : reader.GetString(7); bs_ls_code.Leasing_code_vilage_no = reader.IsDBNull(8) ? defaultString : reader.GetString(8); bs_ls_code.Leasing_code_alley = reader.IsDBNull(9) ? defaultString : reader.GetString(9); bs_ls_code.Leasing_code_road = reader.IsDBNull(10) ? defaultString : reader.GetString(10); bs_ls_code.Leasing_code_subdistrict = reader.IsDBNull(11) ? defaultString : reader.GetString(11); bs_ls_code.Leasing_code_district = reader.IsDBNull(12) ? defaultString : reader.GetString(12); bs_ls_code.Leasing_code_province = reader.IsDBNull(13) ? defaultString : reader.GetString(13); bs_ls_code.Leasing_code_country = reader.IsDBNull(14) ? defaultString : reader.GetString(14); bs_ls_code.Leasing_code_zipcode = reader.IsDBNull(15) ? defaultString : reader.GetString(15); bs_ls_code.Leasing_code_tel = reader.IsDBNull(16) ? defaultString : reader.GetString(16); } return(bs_ls_code); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Base --> Base_Leasing_Code_Manager --> getLeasingCodeById() "; Log_Error._writeErrorFile(error, ex); return(null); } catch (Exception ex) { error = "Exception ==> Managers_Base --> Base_Leasing_Code_Manager --> getLeasingCodeById() "; Log_Error._writeErrorFile(error, ex); return(null); } finally { con.Close(); con.Dispose(); } }
public void printReport() { if (Session["Data_CTFLS_Values"] != null) { try { string Data_CTFLS_Values = (string)Session["Data_CTFLS_Values"]; string[] Array_Data_CTFLS_Values = Data_CTFLS_Values.Split('|'); Certified_Leasing_Result rpt = new Certified_Leasing_Result(); rpt.SetParameterValue("Leasing_Date", Array_Data_CTFLS_Values[0]); rpt.SetParameterValue("Registrar", Array_Data_CTFLS_Values[1]); rpt.SetParameterValue("Car_detail", Array_Data_CTFLS_Values[2]); rpt.SetParameterValue("Car_model", Array_Data_CTFLS_Values[3]); rpt.SetParameterValue("Car_engine_no", Array_Data_CTFLS_Values[4]); rpt.SetParameterValue("Car_chassis_no", Array_Data_CTFLS_Values[5]); rpt.SetParameterValue("Ctm_name", Array_Data_CTFLS_Values[6]); rpt.SetParameterValue("Ctm_address_no", Array_Data_CTFLS_Values[7]); rpt.SetParameterValue("Ctm_moo", Array_Data_CTFLS_Values[8]); rpt.SetParameterValue("Ctm_alley", Array_Data_CTFLS_Values[9]); rpt.SetParameterValue("Ctm_road", Array_Data_CTFLS_Values[10]); rpt.SetParameterValue("Ctm_subdistrict", Array_Data_CTFLS_Values[11]); rpt.SetParameterValue("Ctm_district", Array_Data_CTFLS_Values[12]); rpt.SetParameterValue("Ctm_Province", Array_Data_CTFLS_Values[13]); rpt.SetParameterValue("Finance", Array_Data_CTFLS_Values[14]); rpt.SetParameterValue("Interest", Array_Data_CTFLS_Values[15]); rpt.SetParameterValue("Total_Finance", Array_Data_CTFLS_Values[16]); rpt.SetParameterValue("Total_period", Array_Data_CTFLS_Values[17]); rpt.SetParameterValue("Period_pay", Array_Data_CTFLS_Values[18]); rpt.SetParameterValue("Period_vat", Array_Data_CTFLS_Values[19]); rpt.SetParameterValue("Total_sum_Period", Array_Data_CTFLS_Values[20]); rpt.SetParameterValue("For", Array_Data_CTFLS_Values[21]); rpt.SetParameterValue("Agree", Array_Data_CTFLS_Values[22]); CRV_Display_Report.ReportSource = rpt; /// Export Report to PDF File with Save As Mode /// rpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "Payment_Schedule_" + cls.Deps_no); /// Response.End(); ExportReport(rpt); } catch (Exception ex) { error = "Exception ==> Certified_Leasing : Page --> printReport()"; Log_Error._writeErrorFile(error, ex); } } GC.Collect(); }
public void ExportReport(Certified_Leasing_Result rpt) { try { cls = (Car_Leasings)Session["Leasings"]; /// Create Main Folder for Detected Images of Contact Leasing string mainDirectory = cls.Leasing_id; string mainDirectoryPath = "C:/ReportExport/" + mainDirectory; if (!Directory.Exists(mainDirectoryPath)) { Directory.CreateDirectory(mainDirectoryPath); } string FilePath = "C:/ReportExport/" + mainDirectory + "/หนังสือรับรองการเช่า-ซื้อ_" + cls.Deps_no + ".pdf"; if (File.Exists(FilePath)) { File.Delete(FilePath); } /// Export Report to PDF File with Save As Mode rpt.ExportToDisk(ExportFormatType.PortableDocFormat, @"C:/ReportExport/" + mainDirectory + "/หนังสือรับรองการเช่า-ซื้อ_" + cls.Deps_no + ".pdf"); /// Display PDF File to PDF Program /// Process process = new Process(); /// process.StartInfo.UseShellExecute = true; /// process.StartInfo.FileName = FilePath; /// process.Start(); WebClient User = new WebClient(); Byte[] FileBuffer = User.DownloadData(FilePath); if (FileBuffer != null) { Response.ContentType = "application/pdf"; Response.AddHeader("content-length", FileBuffer.Length.ToString()); Response.BinaryWrite(FileBuffer); } User.Dispose(); } catch (Exception ex) { error = "Exception ==> Certified_Leasing : Page --> ExportReport() "; Log_Error._writeErrorFile(error, ex); } rpt.Dispose(); GC.Collect(); }
/******************************************************************************************************************************************************************************* **************************************************** Search Leasing Method ******************************************************** **************************************************** ******************************************************** *******************************************************************************************************************************************************************************/ private void _getLeasing() { string deposit_no = Deps_No_TBx.Text; string leasing_no = Leasing_No_TBx.Text; string idcard = Cust_Idcard_TBx.Text; string fname = Cust_FName_TBx.Text.Trim(' '); string lname = Cust_LName_TBx.Text.Trim(' '); string date_str = DateTimeUtility.convertDateToMYSQL(Leasing_Date_str_TBx.Text); string date_end = DateTimeUtility.convertDateToMYSQL(Leasing_Date_end_TBx.Text); string car_plate = Car_Plate_TBx.Text; string leasing_Code_inline = _getCheckedLeasing_Code(); string Company_id_inline = _getCheckedCompany(); string zone_id_inline = _getCheckedZone(); if (!string.IsNullOrEmpty(deposit_no) || !string.IsNullOrEmpty(leasing_no) || !string.IsNullOrEmpty(idcard) || !string.IsNullOrEmpty(fname) || !string.IsNullOrEmpty(lname) || !string.IsNullOrEmpty(date_str) || !string.IsNullOrEmpty(date_end) || !string.IsNullOrEmpty(car_plate) || !string.IsNullOrEmpty(leasing_Code_inline) || !string.IsNullOrEmpty(Company_id_inline) || !string.IsNullOrEmpty(zone_id_inline)) { cls_mng = new Car_Leasings_Manager(); List <Car_Leasings> list_cls_all = cls_mng.getCarLeasing(deposit_no, leasing_no, idcard, fname, lname, date_str, date_end, car_plate, leasing_Code_inline, Company_id_inline, zone_id_inline, 0, 0); try { int row = list_cls_all.Count; _pageCount(row); List <Car_Leasings> list_cls = cls_mng.getCarLeasing(deposit_no, leasing_no, idcard, fname, lname, date_str, date_end, car_plate, leasing_Code_inline, Company_id_inline, zone_id_inline, 0, 20); Session["deposit_no"] = deposit_no; Session["leasing_no"] = leasing_no; Session["idcard"] = idcard; Session["fname"] = fname; Session["lname"] = lname; Session["date_str"] = date_str; Session["date_end"] = date_end; Session["car_plate"] = car_plate; Session["leasing_Code_inline"] = leasing_Code_inline; Session["company_id_inline"] = Company_id_inline; Session["zone_id_inline"] = zone_id_inline; Session["row_str"] = 0; Session["List_Leasings"] = list_cls; } catch (Exception ex) { error = "Exception ==> Leasing_Search : Page --> _getLeasing() "; Log_Error._writeErrorFile(error, ex); } } }
public bool editCompany(Base_Companys bs_cpn) { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); MySqlCommand cmd = new MySqlCommand("u_base_companys", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_Company_id", bs_cpn.Company_id); cmd.Parameters.AddWithValue("@i_Company_code", bs_cpn.Company_code); cmd.Parameters.AddWithValue("@i_Company_N_name", bs_cpn.Company_N_name); cmd.Parameters.AddWithValue("@i_Company_F_name", bs_cpn.Company_F_name); cmd.Parameters.AddWithValue("@i_Company_tax_id", bs_cpn.Company_tax_id); cmd.Parameters.AddWithValue("@i_Company_tax_subcode", bs_cpn.Company_tax_subcode); cmd.Parameters.AddWithValue("@i_Company_address_no", bs_cpn.Company_address_no); cmd.Parameters.AddWithValue("@i_Company_vilage", bs_cpn.Company_vilage); cmd.Parameters.AddWithValue("@i_Company_vilage_no", bs_cpn.Company_vilage_no); cmd.Parameters.AddWithValue("@i_Company_alley", bs_cpn.Company_alley); cmd.Parameters.AddWithValue("@i_Company_road", bs_cpn.Company_road); cmd.Parameters.AddWithValue("@i_Company_subdistrict", bs_cpn.Company_subdistrict); cmd.Parameters.AddWithValue("@i_Company_district", bs_cpn.Company_district); cmd.Parameters.AddWithValue("@i_Company_province", bs_cpn.Company_province); cmd.Parameters.AddWithValue("@i_Company_country", bs_cpn.Company_country); cmd.Parameters.AddWithValue("@i_Company_zipcode", bs_cpn.Company_zipcode); cmd.Parameters.AddWithValue("@i_Company_tel", bs_cpn.Company_tel); cmd.ExecuteNonQuery(); return(true); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Base --> Base_Companys_Manager --> editCompany() "; Log_Error._writeErrorFile(error, ex); return(false); } catch (Exception ex) { error = "Exception ==> Managers_Base --> Base_Companys_Manager --> editCompany() "; Log_Error._writeErrorFile(error, ex); return(false); } finally { con.Close(); con.Dispose(); } }
public bool addLeasingCode(Base_Leasing_Code bs_ls_cd) { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); MySqlCommand cmd = new MySqlCommand("i_base_leasing_code", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_Leasing_code_name", bs_ls_cd.Leasing_code_name); cmd.Parameters.AddWithValue("@i_Leasing_code_S_Name", bs_ls_cd.Leasing_code_S_Name); cmd.Parameters.AddWithValue("@i_Leasing_code_F_Name", bs_ls_cd.Leasing_code_F_Name); cmd.Parameters.AddWithValue("@i_Leasing_code_Tax_id", bs_ls_cd.Leasing_code_Tax_id); cmd.Parameters.AddWithValue("@i_Leasing_code_Tax_subcode", bs_ls_cd.Leasing_code_Tax_subcode); cmd.Parameters.AddWithValue("@i_Leasing_code_address_no", bs_ls_cd.Leasing_code_address_no); cmd.Parameters.AddWithValue("@i_Leasing_code_vilage", bs_ls_cd.Leasing_code_vilage); cmd.Parameters.AddWithValue("@i_Leasing_code_vilage_no", bs_ls_cd.Leasing_code_vilage_no); cmd.Parameters.AddWithValue("@i_Leasing_code_alley", bs_ls_cd.Leasing_code_alley); cmd.Parameters.AddWithValue("@i_Leasing_code_road", bs_ls_cd.Leasing_code_road); cmd.Parameters.AddWithValue("@i_Leasing_code_subdistrict", bs_ls_cd.Leasing_code_subdistrict); cmd.Parameters.AddWithValue("@i_Leasing_code_district", bs_ls_cd.Leasing_code_district); cmd.Parameters.AddWithValue("@i_Leasing_code_province", bs_ls_cd.Leasing_code_province); cmd.Parameters.AddWithValue("@i_Leasing_code_country", bs_ls_cd.Leasing_code_country); cmd.Parameters.AddWithValue("@i_Leasing_code_zipcode", bs_ls_cd.Leasing_code_zipcode); cmd.Parameters.AddWithValue("@i_Leasing_code_tel", bs_ls_cd.Leasing_code_tel); cmd.ExecuteNonQuery(); return(true); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Base --> Base_Leasing_Code_Manager --> addLeasingCode() "; Log_Error._writeErrorFile(error, ex); return(false); } catch (Exception ex) { error = "Exception ==> Managers_Base --> Base_Leasing_Code_Manager --> addLeasingCode() "; Log_Error._writeErrorFile(error, ex); return(false); } finally { con.Close(); con.Dispose(); } }
private void _loadCustomer(Car_Leasings cls) { MySqlConnection con_ctm = MySQLConnection.connectionMySQL(); try { con_ctm.Open(); MySqlCommand cmd_ctm = new MySqlCommand("rpt_leasings_customers", con_ctm); cmd_ctm.CommandType = CommandType.StoredProcedure; cmd_ctm.Parameters.AddWithValue("@i_Leasing_id", cls.Leasing_id); cmd_ctm.Parameters.AddWithValue("@i_Cust_id", cls.ctm.Cust_id); MySqlDataReader reader_ctm = cmd_ctm.ExecuteReader(); string defaultString = ""; if (reader_ctm.Read()) { Ctm_Name_TBx.Text = reader_ctm.IsDBNull(3) ? defaultString : reader_ctm.GetString(3); Ctm_Name_TBx.Text += reader_ctm.IsDBNull(4) ? defaultString : " " + reader_ctm.GetString(4); Ctm_Address_No_TBx.Text = reader_ctm.IsDBNull(77) ? defaultString : reader_ctm.GetString(77); Ctm_Moo_TBx.Text = reader_ctm.IsDBNull(79) ? defaultString : reader_ctm.GetString(79).Split('.')[1]; Ctm_Alley_TBx.Text = reader_ctm.IsDBNull(80) ? defaultString : reader_ctm.GetString(80).Split('.')[1]; Ctm_Road_TBx.Text = reader_ctm.IsDBNull(81) ? defaultString : reader_ctm.GetString(81).Split('.')[1]; Ctm_Subdistrict_TBx.Text = reader_ctm.IsDBNull(82) ? defaultString : reader_ctm.GetString(82).Split('.')[1]; Ctm_District_TBx.Text = reader_ctm.IsDBNull(83) ? defaultString : reader_ctm.GetString(83).Split('.')[1]; Ctm_Province_TBx.Text = reader_ctm.IsDBNull(85) ? defaultString : reader_ctm.GetString(85); Ctm_Name_II_TBx.Text = Ctm_Name_TBx.Text; } } catch (MySqlException ex) { error = "MysqlException ==> Certified_Leasing_Result_Prv : Page--> _loadCustomer() "; Log_Error._writeErrorFile(error, ex); } catch (Exception ex) { error = "Exception ==> Certified_Leasing_Result_Prv : Page--> _loadCustomer() "; Log_Error._writeErrorFile(error, ex); } finally { con_ctm.Close(); con_ctm.Dispose(); } GC.Collect(); }
public List <Account_Level> listAccountLevel() { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); string sql = "SELECT * FROM account_login_levels"; MySqlCommand cmd = new MySqlCommand(sql, con); MySqlDataReader reader = cmd.ExecuteReader(); int defaultNum = 0; string defaultString = ""; List <Account_Level> list_acc_lv = new List <Account_Level>(); while (reader.Read()) { Account_Level acc_lv = new Account_Level(); acc_lv.level_id = reader.IsDBNull(0) ? defaultNum : reader.GetInt32(0); acc_lv.level_name_TH = reader.IsDBNull(1) ? defaultString : reader.GetString(1); acc_lv.level_name_ENG = reader.IsDBNull(2) ? defaultString : reader.GetString(2); acc_lv.level_details = reader.IsDBNull(3) ? defaultString : reader.GetString(3); acc_lv.level_access = reader.IsDBNull(4) ? defaultNum : reader.GetInt32(4); list_acc_lv.Add(acc_lv); } return(list_acc_lv); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Base --> Account_Manager --> listAccountLevel() "; Log_Error._writeErrorFile(error, ex); return(null); } catch (Exception ex) { error = "Exception ==> Managers_Base --> Account_Manager --> listAccountLevel() "; Log_Error._writeErrorFile(error, ex); return(null); } finally { con.Close(); con.Dispose(); } }
public List <TH_Provinces> getProvinces() { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); string sql = "SELECT * FROM th_provinces ORDER BY Province_name"; MySqlCommand cmd = new MySqlCommand(sql, con); MySqlDataReader reader = cmd.ExecuteReader(); int defaultNum = 0; string defaultString = ""; List <TH_Provinces> list_th_pv = new List <TH_Provinces>(); while (reader.Read()) { TH_Provinces th_pv = new TH_Provinces(); th_pv.Province_id = reader.IsDBNull(0) ? defaultNum : reader.GetInt32(0); th_pv.Province_code = reader.IsDBNull(1) ? defaultString : reader.GetString(1); th_pv.Province_name = reader.IsDBNull(2) ? defaultString : reader.GetString(2); th_pv.Geo_id = reader.IsDBNull(3) ? defaultNum : reader.GetInt32(3); list_th_pv.Add(th_pv); } return(list_th_pv); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Base --> TH_Provinces_Manager --> getProvinces "; Log_Error._writeErrorFile(error, ex); return(null); } catch (Exception ex) { error = "Exception ==> Managers_Base --> TH_Provinces_Manager --> getProvinces "; Log_Error._writeErrorFile(error, ex); return(null); } finally { con.Close(); con.Dispose(); } }
public List <Base_Nationalitys> getNationalitys() { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); string sql = "SELECT * FROM base_nationalitys"; MySqlCommand cmd = new MySqlCommand(sql, con); MySqlDataReader reader = cmd.ExecuteReader(); int defaultNum = 0; string defaultString = ""; List <Base_Nationalitys> list_bs_ntn = new List <Base_Nationalitys>(); while (reader.Read()) { Base_Nationalitys bs_ntn = new Base_Nationalitys(); bs_ntn.Nationality_id = reader.IsDBNull(0) ? defaultNum : reader.GetInt32(0); bs_ntn.Nationality_name_ENG = reader.IsDBNull(1) ? defaultString : reader.GetString(1); bs_ntn.Nationality_name_TH = reader.IsDBNull(2) ? defaultString : reader.GetString(2); list_bs_ntn.Add(bs_ntn); } return(list_bs_ntn); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Base --> Base_Nationalitys_Manager --> getNationalitys() "; Log_Error._writeErrorFile(error, ex); return(null); } catch (Exception ex) { error = "Exception ==> Managers_Base --> Base_Nationalitys_Manager --> getNationalitys() "; Log_Error._writeErrorFile(error, ex); return(null); } finally { con.Close(); con.Dispose(); } }
public List <Base_Tents_Car> getTents() { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); string sql = "SELECT * FROM base_tents_car ORDER BY Tent_name"; MySqlCommand cmd = new MySqlCommand(sql, con); MySqlDataReader reader = cmd.ExecuteReader(); int defaultNum = 0; string defaultString = ""; List <Base_Tents_Car> list_bs_tnc = new List <Base_Tents_Car>(); while (reader.Read()) { Base_Tents_Car bs_tnc = new Base_Tents_Car(); bs_tnc.Tent_car_id = reader.IsDBNull(0) ? defaultNum : reader.GetInt32(0); bs_tnc.Tent_name = reader.IsDBNull(1) ? defaultString : reader.GetString(1); bs_tnc.Tent_local = reader.IsDBNull(2) ? defaultString : reader.GetString(2); list_bs_tnc.Add(bs_tnc); } return(list_bs_tnc); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Base --> Base_Tents_Car_Manager --> getTents() "; Log_Error._writeErrorFile(error, ex); return(null); } catch (Exception ex) { error = "Exception ==> Managers_Base --> Base_Tents_Car_Manager --> getTents() "; Log_Error._writeErrorFile(error, ex); return(null); } finally { con.Close(); con.Dispose(); } }
public List <Base_Car_Brands> getCarBrands() { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); string sql = "SELECT * FROM base_car_brands ORDER BY car_brand_name_eng"; MySqlCommand cmd = new MySqlCommand(sql, con); MySqlDataReader reader = cmd.ExecuteReader(); int defaultNum = 0; string defaultString = ""; List <Base_Car_Brands> list_bs_cbrn = new List <Base_Car_Brands>(); while (reader.Read()) { Base_Car_Brands bs_cbrn = new Base_Car_Brands(); bs_cbrn.car_brand_id = reader.IsDBNull(0) ? defaultNum : reader.GetInt32(0); bs_cbrn.car_brand_name_eng = reader.IsDBNull(1) ? defaultString : reader.GetString(1); bs_cbrn.car_brand_name_th = reader.IsDBNull(2) ? defaultString : reader.GetString(2); list_bs_cbrn.Add(bs_cbrn); } return(list_bs_cbrn); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Base --> Car_Brand_Manager --> getCarBrands() "; Log_Error._writeErrorFile(error, ex); return(null); } catch (Exception ex) { error = "Exception ==> Managers_Base --> Car_Brand_Manager --> getCarBrands() "; Log_Error._writeErrorFile(error, ex); return(null); } finally { con.Close(); con.Dispose(); } }
public bool editAgent(Agents cag) { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); MySqlCommand cmd = new MySqlCommand("u_car_agents", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_Agent_id", cag.Agent_id); cmd.Parameters.AddWithValue("@i_Agent_Fname", cag.Agent_Fname); cmd.Parameters.AddWithValue("@i_Agent_Lname", cag.Agent_Lname); cmd.Parameters.AddWithValue("@i_Agent_Idcard", cag.Agent_Idcard); cmd.Parameters.AddWithValue("@i_Agent_Address_no", cag.Agent_Address_no); cmd.Parameters.AddWithValue("@i_Agent_Vilage", cag.Agent_Vilage); cmd.Parameters.AddWithValue("@i_Agent_Vilage_no", cag.Agent_Vilage_no); cmd.Parameters.AddWithValue("@i_Agent_Alley", cag.Agent_Alley); cmd.Parameters.AddWithValue("@i_Agent_Road", cag.Agent_Road); cmd.Parameters.AddWithValue("@i_Agent_Subdistrict", cag.Agent_Subdistrict); cmd.Parameters.AddWithValue("@i_Agent_District", cag.Agent_District); cmd.Parameters.AddWithValue("@i_Agent_Province", cag.Agent_Province); cmd.Parameters.AddWithValue("@i_Agent_Country", cag.Agent_Country); cmd.Parameters.AddWithValue("@i_Agent_Zipcode", cag.Agent_Zipcode); cmd.Parameters.AddWithValue("@i_Agent_Status", cag.Agent_Status); cmd.ExecuteNonQuery(); return(true); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Agents --> Car_Agents_Manager --> editAgent() "; Log_Error._writeErrorFile(error, ex); return(false); } catch (Exception ex) { error = "Exception ==> Managers_Agents --> Car_Agents_Manager --> editAgent() "; Log_Error._writeErrorFile(error, ex); return(false); } finally { con.Close(); } }
public List <Base_Total_Payment> getTotalPayment() { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); string sql = "SELECT * FROM base_total_payment"; MySqlCommand cmd = new MySqlCommand(sql, con); MySqlDataReader reader = cmd.ExecuteReader(); int defaultNum = 0; string defaultString = ""; List <Base_Total_Payment> list_bs_t_pay = new List <Base_Total_Payment>(); while (reader.Read()) { Base_Total_Payment bs_t_pay = new Base_Total_Payment(); bs_t_pay.Total_payment_id = reader.IsDBNull(0) ? defaultNum : reader.GetInt32(0); bs_t_pay.Total_payment_name = reader.IsDBNull(1) ? defaultString : reader.GetString(1); list_bs_t_pay.Add(bs_t_pay); } return(list_bs_t_pay); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Base --> Base_Total_Payment_Manager --> getTotalPayment() "; Log_Error._writeErrorFile(error, ex); return(null); } catch (Exception ex) { error = "Exception ==> Managers_Base --> Base_Total_Payment_Manager --> getTotalPayment() "; Log_Error._writeErrorFile(error, ex); return(null); } finally { con.Close(); con.Dispose(); } }
private void _getLeasing() { cls = (Car_Leasings)Session["Leasings"]; MySqlConnection con_cls = MySQLConnection.connectionMySQL(); try { con_cls.Open(); MySqlCommand cmd_cls = new MySqlCommand("rpt_leasings", con_cls); cmd_cls.CommandType = CommandType.StoredProcedure; cmd_cls.Parameters.AddWithValue("@i_Leasing_id", cls.Leasing_id); MySqlDataReader reader_cls = cmd_cls.ExecuteReader(); string defaultString = ""; if (reader_cls.Read()) { Payment_Amount_TBx.Text = reader_cls.IsDBNull(32) ? defaultString : reader_cls.GetString(32); Car_Plate_TBx.Text = reader_cls.IsDBNull(54) ? defaultString : reader_cls.GetString(54); Car_Plate_TBx.Text += reader_cls.IsDBNull(56) ? defaultString : " " + reader_cls.GetString(56); Car_TBx.Text = reader_cls.IsDBNull(57) ? defaultString : reader_cls.GetString(57); Car_Brand_TBx.Text = reader_cls.IsDBNull(61) ? defaultString : reader_cls.GetString(61); Car_Brand_TBx.Text += reader_cls.IsDBNull(60) ? defaultString : " (" + reader_cls.GetString(60) + ")"; Car_Brand_TBx.Text += reader_cls.IsDBNull(62) ? defaultString : " " + reader_cls.GetString(62); Car_Engine_TBx.Text = reader_cls.IsDBNull(65) ? defaultString : reader_cls.GetString(65); Car_Chassis_TBx.Text = reader_cls.IsDBNull(68) ? defaultString : reader_cls.GetString(68); } } catch (MySqlException ex) { error = "MysqlException ==> Confirm_Payment_Web_Outline Page --> _getLeasing() "; Log_Error._writeErrorFile(error, ex); } catch (Exception ex) { error = "Exception ==> Confirm_Payment_Web_Outline Page --> _getLeasing() "; Log_Error._writeErrorFile(error, ex); } finally { con_cls.Close(); con_cls.Dispose(); } }
public bool editAccount(Account_Login acc_lgn) { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); MySqlCommand cmd = new MySqlCommand("u_account_login", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_Account_id", acc_lgn.Account_id); cmd.Parameters.AddWithValue("@i_Username_md", acc_lgn.Username_md); cmd.Parameters.AddWithValue("@i_Password_md", acc_lgn.Password_md); cmd.Parameters.AddWithValue("@i_level_id", acc_lgn.acc_lv.level_id); cmd.Parameters.AddWithValue("@i_Account_Idcard", acc_lgn.Account_Idcard); cmd.Parameters.AddWithValue("@i_Account_F_name", acc_lgn.Account_F_name); cmd.Parameters.AddWithValue("@i_Account_N_Name", acc_lgn.Account_N_Name); cmd.Parameters.AddWithValue("@i_Account_Address_pri", acc_lgn.Account_Address_pri); cmd.Parameters.AddWithValue("@i_Account_Tel", acc_lgn.Account_Tel); cmd.Parameters.AddWithValue("@i_Account_Email", acc_lgn.Account_Email); cmd.Parameters.AddWithValue("@i_Company_id", acc_lgn.bs_cpn.Company_id); cmd.Parameters.AddWithValue("@i_Account_status", acc_lgn.Account_status); cmd.ExecuteNonQuery(); return(true); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Base --> Account_Manager --> editAccount() "; Log_Error._writeErrorFile(error, ex); return(false); } catch (Exception ex) { error = "Exception ==> Managers_Base --> Account_Manager --> editAccount() "; Log_Error._writeErrorFile(error, ex); return(false); } finally { con.Close(); con.Dispose(); } }
public bool addPayment_Mod_III(Car_Leasings_Payment cls_pay, int type) { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); MySqlCommand cmd = new MySqlCommand("i_car_leasings_real_payment_mod_III", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@i_Leasing_id", cls_pay.Leasing_id); cmd.Parameters.AddWithValue("@i_Period_free", cls_pay.Period_fee); cmd.Parameters.AddWithValue("@i_Period_track", cls_pay.Period_track); cmd.Parameters.AddWithValue("@i_Total_payment_fine", cls_pay.Total_payment_fine); cmd.Parameters.AddWithValue("@i_Discount", cls_pay.Discount); cmd.Parameters.AddWithValue("@i_Real_payment", cls_pay.Real_payment); cmd.Parameters.AddWithValue("@i_Bill_no", cls_pay.Bill_no); cmd.Parameters.AddWithValue("@i_Real_payment_date", cls_pay.Real_payment_date); cmd.Parameters.AddWithValue("@i_Account_id", cls_pay.acc_lgn.Account_id); cmd.Parameters.AddWithValue("@i_Company_Id", cls_pay.bs_cpn.Company_id); cmd.Parameters.AddWithValue("@i_Bill_no_manual_ref", cls_pay.Bill_no_manual_ref); cmd.Parameters.AddWithValue("@i_Type_Payment", type); cmd.ExecuteNonQuery(); return(true); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Leasings --> Car_Leasing_Payment_Manager --> addPayment_Mod_III() "; Log_Error._writeErrorFile(error, ex); return(false); } catch (Exception ex) { error = "Exception ==> Managers_Leasings --> Car_Leasings_Payment_Manager --> addPayment_Mod_III() "; Log_Error._writeErrorFile(error, ex); return(false); } finally { con.Close(); } }
public Base_Origins getOriginById(int Origin_id) { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); string sql = "SELECT * FROM base_origins WHERE Origin_id = " + Origin_id; MySqlCommand cmd = new MySqlCommand(sql, con); MySqlDataReader reader = cmd.ExecuteReader(); int defaultNum = 0; string defaultString = ""; Base_Origins bs_org = new Base_Origins(); while (reader.Read()) { bs_org.Origin_id = reader.IsDBNull(0) ? defaultNum : reader.GetInt32(0); bs_org.Origin_name_ENG = reader.IsDBNull(1) ? defaultString : reader.GetString(1); bs_org.Origin_name_TH = reader.IsDBNull(2) ? defaultString : reader.GetString(2); } return(bs_org); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Base --> Base_Origins_Manager --> getOriginById() "; Log_Error._writeErrorFile(error, ex); return(null); } catch (Exception ex) { error = "Exception ==> Managers_Base --> Base_Origins_Manager --> getOriginById() "; Log_Error._writeErrorFile(error, ex); return(null); } finally { con.Close(); con.Dispose(); } }