protected void btnInsert_Click(object sender, EventArgs e) { if (BankslipInfo != null) { Bankslip b = new Bankslip(); b.BankID = BankslipInfo.BankID; b.BankslipNumber = BankslipInfo.BankslipNumber; b.Date = BankslipInfo.Date; b.DebtValue = BankslipInfo.DebtValue; b.DemandValue = BankslipInfo.DemandValue; b.Insert(); foreach (BankslipItemInfo bii in listBankslipItemInfos) { BankslipItem bi = new BankslipItem(); bi.BankslipID = b.ID; bi.CallOnPaymentNumber = bii.CallOnPaymentNumber; bi.ClientAccountNumber = bii.ClientAccountNumber; bi.ClientName = bii.ClientName; bi.Code = bii.Code; bi.DebtValue = bii.DebtValue; bi.DemandValue = bii.DemandValue; bi.PaymentDescription = bii.PaymentDescription; bi.ProvisionValue = bii.ProvisionValue; bi.Insert(); } } }
public static void ValidateInsertBankslipNumber(string bankslipNumber, int bankID) { Bankslip bankslip = new Bankslip(); bankslip.BankslipNumber = bankslipNumber; bankslip.BankID = bankID; bankslip.TestBeforeInsert(); }
public static void ValidateUpdateBankslipNumber(int bankslipID, string bankslipNumber, int bankID) { Bankslip bankslip = new Bankslip(); bankslip.BankslipNumber = bankslipNumber; bankslip.ID = bankslipID; bankslip.BankID = bankID; bankslip.TestBeforeUpdate(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GXGridView1.TotalRecords = ViewBankslip.SelectCountCached(); mvMain.SetActiveView(viewGrid); reportControl.BranchName = BrokerHouseInformation.GetBrokerHouseNameByCode(BrokerHouseInformation.FIRST_ROW); reportControl.CompanyName = "Брокерско друштво"; tbBankslipNumber.Text = Bankslip.GetNextNumber(Broker.DataAccess.Bank.Table.First().ID); } }
public static BankslipInfo GetFromBankslip(Bankslip b) { BankslipInfo bi = new BankslipInfo(); bi.BankID = b.BankID; bi.BankslipNumber = b.BankslipNumber; bi.Date = b.Date; bi.DebtValue = b.DebtValue; bi.DemandValue = b.DemandValue; bi.ID = b.ID; return(bi); }
protected void btnInsertNewPayments_Click(object sender, EventArgs e) { Bankslip b = Bankslip.Get(Convert.ToInt32(dvBankslipForPayments.SelectedValue)); decimal totPaidValue = 0; foreach (GridViewRow gvr in gvNewPayments.Rows) { int polID = Convert.ToInt32(gvr.Cells[0].Text); PolicyItem pi = Policy.Get(polID).PolicyItems[0]; TextBox tbNewPayment = gvr.FindControl("tbNewPayment") as TextBox; decimal newPaidValue = 0; decimal.TryParse(tbNewPayment.Text, out newPaidValue); totPaidValue += newPaidValue; } decimal biDemandValue = 0; if (ViewState["gvForPaymentsSelectedValue"] != null) { BankslipItem bi = BankslipItem.Get(Convert.ToInt32(ViewState["gvForPaymentsSelectedValue"])); biDemandValue = bi.DemandValue; } if (totPaidValue != biDemandValue) { RegisterStartupScript("myAlert", "<script>alert('Вкупниот внесен износ по полиси се разликува од вредноста побарува од ставката на изводот!')</script>"); return; } foreach (GridViewRow gvr in gvNewPayments.Rows) { int polID = Convert.ToInt32(gvr.Cells[0].Text); PolicyItem pi = Policy.Get(polID).PolicyItems[0]; TextBox tbNewPayment = gvr.FindControl("tbNewPayment") as TextBox; decimal newPaidValue = 0; decimal.TryParse(tbNewPayment.Text, out newPaidValue); InsertPaymentsForPolicy(pi, newPaidValue, b.Date, b.BankslipNumber, b.BankID); } if (ViewState["gvForPaymentsSelectedValue"] != null) { BankslipItem bi = BankslipItem.Get(Convert.ToInt32(ViewState["gvForPaymentsSelectedValue"])); bi.IsPaid = true; BankslipItem.Table.Context.SubmitChanges(); } mvMain.SetActiveView(viewGrid); btnInsertNewPayments.Enabled = false; }
protected void DetailsViewBankslipItem_ItemDeleted(object sender, DetailsViewDeletedEventArgs e) { if (e.Exception != null) { e.ExceptionHandled = true; ValidationUtility.ShowValidationErrors(this, e.Exception); } else { int bankslipID = GXGridView1SelectedValue; GXGridViewBankslipItems.TotalRecords = ViewBankslipItem.SelectByFKCountCached("BankslipID", bankslipID); GXGridViewBankslipItems.DataBind(); mvBankslipItems.SetActiveView(viewBankslipGrid); Bankslip bk = Bankslip.Get(GXGridView1SelectedValue); decimal debtValue = Convert.ToDecimal(e.Values["DebtValue"]); decimal demandValue = Convert.ToDecimal(e.Values["DemandValue"]); bk.DebtValue -= debtValue; bk.DemandValue -= demandValue; Bankslip.Table.Context.SubmitChanges(); dvBankslipForItem.DataBind(); } }
void KomercijalnaBanka() { if (FileUpload1.HasFile) { try { //pateka za dodavanje na datotekata. int len = FileUpload1.PostedFile.ContentLength; Stream s = FileUpload1.FileContent; byte[] data = new byte[len]; s.Read(data, 0, len); MemoryStream ms = new MemoryStream(data); StreamReader sr = new StreamReader(ms, Encoding.Default); string line = ""; Bankslip b = new Bankslip(); decimal totDebtValue = 0; decimal totDemandValue = 0; List <BankslipItem> lstBI = new List <BankslipItem>(); DateTime dt = DateTime.Today; while ((line = sr.ReadLine()) != null) { if (line.Length > 270) { BankslipItem bi = new BankslipItem(); bi.ClientName = ConvertToMacedonian.ConvertToMACEDONIAN(line.Substring(18, 70)); bi.ClientAccountNumber = line.Substring(88, 18); string sDebtValue = line.Substring(107, 18); sDebtValue = sDebtValue.Replace(".", ","); bi.DebtValue = Convert.ToDecimal(sDebtValue); totDebtValue += bi.DebtValue; string sDemandValue = line.Substring(126, 18); sDemandValue = sDemandValue.Replace(".", ","); bi.DemandValue = Convert.ToDecimal(sDemandValue); totDemandValue += bi.DemandValue; string sProvisionValue = line.Substring(145, 18); sProvisionValue = sProvisionValue.Replace(".", ","); bi.ProvisionValue = Convert.ToDecimal(sProvisionValue); dt = new DateTime(Convert.ToInt32(line.Substring(163, 4)), Convert.ToInt32(line.Substring(168, 2)), Convert.ToInt32(line.Substring(171, 2))); bi.PaymentDescription = ConvertToMacedonian.ConvertToMACEDONIAN(line.Substring(173, 70)); bi.Code = line.Substring(243, 3); string povikuvanjeZadolzuvanje = line.Substring(246, 24); string povikuvanjeOdobruvanje = line.Substring(270, 24); bi.CallOnPaymentNumber = povikuvanjeOdobruvanje + "/" + povikuvanjeOdobruvanje; lstBI.Add(bi); } } b.BankID = Convert.ToInt32(ddlBanks.SelectedValue); b.DebtValue = totDebtValue; b.DemandValue = totDemandValue; b.Date = dt; b.BankslipNumber = tbBankslipNumber.Text; List <Bankslip> lstB = new List <Bankslip>(); lstB.Add(b); dvBankslip.DataSource = lstB; dvBankslip.DataBind(); gvBankslipItems.DataSource = lstBI; gvBankslipItems.DataBind(); BankslipInfo = BankslipInfo.GetFromBankslip(b); List <BankslipItemInfo> lstBII = new List <BankslipItemInfo>(); foreach (BankslipItem bi in lstBI) { BankslipItemInfo bii = BankslipItemInfo.GetFromBankslipItem(bi); lstBII.Add(bii); } listBankslipItemInfos = lstBII; } catch (Exception ex) { BankslipInfo = null; RegisterStartupScript("myAlert", "<script>alert('ГРЕШКА ВО ФОРМАТОТ НА ВЛЕЗНАТА ДАТОТЕКА')</script>"); } } else { BankslipInfo = null; RegisterStartupScript("myAlert", "<script>alert('НЕМАТЕ ИЗБРАНО ДАТОТЕКА!')</script>"); } }
protected void dvDataSource_Inserting(object sender, ObjectDataSourceMethodEventArgs e) { Bankslip b = e.InputParameters["entityToInsert"] as Bankslip; BankslipController.ValidateInsertBankslipNumber(b.BankslipNumber, b.BankID); }
protected void dvDataSource_Inserted(object sender, ObjectDataSourceStatusEventArgs e) { Bankslip b = (Bankslip)e.ReturnValue; GXGridView1SelectedValue = b.ID; }
protected void dvDataSource_Updating(object sender, ObjectDataSourceMethodEventArgs e) { Bankslip b = e.InputParameters["newEntity"] as Bankslip; BankslipController.ValidateUpdateBankslipNumber(b.ID, b.BankslipNumber, b.BankID); }
protected void ddlBanks_SelectedIndexChanged(object sender, EventArgs e) { tbBankslipNumber.Text = Bankslip.GetNextNumber(Convert.ToInt32(ddlBanks.SelectedValue)); }
protected void dvDataSource_Deleting(object sender, ObjectDataSourceMethodEventArgs e) { Bankslip b = e.InputParameters["entityToDelete"] as Bankslip; b.ValidateDeleteBankslip(); }