Example #1
0
        public override void MergeField(Novacode.DocX doc)
        {
            base.MergeField(doc);

            doc.AddCustomProperty(new Novacode.CustomProperty("CostDetail.BuyingFormat", this.BuyingFormat));
            doc.AddCustomProperty(new Novacode.CustomProperty("CostDetail.PrintingFormat", this.PrintingFormat));

        }
Example #2
0
        public override void MergeField(Novacode.DocX doc)
        {
            base.MergeField(doc);

            var description = String.Empty;
            List<ProductPartPrintRollOption> optSeris = new List<ProductPartPrintRollOption>();
            //serigraphy options where we can find the inks and types
            foreach (var item in this.TaskCost.ProductPartTask.ProductPartTaskOptions.OfType<ProductPartPrintRollOption>())
            {
                description += item.TypeOfTaskPrint + " " + item.Ink + " " + item.Overlay + "%\n";
            }

            doc.AddCustomProperty(new Novacode.CustomProperty("CostDetail.OptionTask", description));
        }
Example #3
0
        private int FillCell(Novacode.Row rr, int col, ExcelPic p)
        {
            var c = rr.Cells[col];
            var img = ImageData.Image.ImageFromId(p.ImageId);
            if (img != null)
                using (var os = img.ResizeToStream(200, 300, "crop"))
                {
                    var pic = dd.AddImage(os).CreatePicture((pa.PicWidthPixels * 1.5).ToInt(), pa.PicWidthPixels);
                    c.Paragraphs[0].InsertPicture(pic);
                }
            col++;
            c = rr.Cells[col];
            //c.RemoveParagraphAt(0);

            c.Paragraphs[0].InsertText("{0}, {1}".Fmt(p.LastName, p.FirstName), false, pa.namebold);

            c.InsertParagraph(p.Email, false, pa.emailsmall);

            if (p.BirthDate.HasValue())
                c.InsertParagraph("BD {0}".Fmt(p.BirthDay), false, pa.font);
            if (p.Spouse.HasValue())
                c.InsertParagraph("Spouse: {0}".Fmt(p.Spouse), false, pa.font);
            if (p.Children.HasValue())
                c.InsertParagraph("Kids: {0}".Fmt(p.Children), false, pa.font);
            col++;
            return col;
        }
Example #4
0
        public bool ProcessMap(decimal[] bulding_ids, Stream childFS, ref Novacode.DocX docx)
        {
            using (var childDocx = Novacode.DocX.Load(childFS))
            {
                using (MemoryStream memStream = new MemoryStream())
                {
                    WebRequest request = WebRequest.Create(
                           "https://maps.googleapis.com/maps/api/staticmap?format=jpg&center=Calgary&zoom=14&size=400x400&key=AIzaSyB64gJHrp5QzW2fNMVRvRygTm8wCuBIrnc");

                    // Get the response.
                    WebResponse response = request.GetResponse();
                    // Get the stream containing content returned by the server.
                    Stream dataStream = response.GetResponseStream();
                    using (Stream rStream = response.GetResponseStream())
                    {

                        byte[] buffer = new byte[1024];
                        int byteCount;
                        do
                        {
                            byteCount = rStream.Read(buffer, 0, buffer.Length);
                            memStream.Write(buffer, 0, byteCount);
                        } while (byteCount > 0);
                    }
                    memStream.Seek(0, SeekOrigin.Begin);
                    try
                    {
                        Novacode.Image img = childDocx.AddImage(memStream); // Create image.
                        Novacode.Picture pic1 = img.CreatePicture();     // Create picture.
                        Novacode.Paragraph p = childDocx.InsertParagraph();
                        p.InsertPicture(pic1); // Insert picture into paragraph.
                    }
                    catch (Exception ex)
                    {
                        Novacode.Paragraph p = childDocx.InsertParagraph(ex.Message + " " + ex.StackTrace);
                    }
                    docx.InsertSectionPageBreak();
                    docx.InsertDocument(childDocx);

                }

            }

            return true;
        }
Example #5
0
        private static Novacode.Table CreateAndInsertInvoiceTableAfter(Novacode.Table t, ref DocX document, PapiroMVC.Models.Document d)
        {

            var docProd = d.DocumentProducts.Select(x => x.CodProduct).Distinct();

            /* 
             * The trick to replacing one Table with another,
             * is to insert the new Table after the old one, 
             * and then remove the old one.
             */
            Novacode.Table invoice_table = t.InsertTableAfterSelf(d.DocumentProducts.Count + 1, 4);
            invoice_table.Design = TableDesign.LightShadingAccent1;

            #region Table title
            Formatting table_title = new Formatting();
            table_title.Bold = true;


            Type res = typeof(PapiroMVC.Models.Resources.Document.ResDocumentProduct);


            invoice_table.Rows[0].Cells[0].Paragraphs[0].InsertText(
                (string)res.GetProperty("Product").GetValue(null, null), false, table_title);
            invoice_table.Rows[0].Cells[0].Paragraphs[0].Alignment = Alignment.left;

            invoice_table.Rows[0].Cells[1].Paragraphs[0].InsertText(
                (string)res.GetProperty("Quantity").GetValue(null, null), false, table_title);
            invoice_table.Rows[0].Cells[1].Paragraphs[0].Alignment = Alignment.right;

            invoice_table.Rows[0].Cells[2].Paragraphs[0].InsertText(
                (string)res.GetProperty("UnitPrice").GetValue(null, null), false, table_title);
            invoice_table.Rows[0].Cells[2].Paragraphs[0].Alignment = Alignment.right;

            invoice_table.Rows[0].Cells[3].Paragraphs[0].InsertText(
                (string)res.GetProperty("TotalAmount").GetValue(null, null), false, table_title);
            invoice_table.Rows[0].Cells[3].Paragraphs[0].Alignment = Alignment.right;

            #endregion

            // Loop through the rows in the Table and insert data from the data source.
            for (int row = 1; row < invoice_table.RowCount; )
            {
                Novacode.Paragraph cell_paragraph;

                foreach (var dp in docProd)
                {
                    var sel = d.DocumentProducts.Where(y => y.CodProduct == dp).OrderBy(z => z.Quantity);
                    var k = 0;
                    foreach (var item in sel)
                    {
                        cell_paragraph = invoice_table.Rows[row].Cells[0].Paragraphs[0];
                        cell_paragraph.InsertText(k++ == 0 ? item.ProductName : "", false);
                        invoice_table.Rows[row].Cells[0].Paragraphs[0].Alignment = Alignment.left;

                        cell_paragraph = invoice_table.Rows[row].Cells[1].Paragraphs[0];
                        cell_paragraph.InsertText(item.Quantity.ToString(), false);
                        invoice_table.Rows[row].Cells[1].Paragraphs[0].Alignment = Alignment.right;

                        cell_paragraph = invoice_table.Rows[row].Cells[2].Paragraphs[0];
                        cell_paragraph.InsertText(item.UnitPrice, false);
                        invoice_table.Rows[row].Cells[2].Paragraphs[0].Alignment = Alignment.right;

                        cell_paragraph = invoice_table.Rows[row].Cells[3].Paragraphs[0];
                        cell_paragraph.InsertText(item.TotalAmount, false);
                        invoice_table.Rows[row].Cells[3].Paragraphs[0].Alignment = Alignment.right;

                        row++;
                    }
                }

            }


            invoice_table.InsertRow();

            // Let the tables coloumns expand to fit its contents.
            invoice_table.AutoFit = AutoFit.Contents;

            // Center the Table
            invoice_table.Alignment = Alignment.center;

            //Return the invloce table now that it has been created.
            return invoice_table;
        }
Example #6
0
        public bool ProcessChildPage(string parent_id,
            IEnumerable<Dictionary<string, object>> buildings,
            string[] zoom, string[] lat, string[] lng,
            ref Novacode.DocX docx, Dictionary<string, object> currentBuilding = null
            )
        {
            OracleRepository repo = new OracleRepository();
            var childIds = repo.LoadChildDocumentIDs(parent_id);

            foreach (var childId in childIds)
            {
                if (currentBuilding != null)
                {
                    ProcessDocument(childId, currentBuilding, buildings, 0, ref docx, zoom, lat, lng);
                    ProcessChildPage(childId.ToString(), buildings, zoom, lat, lng, ref docx, currentBuilding);
                    return true;
                }

                int index = 0;
                foreach (Dictionary<string, object> b in buildings)
                {
                    index++;
                    if (!b.ContainsKey("INDEX"))
                    {
                        b.Add("INDEX", index);
                        b.Add("SIZE_SQ_FORMATTED", "");
                        b.Add("BASE_RENT_FORMATTED", "");
                        b.Add("OP_COST_FORMATTED", "");
                        b.Add("TERM_FORMATTED", "");
                        b.Add("NET_RENTABLE_FORMATTED", "");
                        b.Add("FLOOR_PLATE_FORMATTED", "");

                        if (b["SIZE_SQ"] != null && b["SIZE_SQ"] != DBNull.Value)
                        {
                            b["SIZE_SQ_FORMATTED"] = String.Format("{0} sf", b["SIZE_SQ"]);
                        }
                        if (b["BASE_RENT"] != null && b["BASE_RENT"] != DBNull.Value)
                        {
                            b["BASE_RENT_FORMATTED"] = String.Format("$ {0} per sf", b["BASE_RENT"]);
                        }
                        if (b["LATEST_OP_COST_AMT"] != null && b["LATEST_OP_COST_AMT"] != DBNull.Value)
                        {
                            b["OP_COST_FORMATTED"] = String.Format("$ {0} (est {1})", b["LATEST_OP_COST_AMT"], b["OP_COST_YEAR"]);
                        }
                        if (b["TERM"] != null && b["TERM"] != DBNull.Value)
                        {
                            b["TERM_FORMATTED"] = String.Format("{0} years", b["TERM"]);
                        }
                        if (b["PARKING_RATIO"] != null && b["PARKING_RATIO"] != DBNull.Value)
                        {
                            b["PARKING_RATIO_FORMATTED"] = String.Format("1 stall per {0} sf", b["PARKING_RATIO"]);
                        }
                        if (b["NET_RENTABLE"] != null && b["NET_RENTABLE"] != DBNull.Value)
                        {
                            b["NET_RENTABLE_FORMATTED"] = String.Format("{0:N0} sf", b["NET_RENTABLE"]);
                        }
                        if (b["FLOOR_PLATE"] != null && b["FLOOR_PLATE"] != DBNull.Value)
                        {
                            b["FLOOR_PLATE_FORMATTED"] = String.Format("{0:N0} sf", b["FLOOR_PLATE"]);
                        }
                    }

                    ProcessDocument(childId, b, buildings, index, ref docx, zoom, lat, lng);
                    ProcessChildPage(childId.ToString(), buildings, zoom, lat, lng,ref docx, b);
                }
            }
            return true;
        }
Example #7
0
        public bool ProcessFloorplan(decimal building_id, decimal building_vacancy_id, string building_vacancy_floor, Stream childFS, ref Novacode.DocX docx)
        {
            try
            {
                OracleRepository repo = new OracleRepository();

                string qry = String.Format(@" SELECT ID,FLOOR_NO  FROM TBUILDING_PICTURES WHERE BUILDING_ID ={0} AND BUILDING_VACANCY_ID = {1}", building_id, building_vacancy_id);

                var floors = repo.QueryAll(qry);
                string filename = "";
                string floor_no = "";
                foreach (var floor in floors)
                {
                    using (var childDocx = Novacode.DocX.Load(childFS))
                    {
                        using (var picStream = repo.GetPicture((decimal)floor["ID"], out filename, out floor_no))
                        {
                            int newHeight = 300;
                            using (var tempImg = System.Drawing.Bitmap.FromStream(picStream))
                            {
                                newHeight = (int)Math.Round(((double)tempImg.Height / (double)tempImg.Width) * 300);
                                using (System.Drawing.Bitmap bt = new System.Drawing.Bitmap(tempImg, 300, newHeight))
                                {
                                    using (MemoryStream ms = new MemoryStream())
                                    {
                                        bt.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
                                        ms.Seek(0, SeekOrigin.Begin);
                                        Novacode.Image img = childDocx.AddImage(ms); // Create image.
                                        Novacode.Picture pic1 = img.CreatePicture();     // Create picture.
                                        Novacode.Paragraph p = childDocx.InsertParagraph();
                                        p.InsertPicture(pic1); // Insert picture into paragraph.
                                    }
                                }
                            }
                        }
                        string picDesc = "";
                        if (floor["FLOOR_NO"]!=null && floor["FLOOR_NO"] != System.DBNull.Value)
                        {
                            picDesc = String.Format("({0})", floor["FLOOR_NO"]);
                        }
                        childDocx.ReplaceText(String.Format("<{0}>", "FLOOR_NO"), String.Format("{0}{1}", building_vacancy_floor, picDesc));
                        docx.InsertSectionPageBreak();
                        docx.InsertDocument(childDocx);

                    }
                }

            }
            catch { }
            return true;
        }
Example #8
0
        private bool ProcessDocument(decimal childId, Dictionary<string, object> b, IEnumerable<Dictionary<string, object>> buildings, int index, ref Novacode.DocX docx, string [] zoom, string [] lat, string [] lng)
        {
            OracleRepository repo = new OracleRepository();
            string docType;
            using (Stream childFS = repo.LoadDocument(childId.ToString(), out docType))
            {
                //process floorplan and maps here
                if (docType == "FLOORPLAN")
                {
                    List<string> floorList = new List<string>();
                    floorList.Add(String.Format("{0}", b["FLOOR"]));
                    ProcessFloorplan((decimal)b["BUILDING_ID"], (decimal)b["BUILDING_VACANCY_ID"], (string)b["FLOOR"], childFS, ref docx);
                }
                else if (docType == "MAP")
                {
                    if (index == 1)
                    {

                        List<decimal> ids = new List<decimal>();
                        foreach (var b1 in buildings)
                        {
                            ids.Add((decimal)b1["BUILDING_ID"]);
                        }
                        ProcessPicture(ids, childFS, ref docx, zoom, lat, lng);
                        // ProcessMap(ids.ToArray(), childFS, ref docx);
                    }
                }
                else
                {
                    var docxChild = Novacode.DocX.Load(childFS);
                    foreach (var bm in docxChild.Bookmarks.Where(x => x.Name == "IMAGE"))
                    {
                        string filename;

                        using (var picStream = repo.GetBuildingPicture((decimal)b["BUILDING_ID"], out filename))
                        {
                            if (!String.IsNullOrEmpty(filename))
                            {
                                double newHeight = 1;
                                using (var tempImg = System.Drawing.Image.FromStream(picStream))
                                {
                                    newHeight = (tempImg.Height / tempImg.Width) * 300;
                                }

                                picStream.Seek(0, SeekOrigin.Begin);
                                Novacode.Image img = docxChild.AddImage(picStream); // Create image.

                                Novacode.Picture pic1 = img.CreatePicture((int)newHeight,300);     // Create picture.
                                bm.Paragraph.AppendPicture(pic1);
                            }

                        }
                    }
                    foreach (var k in b.Keys)
                    {
                        docxChild.ReplaceText(String.Format("<{0}>", k), String.Format("{0}", b[k]));
                    }
                    if (docxChild.FindAll("<PARKING_LIST>").Count() > 0)
                    {
                        ProcessParkingList((decimal)b["BUILDING_ID"], ref docxChild);
                    }
                    else
                    {
                        docxChild.ReplaceText("<PARKING_LIST>", "");
                    }

                    docx.InsertSectionPageBreak();
                    docx.InsertDocument(docxChild);

                }
            }
            return true;
        }
Example #9
0
        public bool ProcessUserTemplate(IEnumerable<Dictionary<string, object>> buildings,
            string[] zoom, string[] lat, string[] lng,
            ref Novacode.DocX docx, Dictionary<string, object> currentBuilding = null)
        {
            // docx.

            return true;
        }
Example #10
0
        public bool ProcessPicture(List<decimal> building_ids, Stream childFS, ref Novacode.DocX docx, string [] zoom, string []lat, string []lng)
        {
            try
            {
                OracleRepository repo = new OracleRepository();

                var floors = repo.QueryAll(
                    String.Format(@" SELECT ID FROM TBUILDING_PICTURES WHERE BUILDING_ID ={0} ", 0));
                string filename = "";
                string floor_no = "";
                foreach (var floor in floors)
                {
                    using (var childDocx = Novacode.DocX.Load(childFS))
                    {
                        using (var picStream = repo.GetPicture((decimal)floor["ID"], out filename, out floor_no))
                        {
                            picStream.Seek(0, SeekOrigin.Begin);
                            Novacode.Image img = childDocx.AddImage(picStream); // Create image.
                            Novacode.Picture pic1 = img.CreatePicture(1, 1);     // Create picture.
                            Novacode.Paragraph p = childDocx.InsertParagraph();
                            p.InsertPicture(pic1); // Insert picture into paragraph.
                        }

                        string markers = "";
                        string building_id_csv = "";
                        List<string> buildingList = new List<string>();
                        foreach (var bid in building_ids)
                        {
                            if (String.IsNullOrEmpty(building_id_csv))
                            {
                                building_id_csv = bid.ToString();
                            }
                            else
                            {
                                building_id_csv += "," + bid;
                            }
                        }
                        var latLongs = repo.QueryAll(
                          String.Format(@" SELECT TBUILDING.BUILDING_NAME, LATITUDE, LONGITUDE FROM TBUILDING_LAT_LONG
                                                INNER JOIN TBUILDING ON TBUILDING_LAT_LONG.BUILDING_ID= TBUILDING.BUILDING_ID
                                                WHERE TBUILDING_LAT_LONG.BUILDING_ID  IN ({0}) ", building_id_csv));

                        int index = 0;
                        foreach (var latLong in latLongs)
                        {
                            index++;
                            markers += String.Format("&markers=label:{0}%7C{1},{2}", index, latLong["LATITUDE"], latLong["LONGITUDE"]);
                            buildingList.Add(index  + "." + latLong["BUILDING_NAME"]);
                        }

                        string zoomAmt = "";
                        string center = "";
                        if (zoom.Count()>0)
                        {
                            int z = 14;
                            if (int.TryParse(zoom[0], out z))
                            {
                                zoomAmt = "&zoom=" + z;
                            }
                        }
                        if (lat.Count()>0 && lng.Count()>0)
                        {
                            double latAmt = 0;
                            double lngAmt = 0;
                            if (double.TryParse(lat[0], out latAmt) && double.TryParse(lng[0], out lngAmt))
                            {
                                center = String.Format("&center={0},{1}", latAmt, lngAmt);
                            }
                        }
                        using (MemoryStream memStream = new MemoryStream())
                        {

                            WebRequest request = WebRequest.Create(
                                   String.Format("https://maps.googleapis.com/maps/api/staticmap?format=jpg{0}{1}{2}&size=400x400&key=AIzaSyB64gJHrp5QzW2fNMVRvRygTm8wCuBIrnc", markers, zoomAmt, center));

                            // Get the response.
                            WebResponse response = request.GetResponse();
                            // Get the stream containing content returned by the server.
                            Stream dataStream = response.GetResponseStream();
                            using (Stream rStream = response.GetResponseStream())
                            {

                                byte[] buffer = new byte[1024];
                                int byteCount;
                                do
                                {
                                    byteCount = rStream.Read(buffer, 0, buffer.Length);
                                    memStream.Write(buffer, 0, byteCount);
                                } while (byteCount > 0);
                            }
                            double newHeight = 1;
                            using (var tempImg = System.Drawing.Image.FromStream(memStream))
                            {
                                newHeight = (tempImg.Height / tempImg.Width) * 400;
                            }
                            memStream.Seek(0, SeekOrigin.Begin);
                            try
                            {

                                Novacode.Image img = childDocx.AddImage(memStream); // Create image.
                                Novacode.Picture pic1 = img.CreatePicture((int)newHeight,400);     // Create picture.
                                Novacode.Paragraph p = childDocx.InsertParagraph();
                                p.InsertPicture(pic1); // Insert picture into paragraph.
                                foreach (var s in buildingList)
                                {
                                    childDocx.InsertParagraph(s);
                                }
                            }
                            catch (Exception ex)
                            {
                                Novacode.Paragraph p = childDocx.InsertParagraph(ex.Message + " " + ex.StackTrace);
                            }
                            docx.InsertSectionPageBreak();
                            docx.InsertDocument(childDocx);

                        }
                    }
                }
            }
            catch { }
            return true;
        }
Example #11
0
        public bool ProcessParkingList(decimal building_id, ref Novacode.DocX docx)
        {
            try
            {
                OracleRepository repo = new OracleRepository();

                var parkingList = repo.QueryAll(
                    String.Format(@"
                    SELECT
                        PARKING_ID,
                        BUILDING_ID,
                        PARKING_TYP,
                        NUM_STALLS,
                        COST_AMT,
                        NOTE,
                        INFO_AS_OF_DATE,
                        CREATE_DATE,
                        CREATE_USER,
                        UPDATE_DATE,
                        UPDATE_USER
                        FROM VPARKING WHERE BUILDING_ID={0} ", building_id));
                string strParkingList = "";
                foreach (Dictionary<string, object> p in parkingList)
                {
                    if (String.IsNullOrEmpty(String.Format("{0}", p["COST_AMT"])))
                    {
                        strParkingList = String.Format("{0}", p["PARKING_TYP"]);
                    }
                    else
                    {
                        strParkingList += String.Format("$ {0} per stall,  \n {1} ", p["COST_AMT"], p["PARKING_TYP"]);
                    }

                }
                docx.ReplaceText("<PARKING_LIST>", strParkingList);

            }
            catch { }
            return true;
        }
 public override void MergeField(Novacode.DocX doc)
 {
     base.MergeField(doc);
     if (ProductPartPrinting != null)
     {
         TaskexEcutorSelected = TaskExecutors.FirstOrDefault(x => x.CodTaskExecutor == CodTaskExecutorSelected);
         ProductPartPrinting.MergeField(doc);
     }
 }