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 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 object ToBLO()
{
var config = new MapperConfiguration(cfg =>
{
cfg.AddProfile <GetResolvedCasesResultMapProfile>();
});
IMapper mapper = new Mapper(config);
var blo = mapper.Map <EmpGetNextResolvedCaseNbrsRespBLO>(this);
Fixer.TryFixInvalidWithGetCaseDetails(blo.CaseList);
Fixer.RemoveInvalidFromCollection(blo.CaseList);
//blo.CaseList = blo.CaseList.Where(x => Fixer.IsValid(x)).ToArray();
blo.NumberOfCases = blo.CaseList.Count();
if (this.CaseList.Count() > blo.CaseList.Count())
{
int count = this.CaseList.Count() - blo.CaseList.Count();
string msg = string.Format("Mapping was missed for {0} cases; RawRespObject= ", count);
Log_Error.AddError("Map<EmpGetNextResolvedCaseNbrsRespBLO>", "EVerifyService", msg + CustomTextMessageEncoder.LastResponceObjectRawString, true, false, "WP", string.Empty, "", "EVerify");
}
blo.DTO = this;
return(blo);
}
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();
}
}
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();
}
}
/*******************************************************************************************************************************************************************************
**************************************************** 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 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 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 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 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();
}
private void THREAD_LOG()
{
if (richTextBox3.InvokeRequired)
{
Log_Error error = new Log_Error(Log);
this.Invoke(error);
}
}
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 Log_Error AddLogError(Log_Error model)
{
var dc = new eprocdbDataContext();
model.ErrorTime = DateTime.Now;
dc.Log_Errors.InsertOnSubmit(model);
dc.SubmitChanges();
return(model);
}
/// <summary>
/// 记录日志,数据库错误日志
/// </summary>
/// <param name="logRrror"></param>
public int InsertLog_Error(Log_Error logRrror)
{
#region 记录错误日志
int count = 0;
try
{
HashObject paramter = new HashObject();
if (!string.IsNullOrEmpty(logRrror.Page))
{
paramter.Add("Page", logRrror.Page);
}
if (!string.IsNullOrEmpty(logRrror.CpyNo))
{
paramter.Add("CpyNo", logRrror.CpyNo);
}
if (!string.IsNullOrEmpty(logRrror.LoginName))
{
paramter.Add("LoginName", logRrror.LoginName);
}
if (!string.IsNullOrEmpty(logRrror.Method))
{
paramter.Add("Method", logRrror.Method);
}
if (!string.IsNullOrEmpty(logRrror.ErrorContent))
{
paramter.Add("ErrorContent", logRrror.ErrorContent);
}
if (!string.IsNullOrEmpty(logRrror.DevName))
{
paramter.Add("DevName", logRrror.DevName);
}
paramter.Add("ClientIP", System.Web.HttpContext.Current.Request.UserHostAddress);
paramter.Add("ErorrTime", Convert.ToDateTime(DateTime.Now));
paramter.Add("A1", logRrror.A1);
paramter.Add("A2", logRrror.A2);
if (!string.IsNullOrEmpty(logRrror.A3))
{
paramter.Add("A3", logRrror.A3);
}
if (!string.IsNullOrEmpty(logRrror.A3))
{
paramter.Add("A4", logRrror.A3);
}
if (!string.IsNullOrEmpty(logRrror.A3))
{
paramter.Add("A5", logRrror.A3);
}
count = Log_ErrorDal.Insert(paramter);
}
catch (Exception ex)
{
PbProject.WebCommon.Log.Log.RecordLog("Log_ErrorBll", ex.Message, true, null);
}
return(count);
#endregion
}
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 AddLogError(string Note, string ErrorMessage, string StackTrace)
{
IUserService svc = new UserService();
var model = new Log_Error();
model.UserID = System.Web.HttpContext.Current.Session["UserID"].ToString();
model.Note = Note;
model.ErrorMessage = ErrorMessage;
model.StackTrace = StackTrace;
svc.AddLogError(model);
}
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 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 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 <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_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_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_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();
}
}
