예제 #1
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;
        }
예제 #2
0
 public ActionResult GetListingPicture(decimal id)
 {
     OracleRepository repo = new OracleRepository();
     string filename;
     Stream st = repo.GetBuildingPicture(id, out filename);
     if (String.IsNullOrEmpty(filename))
     {
         filename = "unknown";
     }
     var cd = new System.Net.Mime.ContentDisposition
     {
         FileName = filename
     };
     Response.AppendHeader("Content-Disposition", cd.ToString());
     st.Position = 0;
     string mime = System.Web.MimeMapping.GetMimeMapping(filename);
     return new FileStreamResult(st, mime);
 }
예제 #3
0
        public ActionResult ApplyDocumentOpenXml(string id, string building_vacancy_ids, string[] zoom, string[] lat, string[] lng)
        {
            OracleRepository repo = new OracleRepository();
            var buildings = repo.QueryAll(String.Format(@"
                    Select  VBUILDING.BUILDING_ID, VBUILDING.EXT_REF_ID, VBUILDING.BUILDING_NAME, VBUILDING.CLASS_TYP_ID, VBUILDING.CLASS_TYP,
                         VBUILDING.LOCATION_TYP_ID, VBUILDING.LOCATION_TYP, VBUILDING.QRTRLY_RPT_FLAG, VBUILDING.CONTACT_MECH_ID,
                         VBUILDING.ADDRESS1, VBUILDING.POSTAL_CODE, VBUILDING.YEAR_BUILT, VBUILDING.STOREYS, VBUILDING.NET_RENTABLE,
                         VBUILDING.FLOOR_PLATE, VBUILDING.PARKING_RATIO, VBUILDING.PARKING_RATIO_FORMATTED, VBUILDING.LATEST_OP_COST_AMT,
                         VBUILDING.OP_COST_YEAR, VBUILDING.LANDLORD_CONTACT_ID, VBUILDING.LANDLORD_NAME, VBUILDING.OWNER_CONTACT_ID,
                         VBUILDING.OWNER_NAME, VBUILDING.CREATE_DATE, VBUILDING.CREATE_USER, VBUILDING.UPDATE_DATE,
                         VBUILDING.UPDATE_USER, VBUILDING_VACANCY.BUILDING_VACANCY_ID, VBUILDING_VACANCY.LEASE_TYP_ID,
                         VBUILDING_VACANCY.LEASE_TYP_CODE, VBUILDING_VACANCY.LEASE_TYP, VBUILDING_VACANCY.SUITE_NO, VBUILDING_VACANCY.FLOOR,
                         VBUILDING_VACANCY.FLOOR_NUMERIC, VBUILDING_VACANCY.SIZE_SQ, VBUILDING_VACANCY.SMALLEST_DIV,
                         VBUILDING_VACANCY.INDUCEMENTS, VBUILDING_VACANCY.BASE_RENT, VBUILDING_VACANCY.TERM, VBUILDING_VACANCY.ARCHIVED_YN,
                         VBUILDING_VACANCY.LAST_ARCHIVED_DATE, VBUILDING_VACANCY.RETAIL_YN, VBUILDING_VACANCY.EXCLUSIVE_YN,
                         VBUILDING_VACANCY.VACANCY_DESC, VBUILDING_VACANCY.BROKER_NOTES, TBUILDING_LAT_LONG.LATITUDE, TBUILDING_LAT_LONG.LONGITUDE
             					from VBUILDING
                        inner join VBUILDING_VACANCY on VBUILDING.BUILDING_ID= VBUILDING_VACANCY.BUILDING_ID
                        left join TBUILDING_LAT_LONG on VBUILDING.BUILDING_ID = TBUILDING_LAT_LONG.BUILDING_ID
                    where BUILDING_VACANCY_ID In ({0})
                    ORDER BY VBUILDING.BUILDING_NAME
                    ", building_vacancy_ids));

            Dictionary<string, Tuple<int, string,decimal>> buildingIndices = new Dictionary<string, Tuple<int, string, decimal>>();
            Dictionary<string, Tuple<string, decimal>> floorplanIndices = new Dictionary<string, Tuple<string, decimal>>();
            Dictionary<int, XElement> buildingXML = new Dictionary<int, XElement>();

            Stream st = new MemoryStream();
            string docType = "PARENT TEMPLATE";
            List<SizeAttribute> sa = new List<SizeAttribute>();
            string imageid = "";
            using (Stream fs = repo.LoadDocument(id, out docType))//new MemoryStream())//
            {
              /*  using (FileStream fs1 = System.IO.File.OpenRead(@"d:\CurrentDevelopment\Cresa\Cresa\templates\TOC.dotx"))
                {
                    fs1.CopyTo(fs);
                }*/
                WmlDocument wmlDoc = new WmlDocument("template1.docx", fs as MemoryStream, true);
                WmlDocument wmlAssembledDoc;
                var xml = GenerateDataFromDataSource(buildings.ToList(),
                    ref buildingIndices, ref floorplanIndices,
                    ref buildingXML);

                if (docType=="PARENT TEMPLATE")
                {
                    List<Source> sources = new List<Source>();
                    sources.Add(new Source (wmlDoc,true));

                    List<Tuple<WmlDocument, string>> docs = new List<Tuple<WmlDocument,string>>();
                    docs = LoadDocuments(int.Parse(id));
                    int index = 0;
                    foreach (var b in buildings.ToList())
                    {

                        foreach (var d in docs)
                        {
                            if (index==0 || d.Item2=="DETAIL")
                            {
                                if (d.Item2 == "SUMMARY")
                                {
                                    sources.Add(LoadDocumentToSource(d.Item1, xml,buildingIndices,zoom,lat,lng,  sa));
                                }
                                else
                                {
                                    sources.Add(LoadDocumentToSource(d.Item1, buildingXML[index],null, null,null,null, sa));
                                }
                            }
                        }
                        index++;
                    }

                    wmlAssembledDoc =  DocumentBuilder.BuildDocument(sources);
                }
                else
                {
                    bool templateError;
                     wmlAssembledDoc = DocumentAssembler.AssembleDocument(wmlDoc, xml, out templateError, sa);

                }
                OpenXmlMemoryStreamDocument streamDoc = new OpenXmlMemoryStreamDocument(wmlAssembledDoc);
                streamDoc.GetModifiedDocument().WriteByteArray(st);

                string filename = "";
                using (WordprocessingDocument wordDoc = WordprocessingDocument.Open(st, true))
                {
                    int index = 0;
                    List<decimal> building_ids = new List<decimal>();
                    foreach (var building in buildings)
                    {
                        building_ids.Add((decimal)building["BUILDING_ID"]);
                    }
                    ProcessMap(buildingIndices, wordDoc, zoom, lat, lng, sa);
                    ProcessFloorplan(floorplanIndices, wordDoc, sa);
                    foreach (var b in buildingIndices.Keys)
                    {

                        using (var picStream = repo.GetBuildingPicture(buildingIndices[b].Item3, out filename))
                        {
                            picStream.Position = 0;
                            MainDocumentPart mainPart = wordDoc.MainDocumentPart;
                            ImagePart imagePart = mainPart.AddImagePart(ImagePartType.Jpeg);
                            imagePart.FeedData(picStream);

                            imageid = mainPart.GetIdOfPart(imagePart);
                        }

                        foreach (var txt in wordDoc.MainDocumentPart.Document.Body.Descendants<Text>().Where(x => x.Text == b))
                        {
                            try
                            {
                                long width = 1906524;
                                long height = 1906524;
                                foreach (var s in sa)
                                {
                                    if (s.TransformedValue == txt.Text)
                                    {
                                        width = s.Width;
                                        height = s.Height;
                                    }
                                }
                                var el = AddImageToBody(imageid, width, height);
                                txt.Parent.AppendChild(el);
                                txt.Text = "";
                            }
                            catch { }
                        }
                        index++;
                    }
                }

            }
            string ext = "doc";

            var cd = new System.Net.Mime.ContentDisposition
            {
                FileName = "template." + ext,
                // always prompt the user for downloading, set to true if you want
                // the browser to try to show the file inline
                Inline = false,
            };
            Response.AppendHeader("Content-Disposition", cd.ToString());
            st.Position = 0;
            return new FileStreamResult(st, "application/msword");
        }