Exemple #1
0
 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();
         }
     }
 }
Exemple #2
0
 protected void gvForPayments_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     if (e.CommandName == "Payment")
     {
         int selIndex = Convert.ToInt32(e.CommandArgument);
         gvForPayments.SelectedIndex             = selIndex;
         ViewState["gvForPaymentsSelectedValue"] = gvForPayments.SelectedValue;
         BankslipItem bi = BankslipItem.Get(Convert.ToInt32(gvForPayments.SelectedValue));
         if (bi.IsPaid)
         {
             RegisterStartupScript("myAlert", "<script>alert('Ставката од изводот веќе е евидентирана во плаќања на полисите!')</script>");
             ViewState["ClientID"]        = null;
             btnInsertNewPayments.Enabled = false;
             return;
         }
         if (bi.DemandValue > 0)
         {
             ClientAccount ca = ClientAccount.GetByAccountNumber(bi.ClientAccountNumber);
             if (ca != null)
             {
                 List <FinCardSaldo> lst = Policy.GetForFinCard(ca.ClientID, "OpenItems");
                 if (lst.Count > 0)
                 {
                     ViewState["ClientID"] = ca.ClientID;
                     gvNewPayments.DataBind();
                     SetNewPaidValue(lst, bi.DemandValue);
                     btnInsertNewPayments.Enabled = true;
                 }
                 else
                 {
                     RegisterStartupScript("myAlert", "<script>alert('Не постојат неплатени полиси за клиентот!')</script>");
                     ViewState["ClientID"]        = null;
                     btnInsertNewPayments.Enabled = false;
                 }
             }
             else
             {
                 RegisterStartupScript("myAlert", "<script>alert('Не постои сметката!')</script>");
                 ViewState["ClientID"]        = null;
                 btnInsertNewPayments.Enabled = false;
             }
         }
         else
         {
             RegisterStartupScript("myAlert", "<script>alert('Износот во ставката на изводот не е внесен како побарува!')</script>");
             ViewState["ClientID"]        = null;
             btnInsertNewPayments.Enabled = false;
         }
     }
 }
        public static BankslipItemInfo GetFromBankslipItem(BankslipItem bi)
        {
            BankslipItemInfo bii = new BankslipItemInfo();

            bii.BankslipID          = bi.BankslipID;
            bii.CallOnPaymentNumber = bi.CallOnPaymentNumber;
            bii.ClientAccountNumber = bi.ClientAccountNumber;
            bii.ClientName          = bi.ClientName;
            bii.Code               = bi.Code;
            bii.DebtValue          = bi.DebtValue;
            bii.DemandValue        = bi.DemandValue;
            bii.ID                 = bi.ID;
            bii.PaymentDescription = bi.PaymentDescription;
            bii.ProvisionValue     = bi.ProvisionValue;
            return(bii);
        }
Exemple #4
0
    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;
    }
Exemple #5
0
    protected void dvDataSourceBankslipItem_Deleting(object sender, ObjectDataSourceMethodEventArgs e)
    {
        BankslipItem bi = e.InputParameters["entityToDelete"] as BankslipItem;

        bi.ValidateDeleteBankslipItem();
    }
Exemple #6
0
    protected void dvDataSourceBankslipItem_Updating(object sender, ObjectDataSourceMethodEventArgs e)
    {
        BankslipItem bi = e.InputParameters["newEntity"] as BankslipItem;

        bi.ValidateUpdateBankslipItem();
    }
Exemple #7
0
 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>");
     }
 }