public ActionResult LoadDocument(string id)
{
OracleRepository repo = new OracleRepository();
string docType = "";
var cd = new System.Net.Mime.ContentDisposition
{
FileName = "template.doc",
// 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());
Stream st = repo.LoadDocument(id, out docType);
st.Position = 0;
return new FileStreamResult(st, "application/vnd.openxmlformats-officedocument.wordprocessingml.document");
}
public ActionResult ApplyDocument(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})
", building_vacancy_ids));
Stream st = new MemoryStream();
string docType = ""; ;
using (Stream fs = repo.LoadDocument(id, out docType))
{
var docx = Novacode.DocX.Load(fs);
if (docType== "USER TEMPLATE")
{
//TODO
}
else
{
Dictionary<string, int> tokenIndexes = new Dictionary<string, int>();
foreach (var k in buildings.First().Keys)
{
foreach (var p in docx.Paragraphs)
{
var paraIndex = p.FindAll(String.Format("<{0}>", k));
if (paraIndex.Count > 0)
{
tokenIndexes.Add(k, paraIndex.First());
}
}
}
foreach (Dictionary<string, object> b in buildings)
{
foreach (var token in tokenIndexes.Keys)
{
int paraIndex = tokenIndexes[token];
var para = docx.Paragraphs[paraIndex];
docx.ReplaceText(String.Format("<{0}>", token), "");
docx.InsertParagraph(String.Format("{0}", b[token]), false);
}
}
ProcessChildPage(id, buildings, zoom, lat, lng, ref docx);
}
docx.SaveAs(st);
}
var cd = new System.Net.Mime.ContentDisposition
{
FileName = "template.doc",
// 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/vnd.openxmlformats-officedocument.wordprocessingml.document");
}
protected List<Tuple<WmlDocument, string>> LoadDocuments(int id)
{
OracleRepository repo = new OracleRepository();
var childDocs = repo.QueryAll(String.Format(@"
Select ID, PARENT_DOCUMENT_ID, TYPE
from TDOCUMENT
where PARENT_DOCUMENT_ID = {0} AND STATUS <>'D'
ORDER BY SEQUENCE_NO
", id));
List<Tuple<WmlDocument,string>> wmldocs = new List<Tuple<WmlDocument, string>>();
/* Tuple<string, string>[] docs = new Tuple<string, string>[]
{
new Tuple<string, string>(@"d:\CurrentDevelopment\Cresa\Cresa\templates\map.dotx","SUMMARY"),
new Tuple<string,string> (@"d:\CurrentDevelopment\Cresa\Cresa\templates\section2.dotx","DETAIL"),
new Tuple<string,string> (@"d:\CurrentDevelopment\Cresa\Cresa\templates\section2a.dotx","DETAIL")
};*/
string docType = "";
foreach (var d in childDocs)//docs /*
{
using (Stream fs = repo.LoadDocument(String.Format("{0}",d["ID"]), out docType))//new MemoryStream())//
{
/* using (FileStream fs1 = System.IO.File.OpenRead(d.Item1))
{
fs1.CopyTo(fs);
}*/
wmldocs.Add(new Tuple<WmlDocument, string>(new WmlDocument("template1.docx", fs as MemoryStream), String.Format("{0}", d["TYPE"])));//d.Item2/*
}
}
return wmldocs;
}
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;
}
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");
}
