public static void DiplomProjectToWord(string fileName, DiplomProject work, HttpResponseBase response)
{
response.Clear();
response.Charset = "ru-ru";
response.HeaderEncoding = Encoding.UTF8;
response.ContentEncoding = Encoding.UTF8;
response.ContentType = "application/vnd.ms-word";
response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".doc");
CreateDoc(work, response);
response.Flush();
response.End();
}
private static void CreateDoc(DiplomProject work, HttpResponseBase response)
{
Microsoft.Office.Interop.Word.Application app = null;
string tempfileName = null;
object falseValue = false;
var missing = Type.Missing;
object save = WdSaveOptions.wdSaveChanges;
object original = WdOriginalFormat.wdOriginalDocumentFormat;
try
{
var url = string.Format("{0}.Export.tasklist.doc", Assembly.GetExecutingAssembly().GetName().Name);
using (var templateStream = Assembly.GetExecutingAssembly().GetManifestResourceStream(url))
{
object tempdot = tempfileName = SaveToTemp(templateStream);
app = new Microsoft.Office.Interop.Word.Application();
var doc = app.Documents.Open(ref tempdot, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);
if (doc == null)
{
throw new ApplicationException("Unable to open the word template! Try to add Launch and Activation permissions for Word DCOM component for current IIS user (IIS_IUSRS for example). Or set Identity to Interactive User.");
}
FillDoc(doc, work);
doc.Save();
doc.Close(ref save, ref original, ref falseValue);
SaveToResponse(tempfileName, response);
}
}
finally
{
if (app != null)
{
object dontSave = WdSaveOptions.wdDoNotSaveChanges;
app.Quit(ref dontSave, ref original, ref falseValue);
}
if (tempfileName != null)
{
try
{
File.Delete(tempfileName);
}
catch (Exception)
{
//todo: log
}
}
}
}
private static void FillDoc(Document document, DiplomProject work)
{
var adp = work.AssignedDiplomProjects.Count == 1 ? work.AssignedDiplomProjects.First() : null;
var cinfo = CultureInfo.CreateSpecificCulture("ru-ru");
var xmlData = adp == null ? DiplomProjectToXml(work, cinfo) : DiplomProjectToXml(adp, cinfo);
var nodes = xmlData.SelectNodes("//YearlyWorks/@year");
foreach (XmlNode node in nodes)
{
const string Bookn = "year";
var value = node.InnerText;
ReplaceBookmarkText(document, Bookn, value);
break;
}
nodes = xmlData.SelectNodes("//YearlyWorks/item[@name]");
foreach (XmlNode node in nodes)
{
var name = node.Attributes["name"];
var line = node.Attributes["line"];
var bookn = line != null ? string.Format("{0}_{1}", name.Value, line.Value) : name.Value;
var value = node.InnerText;
ReplaceBookmarkText(document, bookn, value);
}
}
private static XmlDocument DiplomProjectToXml(DiplomProject work, CultureInfo cultureInfo)
{
var doc = new XmlDocument();
var root = doc.CreateElement("YearlyWorks");
root.SetAttribute("DiplomProjectId", work.DiplomProjectId.ToString());
root.SetAttribute("year", string.Empty);
var children = new List<XmlElement>();
children.AddRange(CreateStringNodes(doc, "Theme", work.Theme, 523, 638, 5));
var univer = doc.CreateElement("item");
univer.SetAttribute("name", "Univer");
univer.InnerText = work.Univer;
children.Add(univer);
var faculty = doc.CreateElement("item");
faculty.SetAttribute("name", "Faculty");
faculty.InnerText = work.Faculty;
children.Add(faculty);
var head = doc.CreateElement("item");
head.SetAttribute("name", "HeadCathedra");
head.InnerText = work.HeadCathedra;
children.Add(head);
children.AddRange(CreateStringNodes(doc, "InputData", work.InputData, 439, 638, 13));
children.AddRange(CreateStringNodes(doc, "RPZContent", work.RpzContent, 331, 638, 15));
children.AddRange(CreateStringNodes(doc, "DrawMaterials", work.DrawMaterials, 403, 638, 5));
children.AddRange(CreateStringNodes(doc, "Consultants", work.Consultants, 271, 638, 6));
var ed = doc.CreateElement("item");
ed.SetAttribute("name", "EndData");
ed.InnerText = work.DateEnd.HasValue ? work.DateEnd.Value.ToString("d' 'MMMM' 'yyyy'г.'", cultureInfo.DateTimeFormat) : string.Empty;
children.Add(ed);
var pd = doc.CreateElement("item");
pd.SetAttribute("name", "PublishData");
pd.InnerText = work.DateStart.HasValue ? work.DateStart.Value.ToString("d' 'MMMM' 'yyyy'г.'", cultureInfo.DateTimeFormat) : string.Empty;
children.Add(pd);
children.AddRange(CreateStringNodes(doc, "Workflow", string.Empty, 638, 638, 14));
foreach (var item in children)
{
root.AppendChild(item);
}
doc.AppendChild(root);
return doc;
}
public static string DiplomProjectToDocView(DiplomProject work)
{
var sb = new StringBuilder();
var cinfo = CultureInfo.CreateSpecificCulture("ru-ru");
var doc = DiplomProjectToXml(work, cinfo);
var xslt = new XslTransform();
var url = string.Format("{0}.Export.tasklist.xslt", Assembly.GetExecutingAssembly().GetName().Name);
var xsltFile = Assembly.GetExecutingAssembly().GetManifestResourceStream(url);
xsltFile.Seek(0, SeekOrigin.Begin);
using (var xmlr = XmlReader.Create(xsltFile))
{
xslt.Load(xmlr);
using (TextWriter tw = new StringWriter(sb))
{
var result = new XsltArgumentList();
xslt.Transform(doc, result, tw);
}
}
return sb.ToString();
}
public void SaveProject(DiplomProjectData projectData)
{
if (!projectData.LecturerId.HasValue)
{
throw new ApplicationException("LecturerId cant be empty!");
}
if (Context.DiplomProjects.Any(x => x.Theme == projectData.Theme))
{
throw new ApplicationException("Тема с таким названием уже есть!");
}
AuthorizationHelper.ValidateLecturerAccess(Context, projectData.LecturerId.Value);
DiplomProject project;
if (projectData.Id.HasValue)
{
project = Context.DiplomProjects
.Include(x => x.DiplomProjectGroups)
.Single(x => x.DiplomProjectId == projectData.Id);
}
else
{
project = new DiplomProject();
Context.DiplomProjects.Add(project);
}
var currentGroups = project.DiplomProjectGroups.ToList();
var newGroups = projectData.SelectedGroupsIds.Select(x => new DiplomProjectGroup { GroupId = x, DiplomProjectId = project.DiplomProjectId }).ToList();
var groupsToAdd = newGroups.Except(currentGroups, grp => grp.GroupId);
var groupsToDelete = currentGroups.Except(newGroups, grp => grp.GroupId);
foreach (var projectGroup in groupsToAdd)
{
project.DiplomProjectGroups.Add(projectGroup);
}
foreach (var projectGroup in groupsToDelete)
{
Context.DiplomProjectGroups.Remove(projectGroup);
}
project.LecturerId = projectData.LecturerId.Value;
project.Theme = projectData.Theme;
Context.SaveChanges();
}
private static XmlDocument DiplomProjectToXml(DiplomProject work, CultureInfo cultureInfo)
{
var doc = new XmlDocument();
var root = doc.CreateElement("YearlyWorks");
root.SetAttribute("DiplomProjectId", work.DiplomProjectId.ToString());
root.SetAttribute("year", string.Empty);
var children = new List<XmlElement>();
children.AddRange(CreateStringNodes(doc, "Theme", work.Theme, 523, 638, 5));
var univer = doc.CreateElement("item");
univer.SetAttribute("name", "Univer");
univer.InnerText = "Белорусский Национальный Технический университет";
children.Add(univer);
var faculty = doc.CreateElement("item");
faculty.SetAttribute("name", "Faculty");
faculty.InnerText = "Информационных технологий и робототехники";
children.Add(faculty);
children.AddRange(CreateStringNodes(doc, "InputData", work.InputData, 439, 638, 13));
children.AddRange(CreateStringNodes(doc, "RPZContent", work.RpzContent, 331, 638, 15));
children.AddRange(CreateStringNodes(doc, "DrawMaterials", work.DrawMaterials, 403, 638, 5));
children.AddRange(CreateStringNodes(doc, "Consultants", work.Consultants, 271, 638, 6));
var pd = doc.CreateElement("item");
pd.SetAttribute("name", "PublishData");
pd.InnerText = string.Empty;
children.Add(pd);
children.AddRange(CreateStringNodes(doc, "Workflow", string.Empty, 638, 638, 14));
foreach (var item in children)
{
root.AppendChild(item);
}
doc.AppendChild(root);
return doc;
}
