コード例 #1
0
ファイル: CashReports.aspx.cs プロジェクト: yonass/ASUC2
    protected void btnDiscardCashReport_Click(object sender, EventArgs e)
    {
        int id = GXGridView1SelectedValue;

        if (GXGridView1.SelectedIndex != -1)
        {
            if (GXGridView1.SelectedValue != null)
            {
                id = Convert.ToInt32(GXGridView1.SelectedValue);
            }
            else
            {
                id = GXGridView1SelectedValue;
            }
            CashReport cr = CashReport.Get(id);
            if (cr.CashReportStatuse.Code == CashReportStatuse.ODOBRENO)
            {
                RegisterStartupScript("myAlert", "<script>alert('НЕ МОЖЕ ДА СЕ СТОРНИРА ОДОБРЕН КАСОВ ИЗВЕШТАЈ!')</script>");
                return;
            }
            else
            {
                CashReport.DiscardCashReport(id);
                GXGridView1.TotalRecords = ViewCashReport.SelectByFKCountCached("BranchID", this.PageUser.BranchID);
                GXGridView1.DataBind();
            }
        }
    }
コード例 #2
0
ファイル: CashReportsController.cs プロジェクト: vudc/Kimeco
        public ActionResult DeleteConfirmed(int id)
        {
            CashReport cashReport = db.CashReports.Find(id);

            db.CashReports.Remove(cashReport);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
コード例 #3
0
ファイル: CashReports.aspx.cs プロジェクト: yonass/ASUC2
 protected void btnPrintCashReport_Click(object sender, EventArgs e)
 {
     if (ViewState["CashReportID"] != null)
     {
         CashReport cr = CashReport.Get(Convert.ToInt32(ViewState["CashReportID"]));
         PrintCashReports.PrintCashReport(cr);
     }
 }
コード例 #4
0
ファイル: CashReportsController.cs プロジェクト: vudc/Kimeco
 public ActionResult Edit([Bind(Include = "ID,Date,ProjectName,LastMonthRemain,SubTotalInput,SubTotalOutput,BankRemain,CashInHand,ProjectTotal,CreateDate,CreateBy,Note,Status")] CashReport cashReport)
 {
     if (ModelState.IsValid)
     {
         db.Entry(cashReport).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(cashReport));
 }
コード例 #5
0
ファイル: CashReports.aspx.cs プロジェクト: yonass/ASUC2
    protected void btnPintCashReport_Click(object sender, EventArgs e)
    {
        int id = GXGridView1SelectedValue;

        if (id > 0)
        {
            CashReport cr = CashReport.Get(id);
            PrintCashReports.PrintCashReport(cr);
        }
    }
コード例 #6
0
ファイル: CashReportsController.cs プロジェクト: vudc/Kimeco
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            CashReport cashReport = db.CashReports.Find(id);

            if (cashReport == null)
            {
                return(HttpNotFound());
            }
            return(View(cashReport));
        }
コード例 #7
0
ファイル: CashReports.aspx.cs プロジェクト: yonass/ASUC2
    protected void btnCreate_Click(object sender, EventArgs e)
    {
        List <PaymentInfo>    lastPaymentInfos = listPaymentInfos;
        GridViewRowCollection displayedRows    = gvNewPolicies.Rows;

        foreach (GridViewRow gvRow in displayedRows)
        {
            CheckBox    cbIsForCashReporting = gvRow.FindControl("cbIsForCashReporting") as CheckBox;
            int         paymentInfoID        = Convert.ToInt32(gvNewPolicies.DataKeys[gvRow.RowIndex].Value);
            PaymentInfo payI = lastPaymentInfos.Where(f => f.ID == paymentInfoID).SingleOrDefault();
            payI.IsForCashReporting = cbIsForCashReporting.Checked;
        }
        listPaymentInfos = lastPaymentInfos;
        List <PaymentInfo> listPaymentInfo = listPaymentInfos.Where(c => c.IsForCashReporting == true).ToList();

        if (listPaymentInfo.Count > 0)
        {
            DateTime   reportDate = DateTime.Parse(tbReportDate.Text);
            CashReport cr         = new CashReport();
            cr.Number             = CashReport.GetNextNumber(this.PageUser.Branch);
            cr.BranchID           = this.PageUser.BranchID;
            cr.CashReportDate     = reportDate;
            cr.CashReportStatusID = CashReportStatuse.GetByCode(CashReportStatuse.ZA_ODOBRUVANjE).ID;
            cr.Discard            = false;
            cr.IsAccountBooked    = false;
            cr.TotalValue         = 0;
            cr.Insert();
            decimal totValue = 0;
            foreach (PaymentInfo payI in listPaymentInfo)
            {
                totValue += payI.Value;
                CashReportItem cri = new CashReportItem();
                cri.PaymentID    = payI.ID;
                cri.CashReportID = cr.ID;
                cri.IsActive     = true;
                cri.Insert();
                Payment uPayment = Payment.Get(payI.ID);
                uPayment.IsCashReported = true;
                Payment.Table.Context.SubmitChanges();
            }
            CashReport crTmp = CashReport.Get(cr.ID);
            crTmp.TotalValue = totValue;
            CashReport.Table.Context.SubmitChanges();
            btnPrintCashReport.Enabled = true;
            ViewState["CashReportID"]  = cr.ID;
        }
    }
コード例 #8
0
ファイル: CashReports.aspx.cs プロジェクト: yonass/ASUC2
    protected void btnUpdateStatus_Click(object sender, EventArgs e)
    {
        int id = GXGridView1SelectedValue;

        if (id > 0)
        {
            RadioButtonList rblStatuses = (RadioButtonList)dvChangeStatus.FindControl("rblStatuses");
            CashReport      cr          = CashReport.Get(id);
            if (rblStatuses.SelectedValue == "ODOBRENO")
            {
                cr.CashReportStatusID = CashReportStatuse.GetByCode(CashReportStatuse.ODOBRENO).ID;
            }
            else if (rblStatuses.SelectedValue == "VRATENO")
            {
                cr.CashReportStatusID = CashReportStatuse.GetByCode(CashReportStatuse.VRATENO).ID;
            }
            cr.ApproverUserID = this.PageUser.ID;
            cr.ApproverDate   = DateTime.Now;
            CashReport.Table.Context.SubmitChanges();
            GXGridView1.TotalRecords = ViewCashReport.SelectCountCached();
            GXGridView1.DataBind();
            mvMain.SetActiveView(viewGrid);
        }
    }
コード例 #9
0
ファイル: PrintCashReports.cs プロジェクト: yonass/ASUC2
        public static void PrintCashReport(CashReport cr)
        {
            PDFCreators creator = new PDFCreators(true, 15, 15, 15, 15);

            creator.OpenPDF();
            creator.GetContentByte();
            creator.AddJDBLogoForFactures(10, 775);
            creator.SetTitleLeft10(" ");
            creator.SetTitleLeft10(" ");
            creator.SetTitleLeft10(" ");
            if (cr.Discard)
            {
                creator.SetTitleCenterForFactureNumber("СТОРНИРАН КАСОВ ИЗВЕШТАЈ бр. " + cr.Number);
            }
            else
            {
                creator.SetTitleCenterForFactureNumber("КАСОВ ИЗВЕШТАЈ бр. " + cr.Number);
            }
            creator.SetTitleLeft10("Статус: " + cr.CashReportStatuse.Name);
            creator.SetTitleLeft10("Датум: " + cr.CashReportDate.ToShortDateString());
            creator.SetTitleLeft10("Филијала: " + cr.Branch.Code + " " + cr.Branch.Name);
            List <CashReportItem> lstCRI = CashReportItem.GetByCashReport(cr.ID);

            creator.SetTitleLeft10(" ");
            creator.SetTitleLeft10("Кеш уплата");
            Broker.DataAccess.PaymentType ptCash   = Broker.DataAccess.PaymentType.GetByCode(Broker.DataAccess.PaymentType.CASH);
            List <CashReportItem>         cashList = lstCRI.Where(c => c.Payment.PaymentTypeID == ptCash.ID).ToList();

            string[]   headers          = { "Ред. бр.", "Број на полиса", "Компанија", "Подкласа", "Договорувач", "Уплата" };
            float[]    widthPercentages = { 8, 10, 17, 18, 32, 15 };
            TypeCode[] typeCodes        = { TypeCode.Int32, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.Decimal };
            creator.CreateTable_Facture(headers.Length, headers, widthPercentages);
            object[] values;
            int      ordinalNumber = 1;
            decimal  totCash       = 0;

            foreach (CashReportItem cri in cashList)
            {
                values    = new object[headers.Length];
                values[0] = ordinalNumber.ToString();
                values[1] = cri.Payment.Rate.PolicyItem.PolicyNumber;
                values[2] = cri.Payment.Rate.PolicyItem.Policy.InsuranceCompany.ShortName;
                values[3] = cri.Payment.Rate.PolicyItem.InsuranceSubType.ShortDescription;
                values[4] = cri.Payment.Rate.PolicyItem.Policy.Client.Name;
                values[5] = String.Format("{0:#,0.00}", cri.Payment.Value);
                creator.AddDataRowForFactures(values, headers.Length, typeCodes);
                ordinalNumber++;
                totCash += cri.Payment.Value;
            }
            values    = new object[headers.Length];
            values[0] = "";
            values[1] = "";
            values[2] = "";
            values[3] = "";
            values[4] = "Вкупно";
            values[5] = String.Format("{0:#,0.00}", totCash);
            creator.AddDataRowForFactures(values, headers.Length, typeCodes);
            creator.AddTable();

            creator.SetTitleLeft10(" ");
            creator.SetTitleLeft10("Кредитни картички");
            Broker.DataAccess.PaymentType ptCreditCard   = Broker.DataAccess.PaymentType.GetByCode(Broker.DataAccess.PaymentType.CREDITCARD);
            List <CashReportItem>         creditCardList = lstCRI.Where(c => c.Payment.PaymentTypeID == ptCreditCard.ID).ToList();

            string[]   headersCC          = { "Ред. бр.", "Број на полиса", "Компанија", "Подкласа", "Договорувач", "Банка", "Уплата" };
            float[]    widthPercentagesCC = { 7, 9, 16, 17, 27, 10, 14 };
            TypeCode[] typeCodesCC        = { TypeCode.Int32, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.Decimal };
            creator.CreateTable_Facture(headersCC.Length, headersCC, widthPercentagesCC);
            object[] valuesCC;
            int      ordinalNumberCC = 1;
            decimal  totCreditCard   = 0;

            foreach (CashReportItem cri in creditCardList)
            {
                valuesCC    = new object[headersCC.Length];
                valuesCC[0] = ordinalNumberCC.ToString();
                valuesCC[1] = cri.Payment.Rate.PolicyItem.PolicyNumber;
                valuesCC[2] = cri.Payment.Rate.PolicyItem.Policy.InsuranceCompany.ShortName;
                valuesCC[3] = cri.Payment.Rate.PolicyItem.InsuranceSubType.ShortDescription;
                valuesCC[4] = cri.Payment.Rate.PolicyItem.Policy.Client.Name;
                if (cri.Payment.BankCreditCardID != null)
                {
                    valuesCC[5] = cri.Payment.BankCreditCard.Bank.Name;
                }
                else
                {
                    valuesCC[5] = "";
                }
                valuesCC[6] = String.Format("{0:#,0.00}", cri.Payment.Value);
                creator.AddDataRowForFactures(valuesCC, headersCC.Length, typeCodesCC);
                ordinalNumberCC++;
                totCreditCard += cri.Payment.Value;
            }
            valuesCC    = new object[headersCC.Length];
            valuesCC[0] = "";
            valuesCC[1] = "";
            valuesCC[2] = "";
            valuesCC[3] = "";
            valuesCC[4] = "";
            valuesCC[5] = "Вкупно";
            valuesCC[6] = String.Format("{0:#,0.00}", totCreditCard);
            creator.AddDataRowForFactures(valuesCC, headersCC.Length, typeCodesCC);
            creator.AddTable();
            creator.SetTitleLeft10(" ");
            creator.SetTitleRightBold14("Вкупно: " + String.Format("{0:#,0.00}", (totCreditCard + totCash)));
            creator.FinishPDF_FileName("KasovIzvestaj" + cr.ID);
        }
コード例 #10
0
        public ActionResult Approve(int?cash_spending_id)
        {
            if (cash_spending_id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Cash cash = db.Cashes.Find(cash_spending_id);

            if (cash == null)
            {
                return(HttpNotFound());
            }
            var isExistDate = db.CashReports.Any(x => x.Date == cash.C_Date && x.ProjectName == cash.ProjectName);

            if (isExistDate)
            {
                var this_Date = db.CashReports.FirstOrDefault(x => x.Date == cash.C_Date && x.ProjectName == cash.ProjectName);
                if (this_Date != null)
                {
                    this_Date.SubTotalInput += cash.Input;
                }
            }
            else
            {
                var        thisMonth_Report  = db.CashReports.Where(x => x.Date.Year == cash.C_Date.Year && x.Date.Month == cash.C_Date.Month).OrderBy(x => x.Date).ToList();
                var        sumInput          = db.Cashes.Where(x => x.C_Date.Month == cash.C_Date.Month && x.C_Date.Year == cash.C_Date.Year && x.C_Date.Day < cash.C_Date.Day).Sum(y => y.Input);
                var        sumOutput         = db.Cashes.Where(x => x.C_Date.Month == cash.C_Date.Month && x.C_Date.Year == cash.C_Date.Year && x.C_Date.Day < cash.C_Date.Day).Sum(y => y.Output);
                var        decimal_sumInput  = sumInput == null? 0 :sumInput;
                var        decimal_sumOutput = sumOutput == null ? 0 : sumOutput;
                CashReport cashreport        = new CashReport();
                cashreport.Date           = cash.C_Date;
                cashreport.ProjectName    = cash.ProjectName;
                cashreport.SubTotalOutput = decimal_sumOutput + cash.Output;
                cashreport.SubTotalInput  = decimal_sumInput + cash.Input;
                cashreport.CreateDate     = DateTime.Now;
                cashreport.Status         = true;
                cashreport.CreateBy       = Request.Cookies["username"] == null ? "" : Request.Cookies["username"].Value;
                if (cash.C_Date.Day != 1)
                {
                    CashReport firstDate = thisMonth_Report.FirstOrDefault();
                    if (firstDate != null)
                    {
                        cashreport.LastMonthRemain = firstDate.LastMonthRemain;
                    }
                }
                else
                {
                    if (cash.C_Date.Month != 1)
                    {
                        var thismouth = db.CashReports.Where(x => x.Date.Year == cash.C_Date.Year && x.Date.Month == (cash.C_Date.Month - 1)).OrderByDescending(x => x.Date).FirstOrDefault();
                        if (thismouth != null)
                        {
                            cashreport.LastMonthRemain = thismouth.LastMonthRemain;
                        }
                    }
                    else
                    {
                        var thismouth = db.CashReports.Where(x => x.Date.Year == (cash.C_Date.Year - 1) && x.Date.Month == 12).FirstOrDefault();
                        if (thismouth != null)
                        {
                            cashreport.LastMonthRemain = thismouth.LastMonthRemain;
                        }
                    }
                }
                db.CashReports.Add(cashreport);
            }
            cash.Status = true;
            db.SaveChanges();
            return(RedirectToAction("Spending"));
        }