コード例 #1
0
        // GET: Invoice/Create
        public ActionResult Create(string id)
        {
            if (id == null)
            {
                id = globalID;
            }
            Invoice objInvoice = new Invoice();

            objInvoice.PatientChild = db.Children.FirstOrDefault(x => x.IdNumber == id);
            objInvoice.VaccinationList = db.Vaccinations.Where(x => x.IdNumber == id).ToList();
            string branch = db.UserStatus.FirstOrDefault(x => x.Username == User.Identity.Name).Branch_Practice_No;
            var  temp = new List<ExtendedFeesCustom>();
            List<ExtendedFee> listFromDB = null;
            if (branch == "ADMIN2010")
            {
                listFromDB = db.ExtendedFees.ToList();
            }
            else
            {
                listFromDB = db.ExtendedFees.Where(x => x.Branch == branch).ToList();
            }

            foreach (ExtendedFee item in listFromDB)
            {
                temp.Add(FeesToCustomObj(item));
            }

            objInvoice.ExtendedFeeList = temp;

            objInvoice.InvoiceFromDate = DateTime.Now.Date;
            objInvoice.BranchInformation = db.Branches1.FirstOrDefault(x => x.Practice_No == branch);
                

            return View(objInvoice);
        }
コード例 #2
0
        public Document CreateDocument(Invoice inputInvoice, string loggedInUser)
        {
            globalCurrentUser = loggedInUser;
            this.document = new Document();
            document.DefaultPageSetup.Orientation = Orientation.Portrait;
            this.document.Info.Title = "Vaccination Invoice";
            this.document.Info.Subject = "Contains Child's Vaccinations Invoice";
            this.document.Info.Author = loggedInUser;

            if (inputInvoice.VaccinationList.Count < 1)
            {
                Section s = this.document.AddSection();
                Paragraph p = s.AddParagraph("No vaccinations for the selected date");
                p.Format.Font.Size = 20;
                p.Format.Font.Color = Colors.Red;
                p.AddLineBreak(); p.AddLineBreak(); p.AddLineBreak(); p.AddLineBreak(); p.AddLineBreak(); p.AddLineBreak();
                p.Format.Alignment = ParagraphAlignment.Center;
                return this.document;

            }


            DefineStyles();
            CreatePage();
            FillContents(inputInvoice);

            return this.document;
        }
コード例 #3
0
        private FileContentResult CreateDummyReport()
        {
            //-------------------------------------------
            //outputDate = ViewBag.GlobalDate;
            string id = Url.RequestContext.RouteData.Values["id"].ToString();
            if (string.IsNullOrEmpty(id))
            {
                id = invoiceID;
            }
            Invoice objInvoice = new Invoice();

            objInvoice.PatientChild = db.Children.FirstOrDefault(x => x.IdNumber == id);
            objInvoice.VaccinationList = db.Vaccinations.Where(x => x.IdNumber == id && x.Date.Day == outputDate.Day && x.Date.Month == outputDate.Month && x.Date.Year == outputDate.Year).ToList();
            string branch = db.UserStatus.FirstOrDefault(x => x.Username == User.Identity.Name).Branch_Practice_No;
            var temp = new List<ExtendedFeesCustom>();
            List<ExtendedFee> listFromDB = null;
            if (branch == "ADMIN2010")
            {
                listFromDB = db.ExtendedFees.ToList();
            }
            else
            {
                listFromDB = db.ExtendedFees.Where(x => x.Branch == branch).ToList();
            }

            foreach (ExtendedFee item in listFromDB)
            {
                temp.Add(FeesToCustomObj(item));
            }

            objInvoice.ExtendedFeeList = temp;
            objInvoice.InvoiceFromDate = outputDate;
            objInvoice.InvoiceToDate = outputDate;


            objInvoice.BranchInformation = db.Branches1.FirstOrDefault(x => x.Practice_No == branch);

            //-------------------------------------------


            InvoiceReport report = new InvoiceReport();


            Document document = report.CreateDocument(objInvoice, User.Identity.Name);
            //string ddl = MigraDoc.DocumentObjectModel.IO.DdlWriter.WriteToString(document);
            PdfDocumentRenderer renderer = new PdfDocumentRenderer(true, PdfSharp.Pdf.PdfFontEmbedding.Always);
            renderer.Document = document;

            renderer.RenderDocument();

            using (MemoryStream stream = new MemoryStream())
            {
                renderer.PdfDocument.Save(stream, false);
                return File(stream.ToArray(), "application/pdf");
            }
        }
コード例 #4
0
        public ActionResult Create(Invoice model)
        {
            Session["DateError"] = "";
            string tempId = Url.RequestContext.RouteData.Values["id"].ToString();
            if (string.IsNullOrEmpty(tempId))
            {
                
            }
            else
            {
                Session["GlobalID"] = tempId;
            }
            try
            {
                //var obj = (List<ExtendedFeesCustom>)Request["Model.ExtendedFeeList"];
                //string test = obj[0].FeeName;
                var obj2 = model.InvoiceFromDate.ToString().Substring(0, model.InvoiceFromDate.ToString().LastIndexOf(" "));
                string obj3 = obj2.Substring(0, obj2.LastIndexOf(" "));
                obj2 = obj3;
                if (!isValidDate(obj2))
                {
                    Session["DateError"] = "Invalid";

                    return View(model);
                    //return RedirectToAction("Create", "Invoice", new { id = Session["GlobalID"] });
                }
                Session["DateError"] = "";
                ViewBag.GlobalDate = outputDate;
                resultPDF = CreateDummyReport();
                return RedirectToAction("Edit", new {id = tempId});
            }
            catch(Exception ex)
            {
                return View(model);
            }
        }
コード例 #5
0
        public void FillContents(Invoice contents)
        {
            #region Top paragraph data
            
            Details.Format.Font.Size = 18;
            Details.AddTab(); Details.AddTab(); Details.AddTab(); Details.AddTab(); Details.AddTab();
            Details.AddFormattedText("Invoice", TextFormat.Bold);
            Details.AddLineBreak();

            Details.AddLineBreak(); Details.AddLineBreak();
            //---------------CENTRE DETAILS-----------------------------------------------------------------------------
            Details.Format.Font.Size = 12;
            Details.AddTab(); Details.AddTab(); Details.AddTab(); Details.AddTab(); 
            Details.AddFormattedText("Medical Centre Details", TextFormat.Bold);
            Details.AddLineBreak(); Details.AddLineBreak();

            Details.Format.Font.Size = 11;
            Details.AddFormattedText("Branch Centre Name:", TextFormat.Bold);
            Details.AddTab();
            Details.AddTab();
            if (contents != null && (contents.BranchInformation != null && contents.BranchInformation.Name != null)) Details.AddText(contents.BranchInformation.Name);
            Details.AddLineBreak();

            Details.AddFormattedText("Manager:", TextFormat.Bold);
            Details.AddTab();
            Details.AddTab();
            Details.AddTab();
            if (contents != null && (contents.BranchInformation != null && contents.BranchInformation.Overseer_Name != null))
                Details.AddText(contents.BranchInformation.Overseer_Name + " " + contents.BranchInformation.Overseer_Surname);
            Details.AddLineBreak();

            Details.AddFormattedText("Practice Number:", TextFormat.Bold);
            Details.AddTab();
            Details.AddTab();
            if (contents != null && contents.BranchInformation != null && contents.BranchInformation.Practice_No != null)
            {
                Details.AddText(contents.BranchInformation.Practice_No);
            }

            Details.AddLineBreak();

            Details.AddFormattedText("Address:", TextFormat.Bold);
            Details.AddTab();
            Details.AddTab(); Details.AddTab();
            if (contents != null && contents.BranchInformation != null && contents.BranchInformation.Address != null)
                Details.AddText(contents.BranchInformation.Address);
            Details.AddLineBreak(); Details.AddLineBreak();

            Details.AddFormattedText("Telephone:", TextFormat.Bold);
            Details.AddTab();
            Details.AddTab();
            Details.AddTab();
            if (contents != null && contents.BranchInformation != null && contents.BranchInformation.Tel_Number != null)
                Details.AddText(contents.BranchInformation.Tel_Number);
            Details.AddLineBreak();

            Details.AddFormattedText("Fax:", TextFormat.Bold);
            Details.AddTab();
            Details.AddTab();
            Details.AddTab();
            Details.AddTab();
            if (contents != null && contents.BranchInformation != null && contents.BranchInformation.Fax_Number != null)
                Details.AddText(contents.BranchInformation.Fax_Number);
            Details.AddLineBreak(); Details.AddLineBreak();

            //------------------------Parent Details---------------------------------------------------
            var parent = db.Parents.FirstOrDefault(x => x.IdNumber == contents.PatientChild.MotherId);

            if (parent == null)
            {
                parent = db.Parents.FirstOrDefault(x => x.IdNumber == contents.PatientChild.FatherId);
            }

            Details.Format.Font.Size = 11;
            Details.AddTab(); Details.AddTab(); Details.AddTab(); Details.AddTab(); 
            Details.AddFormattedText("Medical Aid Principal Member Details", TextFormat.Bold);
            Details.AddLineBreak(); Details.AddLineBreak();

            Details.AddFormattedText("Name:", TextFormat.Bold);
            Details.AddTab(); Details.AddTab();
            Details.AddTab(); Details.AddTab();
            if (parent != null && parent.Name != null) { Details.AddText(parent.Name); }
            Details.AddLineBreak();
            


            Details.AddFormattedText("Surname:", TextFormat.Bold);
            Details.AddTab();
            Details.AddTab();
            Details.AddTab();
            if (parent != null && parent.Surname != null) Details.AddText(parent.Surname);
            Details.AddLineBreak();
            


            Details.AddFormattedText("ID Number:", TextFormat.Bold);
            Details.AddTab();
            Details.AddTab();
            Details.AddTab();
            if (parent != null && parent.IdNumber != null) Details.AddText(parent.IdNumber);
            Details.AddLineBreak();
            

            Details.AddFormattedText("Address:", TextFormat.Bold);
            Details.AddTab();
            Details.AddTab();
            Details.AddTab();
            if (parent != null && parent.Address != null)
            {

                Address addressResult = parent.Address;
                Details.AddText(addressResult.AddressLine1 + ", " + addressResult.AddressLine2 + ", " + addressResult.Suburb + ", " + addressResult.Town + ", " + addressResult.PostalCode); //Fetch Address from ID and display
            }
                
            Details.AddLineBreak(); Details.AddLineBreak();
            

            Details.AddFormattedText("Telephone:", TextFormat.Bold);
            Details.AddTab();
            Details.AddTab();
            Details.AddTab();
            if (parent != null && parent.HomeTel != null) Details.AddText(parent.HomeTel);
            Details.AddLineBreak();
            

            Details.AddFormattedText("Cell:", TextFormat.Bold);
            Details.AddTab();
            Details.AddTab();
            Details.AddTab();
            Details.AddTab();
            if (parent != null && parent.Cellphone != null) Details.AddText(parent.Cellphone);
            Details.AddLineBreak(); Details.AddLineBreak();

            //----------------------END Parent Details-------------------------------------------------

            //----------------------Medical Aid Info---------------------------------------------------
            
            Details.AddFormattedText("Employer:", TextFormat.Bold);
            Details.AddTab(); Details.AddTab();
            Details.AddTab();
            if(parent != null && parent.Employer != null)
                Details.AddText(parent.Employer);
            Details.AddLineBreak();
            
            Details.AddFormattedText("Office Phone:", TextFormat.Bold);
            Details.AddTab();
            Details.AddTab();
            Details.AddTab();
            if (parent != null && parent.Telephone != null)
                if (parent != null) Details.AddText(parent.Telephone);
            Details.AddLineBreak();
            
            Details.AddFormattedText("Medical Aid:", TextFormat.Bold);
            Details.AddTab();
            Details.AddTab();
            Details.AddTab();
            if (parent != null && parent.MedicalAidName != null) Details.AddText(parent.MedicalAidName);
            Details.AddLineBreak();
            
            Details.AddFormattedText("Medical Aid No:", TextFormat.Bold);
            Details.AddTab();
            Details.AddTab();
            if (parent != null && parent.MedicalAidNumber != null)
                Details.AddText(parent.MedicalAidNumber);
            Details.AddLineBreak();
            
            Details.AddFormattedText("Medical Aid Plan:", TextFormat.Bold);
            Details.AddTab();
            Details.AddTab();
            if (parent != null && parent.MedicalAidPlan != null) Details.AddText(parent.MedicalAidPlan);
            Details.AddLineBreak();

            //----------------------END Medical Aid Info-----------------------------------------------

            //------------------------END CENTRE DETAILS----------------------------------------------------------------


            #endregion

            //-----------------------VACCINATIONS-----------------------------------------------------------------------

            var vaccinations = contents.VaccinationList;
            var temp = db.UserStatus.FirstOrDefault(x => x.Username == globalCurrentUser);
            string currentBranch = "";
            if (temp != null)
            {
                currentBranch = temp.Branch_Practice_No;
            }

            decimal sum = Convert.ToDecimal(0.0);
            var extendedFees = db.ExtendedFees.Where(x => x.IncludeInReport == "Include" && x.Branch == currentBranch).ToList();
            foreach (var vacc in vaccinations)
            {
                //if (vacc.Existing)
                //{
                // Each item fills two rows
                Row row1 = this.VaccincationsTable.AddRow();
                //Row row2 = this.table.AddRow();
                //row1.TopPadding = 1.5;
                //row1.Cells[0].Shading.Color = Colors.Gray;
                //row1.Cells[0].VerticalAlignment = VerticalAlignment.Center;
                //row1.Cells[0].MergeDown = 1;
                //row1.Cells[1].Format.Alignment = ParagraphAlignment.Left;
                //row1.Cells[1].MergeRight = 3;
                //row1.Cells[5].Shading.Color = Colors.Gray;
                //row1.Cells[5].MergeDown = 1;
                
                VaccinationDefinition vaccDef = db.VaccinationDefinitions.FirstOrDefault(x=>x.Id == vacc.VaccinationDefinitionId);
                VaccinationPrice vaccPrice = db.VaccinationPrices.FirstOrDefault(x=>x.VaccinationDefId == vacc.VaccinationDefinitionId.ToString());
                int quantity = 1;
                row1.Cells[0].AddParagraph(contents.InvoiceFromDate.ToString("yyyy-MM-dd"));
                if (vaccDef != null && vaccDef.Description != null) row1.Cells[1].AddParagraph(vaccDef.Description);
                if (vaccDef != null && vaccDef.Code != null) row1.Cells[2].AddParagraph(vaccDef.Code);
                if (vaccDef != null && vaccDef.ICDCode != null) row1.Cells[3].AddParagraph(vaccDef.ICDCode);
                row1.Cells[4].AddParagraph(quantity.ToString()); // Dummy value for QTY
                if (vaccDef.Price == null)
                {
                    row1.Cells[5].AddParagraph("0.00");
                }
                else
                {
                    row1.Cells[5].AddParagraph(vaccDef.Price.ToString());
                }


                this.VaccincationsTable.SetEdge(0, this.VaccincationsTable.Rows.Count - 2, 6, 2, Edge.Box, BorderStyle.Single, 0.75);
                decimal price;
                if (vaccDef.Price == null)
                {
                    price = Convert.ToDecimal(0.0);
                }
                else
                {
                    price = Convert.ToDecimal(vaccDef.Price);
                }
                sum += (price * quantity);
                //}
            }
            foreach (var item in extendedFees)
            {
                Row row1 = this.VaccincationsTable.AddRow();
                int quantity = 1;

                row1.Cells[0].AddParagraph(contents.InvoiceFromDate.ToString());
                row1.Cells[1].AddParagraph(item.FeeName);
                row1.Cells[2].AddParagraph(item.NappiCode);
                row1.Cells[3].AddParagraph(item.FeeCode);
                row1.Cells[4].AddParagraph(quantity.ToString()); // Dummy value for QTY
                row1.Cells[5].AddParagraph(item.Amount.ToString());
                this.VaccincationsTable.SetEdge(0, this.VaccincationsTable.Rows.Count - 2, 6, 2, Edge.Box, BorderStyle.Single, 0.75);

                sum += (item.Amount*quantity);
            }
            //-----------------------END VACCINATIONS-------------------------------------------------------------------

            //------------------------BANKING DETAILS-------------------------------------------------------------------
            Totals.Format.Alignment = ParagraphAlignment.Right;
            Totals.AddLineBreak();
            Totals.Format.Font.Size = 13;
            Totals.AddFormattedText("Total:", TextFormat.Bold);
            Totals.AddTab();
            Totals.AddTab();
            Totals.AddText("R " + sum);
            Totals.AddTab(); Details.AddTab();
            Totals.AddLineBreak(); Totals.AddLineBreak();

            BankingDetails.Format.Alignment = ParagraphAlignment.Left;
            BankingDetails.AddFormattedText("Banking Details", TextFormat.Underline);
            BankingDetails.AddLineBreak(); Details.AddLineBreak();

            BankingDetails.AddFormattedText("Bank Name:", TextFormat.Bold);
            if (!string.IsNullOrEmpty(contents.BranchInformation.Bank_Name))
            {
                BankingDetails.AddText(contents.BranchInformation.Bank_Name);
            }
            BankingDetails.AddTab();
            BankingDetails.AddLineBreak();

            BankingDetails.AddFormattedText("Account No:", TextFormat.Bold);
            if (!string.IsNullOrEmpty(contents.BranchInformation.Account_Number))
            {
                BankingDetails.AddText(contents.BranchInformation.Account_Number);
            }
            BankingDetails.AddTab();
            BankingDetails.AddLineBreak();
            
            BankingDetails.AddFormattedText("Branch No:", TextFormat.Bold);
            if (!string.IsNullOrEmpty(contents.BranchInformation.Branch_Number))
            {
                BankingDetails.AddText(contents.BranchInformation.Branch_Number);
            }
            BankingDetails.AddTab();
            BankingDetails.AddLineBreak(); Details.AddLineBreak();

            //Details.AddTab(); Details.AddTab(); Details.AddTab(); Details.AddTab();
            //Details.AddFormattedText("Invoice Date: " + contents.InvoiceFromDate.Date.ToString(), TextFormat.Underline);
            //Details.AddLineBreak(); Details.AddLineBreak();


            //------------------------END BANKING DETAILS---------------------------------------------------------------
        }