public bool CreateNewArrearSavingAccount(ArrearSavingAccount arrearSavingAccount) { using (var conn = new SqlConnection(DataProvider.ConnectionString)) { return conn.Execute(INSERT_ARREAR_SAVING_ACCOUNT, arrearSavingAccount) > 0; } }
private void BuildArrearSavingAccount(ArrearSavingAccount arrearSavingAccount) { arrearSavingAccount.RefId = tbDepositCode.Text; arrearSavingAccount.Status = AuthoriseStatus.UNA.ToString(); arrearSavingAccount.CustomerId = rcbCustomerID.SelectedValue; arrearSavingAccount.CustomerName = rcbCustomerID.SelectedItem.Text.Replace(arrearSavingAccount.CustomerId + " - ", ""); arrearSavingAccount.AccCategory = rcbCategoryCode.SelectedValue; arrearSavingAccount.AccTitle = tbAccountName.Text; arrearSavingAccount.ShortTitle = tbShortName.Text; arrearSavingAccount.Currency = rcbCurrentcy.SelectedValue; arrearSavingAccount.ProductLineId = rcbProductLine.SelectedValue; arrearSavingAccount.JointACHolderId = rcbJointHolderID.SelectedValue; arrearSavingAccount.JointACHolderName = rcbJointHolderID.SelectedItem.Text.Replace(arrearSavingAccount.JointACHolderId + " - ", ""); arrearSavingAccount.RelationshipId = rcbRelationCode.SelectedValue; arrearSavingAccount.RelationshipName = rcbRelationCode.SelectedItem.Text.Replace(arrearSavingAccount.RelationshipId + " - ", ""); arrearSavingAccount.Note = tbNotes.Text; arrearSavingAccount.AccountOfferCode = rcbAccOfficer.SelectedValue; arrearSavingAccount.AZProductCode = rcbProductAZ.SelectedValue; arrearSavingAccount.AZPrincipal = radNumPrincipalAZ.Value.HasValue ? (decimal)radNumPrincipalAZ.Value : 0; arrearSavingAccount.AZValueDate = dtpValueDateAZ.SelectedDate; arrearSavingAccount.AZTerm = radTermAZ.SelectedValue; arrearSavingAccount.AZOriginalMaturityDate = dtpMaturityDateAZ.SelectedDate; arrearSavingAccount.AZInterestRate = tbInterestRateAZ.Value.HasValue ? (decimal)tbInterestRateAZ.Value : 0; arrearSavingAccount.AZWorkingAccount = rcbWorkingAccAZ.SelectedValue; arrearSavingAccount.AZMaturityInstr = lblMaturityInstrAZ.Text; arrearSavingAccount.AZRolloverPR = rcbRollOverPROnlyAZ.SelectedValue; arrearSavingAccount.TTNo = TTtbPaymentNo.Text; arrearSavingAccount.TTAccNo = TTlblAcctNo.Text; arrearSavingAccount.TTCurrency = TTrcbPaymentCcy.SelectedValue; arrearSavingAccount.TTForTeller = TTtbTeller.Text; arrearSavingAccount.TTDebitAccount = TTrcbDebitAmmount.SelectedValue; arrearSavingAccount.TTNarative = TTtbNarative.Text; arrearSavingAccount.TTDealRate = tbDealRate.Value.HasValue? (decimal?)tbDealRate.Value:null; }
private bool CommitArrearSavingAccount() { var arrearSavingAccount = new ArrearSavingAccount(); BuildArrearSavingAccount(arrearSavingAccount); if (SavingAccountDAO.CheckArrearSavingAccountExist(arrearSavingAccount.RefId)) { arrearSavingAccount.UpdatedBy = this.UserInfo.Username; return SavingAccountDAO.UpdateArrearSavingAccount(arrearSavingAccount); } else { arrearSavingAccount.CreatedBy = this.UserInfo.Username; return SavingAccountDAO.CreateNewArrearSavingAccount(arrearSavingAccount); } //Response.Redirect(string.Format("Default.aspx?tabid={0}&mid={1}", TabId, ModuleId)); //AutoLoadExtraInformationForTT(arrearSavingAccount); //StatusCommit.Value = 1.ToString(); }
private void AutoLoadExtraInformationForTT(ArrearSavingAccount arrearLoadAccount) { //TTtbTeller.Text = arrearLoadAccount.TTForTeller; //TTrcbDebitAmmount.Text = arrearLoadAccount.TTDebitAccount; //lblAccountLcy.Text = arrearLoadAccount.Currency; //lblCurrency.Text = arrearLoadAccount.Currency; //TTlblCustomerID.Text = arrearLoadAccount.CustomerId; //lblAccountNo.Text = arrearLoadAccount.RefId; //lblAccountLcy.Text = string.Format("{0:##,#}", arrearLoadAccount.AZPrincipal); //lblAmountInLCY.Text = string.Format("{0:##,#}", arrearLoadAccount.AZPrincipal); //lblAmmount.Text = "Ammount = " + arrearLoadAccount.AZPrincipal; //lblDate.Text = "Date = " + (arrearLoadAccount.AZValueDate.HasValue ? arrearLoadAccount.AZValueDate.Value.ToString("yyyyMMdd") : DateTime.Now.ToString("yyyyMMdd")); }