protected void lvLoanInterestedRate_ItemInserting(object sender, ListViewInsertEventArgs e)
{
NewLoanInterestedKeyRepository facade = new NewLoanInterestedKeyRepository();
StoreProRepository storeFacade = new StoreProRepository();
RadNumericTextBox monthRate = (lvLoanInterestedRate.InsertItem.FindControl("radMonthRate")) as RadNumericTextBox;
TextBox rateDisplay = (lvLoanInterestedRate.InsertItem.FindControl("tbRateDisplay")) as TextBox;
RadNumericTextBox rnbVNDRate = (lvLoanInterestedRate.InsertItem.FindControl("rnbVNDRate")) as RadNumericTextBox;
RadNumericTextBox rnbUSDRate = (lvLoanInterestedRate.InsertItem.FindControl("rnbUSDRate")) as RadNumericTextBox;
if ((Int16)monthRate.Value <= 0)
{
RadWindowManager1.RadAlert("Deposite Rate is required!", 340, 150, "Alert", null);
return;
}
BLOANINTEREST_KEY intKey = new BLOANINTEREST_KEY();
intKey.MonthLoanRateNo = (Int16)monthRate.Value;
intKey.USD_InterestRate = (decimal)rnbUSDRate.Value;
intKey.VND_InterestRate = (decimal)rnbVNDRate.Value;
intKey.LoanInterest_Key = rateDisplay.Text;
intKey.Id = (Int16)monthRate.Value;
storeFacade.StoreProcessor().B_LoanInterested_Key_history_process(intKey.MonthLoanRateNo, intKey.VND_InterestRate, intKey.USD_InterestRate, this.UserId, 1);
facade.Add(intKey);
facade.Commit();
LoadDataTolvLoanInterestedRate();
}
protected void lvLoanInterestedRate_ItemUpdating(object sender, ListViewUpdateEventArgs e)
{
NewLoanInterestedKeyRepository facade = new NewLoanInterestedKeyRepository();
StoreProRepository storeFacade = new StoreProRepository();
RadNumericTextBox monthRate = (lvLoanInterestedRate.EditItem.FindControl("radMonthRate")) as RadNumericTextBox;
TextBox rateDisplay = (lvLoanInterestedRate.EditItem.FindControl("tbRateDisplay")) as TextBox;
RadNumericTextBox rnbVNDRate = (lvLoanInterestedRate.EditItem.FindControl("rnbVNDRate")) as RadNumericTextBox;
RadNumericTextBox rnbUSDRate = (lvLoanInterestedRate.EditItem.FindControl("rnbUSDRate")) as RadNumericTextBox;
Label lbl = (lvLoanInterestedRate.Items[e.ItemIndex].FindControl("lbID")) as Label;
String ids = "";
if (lbl != null)
ids = lbl.Text;
BLOANINTEREST_KEY intKey = new BLOANINTEREST_KEY();
intKey.MonthLoanRateNo = (Int16)monthRate.Value;
intKey.USD_InterestRate = (decimal)rnbUSDRate.Value;
intKey.VND_InterestRate = (decimal)rnbVNDRate.Value;
intKey.LoanInterest_Key = rateDisplay.Text;
intKey.Id = Int32.Parse(ids);
BLOANINTEREST_KEY exits = facade.GetById(intKey.Id);
if (exits != null)
{
storeFacade.StoreProcessor().B_LoanInterested_Key_history_process(intKey.MonthLoanRateNo, intKey.VND_InterestRate, intKey.USD_InterestRate, this.UserId, 2);
facade.Update(facade.GetById(intKey.Id), intKey);
facade.Commit();
}
lvLoanInterestedRate.EditIndex = -1;
LoadDataTolvLoanInterestedRate();
}
protected void lvRateExchange_ItemUpdating(object sender, ListViewUpdateEventArgs e)
{
ExchangeRatesRepository facade = new ExchangeRatesRepository();
StoreProRepository storeFacade = new StoreProRepository();
TextBox tbcurrency = (lvRateExchange.EditItem.FindControl("tbCurrency")) as TextBox;
RadNumericTextBox rnbVNDRate = (lvRateExchange.EditItem.FindControl("rnbVNDRate")) as RadNumericTextBox;
Label lbl = (lvRateExchange.Items[e.ItemIndex].FindControl("lbID")) as Label;
String ids = "";
if (lbl != null)
ids = lbl.Text;
B_ExchangeRates exchangeRate = new B_ExchangeRates();
exchangeRate.Rate = (decimal)rnbVNDRate.Value;
exchangeRate.Currency = tbcurrency.Text;
exchangeRate.Id = Int32.Parse(ids);
B_ExchangeRates exits = facade.GetById(exchangeRate.Id);
if (exits != null)
{
storeFacade.StoreProcessor().B_ExchangeRate_history_process(exchangeRate.Currency, exchangeRate.Rate, this.UserId, 2);
facade.Update(facade.GetById(exchangeRate.Id), exchangeRate);
facade.Commit();
}
lvRateExchange.EditIndex = -1;
LoadDataTolvRateExchange();
}
protected void lvRateExchange_ItemInserting(object sender, ListViewInsertEventArgs e)
{
ExchangeRatesRepository facade = new ExchangeRatesRepository();
StoreProRepository storeFacade = new StoreProRepository();
TextBox tbcurrency = (lvRateExchange.InsertItem.FindControl("tbCurrency")) as TextBox;
RadNumericTextBox rnbVNDRate = (lvRateExchange.InsertItem.FindControl("rnbVNDRate")) as RadNumericTextBox;
B_ExchangeRates exchangeRate = new B_ExchangeRates();
exchangeRate.Rate = (decimal)rnbVNDRate.Value;
exchangeRate.Currency = tbcurrency.Text;
storeFacade.StoreProcessor().B_ExchangeRate_history_process(exchangeRate.Currency, exchangeRate.Rate, this.UserId, 1);
facade.Add(exchangeRate);
facade.Commit();
LoadDataTolvRateExchange();
}
protected void lvLoanInterestedRate_ItemDeleting(object sender, ListViewDeleteEventArgs e)
{
String ids = "";
Label lbl = (lvLoanInterestedRate.Items[e.ItemIndex].FindControl("lbID")) as Label;
if (lbl != null)
ids = lbl.Text;
if (!String.IsNullOrEmpty(ids))
{
StoreProRepository storeFacade = new StoreProRepository();
NewLoanInterestedKeyRepository facade = new NewLoanInterestedKeyRepository();
var itm = facade.GetById(Int16.Parse(ids));
if (itm != null)
{
storeFacade.StoreProcessor().B_LoanInterested_Key_history_process(itm.MonthLoanRateNo, itm.VND_InterestRate, itm.USD_InterestRate, this.UserId, 3);
facade.Delete(itm);
facade.Commit();
LoadDataTolvLoanInterestedRate();
}
}
}
protected void lvRateExchange_ItemDeleting(object sender, ListViewDeleteEventArgs e)
{
String ids = "";
Label lbl = (lvRateExchange.Items[e.ItemIndex].FindControl("lbID")) as Label;
if (lbl != null)
ids = lbl.Text;
if (!String.IsNullOrEmpty(ids))
{
StoreProRepository storeFacade = new StoreProRepository();
ExchangeRatesRepository facade = new ExchangeRatesRepository();
var itm = facade.GetById(Int16.Parse(ids));
if (itm != null)
{
storeFacade.StoreProcessor().B_ExchangeRate_history_process(itm.Currency, itm.Rate, this.UserId, 3);
facade.Delete(itm);
facade.Commit();
LoadDataTolvRateExchange();
}
}
}
protected void btCalcu_Click(object sender, EventArgs e)
{
StoreProRepository facade = new StoreProRepository();
facade.StoreProcessor().B_Normal_Loan_Process_Payment(dtpDate.SelectedDate);
}
public void UpdateDataToPriciplePaymentSchedule(BNEWNORMALLOAN normalLoanEntryM, int replaymentTime, int userID)
{
NormalLoanPaymentSchedule facde = new NormalLoanPaymentSchedule();
var ds = PrepareDataForLoanContractSchedule(normalLoanEntryM, replaymentTime);
DataTable dtInfor = ds.DtInfor;
DataTable dtItems = ds.DtItems;
if (dtInfor == null || dtItems == null)
{
return;
}
facde.DeleteAllScheduleOfContract(dtInfor.Rows[0]["Code"].ToString(), replaymentTime);
foreach (DataRow it in dtItems.Rows)
{
B_NORMALLOAN_PAYMENT_SCHEDULE princleSchedue = new B_NORMALLOAN_PAYMENT_SCHEDULE();
princleSchedue.Code = dtInfor.Rows[0]["Code"].ToString();
princleSchedue.CustomerID = dtInfor.Rows[0]["CustomerID"].ToString();
princleSchedue.LoanAmount = decimal.Parse((dtInfor.Rows[0]["LoanAmount"].ToString().Replace(",", "")));
princleSchedue.Drawdown = String.IsNullOrEmpty(dtInfor.Rows[0]["Drawdown"].ToString()) ? this.disbursalDate : (DateTime)dtInfor.Rows[0]["Drawdown"];
princleSchedue.InterestKey = dtInfor.Rows[0]["InterestKey"].ToString();
princleSchedue.Freq = dtInfor.Rows[0]["Freq"].ToString();
princleSchedue.PeriodRepaid = replaymentTime;
princleSchedue.Interest = (Decimal)dtInfor.Rows[0]["interest"];
princleSchedue.Period = (Int16)it["Perios"];
princleSchedue.DueDate = (DateTime)it["DueDate"];
princleSchedue.PrincipalAmount = (Decimal)it["Principle"];
princleSchedue.PrinOS = (Decimal)it["PrinOS"];
princleSchedue.InterestAmount = (Decimal)it["InterestAmount"];
princleSchedue.CreateBy = userID;
princleSchedue.CreateDate = facde.GetSystemDatetime();
facde.Add(princleSchedue);
}
facde.Commit();
StoreProRepository storeFacase = new StoreProRepository();
storeFacase.StoreProcessor().B_Normal_Loan_Process_Payment_AmendAuthorizeProcess(dtInfor.Rows[0]["Code"].ToString(), replaymentTime);
}
private string generateCode()
{
VietVictoryCoreBankingEntities bd = new VietVictoryCoreBankingEntities();
StoreProRepository storePro = new StoreProRepository();
return storePro.StoreProcessor().B_BMACODE_GetNewID("CRED_REVOLVING_CONTRACT", REFIX_MACODE, ".").First<string>();
}
private void processDebitCashRepayment()
{
StoreProRepository facade = new StoreProRepository();
CashRepaymentRepository cashFacade = new CashRepaymentRepository();
if (normalLoanEntryM != null && !String.IsNullOrEmpty(normalLoanEntryM.CreditAccount))
{
var cashRepay = cashFacade.FindActiveCashRepayment(normalLoanEntryM.CreditAccount).FirstOrDefault();
if (cashRepay != null && cashRepay.AmountDeposited != null)
{
facade.StoreProcessor().B_Normal_Loan_CashRepayment_Subtract_To_Account(normalLoanEntryM.CreditAccount, cashRepay.AmountDeposited, normalLoanEntryM.Code, this.UserId);
}
}
}
private void LoadRemainLoanAmount()
{
StoreProRepository facade = new StoreProRepository();
CashRepaymentRepository cashFacade = new CashRepaymentRepository();
double remainAmount = 0;
var amt = facade.StoreProcessor().B_Normal_Loan_GetRemainLoanAmount(tbNewNormalLoan.Text).FirstOrDefault();
remainAmount = amt == null ? 0 : (double)amt;
if(normalLoanEntryM!=null && !String.IsNullOrEmpty(normalLoanEntryM.CreditAccount)){
var cashRepay = cashFacade.FindActiveCashRepayment(normalLoanEntryM.CreditAccount).FirstOrDefault();
if (cashRepay != null && cashRepay.AmountDeposited != null)
{
remainAmount = remainAmount - (cashRepay.AmountDeposited == null ? 0 : (double)cashRepay.AmountDeposited);
}
}
tbOutstandingAmount.Value = remainAmount;
}
private void LoadMainCategoryCombobox(string selectedItem)
{
StoreProRepository storeFacade = new StoreProRepository();
var db = storeFacade.StoreProcessor().B_BRPODCATEGORY_GetAll_IdOver200().ToList();
Util.LoadData2RadCombo(radcbMainCategory, db, "CatId", "Display", "-Select Main Category-", false);
radcbMainCategory.SelectedValue = selectedItem;
}
//private void LoadCustomerCombobox(string SelectedCus)
//{
// BCustomerRepository facade1 = new BCustomerRepository();
// var db = facade1.getCustomerList("AUT");
// List<BCUSTOMER_INFO> hh = db.ToList<BCUSTOMER_INFO>();
// Util.LoadData2RadCombo(rcbCustomerID, hh, "CustomerID", "ID_FullName", "-Select Customer Code-", false);
// if (!String.IsNullOrEmpty(SelectedCus))
// {
// rcbCustomerID.SelectedValue = SelectedCus;
// }
//}
void LoadAllAccount(string custID, string currency, string credit, string printRep, string inRep, string chagreRep)
{
StoreProRepository storeFacade = new StoreProRepository();
var ds = storeFacade.StoreProcessor().BOPENACCOUNT_LOANACCOUNT_GetByCode(custID, currency).ToList();
//Database.BOPENACCOUNT_LOANACCOUNT_GetByCode(name, currency);
Util.LoadData2RadCombo(rcbCreditToAccount, ds, "Id", "Display", "-Select a credit Account-", true);
if (!String.IsNullOrEmpty(credit))
{
rcbCreditToAccount.SelectedValue = credit;
}
}
private bool isCurrentAmountEnoughtForRequestCash()
{
StoreProRepository facade = new StoreProRepository();
CashRepaymentRepository cashFacade = new CashRepaymentRepository();
decimal AccRemainAmount = 0;
if (normalLoanEntryM != null && !String.IsNullOrEmpty(normalLoanEntryM.CreditAccount))
{
var cashRepay = cashFacade.FindActiveCashRepayment(normalLoanEntryM.CreditAccount).FirstOrDefault();
AccRemainAmount = (decimal)facade.StoreProcessor().B_Normal_Loan_Account_GetCurrentAmount(normalLoanEntryM.CreditAccount).FirstOrDefault();
if (cashRepay != null && cashRepay.AmountDeposited != null)
{
if (AccRemainAmount < cashRepay.AmountDeposited)
{
return false;
}
}
}
else
{
return false;
}
return true;
}
private string generateCode()
{
StoreProRepository storePro = new StoreProRepository();
return storePro.StoreProcessor().B_BMACODE_GetNewID("SALARY_PAYMENT", "TT", ".").First<string>();
}
protected void LoadCreditAccount()
{
StoreProRepository facade = new StoreProRepository();
comboCreditAcct.Items.Clear();
comboCreditAcct.Items.Add(new RadComboBoxItem(""));
comboCreditAcct.DataValueField = "Id";
comboCreditAcct.DataTextField = "Id";
comboCreditAcct.DataSource = bd.SQLData.B_BCRFROMACCOUNT_GetByCurrency_Name(txtDrawerCusName.Text, comboCreditCurrency.SelectedValue);
//comboCreditAcct.DataSource = facade.StoreProcessor().B_BCRFROMACCOUNT_GetByCurrency_Name(txtDrawerCusName.Text, comboCreditCurrency.SelectedValue).ToList();
comboCreditAcct.DataBind();
}
private void CalcRemainDisbursalLoanAmount()
{
StoreProRepository facade = new StoreProRepository();
decimal planAmount = tbLoanAmount.Text != "" ? decimal.Parse(tbLoanAmount.Text) : 0;
var rus = facade.StoreProcessor().B_LOAN_DISBURSAL_SCHEDULE_Get_Total_LoanAmount(tbNewNormalLoan.Text).First<double?>();
this.remainLoanAmountDis = rus == null ? 0 : (double)rus;
remainLoanAmountDis = ((double)planAmount - remainLoanAmountDis);
}