Example #1
0
        private async Task <TotalSale> CalculateTotalSale(DateTime date)
        {
            TransactionRepository transactionRepository = new TransactionRepository();
            BorrowRepository      borrowRepository      = new BorrowRepository();
            SaleReturnRepository  saleReturnRepository  = new SaleReturnRepository();

            IEnumerable <Transaction> transactions = await transactionRepository.GetAllByDate(date);

            List <Borrow> borrowsUndeposited = await borrowRepository.GetAllUndepositedByDate(date);

            List <Borrow> borrowsDeposited = await borrowRepository.GetAllDepositedByDate(date);

            IEnumerable <SaleReturn> saleReturns = await saleReturnRepository.GetAllByDate(date);

            double CashPayment = await Task.Run(() => (double)transactions.Where(row => row.PaymentMethod == PaymentMethods.Cash).Sum(row => row.Amount));

            double CardPayment = await Task.Run(() => (double)transactions.Where(row => row.PaymentMethod == PaymentMethods.Card).Sum(row => row.Amount));

            double UPIPayment = await Task.Run(() => (double)transactions.Where(row => row.PaymentMethod == PaymentMethods.Online).Sum(row => row.Amount));

            double ExtraAmount = await Task.Run(() => (double)transactions.Sum(row => row.Extras));

            double SaleReturnAmount = await Task.Run(() => (double)saleReturns.Sum(row => row.Amount));

            double BorrowingBalanceAmount = await Task.Run(() => (double)borrowsUndeposited.Sum(row => row.Amount));

            double CreditDepositAmount = await Task.Run(() => (double)borrowsDeposited.Sum(row => row.Amount));

            double TotalSaleAmount = await Task.Run(() => (CashPayment + CardPayment + UPIPayment + SaleReturnAmount + BorrowingBalanceAmount - CreditDepositAmount - ExtraAmount));

            TotalSale totalSale = new TotalSale
            {
                CashAmount             = (decimal)CashPayment,
                CardAmount             = (decimal)CardPayment,
                OnlineAmount           = (decimal)UPIPayment,
                SaleReturnAmount       = (decimal)SaleReturnAmount,
                ExtraAmount            = (decimal)ExtraAmount,
                BorrowingBalanceAmount = (decimal)BorrowingBalanceAmount,
                CreditDepositAmount    = (decimal)CreditDepositAmount,
                TotalSaleAmount        = (decimal)TotalSaleAmount,
                Date = date
            };

            return(totalSale);
        }
Example #2
0
        /*
         * public TotalSale GetCurrentTotalSale()
         * {
         *  //_db.TotalSales.Where(row => row.Date.Date.Equals())
         *  //CalculateTotalSale();
         *  IEnumerable<TotalSale> totalSales = GetByDate(DateTime.Now);
         *  if(totalSales != null)
         *  {
         *      if (totalSales.Any())
         *      {
         *          return totalSales.First();
         *      }
         *  }
         *  return null;
         * }
         */

        public async Task <string> GeneratePdf(TotalSale totalSale)
        {
            Document   document = new Document(PageSize.A4, 20f, 20f, 20f, 20f);
            FileStream fs       = null;
            string     path     = "";

            try
            {
                BorrowRepository borrowRepository   = new BorrowRepository();
                List <Borrow>    borrowsUndeposited = await borrowRepository.GetAllUndepositedByDate(totalSale.Date);

                List <Borrow> borrowsDeposited = await borrowRepository.GetAllDepositedByDate(totalSale.Date);


                //Create new PDF document
                string fileName = totalSale.Date.ToString();
                fileName  = fileName.Replace("-", "");
                fileName  = fileName.Replace(":", "");
                fileName  = fileName.Replace(" ", "");
                fileName += ".pdf";
                path      = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + $"\\Client\\{fileName}";
                fs        = new FileStream(path, FileMode.OpenOrCreate);
                PdfWriter.GetInstance(document, fs);

                document.Open();
                //Report Header
                BaseFont  bfntHead   = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
                Font      fntHead    = iTextSharp.text.FontFactory.GetFont(FontFactory.HELVETICA, 16, BaseColor.Black);
                Paragraph prgHeading = new Paragraph();
                prgHeading.Alignment = Element.ALIGN_CENTER;
                prgHeading.Add(new Chunk("Aditya Medical", fntHead));
                document.Add(prgHeading);

                //Author
                Paragraph prgAuthor = new Paragraph();
                BaseFont  btnAuthor = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
                Font      fntAuthor = iTextSharp.text.FontFactory.GetFont(FontFactory.HELVETICA, 8, BaseColor.Black);
                prgAuthor.Alignment = Element.ALIGN_RIGHT;
                string author = Program.author != null ? Program.author : "Aditya Medical";
                prgAuthor.Add(new Chunk($"Author : {author}", fntAuthor));
                prgAuthor.Add(new Chunk("\nDate : " + totalSale.Date.ToShortDateString(), fntAuthor));
                document.Add(prgAuthor);

                //Add a line seperation
                Paragraph p = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 100.0F, BaseColor.Black, Element.ALIGN_LEFT, 1)));
                document.Add(p);

                ///////////////////////////////////////// START Total Sale Table ////////////////////////////////////////////

                document.Add(new Chunk("\n", fntHead));
                Paragraph prg = new Paragraph();
                prg.Alignment = Element.ALIGN_CENTER;
                Font  fntHeading     = iTextSharp.text.FontFactory.GetFont(FontFactory.HELVETICA, 13, BaseColor.Black);
                Chunk totalSaleLabel = new Chunk("Total Sale", fntHeading);
                prg.Add(totalSaleLabel);
                document.Add(prg);

                //Write the table
                PdfPTable table = new PdfPTable(8);
                table.TotalWidth = 550f;
                //fix the absolute width of the table
                table.LockedWidth = true;
                float[] widths = new float[] { 2f, 2f, 2f, 2f, 2f, 2f, 2f, 2f };
                table.SetWidths(widths);
                table.HorizontalAlignment = 1;
                //leave a gap before and after the table
                table.SpacingBefore = 10f;
                table.SpacingAfter  = 20f;

                Font fntColumnHeader = iTextSharp.text.FontFactory.GetFont(FontFactory.HELVETICA, 12, BaseColor.Black);
                for (int i = 0; i < 8; i++)
                {
                    PdfPCell cell = new PdfPCell();
                    cell.BackgroundColor = BaseColor.Gray;
                    cell.AddElement(new Chunk(totalSale.Columns[i], fntColumnHeader));
                    table.AddCell(cell);
                }
                //table Data
                for (int i = 0; i < 8; i++)
                {
                    PdfPCell cell = new PdfPCell();
                    cell.BackgroundColor = BaseColor.White;
                    cell.AddElement(new Chunk(totalSale.GetByString(totalSale.Columns[i]), fntColumnHeader));
                    table.AddCell(cell);
                }
                document.Add(table);
                /////////////////////////////////////////// END Total Sale Table ////////////////////////////////////////
                ///

                ///////////////////////////////////////// START Borrowing Balance Table ////////////////////////////////////////////

                document.Add(new Chunk("\n", fntHead));
                Paragraph prg2 = new Paragraph();
                prg2.Alignment = Element.ALIGN_CENTER;
                Chunk bbLabel = new Chunk("Borrowing Balance", fntHeading);
                prg2.Add(bbLabel);
                document.Add(prg2);

                //Write the table
                PdfPTable bbTable = new PdfPTable(2);
                bbTable.TotalWidth = 400f;
                //fix the absolute width of the table
                bbTable.LockedWidth = true;
                float[] bbWidths = new float[] { 5f, 2f };
                bbTable.SetWidths(bbWidths);
                bbTable.HorizontalAlignment = 1;
                //leave a gap before and after the table
                bbTable.SpacingBefore = 10f;
                bbTable.SpacingAfter  = 20f;
                for (int i = 0; i < 2; i++)
                {
                    PdfPCell cell = new PdfPCell();
                    cell.BackgroundColor = BaseColor.Gray;
                    cell.AddElement(new Chunk(Borrow.PdfColumnsName[i], fntColumnHeader));
                    bbTable.AddCell(cell);
                }
                //table Data
                for (int i = 0; i < borrowsUndeposited.Count; i++)
                {
                    for (int j = 0; j < 2; j++)
                    {
                        PdfPCell cell = new PdfPCell();
                        cell.BackgroundColor = BaseColor.White;
                        cell.AddElement(new Chunk(borrowsUndeposited[i].GetByString(Borrow.PdfColumnsName[j]), fntColumnHeader));
                        bbTable.AddCell(cell);
                    }
                }
                document.Add(bbTable);
                /////////////////////////////////////////// END Borrowing Balance Table ////////////////////////////////////////
                ///


                ///////////////////////////////////////// START Credit Deposit Table ////////////////////////////////////////////

                document.Add(new Chunk("\n", fntHead));
                Paragraph prg3 = new Paragraph();
                prg3.Alignment = Element.ALIGN_CENTER;
                Chunk cdLabel = new Chunk("Credit Deposite", fntHeading);
                prg3.Add(cdLabel);
                document.Add(prg3);

                //Write the table
                PdfPTable cdTable = new PdfPTable(2);
                cdTable.TotalWidth = 400f;
                //fix the absolute width of the table
                cdTable.LockedWidth = true;
                float[] cdWidths = new float[] { 5f, 2f };
                cdTable.SetWidths(cdWidths);
                cdTable.HorizontalAlignment = 1;
                //leave a gap before and after the table
                cdTable.SpacingBefore = 10f;
                cdTable.SpacingAfter  = 20f;
                for (int i = 0; i < 2; i++)
                {
                    PdfPCell cell = new PdfPCell();
                    cell.BackgroundColor = BaseColor.Gray;
                    cell.AddElement(new Chunk(Borrow.PdfColumnsName[i], fntColumnHeader));
                    cdTable.AddCell(cell);
                }
                //table Data
                for (int i = 0; i < borrowsDeposited.Count; i++)
                {
                    for (int j = 0; j < 2; j++)
                    {
                        PdfPCell cell = new PdfPCell();
                        cell.BackgroundColor = BaseColor.White;
                        cell.AddElement(new Chunk(borrowsDeposited[i].GetByString(Borrow.PdfColumnsName[j]), fntColumnHeader));
                        cdTable.AddCell(cell);
                    }
                }
                document.Add(cdTable);
                /////////////////////////////////////////// END Credit Deposit Table ////////////////////////////////////////
                document.Close();
                fs.Close();
                return(path);
            }
            catch (DirectoryNotFoundException)
            {
                throw new PdfGenerationException("Please Create Folder Named Client in yout Documents Folder.");
            }
            catch (Exception)
            {
                throw new PdfGenerationException("Failed to generate Pdf.");
            }
            finally
            {
                if (document != null)
                {
                    if (document.IsOpen())
                    {
                        document.Close();
                    }
                }
                if (fs != null)
                {
                    fs.Close();
                }
            }
        }