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 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();
}
}
private void _CheckLeasingPayment(string Leasing_id)
{
Car_Leasings_Manager cls_mng = new Car_Leasings_Manager();
Car_Leasings_Payment_Manager cls_pay_mng = new Car_Leasings_Payment_Manager();
List <Car_Leasings_Payment> list_cls_pay = cls_pay_mng.getPaymentSchedule(Leasing_id);
if (list_cls_pay.Count > 0)
{
Car_Leasings_Payment cls_pay = list_cls_pay[0];
if (string.IsNullOrEmpty(cls_pay.Real_payment_date))
{
Payment_Schedule_DDL.Enabled = true;
First_Payment_Date_TBx.Enabled = true;
Total_Require_TBx.Enabled = true;
Interest_Rate_TBx.Enabled = true;
Total_Period_TBx.Enabled = true;
Vat_TBx.Enabled = true;
Calculate_Btn.Enabled = true;
}
else
{
Payment_Schedule_DDL.Enabled = false;
First_Payment_Date_TBx.Enabled = false;
Total_Require_TBx.Enabled = false;
Interest_Rate_TBx.Enabled = false;
Total_Period_TBx.Enabled = false;
Vat_TBx.Enabled = false;
Calculate_Btn.Enabled = false;
}
}
else
{
Payment_Schedule_DDL.Enabled = true;
First_Payment_Date_TBx.Enabled = true;
Total_Require_TBx.Enabled = true;
Interest_Rate_TBx.Enabled = true;
Total_Period_TBx.Enabled = true;
Vat_TBx.Enabled = true;
Calculate_Btn.Enabled = true;
}
}
public bool fixUpdtaeFine(Car_Leasings_Payment cls_pay)
{
MySqlConnection con = MySQLConnection.connectionMySQL();
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand("s_fix_fine_amount", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@i_Leasing_id", cls_pay.Leasing_id);
cmd.Parameters.AddWithValue("@i_Total_payment_fine", cls_pay.Total_payment_fine);
cmd.Parameters.AddWithValue("@i_Bill_no", cls_pay.Bill_no);
cmd.Parameters.AddWithValue("@i_Real_payment_date", cls_pay.Real_payment_date);
cmd.ExecuteNonQuery();
return(true);
}
catch (MySqlException ex)
{
error = "MysqlException ==> Managers_Leasings --> Car_Leasing_Payment_Manager --> fixUpdtaeFine() ";
Log_Error._writeErrorFile(error, ex);
return(false);
}
catch (Exception ex)
{
error = "Exception ==> Managers_Leasings --> Car_Leasings_Payment_Manager --> fixUpdtaeFine() ";
Log_Error._writeErrorFile(error, ex);
return(false);
}
finally
{
con.Close();
}
}
public List <Car_Leasings_Payment> getRealPaymentInfo(string Leasing_id)
{
MySqlConnection con = MySQLConnection.connectionMySQL();
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand("g_car_leasings_payment_info", 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);
cls_pay.Count_payment = reader.IsDBNull(14) ? defaultNum : reader.GetInt32(14);
cls_pay.Period_fee = reader.IsDBNull(15) ? defaultNum : reader.GetDouble(15);
cls_pay.Period_track = reader.IsDBNull(16) ? defaultNum : reader.GetDouble(16);
cls_pay.Discount = reader.IsDBNull(17) ? defaultNum : reader.GetDouble(17);
cls_pay.Real_payment = reader.IsDBNull(18) ? defaultNum : reader.GetDouble(18);
cls_pay.Real_payment_fine = reader.IsDBNull(19) ? defaultNum : reader.GetDouble(19);
cls_pay.Total_payment_fine = reader.IsDBNull(20) ? defaultNum : reader.GetDouble(20);
cls_pay.Total_payment_left = reader.IsDBNull(21) ? defaultNum : reader.GetDouble(21);
cls_pay.Bill_no = reader.IsDBNull(22) ? defaultString : reader.GetString(22);
cls_pay.Real_payment_date = reader.IsDBNull(23) ? defaultString : reader.GetString(23);
cls_pay.INN = reader.IsDBNull(24) ? defaultNum : reader.GetDouble(24);
cls_pay.TNC = reader.IsDBNull(25) ? defaultNum : reader.GetDouble(25);
cls_pay.acc_lgn = new Account_Login();
cls_pay.acc_lgn.Account_id = reader.IsDBNull(26) ? defaultString : reader.GetString(26);
cls_pay.acc_lgn.Account_F_name = reader.IsDBNull(27) ? defaultString : reader.GetString(27);
cls_pay.bs_cpn = new Base_Companys();
cls_pay.bs_cpn.Company_id = reader.IsDBNull(28) ? defaultNum : reader.GetInt32(28);
cls_pay.bs_cpn.Company_N_name = reader.IsDBNull(29) ? defaultString : reader.GetString(29);
cls_pay.bs_cpn.Company_F_name = reader.IsDBNull(30) ? defaultString : reader.GetString(30);
cls_pay.bs_cpn.Company_tax_id = reader.IsDBNull(31) ? defaultString : reader.GetString(31);
cls_pay.bs_cpn.Company_tax_subcode = reader.IsDBNull(32) ? defaultString : reader.GetString(32);
cls_pay.bs_cpn.Company_province = reader.IsDBNull(33) ? defaultString : reader.GetString(33);
cls_pay.Bill_no_manual_ref = reader.IsDBNull(34) ? defaultString : reader.GetString(34);
cls_pay.Payment_save_date = reader.IsDBNull(35) ? defaultString : reader.GetString(35);
list_cls_pay.Add(cls_pay);
}
return(list_cls_pay);
}
catch (MySqlException ex)
{
error = "MysqlException ==> Managers_Leasings --> Car_Leasing_Payment_Manager --> getRealPaymentInfo() ";
Log_Error._writeErrorFile(error, ex);
return(null);
}
catch (Exception ex)
{
error = "Exception ==> Managers_Leasings --> Car_Leasing_Payment_Manager --> getRealPaymentInfo() ";
Log_Error._writeErrorFile(error, ex);
return(null);
}
finally
{
con.Close();
}
}
private void _loadLeasingDetails(string leasing_id, string idcard, string bill_no)
{
cls = cls_mng.getCarLeasingById(leasing_id);
Leasing_Date_TBx.Text = DateTimeUtility.convertDateToPageRealServer(cls.Leasing_date);
Deps_No_TBx.Text = cls.Deps_no;
Leasing_No_TBx.Text = cls.Leasing_no;
Leasing_Comments_Lbl.Text = cls.Leasing_Comment;
bs_cpn = bs_cpn_mng.getCompanysById(cls.bs_cpn.Company_id.ToString());
Company_N_Name_TBx.Text = bs_cpn.Company_N_name;
Company_F_Name_TBx.Text = bs_cpn.Company_F_name;
bs_zn = bs_zn_mng.getZoneById(cls.bs_zn.Zone_id);
Zone_Name_TBx.Text = bs_zn.Zone_code + " " + bs_zn.Zone_name;
ctm = cls_ctm_mng.getCustomersLeasing(leasing_id, idcard);
if (ctm != null)
{
Customer_Name_TBx.Text = ctm.Cust_Fname + " " + ctm.Cust_LName;
Customer_Idcard_TBx.Text = ctm.Cust_Idcard.Length == 13 ? ctm.Cust_Idcard.Substring(0, 1) + "-" + ctm.Cust_Idcard.Substring(1, 4) + "-" + ctm.Cust_Idcard.Substring(5, 5) + "-" + ctm.Cust_Idcard.Substring(10, 2) + "-" + ctm.Cust_Idcard.Substring(12) : ctm.Cust_Idcard;
//Customer_B_Date_TBx.Text = DateTimeUtility.convertDateToPage(ctm.Cust_B_date);
//Customer_Age_TBx.Text = ctm.Cust_Age.ToString();
Customer_H_Address_TBx.Text = string.IsNullOrEmpty(ctm.Cust_Home_address_no) ? "" : ctm.Cust_Home_address_no;
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_vilage_no) ? "" : ctm.Cust_Home_vilage_no.IndexOf('.') >= 1 ? ctm.Cust_Home_vilage_no.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_vilage_no : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_vilage) ? "" : ctm.Cust_Home_vilage.IndexOf('.') >= 1 ? ctm.Cust_Home_vilage.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_vilage : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_alley) ? "" : ctm.Cust_Home_alley.IndexOf('.') >= 1 ? ctm.Cust_Home_alley.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_alley : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_road) ? "" : ctm.Cust_Home_road.IndexOf('.') >= 1 ? ctm.Cust_Home_road.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_road : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_subdistrict) ? "" : ctm.Cust_Home_subdistrict.IndexOf('.') >= 1 ? ctm.Cust_Home_subdistrict.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_subdistrict : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_district) ? "" : ctm.Cust_Home_district.IndexOf('.') >= 1 ? ctm.Cust_Home_district.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_district : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_province) ? "" : ctm.Cust_Home_province.IndexOf('.') >= 1 ? ctm.Cust_Home_province.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_province : "";
Customer_C_Address_TBx.Text = string.IsNullOrEmpty(ctm.Cust_Current_address_no) ? "" : ctm.Cust_Current_address_no;
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_vilage_no) ? "" : ctm.Cust_Current_vilage_no.IndexOf('.') >= 1 ? ctm.Cust_Current_vilage_no.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_vilage_no : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_vilage) ? "" : ctm.Cust_Current_vilage.IndexOf('.') >= 1 ? ctm.Cust_Current_vilage.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_vilage : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_alley) ? "" : ctm.Cust_Current_alley.IndexOf('.') >= 1 ? ctm.Cust_Current_alley.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_alley : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_road) ? "" : ctm.Cust_Current_road.IndexOf('.') >= 1 ? ctm.Cust_Current_road.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_road : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_subdistrict) ? "" : ctm.Cust_Current_subdistrict.IndexOf('.') >= 1 ? ctm.Cust_Current_subdistrict.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_subdistrict : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_district) ? "" : ctm.Cust_Current_district.IndexOf('.') >= 1 ? ctm.Cust_Current_district.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_district : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_province) ? "" : ctm.Cust_Current_province.IndexOf('.') >= 1 ? ctm.Cust_Current_province.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_province : "";
}
Car_Type_TBx.Text = cls.Car_type;
bs_cbrn = cbrn_mng.getCarBrandById(cls.bs_cbrn.car_brand_id);
if (bs_cbrn != null)
{
Car_Brand_TBx.Text = bs_cbrn.car_brand_name_th + " ( " + bs_cbrn.car_brand_name_eng + " )";
}
Car_Plate_TBx.Text = cls.Car_license_plate + " " + cls.Car_license_plate_province;
Car_Chassis_No_TBx.Text = cls.Car_chassis_no;
Car_Engine_No_TBx.Text = cls.Car_engine_no;
cag_com = cag_mng.getAgentCommission("", leasing_id);
Agent_Commission_TBx.Text = cag_com.Agent_commission.ToString("#,###.00");
Finance_Cost_TBx.Text = cls.Total_require.ToString("#,###.00");
Finance_Value_TBx.Text = cls.Total_sum.ToString("#,###.00");
Leasing_Cost_TBx.Text = cls.Total_Net_leasing.ToString("#,###.00");
Period_Amount_TBx.Text = cls.Total_period.ToString();
Period_Payment_TBx.Text = cls.Period_payment.ToString("#,###.00");
Payment_Schedule_TBx.Text = cls.Payment_schedule.ToString();
Frist_Payment_Date_TBx.Text = DateTimeUtility.convertDateToPageRealServer(cls.First_payment_date);
Bill_No_TBx.Text = bill_no;
Period_fee_TBx.Text = "0.00";
Period_track_TBx.Text = "0.00";
List <Car_Leasings_Payment> list_cls_pay = cls_pay_mng.getRealPaymentInfo(leasing_id);
double total_payment_left = 0.00;
double total_payment_fine = 0.00;
double total_fee = 0.00;
double total_track = 0.00;
double total_real_payment = 0.00;
double total_rea_payment_fine = 0.00;
double total_discount = 0.00;
for (int i = 0; i < list_cls_pay.Count; i++)
{
Car_Leasings_Payment cls_pay = list_cls_pay[i];
if (cls_pay.Bill_no == bill_no)
{
Payment_Date_TBx.Text = DateTimeUtility.convertDateToPageRealServer(cls_pay.Real_payment_date);
total_fee += cls_pay.Period_fee;
total_track += cls_pay.Period_track;
total_real_payment += cls_pay.Real_payment;
total_rea_payment_fine += cls_pay.Real_payment_fine;
total_discount += cls_pay.Discount;
total_payment_left = cls_pay.Total_payment_left;
total_payment_fine = cls_pay.Total_payment_fine;
Bill_No_Manual_Ref_TBx.Text = cls_pay.Bill_no_manual_ref;
Session["old_company"] = cls_pay.bs_cpn.Company_id;
}
}
Total_payment_left_TBx.Text = total_payment_left.ToString("#,###.00");
Total_payment_fine_TBx.Text = total_payment_fine.ToString("#,###.00");
Old_Period_fee_TBx.Text = total_fee.ToString("#,###.00");
Old_Period_track_TBx.Text = total_track.ToString("#,###.00");
Old_Real_Payment_TBx.Text = total_real_payment.ToString("#,###.00");
Old_Real_Payment_Fine_TBx.Text = total_rea_payment_fine.ToString("#,###.00");
Old_Real_Discount_TBx.Text = total_discount.ToString("#,###.00");
Session["list_cls_pay"] = list_cls_pay;
Real_Payment_TBx.Focus();
}
private void _calculateCloseLeasing(string leasing_id, string idcard)
{
cls = cls_mng.getCarLeasingById(leasing_id);
List <Car_Leasings_Payment> list_cls_pay = cls_pay_mng.getRealPaymentInfo(leasing_id);
double total_lost = 0;
double total_payment = 0;
double total_payment_fine = 0.00;
string date_last_payemnt = string.Empty;
double payment_fine = 0.00;
double real_payment_fine = 0.00;
double interest = 0;
double interest_per_day = 0;
double day_of_cal = 0;
double discount = 0;
double next_period_no = 1;
double real_payment = 0.00;
double duplicate_period = 0;
for (int i = 0; i < list_cls_pay.Count; i++)
{
Car_Leasings_Payment cls_pay = list_cls_pay[i];
if (string.IsNullOrEmpty(cls.Total_period_length))
{
Period_No_TBx.Text = next_period_no.ToString();
}
else
{
int period_str = Convert.ToInt32(cls.Total_period_length.Split('-')[0].Trim());
int period_end = Convert.ToInt32(cls.Total_period_length.Split('-')[1].Trim());
if (cls_pay.Period_no >= period_str && cls_pay.Period_no <= period_end)
{
total_lost += cls_pay.Period_current;
}
}
if (cls_pay.Period_no != duplicate_period)
{
total_payment += cls_pay.Period_current;
}
else
{
next_period_no += 1;
}
if (cls_pay.Total_payment_fine != 0)
{
total_payment_fine = cls_pay.Total_payment_fine;
}
date_last_payemnt = cls_pay.Period_schedule;
interest = cls_pay.Period_interst;
if (cls_pay.Period_fine > 0 && cls_pay.Period_no != duplicate_period)
{
payment_fine += cls_pay.Period_fine;
duplicate_period = cls_pay.Period_no;
}
if (cls_pay.Real_payment_fine > 0)
{
real_payment_fine += cls_pay.Real_payment_fine;
}
if (cls_pay.Real_payment > 0)
{
real_payment += cls_pay.Real_payment;
}
}
total_payment_fine = payment_fine - real_payment_fine;
Total_payment_fine_TBx.Text = total_payment_fine <= 0 ? "0.00" : total_payment_fine.ToString("#,###.00");
Total_period_left_TBx.Text = (total_lost - real_payment) <= 0 ? "0.00" : (total_lost - real_payment).ToString("#,###.00");
Period_fine_TBx.Text = total_payment_fine < 0 ? "0.00" : total_payment_fine.ToString("#,###.00");
interest_per_day = interest / 30;
day_of_cal = (Convert.ToDateTime(date_last_payemnt) - DateTime.Now).TotalDays;
discount = Math.Floor((day_of_cal * interest_per_day) / 2);
Discount_TBx.Text = discount.ToString("#,###.00");
Cal_Period_Payment_TBx.Text = (cls.Total_Net_leasing - real_payment).ToString("#,###.00");
Real_Payment_TBx.Focus();
Close_Leasing_Lbl.Visible = false;
Cal_Status_Lbl.Visible = true;
}
private void _loadLeasingDetails(string leasing_id, string idcard)
{
cls = cls_mng.getCarLeasingById(leasing_id);
Leasing_Comments_Lbl.Text = cls.Leasing_Comment;
if (cls.Total_payment_left == 0)
{
Close_Leasing_Lbl.Visible = true;
Cal_Status_Lbl.Visible = false;
Payment_Btn.Visible = false;
Calculate_Close_Leasing_Btn.Visible = false;
Back_Before_Page_Btn.Visible = false;
Leasing_Date_TBx.Text = DateTimeUtility.convertDateToPageRealServer(cls.Leasing_date);
Deps_No_TBx.Text = cls.Deps_no;
Leasing_No_TBx.Text = cls.Leasing_no;
bs_cpn = bs_cpn_mng.getCompanysById(cls.bs_cpn.Company_id.ToString());
Company_N_Name_TBx.Text = bs_cpn.Company_N_name;
Company_F_Name_TBx.Text = bs_cpn.Company_F_name;
bs_zn = bs_zn_mng.getZoneById(cls.bs_zn.Zone_id);
Zone_Name_TBx.Text = bs_zn.Zone_code + " " + bs_zn.Zone_name;
ctm = cls_ctm_mng.getCustomersLeasing(leasing_id, idcard);
if (ctm != null)
{
Customer_Name_TBx.Text = ctm.Cust_Fname + " " + ctm.Cust_LName;
Customer_Idcard_TBx.Text = ctm.Cust_Idcard.Length == 13 ? ctm.Cust_Idcard.Substring(0, 1) + "-" + ctm.Cust_Idcard.Substring(1, 4) + "-" + ctm.Cust_Idcard.Substring(5, 5) + "-" + ctm.Cust_Idcard.Substring(10, 2) + "-" + ctm.Cust_Idcard.Substring(12) : ctm.Cust_Idcard;
//Customer_B_Date_TBx.Text = DateTimeUtility.convertDateToPage(ctm.Cust_B_date);
//Customer_Age_TBx.Text = ctm.Cust_Age.ToString();
Customer_H_Address_TBx.Text = string.IsNullOrEmpty(ctm.Cust_Home_address_no) ? "" : ctm.Cust_Home_address_no;
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_vilage_no) ? "" : ctm.Cust_Home_vilage_no.IndexOf('.') >= 1 ? ctm.Cust_Home_vilage_no.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_vilage_no : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_vilage) ? "" : ctm.Cust_Home_vilage.IndexOf('.') >= 1 ? ctm.Cust_Home_vilage.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_vilage : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_alley) ? "" : ctm.Cust_Home_alley.IndexOf('.') >= 1 ? ctm.Cust_Home_alley.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_alley : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_road) ? "" : ctm.Cust_Home_road.IndexOf('.') >= 1 ? ctm.Cust_Home_road.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_road : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_subdistrict) ? "" : ctm.Cust_Home_subdistrict.IndexOf('.') >= 1 ? ctm.Cust_Home_subdistrict.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_subdistrict : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_district) ? "" : ctm.Cust_Home_district.IndexOf('.') >= 1 ? ctm.Cust_Home_district.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_district : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_province) ? "" : ctm.Cust_Home_province.IndexOf('.') >= 1 ? ctm.Cust_Home_province.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_province : "";
Customer_C_Address_TBx.Text = string.IsNullOrEmpty(ctm.Cust_Current_address_no) ? "" : ctm.Cust_Current_address_no;
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_vilage_no) ? "" : ctm.Cust_Current_vilage_no.IndexOf('.') >= 1 ? ctm.Cust_Current_vilage_no.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_vilage_no : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_vilage) ? "" : ctm.Cust_Current_vilage.IndexOf('.') >= 1 ? ctm.Cust_Current_vilage.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_vilage : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_alley) ? "" : ctm.Cust_Current_alley.IndexOf('.') >= 1 ? ctm.Cust_Current_alley.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_alley : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_road) ? "" : ctm.Cust_Current_road.IndexOf('.') >= 1 ? ctm.Cust_Current_road.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_road : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_subdistrict) ? "" : ctm.Cust_Current_subdistrict.IndexOf('.') >= 1 ? ctm.Cust_Current_subdistrict.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_subdistrict : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_district) ? "" : ctm.Cust_Current_district.IndexOf('.') >= 1 ? ctm.Cust_Current_district.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_district : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_province) ? "" : ctm.Cust_Current_province.IndexOf('.') >= 1 ? ctm.Cust_Current_province.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_province : "";
}
Car_Type_TBx.Text = cls.Car_type;
bs_cbrn = cbrn_mng.getCarBrandById(cls.bs_cbrn.car_brand_id);
if (bs_cbrn != null)
{
Car_Brand_TBx.Text = bs_cbrn.car_brand_name_th + " ( " + bs_cbrn.car_brand_name_eng + " )";
}
Car_Plate_TBx.Text = cls.Car_license_plate + " " + cls.Car_license_plate_province;
Car_Chassis_No_TBx.Text = cls.Car_chassis_no;
Car_Engine_No_TBx.Text = cls.Car_engine_no;
cag_com = cag_mng.getAgentCommission("", leasing_id);
Agent_Commission_TBx.Text = cag_com.Agent_commission.ToString("#,###.00");
Finance_Cost_TBx.Text = cls.Total_require.ToString("#,###.00");
Finance_Value_TBx.Text = cls.Total_sum.ToString("#,###.00");
Leasing_Cost_TBx.Text = cls.Total_Net_leasing.ToString("#,###.00");
Period_Amount_TBx.Text = cls.Total_period.ToString();
Period_Payment_TBx.Text = cls.Period_payment.ToString("#,###.00");
Payment_Schedule_TBx.Text = cls.Payment_schedule.ToString();
Frist_Payment_Date_TBx.Text = DateTimeUtility.convertDateToPageRealServer(cls.First_payment_date);
Payment_Date_TBx.Enabled = false;
List <Car_Leasings_Payment> list_cls_pay = cls_pay_mng.getRealPaymentInfo(leasing_id);
Session["list_cls_pay"] = list_cls_pay;
Period_free_TBx.Enabled = false;
Period_track_TBx.Enabled = false;
Real_Payment_TBx.Enabled = false;
Real_Payment_Fine_TBx.Enabled = false;
Real_Discount_TBx.Enabled = false;
Payment_Date_TBx.Text = "";
Period_No_TBx.Text = "";
Total_Payment_Period_TBx.Text = "";
Total_payment_left_TBx.Text = "";
Period_free_TBx.Text = "";
Period_track_TBx.Text = "";
Discount_TBx.Text = "";
Total_payment_fine_TBx.Text = "";
Total_period_left_TBx.Text = "";
Period_fine_TBx.Text = "";
Cal_Period_Payment_TBx.Text = "";
}
else
{
Leasing_Date_TBx.Text = DateTimeUtility.convertDateToPageRealServer(cls.Leasing_date);
Deps_No_TBx.Text = cls.Deps_no;
Leasing_No_TBx.Text = cls.Leasing_no;
bs_cpn = bs_cpn_mng.getCompanysById(cls.bs_cpn.Company_id.ToString());
Company_N_Name_TBx.Text = bs_cpn.Company_N_name;
Company_F_Name_TBx.Text = bs_cpn.Company_F_name;
bs_zn = bs_zn_mng.getZoneById(cls.bs_zn.Zone_id);
Zone_Name_TBx.Text = bs_zn.Zone_code + " " + bs_zn.Zone_name;
ctm = cls_ctm_mng.getCustomersLeasing(leasing_id, idcard);
if (ctm != null)
{
Customer_Name_TBx.Text = ctm.Cust_Fname + " " + ctm.Cust_LName;
Customer_Idcard_TBx.Text = ctm.Cust_Idcard.Length == 13 ? ctm.Cust_Idcard.Substring(0, 1) + "-" + ctm.Cust_Idcard.Substring(1, 4) + "-" + ctm.Cust_Idcard.Substring(5, 5) + "-" + ctm.Cust_Idcard.Substring(10, 2) + "-" + ctm.Cust_Idcard.Substring(12) : ctm.Cust_Idcard;
//Customer_B_Date_TBx.Text = DateTimeUtility.convertDateToPage(ctm.Cust_B_date);
//Customer_Age_TBx.Text = ctm.Cust_Age.ToString();
Customer_H_Address_TBx.Text = string.IsNullOrEmpty(ctm.Cust_Home_address_no) ? "" : ctm.Cust_Home_address_no;
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_vilage_no) ? "" : ctm.Cust_Home_vilage_no.IndexOf('.') >= 1 ? ctm.Cust_Home_vilage_no.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_vilage_no : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_vilage) ? "" : ctm.Cust_Home_vilage.IndexOf('.') >= 1 ? ctm.Cust_Home_vilage.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_vilage : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_alley) ? "" : ctm.Cust_Home_alley.IndexOf('.') >= 1 ? ctm.Cust_Home_alley.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_alley : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_road) ? "" : ctm.Cust_Home_road.IndexOf('.') >= 1 ? ctm.Cust_Home_road.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_road : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_subdistrict) ? "" : ctm.Cust_Home_subdistrict.IndexOf('.') >= 1 ? ctm.Cust_Home_subdistrict.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_subdistrict : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_district) ? "" : ctm.Cust_Home_district.IndexOf('.') >= 1 ? ctm.Cust_Home_district.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_district : "";
Customer_H_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Home_province) ? "" : ctm.Cust_Home_province.IndexOf('.') >= 1 ? ctm.Cust_Home_province.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Home_province : "";
Customer_C_Address_TBx.Text = string.IsNullOrEmpty(ctm.Cust_Current_address_no) ? "" : ctm.Cust_Current_address_no;
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_vilage_no) ? "" : ctm.Cust_Current_vilage_no.IndexOf('.') >= 1 ? ctm.Cust_Current_vilage_no.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_vilage_no : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_vilage) ? "" : ctm.Cust_Current_vilage.IndexOf('.') >= 1 ? ctm.Cust_Current_vilage.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_vilage : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_alley) ? "" : ctm.Cust_Current_alley.IndexOf('.') >= 1 ? ctm.Cust_Current_alley.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_alley : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_road) ? "" : ctm.Cust_Current_road.IndexOf('.') >= 1 ? ctm.Cust_Current_road.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_road : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_subdistrict) ? "" : ctm.Cust_Current_subdistrict.IndexOf('.') >= 1 ? ctm.Cust_Current_subdistrict.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_subdistrict : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_district) ? "" : ctm.Cust_Current_district.IndexOf('.') >= 1 ? ctm.Cust_Current_district.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_district : "";
Customer_C_Address_TBx.Text += string.IsNullOrEmpty(ctm.Cust_Current_province) ? "" : ctm.Cust_Current_province.IndexOf('.') >= 1 ? ctm.Cust_Current_province.Split('.')[1] == "-" ? "" : " " + ctm.Cust_Current_province : "";
}
Car_Type_TBx.Text = cls.Car_type;
bs_cbrn = cbrn_mng.getCarBrandById(cls.bs_cbrn.car_brand_id);
if (bs_cbrn != null)
{
Car_Brand_TBx.Text = bs_cbrn.car_brand_name_th + " ( " + bs_cbrn.car_brand_name_eng + " )";
}
Car_Plate_TBx.Text = cls.Car_license_plate + " " + cls.Car_license_plate_province;
Car_Chassis_No_TBx.Text = cls.Car_chassis_no;
Car_Engine_No_TBx.Text = cls.Car_engine_no;
cag_com = cag_mng.getAgentCommission("", leasing_id);
Agent_Commission_TBx.Text = cag_com.Agent_commission.ToString("#,###.00");
Finance_Cost_TBx.Text = cls.Total_require.ToString("#,###.00");
Finance_Value_TBx.Text = cls.Total_sum.ToString("#,###.00");
Leasing_Cost_TBx.Text = cls.Total_Net_leasing.ToString("#,###.00");
Period_Amount_TBx.Text = cls.Total_period.ToString();
Period_Payment_TBx.Text = cls.Period_payment.ToString("#,###.00");
Payment_Schedule_TBx.Text = cls.Payment_schedule.ToString();
Frist_Payment_Date_TBx.Text = DateTimeUtility.convertDateToPageRealServer(cls.First_payment_date);
Payment_Date_TBx.Text = DateTimeUtility.convertDateToPageRealServer(DateTime.Now.ToString());
Period_No_TBx.Text = cls.Total_period_length;
Total_Payment_Period_TBx.Text = cls.Total_period_lose == 0 ? "1" : cls.Total_period_lose.ToString();
Total_payment_left_TBx.Text = cls.Total_payment_left.ToString("#,###.00");
Period_free_TBx.Text = "0.00";
Period_track_TBx.Text = "0.00";
Discount_TBx.Text = "0.00";
List <Car_Leasings_Payment> list_cls_pay = cls_pay_mng.getRealPaymentInfo(leasing_id);
double total_lost = 0.00;
double total_payment_fine = 0.00;
double payment_fine = 0.00;
double real_payment_fine = 0.00;
double real_payment = 0.00;
double next_period_no = 1;
double duplicate_period = 0;
for (int i = 0; i < list_cls_pay.Count; i++)
{
Car_Leasings_Payment cls_pay = list_cls_pay[i];
if (string.IsNullOrEmpty(cls.Total_period_length))
{
total_lost = cls_pay.Period_current;
Period_No_TBx.Text = next_period_no.ToString();
}
else
{
int period_str = Convert.ToInt32(cls.Total_period_length.Split('-')[0].Trim());
int period_end = Convert.ToInt32(cls.Total_period_length.Split('-')[1].Trim());
if (cls_pay.Period_no >= period_str && cls_pay.Period_no <= period_end && cls_pay.Period_no != duplicate_period)
{
total_lost += cls_pay.Period_current;
}
}
if (cls_pay.Period_fine > 0 && cls_pay.Period_no != duplicate_period)
{
payment_fine += cls_pay.Period_fine;
}
if (cls_pay.Real_payment_fine > 0)
{
real_payment_fine += cls_pay.Real_payment_fine;
}
if (cls_pay.Real_payment > 0 && cls_pay.Period_payment_status != 9)
{
real_payment += cls_pay.Real_payment;
}
if (cls_pay.Period_payment_status == 9 && cls_pay.Period_no != duplicate_period)
{
next_period_no += 1;
}
duplicate_period = cls_pay.Period_no;
}
total_payment_fine = payment_fine - real_payment_fine;
Total_payment_fine_TBx.Text = total_payment_fine > 0 ? total_payment_fine.ToString("#,###.00") : "0.00";
Total_period_left_TBx.Text = string.IsNullOrEmpty(cls.Total_period_length) ? "0.00" : (total_lost - real_payment).ToString("#,###.00");
Period_fine_TBx.Text = total_payment_fine < 0 ? "0.00" : total_payment_fine.ToString("#,###.00");
Cal_Period_Payment_TBx.Text = (total_lost - real_payment).ToString("#,###.00");
Session["list_cls_pay"] = list_cls_pay;
Real_Payment_TBx.Focus();
}
}
