public void Generate(IPriceList priceList, FileInfo template, string outputFileName) { lock (WordApplication.SyncRoot) { WordApplication application = WordApplication.Instance; try { WordDocument document = application.OpenDocument(template.FullName); _replacements.Apply(document.Content, priceList); foreach (WordSection section in document.Sections) { foreach (var header in section.Headers) { _replacements.Apply(header.Range, priceList); } foreach (var footer in section.Footers) { _replacements.Apply(footer.Range, priceList); } } document.Content.UpdateFields(); document.SaveAs(outputFileName, WdSaveFormat.wdFormatPDF); document.Close(false); } finally { application.Quit(false); } } }
private void InitStatus() { UpdateController controller = new UpdateController(this); controller.CheckUpdate(); //UpgradeService us = new UpgradeService(true); //us.SynCheckUpdate(); MagazineStyle se = MagazineStyle.GetInstance(); if (se.Exist()) { cb_style.Text = se.Name; } //2016-06-13 测试 吴海龙 WordApplication.GetInstance().WordApp = Globals.ThisAddIn.Application; //WordApplication.GetInstance().WordApp = Globals.ThisAddIn.Application; //日志目录 if (!Directory.Exists("C:\\log\\")) { Directory.CreateDirectory("C:\\log\\"); } //多线程下载样式避免,网络卡顿造成word 卡死。 Thread t = new Thread(DownloadStyles); t.Start(); RefreshStyleList(); }
void Application_WindowBeforeRightClick(Word.Selection Sel, ref bool Cancel) { Word.Field _field = CommonFunction.GetFieldBySection(WordApplication.GetInstance().WordApp); if (_field == null) { return; } if (_field.Code.Text.Contains(QuotationItem.FLAG) || _field.Code.Text.Contains(QuotationItem.FLAG)) { addBtn.Enabled = true; WordApplication.GetInstance().WordApp.ActiveDocument.Range(_field.Result.End + 1, _field.Result.End + 1).Select(); } }
public string SnapshotWordDocument(HttpFile httpFile) { string documentFileName = TempUpload(httpFile); string dirName = CreateGuidDirectory(); var wordApplication = new WordApplication(); var wordDocument = wordApplication.OpenDocument(documentFileName); wordDocument.SnapshotPages(dirName); wordDocument.Close(); wordApplication.Quit(); return(dirName); }
public void Snapshot(Uri uri, string fileName) { var wordApplication = new WordApplication(); var wordDocument = wordApplication.OpenDocument(fileName); var buildPath = this.CreateTempDirectory(); wordDocument.SnapshotPages(buildPath); wordDocument.Close(); wordApplication.Quit(); if (this.SendResponse(uri, buildPath)) { Directory.Delete(buildPath, true); File.Delete(fileName); } }
public string ConvertWordToHtml(HttpFile httpFile) { string pageBaseName = ConfigurationManager.AppSettings.Get("page"); string documentFileName = TempUpload(httpFile); string dirName = CreateGuidDirectory(); string pageFileName = Path.Combine(dirName, pageBaseName); var wordApplication = new WordApplication(); var wordDocument = wordApplication.OpenDocument(documentFileName); wordDocument.FixPageBreaks(); wordDocument.SaveAsHtml(pageFileName); wordDocument.Close(); wordApplication.Quit(); return(dirName); }
private void button18_Click(object sender, RibbonControlEventArgs e) { Word.Paragraph p = CommonFunction.AddParagraphAtSelection(WordApplication.GetInstance().WordApp); }
public static void GenerateContemporaryDocument2(string strPortfolioID, bool blProfileTable, string strUserLanguage, string strPortTypeID, string strPortSettingTable) { DataTable dtPortfolio, dtEdu, dtWork, dtComm, dtAward, dtHobby, dtSkill, dtRef, dtOrg; string strPersonalInfo, strWorkExp, strCommunityHrs, strExtraOrg, strInterHobbies, strAdditionalInfo;//user info settings string[] arrResumeSections; int intMenuGrade; if (blProfileTable) { dtPortfolio = CCLib.Common.DataAccess.GetDataTable("select * from Port_ResumeBuilder_View where PortfolioID=" + strPortfolioID); } else { dtPortfolio = CCLib.Common.DataAccess.GetDataTable("select * from Portfolio where PortfolioID=" + strPortfolioID); } DataRow drPortSettings = CCLib.Login.GetPortSettings(strPortfolioID); arrResumeSections = CCLib.Common.Resume.GetSections(dtPortfolio, drPortSettings, blProfileTable); if (dtPortfolio.Rows.Count > 0) { switch (dtPortfolio.Rows[0]["GradeNumber"].ToString()) { case "1": intMenuGrade = 5; break; case "2": intMenuGrade = 5; break; case "3": intMenuGrade = 5; break; case "4": intMenuGrade = 5; break; case "5": intMenuGrade = 5; break; case "6": intMenuGrade = 6; break; case "7": intMenuGrade = 7; break; case "8": intMenuGrade = 8; break; case "9": intMenuGrade = 9; break; case "10": intMenuGrade = 10; break; case "11": intMenuGrade = 11; break; case "12": intMenuGrade = 12; break; case "13": intMenuGrade = 13; break; case "30": intMenuGrade = 13; break; case "40": intMenuGrade = 13; break; case "50": intMenuGrade = 13; break; case "60": intMenuGrade = 13; break; case "70": intMenuGrade = 13; break; default: intMenuGrade = 6; break; } if (blProfileTable) { strPersonalInfo = drPortSettings["RBPersonalProfile" + intMenuGrade].ToString(); strWorkExp = drPortSettings["RBWorkExp" + intMenuGrade].ToString(); strCommunityHrs = drPortSettings["RBCommunity" + intMenuGrade].ToString(); strExtraOrg = drPortSettings["RBOrganizations" + intMenuGrade].ToString(); strInterHobbies = drPortSettings["RBHobbies" + intMenuGrade].ToString(); strAdditionalInfo = drPortSettings["RBAdditionalInfo" + intMenuGrade].ToString(); } else { strPersonalInfo = drPortSettings["PersonalProfile" + intMenuGrade].ToString(); strWorkExp = drPortSettings["RBWorkExp" + intMenuGrade].ToString(); strCommunityHrs = drPortSettings["RBCommunity" + intMenuGrade].ToString(); strExtraOrg = drPortSettings["RBOrganizations" + intMenuGrade].ToString(); strInterHobbies = drPortSettings["RBHobbies" + intMenuGrade].ToString(); strAdditionalInfo = drPortSettings["RBAdditionalInfo" + intMenuGrade].ToString(); } #region Build Resume byte c = 187; // for extended ASCII ">>" char ch = (char)c; /* Initialize the WordApplication and create our document. */ WordApplication wordApp = new WordApplication(); Document doc = wordApp.Create(); //Create tblMain and tblContactInfo tables to keep consistent margin Table tblMain = doc.InsertTableAfter(1, 1); Table tblContactInfo = tblMain[tblMain.NumRows - 1, 0].InsertTableAfter(2, 1); if (strPersonalInfo == "True") { Font fInfo = doc.CreateFont(); fInfo.FontName = "Garamond"; fInfo.FontSize = 9; ParagraphFormatting pf = doc.CreateParagraphFormatting(); pf.TextJustification = ParagraphFormatting.Justification.Center; // Add contact information to the document if (dtPortfolio.Rows[0]["FirstName"].ToString().Trim() != "" && dtPortfolio.Rows[0]["LastName"].ToString().Trim() != "") { string sName = dtPortfolio.Rows[0]["FirstName"].ToString() + " " + dtPortfolio.Rows[0]["LastName"].ToString(); Font fName = doc.CreateFont(); fName.FontName = "Garamond"; fName.FontSize = 18; fName.Bold = true; tblContactInfo[0, 0].ApplyParagraphFormatting(pf); tblContactInfo[0, 0].VertAlignment = TableCell.VerticalAlignment.Top; tblContactInfo.set_RowHeight(0, 450); tblContactInfo.set_RowHeightExact(0, false); tblContactInfo[0, 0].InsertTextAfter(sName, fName); } tblContactInfo[1, 0].ApplyParagraphFormatting(pf); if (dtPortfolio.Rows[0]["Address1"].ToString().Trim() != "") { tblContactInfo[1, 0].InsertTextAfter(dtPortfolio.Rows[0]["Address1"].ToString(), fInfo); if (dtPortfolio.Rows[0]["Address2"].ToString().Trim() != "") tblContactInfo[1, 0].InsertTextAfter(", " + dtPortfolio.Rows[0]["Address2"].ToString(), fInfo); tblContactInfo[1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } if (dtPortfolio.Rows[0]["City"].ToString().Trim() != "") tblContactInfo[1, 0].InsertTextAfter(dtPortfolio.Rows[0]["City"].ToString(), fInfo); if (dtPortfolio.Rows[0]["StateProv"].ToString().Trim() != "") tblContactInfo[1, 0].InsertTextAfter(", " + dtPortfolio.Rows[0]["StateProv"].ToString(), fInfo); if (dtPortfolio.Rows[0]["PostalZip"].ToString().Trim() != "") tblContactInfo[1, 0].InsertTextAfter(" " + dtPortfolio.Rows[0]["PostalZip"].ToString(), fInfo); tblContactInfo[1, 0].InsertBreakAfter(Element.BreakType.TextWrap); if (dtPortfolio.Rows[0]["Phone"].ToString().Trim() != "") { tblContactInfo[1, 0].InsertTextAfter(dtPortfolio.Rows[0]["Phone"].ToString(), fInfo); tblContactInfo[1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } if (dtPortfolio.Rows[0]["EmailAddress"].ToString().Trim() != "") { string strUrl = (dtPortfolio.Rows[0]["EmailAddress"].ToString()); tblContactInfo[1, 0].InsertTextAfter(dtPortfolio.Rows[0]["EmailAddress"].ToString(), fInfo); tblContactInfo[1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } if (dtPortfolio.Rows[0]["WebAddress"].ToString().Trim() != "") { string strUrl = (dtPortfolio.Rows[0]["WebAddress"].ToString().IndexOf("HTTP") == -1) ? "HTTP://" + dtPortfolio.Rows[0]["WebAddress"].ToString() : dtPortfolio.Rows[0]["WebAddress"].ToString(); tblContactInfo[1, 0].InsertTextAfter(dtPortfolio.Rows[0]["WebAddress"].ToString(), fInfo); } tblMain[0, 0].InsertBreakAfter(Element.BreakType.TextWrap); } if (arrResumeSections != null) { DataSet dsSections = CCLib.Common.Resume.GetSectionsDetail(arrResumeSections, strPortfolioID, strPortTypeID, strUserLanguage); for (int i = 0; i < arrResumeSections.Length; i++) { Font fBold = doc.CreateFont(); fBold.FontName = "Garamond"; fBold.FontSize = 10; fBold.Bold = true; Font fText = doc.CreateFont(); fText.FontName = "Garamond"; fText.FontSize = 9; Font fTextStrong = doc.CreateFont(); fTextStrong.FontName = "Garamond"; fTextStrong.FontSize = 9; fTextStrong.Italic = true; fTextStrong.Bold = true; Font fBullet = doc.CreateFont(); //fBullet.FontName = "Haettenschweiler"; fBullet.FontSize = 10; fBullet.Bold = true; Font fWhite = doc.CreateFont(); fWhite.FontName = "Garamond"; fWhite.FontSize = 10; fWhite.TextColor = System.Drawing.Color.White; switch (arrResumeSections[i].ToString()) { case "CareerObjective": if (dtPortfolio.Rows[0]["CareerObjective"].ToString() != "") { tblMain.AddRows(1); Table tblCO = tblMain[tblMain.NumRows - 1, 0].InsertTableAfter(3, 1); TableCell Cell1 = tblCO[0, 0]; Cell1.VertAlignment = TableCell.VerticalAlignment.Top; tblCO.set_RowHeight(0, 350); tblCO.set_RowHeightExact(0, true); Cell1.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2876, strUserLanguage), fBold); TableCell Cell2 = tblCO[1, 0]; Cell2.VertAlignment = TableCell.VerticalAlignment.Top; InlineImage imgLine1 = Cell2.InsertImageBefore(ConfigurationManager.AppSettings["strMediaLocation"] + "portfolio_tool\\line.gif"); imgLine1.Width = 8600; imgLine1.Height = 20; Cell2.InsertTextAfter("----", fWhite); TableCell Cell3 = tblCO[2, 0]; Cell3.InsertTextAfter(dtPortfolio.Rows[0]["CareerObjective"].ToString(), fText); tblMain[tblMain.NumRows - 1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } break; case "WorkExperience": if (strWorkExp == "True") { if (dsSections.Tables["WorkExperience"] != null) { dtWork = dsSections.Tables["WorkExperience"]; if (dtWork.Rows.Count > 0) { tblMain.AddRows(1); Table tblWE = tblMain[tblMain.NumRows - 1, 0].InsertTableAfter(dtWork.Rows.Count + 2, 2); TableCell Cell4 = tblWE[0, 0]; Cell4.CellWidthUnits = TableCell.WidthUnits.Percentage; Cell4.PreferredWidth = 20; tblWE[0, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; tblWE[0, 1].PreferredWidth = 80; Cell4.FirstMerged = true; tblWE[0, 1].Merged = true; Cell4.VertAlignment = TableCell.VerticalAlignment.Top; tblWE.set_RowHeight(0, 350); tblWE.set_RowHeightExact(0, true); Cell4.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2878, strUserLanguage), fBold); TableCell Cell5 = tblWE[1, 0]; Cell5.FirstMerged = true; tblWE[1, 1].Merged = true; Cell5.VertAlignment = TableCell.VerticalAlignment.Top; InlineImage imgLine2 = Cell5.InsertImageBefore(ConfigurationManager.AppSettings["strMediaLocation"] + "portfolio_tool\\line.gif"); imgLine2.Width = 8600; imgLine2.Height = 20; Cell5.InsertTextAfter("----", fWhite); for (int j = 0; j < dtWork.Rows.Count; j++) { tblWE[j + 2, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblWE[j + 2, 0].PreferredWidth = 20; if (dtWork.Rows[j]["StartMonthID"].ToString() != "0" && dtWork.Rows[j]["StartMonthID"].ToString() != "") tblWE[j + 2, 0].InsertTextAfter(CCLib.Common.Strings.GetShortMonth(Convert.ToInt32(dtWork.Rows[j]["StartMonthID"]), strUserLanguage) + " " + dtWork.Rows[j]["StartYear"].ToString().Substring(2, 2) + " - ", fText); if (dtWork.Rows[j]["EndMonthID"].ToString() != "" && dtWork.Rows[j]["EndMonthID"].ToString() != "0") { if (dtWork.Rows[j]["EndMonthID"].ToString().Trim() == "13") tblWE[j + 2, 0].InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2879, strUserLanguage), fText); else tblWE[j + 2, 0].InsertTextAfter(CCLib.Common.Strings.GetShortMonth(Convert.ToInt32(dtWork.Rows[j]["EndMonthID"]), strUserLanguage) + " " + dtWork.Rows[j]["EndYear"].ToString().Substring(2, 2), fText); } tblWE[j + 2, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; tblWE[j + 2, 1].PreferredWidth = 80; tblWE[j + 2, 1].InsertTextAfter(dtWork.Rows[j]["Title"].ToString() + ", ", fTextStrong); tblWE[j + 2, 1].InsertTextAfter(dtWork.Rows[j]["Company"].ToString(), fText); tblWE[j + 2, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblWE[j + 2, 1].InsertTextAfter(dtWork.Rows[j]["City"].ToString(), fText); if ((dtWork.Rows[j]["City"].ToString() != "") && (dtWork.Rows[j]["StateProv"].ToString() != "")) { tblWE[j + 2, 1].InsertTextAfter(", ", fText); } tblWE[j + 2, 1].InsertTextAfter(dtWork.Rows[j]["StateProv"].ToString(), fText); if (dtWork.Rows[j]["ExpDesc"].ToString() != "") { tblWE[j + 2, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblWE[j + 2, 1].InsertBreakAfter(Element.BreakType.TextWrap); //tblWE[j + 2, 1].InsertTextAfter(ch.ToString() + " ", fBullet); tblWE[j + 2, 1].InsertTextAfter("» " + dtWork.Rows[j]["ExpDesc"].ToString().Replace("\n", "\n» "), fText); } if (j < dtWork.Rows.Count - 1) tblWE[j + 2, 1].InsertBreakAfter(Element.BreakType.TextWrap); } tblMain[tblMain.NumRows - 1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } } } break; case "Education": if (drPortSettings["RBEducation" + intMenuGrade].ToString() == "True") { if (dsSections.Tables["Education"] != null) { dtEdu = dsSections.Tables["Education"]; if (dtEdu.Rows.Count > 0) { tblMain.AddRows(1); Table tblEdu = tblMain[tblMain.NumRows - 1, 0].InsertTableAfter(dtEdu.Rows.Count + 2, 2); TableCell Cell6 = tblEdu[0, 0]; Cell6.CellWidthUnits = TableCell.WidthUnits.Percentage; Cell6.PreferredWidth = 20; tblEdu[0, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; tblEdu[0, 1].PreferredWidth = 80; Cell6.FirstMerged = true; tblEdu[0, 1].Merged = true; Cell6.VertAlignment = TableCell.VerticalAlignment.Top; tblEdu.set_RowHeight(0, 350); tblEdu.set_RowHeightExact(0, true); Cell6.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2877, strUserLanguage), fBold); TableCell Cell7 = tblEdu[1, 0]; Cell7.FirstMerged = true; tblEdu[1, 1].Merged = true; Cell7.VertAlignment = TableCell.VerticalAlignment.Top; InlineImage imgLine3 = Cell7.InsertImageBefore(ConfigurationManager.AppSettings["strMediaLocation"] + "portfolio_tool\\line.gif"); imgLine3.Width = 8600; imgLine3.Height = 20; Cell7.InsertTextAfter("----", fWhite); for (int j = 0; j < dtEdu.Rows.Count; j++) { tblEdu[j + 2, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblEdu[j + 2, 0].PreferredWidth = 20; if (dtEdu.Rows[j]["StartMonthID"].ToString() != "0" && dtEdu.Rows[j]["StartMonthID"].ToString() != "") tblEdu[j + 2, 0].InsertTextAfter(CCLib.Common.Strings.GetShortMonth(Convert.ToInt32(dtEdu.Rows[j]["StartMonthID"]), strUserLanguage) + " " + dtEdu.Rows[j]["StartYear"].ToString().Substring(2, 2) + " - ", fText); if (dtEdu.Rows[j]["EndMonthID"].ToString() != "" && dtEdu.Rows[j]["EndMonthID"].ToString() != "0") { if (dtEdu.Rows[j]["EndMonthID"].ToString().Trim() == "13") tblEdu[j + 2, 0].InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2879, strUserLanguage), fText); else tblEdu[j + 2, 0].InsertTextAfter(CCLib.Common.Strings.GetShortMonth(Convert.ToInt32(dtEdu.Rows[j]["EndMonthID"]), strUserLanguage) + " " + dtEdu.Rows[j]["EndYear"].ToString().Substring(2, 2), fText); } tblEdu[j + 2, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; tblEdu[j + 2, 1].PreferredWidth = 80; tblEdu[j + 2, 1].InsertTextAfter(dtEdu.Rows[j]["Degree"].ToString() + ", ", fTextStrong); tblEdu[j + 2, 1].InsertTextAfter(dtEdu.Rows[j]["School"].ToString(), fText); tblEdu[j + 2, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblEdu[j + 2, 1].InsertTextAfter(dtEdu.Rows[j]["City"].ToString(), fText); if ((dtEdu.Rows[j]["City"].ToString() != "") && (dtEdu.Rows[j]["StateProv"].ToString() != "")) { tblEdu[j + 2, 1].InsertTextAfter(", ", fText); } tblEdu[j + 2, 1].InsertTextAfter(dtEdu.Rows[j]["StateProv"].ToString(), fText); if (dtEdu.Rows[j]["EduDesc"].ToString() != "") { tblEdu[j + 2, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblEdu[j + 2, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblEdu[j + 2, 1].InsertTextAfter(ch.ToString() + " ", fBullet); tblEdu[j + 2, 1].InsertTextAfter(dtEdu.Rows[j]["EduDesc"].ToString(), fText); } if (j < dtEdu.Rows.Count - 1) tblEdu[j + 2, 1].InsertBreakAfter(Element.BreakType.TextWrap); } tblMain[tblMain.NumRows - 1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } } } break; case "VolunteerExperience": if (strCommunityHrs == "True") { if (dsSections.Tables["VolunteerExperience"] != null) { dtComm = dsSections.Tables["VolunteerExperience"]; if (dtComm.Rows.Count > 0) { tblMain.AddRows(1); Table tblVol = tblMain[tblMain.NumRows - 1, 0].InsertTableAfter(dtComm.Rows.Count + 2, 2); TableCell Cell8 = tblVol[0, 0]; Cell8.CellWidthUnits = TableCell.WidthUnits.Percentage; Cell8.PreferredWidth = 20; tblVol[0, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; tblVol[0, 1].PreferredWidth = 80; Cell8.FirstMerged = true; tblVol[0, 1].Merged = true; Cell8.VertAlignment = TableCell.VerticalAlignment.Top; tblVol.set_RowHeight(0, 350); tblVol.set_RowHeightExact(0, true); Cell8.InsertTextAfter(CCLib.Common.Strings.GenerateLanguageText(5369, strUserLanguage, false, strPortTypeID), fBold); TableCell Cell9 = tblVol[1, 0]; Cell9.FirstMerged = true; tblVol[1, 1].Merged = true; Cell9.VertAlignment = TableCell.VerticalAlignment.Top; InlineImage imgLine4 = Cell9.InsertImageBefore(ConfigurationManager.AppSettings["strMediaLocation"] + "portfolio_tool\\line.gif"); imgLine4.Width = 8600; imgLine4.Height = 20; Cell9.InsertTextAfter("----", fWhite); for (int j = 0; j < dtComm.Rows.Count; j++) { tblVol[j + 2, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblVol[j + 2, 0].PreferredWidth = 20; if (dtComm.Rows[j]["StartMonthID"].ToString() != "0" && dtComm.Rows[j]["StartMonthID"].ToString() != "") tblVol[j + 2, 0].InsertTextAfter(CCLib.Common.Strings.GetShortMonth(Convert.ToInt32(dtComm.Rows[j]["StartMonthID"]), strUserLanguage) + " " + dtComm.Rows[j]["StartYear"].ToString().Substring(2, 2) + " - ", fText); if (dtComm.Rows[j]["EndMonthID"].ToString() != "" && dtComm.Rows[j]["EndMonthID"].ToString() != "0") { if (dtComm.Rows[j]["EndMonthID"].ToString().Trim() == "13") tblVol[j + 2, 0].InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2879, strUserLanguage), fText); else tblVol[j + 2, 0].InsertTextAfter(CCLib.Common.Strings.GetShortMonth(Convert.ToInt32(dtComm.Rows[j]["EndMonthID"]), strUserLanguage) + " " + dtComm.Rows[j]["EndYear"].ToString().Substring(2, 2), fText); } tblVol[j + 2, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; tblVol[j + 2, 1].PreferredWidth = 80; tblVol[j + 2, 1].InsertTextAfter(dtComm.Rows[j]["Title"].ToString() + ", ", fTextStrong); tblVol[j + 2, 1].InsertTextAfter(dtComm.Rows[j]["Company"].ToString(), fText); tblVol[j + 2, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblVol[j + 2, 1].InsertTextAfter(dtComm.Rows[j]["City"].ToString(), fText); if ((dtComm.Rows[j]["City"].ToString() != "") && (dtComm.Rows[j]["StateProv"].ToString() != "")) { tblVol[j + 2, 1].InsertTextAfter(", ", fText); } tblVol[j + 2, 1].InsertTextAfter(dtComm.Rows[j]["StateProv"].ToString(), fText); if (dtComm.Rows[j]["ExpDesc"].ToString() != "") { tblVol[j + 2, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblVol[j + 2, 1].InsertBreakAfter(Element.BreakType.TextWrap); //tblVol[j + 2, 1].InsertTextAfter(ch.ToString() + " ", fBullet); tblVol[j + 2, 1].InsertTextAfter("» " + dtComm.Rows[j]["ExpDesc"].ToString().Replace("\n", "\n» "), fText); } if (j < dtComm.Rows.Count - 1) tblVol[j + 2, 1].InsertBreakAfter(Element.BreakType.TextWrap); } tblMain[tblMain.NumRows - 1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } } } break; case "Organization": if (strExtraOrg == "True") { if (dsSections.Tables["Organization"] != null) { dtOrg = dsSections.Tables["Organization"]; if (dtPortfolio.Rows[0]["ResumeSections"].ToString().IndexOf("OrgComments") > 0) { if (dtOrg.Rows.Count > 0) { tblMain.AddRows(1); Table tblWE = tblMain[tblMain.NumRows - 1, 0].InsertTableAfter(dtOrg.Rows.Count + 2, 2); TableCell Cell4 = tblWE[0, 0]; Cell4.CellWidthUnits = TableCell.WidthUnits.Percentage; Cell4.PreferredWidth = 20; tblWE[0, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; tblWE[0, 1].PreferredWidth = 80; Cell4.FirstMerged = true; tblWE[0, 1].Merged = true; Cell4.VertAlignment = TableCell.VerticalAlignment.Top; tblWE.set_RowHeight(0, 350); tblWE.set_RowHeightExact(0, true); Cell4.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(5399, strUserLanguage), fBold); TableCell Cell5 = tblWE[1, 0]; Cell5.FirstMerged = true; tblWE[1, 1].Merged = true; Cell5.VertAlignment = TableCell.VerticalAlignment.Top; InlineImage imgLine2 = Cell5.InsertImageBefore(ConfigurationManager.AppSettings["strMediaLocation"] + "portfolio_tool\\line.gif"); imgLine2.Width = 8600; imgLine2.Height = 20; Cell5.InsertTextAfter("----", fWhite); for (int j = 0; j < dtOrg.Rows.Count; j++) { tblWE[j + 2, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblWE[j + 2, 0].PreferredWidth = 20; if (dtOrg.Rows[j]["OrgStartMonth"].ToString() != "0" && dtOrg.Rows[j]["OrgStartMonth"].ToString() != "") tblWE[j + 2, 0].InsertTextAfter(CCLib.Common.Strings.GetShortMonth(Convert.ToInt32(dtOrg.Rows[j]["OrgStartMonth"]), strUserLanguage) + " " + dtOrg.Rows[j]["OrgStartYear"].ToString().Substring(2, 2) + " - ", fText); if (dtOrg.Rows[j]["OrgEndMonth"].ToString() != "" && dtOrg.Rows[j]["OrgEndMonth"].ToString() != "0") { if (dtOrg.Rows[j]["OrgEndMonth"].ToString().Trim() == "13") tblWE[j + 2, 0].InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2879, strUserLanguage), fText); else tblWE[j + 2, 0].InsertTextAfter(CCLib.Common.Strings.GetShortMonth(Convert.ToInt32(dtOrg.Rows[j]["OrgEndMonth"]), strUserLanguage) + " " + dtOrg.Rows[j]["OrgEndYear"].ToString().Substring(2, 2), fText); } tblWE[j + 2, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; tblWE[j + 2, 1].PreferredWidth = 80; tblWE[j + 2, 1].InsertTextAfter(dtOrg.Rows[j]["MyActivity"].ToString(), fText); tblWE[j + 2, 1].InsertBreakAfter(Element.BreakType.TextWrap); if (dtOrg.Rows[j]["OrgDescription"].ToString() != "") { tblWE[j + 2, 1].InsertTextAfter(ch.ToString() + " ", fBullet); tblWE[j + 2, 1].InsertTextAfter(dtOrg.Rows[j]["OrgDescription"].ToString(), fText); } if (j < dtOrg.Rows.Count - 1) tblWE[j + 2, 1].InsertBreakAfter(Element.BreakType.TextWrap); } tblMain[tblMain.NumRows - 1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } } else { if (dtOrg.Rows.Count > 0) { tblMain.AddRows(1); Table tblEtr = tblMain[tblMain.NumRows - 1, 0].InsertTableAfter(3, 1); TableCell Cell12 = tblEtr[0, 0]; Cell12.VertAlignment = TableCell.VerticalAlignment.Top; tblEtr.set_RowHeight(0, 350); tblEtr.set_RowHeightExact(0, true); Cell12.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(5399, strUserLanguage), fBold); TableCell Cell13 = tblEtr[1, 0]; Cell13.VertAlignment = TableCell.VerticalAlignment.Top; InlineImage imgLine5 = Cell13.InsertImageBefore(ConfigurationManager.AppSettings["strMediaLocation"] + "portfolio_tool\\line.gif"); imgLine5.Width = 8600; imgLine5.Height = 20; Cell13.InsertTextAfter("----", fWhite); string strOrg = ""; for (int m = 0; m < dtOrg.Rows.Count; m++) { strOrg = strOrg + dtOrg.Rows[m]["MyActivity"].ToString() + ", "; } if (strOrg.Length > 0) strOrg = strOrg.Substring(0, strOrg.Length - 2); tblEtr[2, 0].InsertTextAfter(strOrg, fText); tblMain[tblMain.NumRows - 1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } } } } break; case "Award": if (drPortSettings["RBAwards" + intMenuGrade].ToString() == "True") { if (dsSections.Tables["Award"] != null) { dtAward = dsSections.Tables["Award"]; if (dtAward.Rows.Count > 0) { tblMain.AddRows(1); Table tblAwd = tblMain[tblMain.NumRows - 1, 0].InsertTableAfter(dtAward.Rows.Count + 2, 1); TableCell Cell10 = tblAwd[0, 0]; Cell10.VertAlignment = TableCell.VerticalAlignment.Top; //Cell10.CellWidthUnits = TableCell.WidthUnits.Percentage; //Cell10.PreferredWidth = 20; //tblAwd[0, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; //tblAwd[0, 1].PreferredWidth = 80; //Cell10.FirstMerged = true; //tblAwd[0, 1].Merged = true; tblAwd.set_RowHeight(0, 350); tblAwd.set_RowHeightExact(0, true); Cell10.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(5398, strUserLanguage), fBold); TableCell Cell11 = tblAwd[1, 0]; Cell11.VertAlignment = TableCell.VerticalAlignment.Top; InlineImage imgLine5 = Cell11.InsertImageBefore(ConfigurationManager.AppSettings["strMediaLocation"] + "portfolio_tool\\line.gif"); imgLine5.Width = 8600; imgLine5.Height = 20; Cell11.InsertTextAfter("----", fWhite); for (int m = 0; m < dtAward.Rows.Count; m++) { DateTime d = (DateTime)dtAward.Rows[m]["AwardDate"]; string y = d.Year.ToString().Substring(2, 2); string mm = CCLib.Common.Strings.GetShortMonth(d.Month, strUserLanguage); //tblAwd[m + 2, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; //tblAwd[m + 2, 0].PreferredWidth = 20; //tblAwd[m + 2, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; //tblAwd[m + 2, 1].PreferredWidth = 80; tblAwd[m + 2, 0].VertAlignment = TableCell.VerticalAlignment.Bottom; //tblAwd[m + 2, 0].InsertTextAfter("", fText); tblAwd[m + 2, 0].InsertTextAfter(ch.ToString() + " ", fBullet); tblAwd[m + 2, 0].InsertTextAfter(dtAward.Rows[m]["AwardName"].ToString() + " (" + mm + " " + y + ")", fText); } //string strAward = ""; //for (int m = 0; m < dtAward.Rows.Count; m++) //{ // strAward = strAward + dtAward.Rows[m]["AwardName"].ToString() + ", "; //} //if (strAward.Length > 0) // strAward = strAward.Substring(0, strAward.Length - 2); tblMain[tblMain.NumRows - 1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } } } break; case "Extracurricular": if (strInterHobbies == "True") { if (dsSections.Tables["Extracurricular"] != null) { dtHobby = dsSections.Tables["Extracurricular"]; if (dtPortfolio.Rows[0]["ResumeSections"].ToString().IndexOf("ExtraComments") > 0) { if (dtHobby.Rows.Count > 0) { tblMain.AddRows(1); Table tblEtr = tblMain[tblMain.NumRows - 1, 0].InsertTableAfter(dtHobby.Rows.Count + 2, 1); TableCell Cell12 = tblEtr[0, 0]; Cell12.VertAlignment = TableCell.VerticalAlignment.Top; tblEtr.set_RowHeight(0, 350); tblEtr.set_RowHeightExact(0, true); Cell12.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(4037, strUserLanguage), fBold); TableCell Cell13 = tblEtr[1, 0]; Cell13.VertAlignment = TableCell.VerticalAlignment.Top; InlineImage imgLine5 = Cell13.InsertImageBefore(ConfigurationManager.AppSettings["strMediaLocation"] + "portfolio_tool\\line.gif"); imgLine5.Width = 8600; imgLine5.Height = 20; Cell13.InsertTextAfter("----", fWhite); for (int m = 0; m < dtHobby.Rows.Count; m++) { tblEtr[m + 2, 0].VertAlignment = TableCell.VerticalAlignment.Bottom; tblEtr[m + 2, 0].InsertTextAfter(ch.ToString() + " ", fBullet); tblEtr[m + 2, 0].InsertTextAfter(dtHobby.Rows[m]["MyActivity"].ToString(), fText); if (dtHobby.Rows[m]["IntDescription"].ToString().Length > 0) tblEtr[m + 2, 0].InsertTextAfter(" - " + dtHobby.Rows[m]["IntDescription"].ToString(), fText); } tblMain[tblMain.NumRows - 1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } } else { if (dtHobby.Rows.Count > 0) { tblMain.AddRows(1); Table tblEtr = tblMain[tblMain.NumRows - 1, 0].InsertTableAfter(3, 1); TableCell Cell12 = tblEtr[0, 0]; Cell12.VertAlignment = TableCell.VerticalAlignment.Top; tblEtr.set_RowHeight(0, 350); tblEtr.set_RowHeightExact(0, true); Cell12.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(4037, strUserLanguage), fBold); TableCell Cell13 = tblEtr[1, 0]; Cell13.VertAlignment = TableCell.VerticalAlignment.Top; InlineImage imgLine5 = Cell13.InsertImageBefore(ConfigurationManager.AppSettings["strMediaLocation"] + "portfolio_tool\\line.gif"); imgLine5.Width = 8600; imgLine5.Height = 20; Cell13.InsertTextAfter("----", fWhite); string strExtra = ""; for (int m = 0; m < dtHobby.Rows.Count; m++) { strExtra = strExtra + dtHobby.Rows[m]["MyActivity"].ToString() + ", "; } if (strExtra.Length > 0) strExtra = strExtra.Substring(0, strExtra.Length - 2); tblEtr[2, 0].InsertTextAfter(strExtra, fText); tblMain[tblMain.NumRows - 1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } } } } break; case "Skill": if (drPortSettings["RBSkills" + intMenuGrade].ToString() == "True") { if (dsSections.Tables["Skill"] != null) { dtSkill = dsSections.Tables["Skill"]; if (dtPortfolio.Rows[0]["ResumeSections"].ToString().IndexOf("SkillsComments") > 0) { if (dtSkill.Rows.Count > 0) { tblMain.AddRows(1); Table tblSkill = tblMain[tblMain.NumRows - 1, 0].InsertTableAfter(dtSkill.Rows.Count + 2, 1); TableCell Cell14 = tblSkill[0, 0]; Cell14.VertAlignment = TableCell.VerticalAlignment.Top; tblSkill.set_RowHeight(0, 350); tblSkill.set_RowHeightExact(0, true); Cell14.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2883, strUserLanguage), fBold); TableCell Cell15 = tblSkill[1, 0]; Cell15.VertAlignment = TableCell.VerticalAlignment.Top; InlineImage imgLine6 = Cell15.InsertImageBefore(ConfigurationManager.AppSettings["strMediaLocation"] + "portfolio_tool\\line.gif"); imgLine6.Width = 8600; imgLine6.Height = 20; Cell15.InsertTextAfter("----", fWhite); for (int m = 0; m < dtSkill.Rows.Count; m++) { tblSkill[m + 2, 0].VertAlignment = TableCell.VerticalAlignment.Bottom; tblSkill[m + 2, 0].InsertTextAfter(ch.ToString() + " ", fBullet); tblSkill[m + 2, 0].InsertTextAfter(dtSkill.Rows[m]["Skill" + strUserLanguage].ToString(), fText); if (dtSkill.Rows[m]["SkillDesc"].ToString().Length > 0) tblSkill[m + 2, 0].InsertTextAfter(" - " + dtSkill.Rows[m]["SkillDesc"].ToString(), fText); } tblMain[tblMain.NumRows - 1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } } else { if (dtSkill.Rows.Count > 0) { tblMain.AddRows(1); Table tblSkill = tblMain[tblMain.NumRows - 1, 0].InsertTableAfter(5, 1); TableCell Cell14 = tblSkill[0, 0]; Cell14.VertAlignment = TableCell.VerticalAlignment.Top; tblSkill.set_RowHeight(0, 350); tblSkill.set_RowHeightExact(0, true); Cell14.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2883, strUserLanguage), fBold); TableCell Cell15 = tblSkill[1, 0]; InlineImage imgLine6 = Cell15.InsertImageBefore(ConfigurationManager.AppSettings["strMediaLocation"] + "portfolio_tool\\line.gif"); imgLine6.Width = 8600; imgLine6.Height = 20; Cell15.InsertTextAfter("----", fWhite); string strSkill2 = ""; string strSkill1 = ""; string strSkill3 = ""; for (int m = 0; m < dtSkill.Rows.Count; m++) { if (dtSkill.Rows[m]["SkillCategoryID"].ToString() == "2") strSkill2 += dtSkill.Rows[m]["Skill" + strUserLanguage].ToString() + ", "; if (dtSkill.Rows[m]["SkillCategoryID"].ToString() == "1") strSkill1 += dtSkill.Rows[m]["Skill" + strUserLanguage].ToString() + ", "; if (dtSkill.Rows[m]["SkillCategoryID"].ToString() == "3") strSkill3 += dtSkill.Rows[m]["Skill" + strUserLanguage].ToString() + ", "; } if (strSkill2.Length > 0) { strSkill2 = strSkill2.Substring(0, strSkill2.Length - 2); tblSkill[2, 0].VertAlignment = TableCell.VerticalAlignment.Bottom; tblSkill[2, 0].InsertTextAfter(ch.ToString() + " ", fBullet); tblSkill[2, 0].InsertTextAfter(strSkill2, fText); } if (strSkill1.Length > 0) { strSkill1 = strSkill1.Substring(0, strSkill1.Length - 2); tblSkill[3, 0].VertAlignment = TableCell.VerticalAlignment.Bottom; tblSkill[3, 0].InsertTextAfter(ch.ToString() + " ", fBullet); tblSkill[3, 0].InsertTextAfter(strSkill1, fText); } if (strSkill3.Length > 0) { strSkill3 = strSkill3.Substring(0, strSkill3.Length - 2); tblSkill[4, 0].VertAlignment = TableCell.VerticalAlignment.Bottom; tblSkill[4, 0].InsertTextAfter(ch.ToString() + " ", fBullet); tblSkill[4, 0].InsertTextAfter(strSkill3, fText); } if (strSkill2.Length == 0) tblSkill.DeleteRows(2, 0); if (strSkill1.Length == 0) tblSkill.DeleteRows(3, 0); if (strSkill3.Length == 0) tblSkill.DeleteRows(4, 0); tblMain[tblMain.NumRows - 1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } } } } break; case "Additional": if (strAdditionalInfo == "True") { if (dtPortfolio.Rows[0]["AddInfo"].ToString() != "") { tblMain.AddRows(1); Table tblAdd = tblMain[tblMain.NumRows - 1, 0].InsertTableAfter(3, 1); TableCell Cell17 = tblAdd[0, 0]; Cell17.VertAlignment = TableCell.VerticalAlignment.Top; tblAdd.set_RowHeight(0, 350); tblAdd.set_RowHeightExact(0, true); Cell17.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2884, strUserLanguage), fBold); TableCell Cell18 = tblAdd[1, 0]; Cell18.VertAlignment = TableCell.VerticalAlignment.Top; InlineImage imgLine7 = Cell18.InsertImageBefore(ConfigurationManager.AppSettings["strMediaLocation"] + "portfolio_tool\\line.gif"); imgLine7.Width = 8600; imgLine7.Height = 20; Cell18.InsertTextAfter("----", fWhite); tblAdd[2, 0].InsertTextAfter(dtPortfolio.Rows[0]["AddInfo"].ToString().Trim(), fText); tblMain[tblMain.NumRows - 1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } } break; default: break; } } } string targetfile = ConfigurationManager.AppSettings["strResumeLocation"] + "word\\Resume_Word_" + strPortfolioID + "_Contemporary.doc"; if (File.Exists(ConfigurationManager.AppSettings["strResumeLocation"] + "word\\Resume_Word_" + strPortfolioID + "_Contemporary.doc")) File.Delete(ConfigurationManager.AppSettings["strResumeLocation"] + "word\\Resume_Word_" + strPortfolioID + "_Contemporary.doc"); wordApp.Save(doc, targetfile); #endregion Build Resume #region Build Reference /* Initialize the WordApplication and create our document. */ WordApplication wordAppRef = new WordApplication(); Document docRef = wordAppRef.Create(); //Create tblMain and tblContactInfo tables to keep consistent margin Table tblMainRef = docRef.InsertTableAfter(1, 1); Table tblContactInfoRef = tblMainRef[tblMainRef.NumRows - 1, 0].InsertTableAfter(2, 1); if (strPersonalInfo == "True") { Font fInfo = docRef.CreateFont(); fInfo.FontName = "Garamond"; fInfo.FontSize = 9; ParagraphFormatting pf = doc.CreateParagraphFormatting(); pf.TextJustification = ParagraphFormatting.Justification.Center; // Add contact information to the document if (dtPortfolio.Rows[0]["FirstName"].ToString().Trim() != "" && dtPortfolio.Rows[0]["LastName"].ToString().Trim() != "") { string sName = dtPortfolio.Rows[0]["FirstName"].ToString() + " " + dtPortfolio.Rows[0]["LastName"].ToString(); Font fName = docRef.CreateFont(); fName.FontName = "Garamond"; fName.FontSize = 18; fName.Bold = true; tblContactInfoRef[0, 0].ApplyParagraphFormatting(pf); tblContactInfoRef[0, 0].VertAlignment = TableCell.VerticalAlignment.Top; tblContactInfoRef.set_RowHeight(0, 450); tblContactInfoRef.set_RowHeightExact(0, false); tblContactInfoRef[0, 0].InsertTextAfter(sName, fName); } tblContactInfoRef[1, 0].ApplyParagraphFormatting(pf); if (dtPortfolio.Rows[0]["Address1"].ToString().Trim() != "") { tblContactInfoRef[1, 0].InsertTextAfter(dtPortfolio.Rows[0]["Address1"].ToString(), fInfo); if (dtPortfolio.Rows[0]["Address2"].ToString().Trim() != "") tblContactInfoRef[1, 0].InsertTextAfter(", " + dtPortfolio.Rows[0]["Address2"].ToString(), fInfo); tblContactInfoRef[1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } if (dtPortfolio.Rows[0]["City"].ToString().Trim() != "") tblContactInfoRef[1, 0].InsertTextAfter(dtPortfolio.Rows[0]["City"].ToString(), fInfo); if (dtPortfolio.Rows[0]["StateProv"].ToString().Trim() != "") tblContactInfoRef[1, 0].InsertTextAfter(", " + dtPortfolio.Rows[0]["StateProv"].ToString(), fInfo); if (dtPortfolio.Rows[0]["PostalZip"].ToString().Trim() != "") tblContactInfoRef[1, 0].InsertTextAfter(" " + dtPortfolio.Rows[0]["PostalZip"].ToString(), fInfo); tblContactInfoRef[1, 0].InsertBreakAfter(Element.BreakType.TextWrap); if (dtPortfolio.Rows[0]["Phone"].ToString().Trim() != "") { tblContactInfoRef[1, 0].InsertTextAfter(dtPortfolio.Rows[0]["Phone"].ToString(), fInfo); tblContactInfoRef[1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } if (dtPortfolio.Rows[0]["EmailAddress"].ToString().Trim() != "") { string strUrl = (dtPortfolio.Rows[0]["EmailAddress"].ToString()); tblContactInfoRef[1, 0].InsertTextAfter(dtPortfolio.Rows[0]["EmailAddress"].ToString(), fInfo); tblContactInfoRef[1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } if (dtPortfolio.Rows[0]["WebAddress"].ToString().Trim() != "") { string strUrl = (dtPortfolio.Rows[0]["WebAddress"].ToString().IndexOf("HTTP") == -1) ? "HTTP://" + dtPortfolio.Rows[0]["WebAddress"].ToString() : dtPortfolio.Rows[0]["WebAddress"].ToString(); tblContactInfoRef[1, 0].InsertTextAfter(dtPortfolio.Rows[0]["WebAddress"].ToString(), fInfo); } tblMainRef[0, 0].InsertBreakAfter(Element.BreakType.TextWrap); } dtRef = CCLib.Common.DataAccess.GetDataTable(" Select * from Port_Reference where Portfolioid=" + strPortfolioID); if (drPortSettings["RBReferences" + intMenuGrade].ToString() == "True") { if (dtRef != null) { if (dtRef.Rows.Count > 0) { Font fBold = docRef.CreateFont(); fBold.FontName = "Garamond"; fBold.FontSize = 10; fBold.Bold = true; Font fText = doc.CreateFont(); fText.FontName = "Garamond"; fText.FontSize = 9; Font fTextStrong = doc.CreateFont(); fTextStrong.FontName = "Garamond"; fTextStrong.FontSize = 9; fTextStrong.Italic = true; fTextStrong.Bold = true; Font fBullet = docRef.CreateFont(); //fBullet.FontName = "Haettenschweiler"; fBullet.FontSize = 10; fBullet.Bold = true; Font fWhite = docRef.CreateFont(); fWhite.FontName = "Garamond"; fWhite.FontSize = 10; fWhite.TextColor = System.Drawing.Color.White; tblMainRef.AddRows(1); Table tblRef = tblMainRef[tblMainRef.NumRows - 1, 0].InsertTableAfter(dtRef.Rows.Count + 2, 1); TableCell Cell19 = tblRef[0, 0]; Cell19.VertAlignment = TableCell.VerticalAlignment.Top; tblRef.set_RowHeight(0, 350); tblRef.set_RowHeightExact(0, true); Cell19.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2885, strUserLanguage), fBold); TableCell Cell20 = tblRef[1, 0]; Cell20.VertAlignment = TableCell.VerticalAlignment.Top; InlineImage imgLine8 = Cell20.InsertImageBefore(ConfigurationManager.AppSettings["strMediaLocation"] + "portfolio_tool\\line.gif"); imgLine8.Width = 8600; imgLine8.Height = 20; Cell20.InsertTextAfter("----", fWhite); for (int m = 0; m < dtRef.Rows.Count; m++) { tblRef[m + 2, 0].InsertTextAfter(dtRef.Rows[m]["ReferenceName"].ToString(), fTextStrong); tblRef[m + 2, 0].InsertBreakAfter(Element.BreakType.TextWrap); tblRef[m + 2, 0].InsertTextAfter(dtRef.Rows[m]["Title"].ToString(), fText); tblRef[m + 2, 0].InsertBreakAfter(Element.BreakType.TextWrap); tblRef[m + 2, 0].InsertTextAfter(dtRef.Rows[m]["CompanySchool"].ToString(), fText); if (dtRef.Rows[m]["Address1"].ToString() != "") { tblRef[m + 2, 0].InsertBreakAfter(Element.BreakType.TextWrap); tblRef[m + 2, 0].InsertTextAfter(dtRef.Rows[m]["Address1"].ToString(), fText); } if (dtRef.Rows[m]["Address2"].ToString() != "") { tblRef[m + 2, 0].InsertBreakAfter(Element.BreakType.TextWrap); tblRef[m + 2, 0].InsertTextAfter(dtRef.Rows[m]["Address2"].ToString(), fText); } if ((dtRef.Rows[m]["City"].ToString() != "") || (dtRef.Rows[m]["StateProv"].ToString() != "")) { tblRef[m + 2, 0].InsertBreakAfter(Element.BreakType.TextWrap); tblRef[m + 2, 0].InsertTextAfter(dtRef.Rows[m]["City"].ToString() + ", " + dtRef.Rows[m]["StateProv"].ToString(), fText); } if (dtRef.Rows[m]["PostalZip"].ToString() != "") { tblRef[m + 2, 0].InsertBreakAfter(Element.BreakType.TextWrap); tblRef[m + 2, 0].InsertTextAfter(dtRef.Rows[m]["PostalZip"].ToString(), fText); } if (dtRef.Rows[m]["Phone"].ToString() != "") { tblRef[m + 2, 0].InsertBreakAfter(Element.BreakType.TextWrap); tblRef[m + 2, 0].InsertTextAfter(dtRef.Rows[m]["Phone"].ToString(), fText); } if (dtRef.Rows[m]["EmailAddress"].ToString() != "") { tblRef[m + 2, 0].InsertBreakAfter(Element.BreakType.TextWrap); tblRef[m + 2, 0].InsertTextAfter(dtRef.Rows[m]["EmailAddress"].ToString(), fText); } if (m < dtRef.Rows.Count - 1) tblRef[m + 2, 0].InsertBreakAfter(Element.BreakType.TextWrap); } tblMainRef[tblMainRef.NumRows - 1, 0].InsertBreakAfter(Element.BreakType.TextWrap); } } } string targetfileRef = ConfigurationManager.AppSettings["strResumeLocation"] + "word\\ResumeRef_Word_" + strPortfolioID + "_Contemporary.doc"; if (File.Exists(ConfigurationManager.AppSettings["strResumeLocation"] + "word\\ResumeRef_Word_" + strPortfolioID + "_Contemporary.doc")) File.Delete(ConfigurationManager.AppSettings["strResumeLocation"] + "word\\ResumeRef_Word_" + strPortfolioID + "_Contemporary.doc"); wordAppRef.Save(docRef, targetfileRef); #endregion Build Reference } }
public static void GenerateProfessionalDocument(string strPortfolioID, bool blProfileTable, string strUserLanguage, string strPortTypeID, string strPortSettingTable) { DataTable dtPortfolio, dtEdu, dtWork, dtComm, dtAward, dtHobby, dtSkill, dtRef, dtOrg; string strPersonalInfo, strWorkExp, strCommunityHrs, strExtraOrg, strInterHobbies, strAdditionalInfo;//user info settings string[] arrResumeSections; int intMenuGrade; if (blProfileTable) { dtPortfolio = CCLib.Common.DataAccess.GetDataTable("select * from Port_ResumeBuilder_View where PortfolioID=" + strPortfolioID); } else { dtPortfolio = CCLib.Common.DataAccess.GetDataTable("select * from Portfolio where PortfolioID=" + strPortfolioID); } DataRow drPortSettings = CCLib.Login.GetPortSettings(strPortfolioID); arrResumeSections = CCLib.Common.Resume.GetSections(dtPortfolio, drPortSettings, blProfileTable); if (dtPortfolio.Rows.Count > 0) { switch (dtPortfolio.Rows[0]["GradeNumber"].ToString()) { case "1": intMenuGrade = 5; break; case "2": intMenuGrade = 5; break; case "3": intMenuGrade = 5; break; case "4": intMenuGrade = 5; break; case "5": intMenuGrade = 5; break; case "6": intMenuGrade = 6; break; case "7": intMenuGrade = 7; break; case "8": intMenuGrade = 8; break; case "9": intMenuGrade = 9; break; case "10": intMenuGrade = 10; break; case "11": intMenuGrade = 11; break; case "12": intMenuGrade = 12; break; case "13": intMenuGrade = 13; break; case "30": intMenuGrade = 13; break; case "40": intMenuGrade = 13; break; case "50": intMenuGrade = 13; break; case "60": intMenuGrade = 13; break; case "70": intMenuGrade = 13; break; default: intMenuGrade = 6; break; } if (blProfileTable) { strPersonalInfo = drPortSettings["RBPersonalProfile" + intMenuGrade].ToString(); strWorkExp = drPortSettings["RBWorkExp" + intMenuGrade].ToString(); strCommunityHrs = drPortSettings["RBCommunity" + intMenuGrade].ToString(); strExtraOrg = drPortSettings["RBOrganizations" + intMenuGrade].ToString(); strInterHobbies = drPortSettings["RBHobbies" + intMenuGrade].ToString(); strAdditionalInfo = drPortSettings["RBAdditionalInfo" + intMenuGrade].ToString(); } else { strPersonalInfo = drPortSettings["PersonalProfile" + intMenuGrade].ToString(); strWorkExp = drPortSettings["RBWorkExp" + intMenuGrade].ToString(); strCommunityHrs = drPortSettings["RBCommunity" + intMenuGrade].ToString(); strExtraOrg = drPortSettings["RBOrganizations" + intMenuGrade].ToString(); strInterHobbies = drPortSettings["RBHobbies" + intMenuGrade].ToString(); strAdditionalInfo = drPortSettings["RBAdditionalInfo" + intMenuGrade].ToString(); } byte c = 187; // for extended ASCII ">>" char ch = (char)c; /* Initialize the WordApplication and create our document. */ WordApplication wordApp = new WordApplication(); Document doc = wordApp.Create(); //Create tblMain and tblContactInfo tables to keep consistent margin Table tblMain = doc.InsertTableAfter(2, 1); Table tblContactInfo = tblMain[0, 0].InsertTableAfter(1, 1); if (strPersonalInfo == "True") { // Add contact information to the document Paragraph pAddress = tblContactInfo[0, 0].InsertParagraphAfter(null); pAddress.Formatting.TextJustification = ParagraphFormatting.Justification.Left; Font fAddress = doc.CreateFont(); fAddress.FontName = "Arial"; fAddress.FontSize = 9; if (dtPortfolio.Rows[0]["Address1"].ToString().Trim() != "") { pAddress.InsertTextAfter(dtPortfolio.Rows[0]["Address1"].ToString(), fAddress); if (dtPortfolio.Rows[0]["Address2"].ToString().Trim() != "") pAddress.InsertTextAfter(", " + dtPortfolio.Rows[0]["Address2"].ToString(), fAddress); } if (dtPortfolio.Rows[0]["City"].ToString().Trim() != "") { pAddress.InsertBreakAfter(Element.BreakType.TextWrap); pAddress.InsertTextAfter(dtPortfolio.Rows[0]["City"].ToString(), fAddress); } if (dtPortfolio.Rows[0]["StateProv"].ToString().Trim() != "") pAddress.InsertTextAfter(", " + dtPortfolio.Rows[0]["StateProv"].ToString(), fAddress); if (dtPortfolio.Rows[0]["PostalZip"].ToString().Trim() != "") pAddress.InsertTextAfter(" " + dtPortfolio.Rows[0]["PostalZip"].ToString(), fAddress); if (dtPortfolio.Rows[0]["Phone"].ToString().Trim() != "") { pAddress.InsertBreakAfter(Element.BreakType.TextWrap); pAddress.InsertTextAfter(dtPortfolio.Rows[0]["Phone"].ToString(), fAddress); } if (dtPortfolio.Rows[0]["EmailAddress"].ToString().Trim() != "") { string strUrl = (dtPortfolio.Rows[0]["EmailAddress"].ToString()); pAddress.InsertBreakAfter(Element.BreakType.TextWrap); pAddress.InsertTextAfter(dtPortfolio.Rows[0]["EmailAddress"].ToString(), fAddress); } if (dtPortfolio.Rows[0]["WebAddress"].ToString().Trim() != "") { string strUrl = (dtPortfolio.Rows[0]["WebAddress"].ToString().IndexOf("HTTP") == -1) ? "HTTP://" + dtPortfolio.Rows[0]["WebAddress"].ToString() : dtPortfolio.Rows[0]["WebAddress"].ToString(); pAddress.InsertBreakAfter(Element.BreakType.TextWrap); pAddress.InsertTextAfter(dtPortfolio.Rows[0]["WebAddress"].ToString(), fAddress); } if (dtPortfolio.Rows[0]["FirstName"].ToString().Trim() != "" && dtPortfolio.Rows[0]["LastName"].ToString().Trim() != "") { string sName = dtPortfolio.Rows[0]["FirstName"].ToString() + " " + dtPortfolio.Rows[0]["LastName"].ToString(); pAddress.InsertBreakAfter(Element.BreakType.TextWrap); pAddress.InsertBreakAfter(Element.BreakType.TextWrap); Font fName = doc.CreateFont(); fName.FontName = "Tahoma"; fName.FontSize = 24; pAddress.InsertTextAfter(sName, fName); } InlineImage imgLine = tblContactInfo[0, 0].InsertImageAfter(ConfigurationManager.AppSettings["strMediaLocation"] + "portfolio_tool\\line.gif"); imgLine.Width = 8600; imgLine.Height = 20; //tblMain[0, 0].InsertBreakAfter(Element.BreakType.TextWrap); } if (arrResumeSections != null) { DataSet dsSections = CCLib.Common.Resume.GetSectionsDetail(arrResumeSections, strPortfolioID, strPortTypeID, strUserLanguage); Table tbl = tblMain[1, 0].InsertTableAfter(1, 2); for (int i = 0; i < arrResumeSections.Length; i++) { Font fBold = doc.CreateFont(); fBold.FontName = "Tahoma"; fBold.FontSize = 10; fBold.Bold = true; Font fText = doc.CreateFont(); fText.FontName = "Arial"; fText.FontSize = 9; Font fTextStrong = doc.CreateFont(); fTextStrong.FontName = "Arial"; fTextStrong.FontSize = 9; fTextStrong.Italic = true; fTextStrong.Bold = true; Font fBullet = doc.CreateFont(); fBullet.FontName = "Haettenschweiler"; fBullet.FontSize = 10; fBullet.Bold = true; switch (arrResumeSections[i].ToString()) { case "CareerObjective": if (dtPortfolio.Rows[0]["CareerObjective"].ToString() != "") { tbl.AddRows(1); TableCell Cell1 = tbl[tbl.NumRows - 1, 0]; Cell1.CellWidthUnits = TableCell.WidthUnits.Percentage; Cell1.PreferredWidth = 25; TableCell Cell2 = tbl[tbl.NumRows - 1, 1]; Cell2.CellWidthUnits = TableCell.WidthUnits.Percentage; Cell2.PreferredWidth = 75; Cell1.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2876, strUserLanguage), fBold); Table tblCO = Cell2.InsertTableAfter(1, 1); tblCO[0, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblCO[0, 0].PreferredWidth = 100; tblCO[0, 0].InsertTextAfter(dtPortfolio.Rows[0]["CareerObjective"].ToString(), fText); Cell2.InsertBreakAfter(Element.BreakType.TextWrap); } break; case "WorkExperience": if (strWorkExp == "True") { if (dsSections.Tables["WorkExperience"] != null) { dtWork = dsSections.Tables["WorkExperience"]; if (dtWork.Rows.Count > 0) { tbl.AddRows(1); TableCell Cell3 = tbl[tbl.NumRows - 1, 0]; TableCell Cell4 = tbl[tbl.NumRows - 1, 1]; Cell3.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2878, strUserLanguage), fBold); Table tblDetail = Cell4.InsertTableAfter(dtWork.Rows.Count, 2); for (int j = 0; j < dtWork.Rows.Count; j++) { tblDetail[j, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblDetail[j, 0].PreferredWidth = 30; if (dtWork.Rows[j]["StartMonthID"].ToString() != "0" && dtWork.Rows[j]["StartMonthID"].ToString() != "") tblDetail[j, 0].InsertTextAfter(CCLib.Common.Strings.GetShortMonth(Convert.ToInt32(dtWork.Rows[j]["StartMonthID"]), strUserLanguage) + " " + dtWork.Rows[j]["StartYear"].ToString().Substring(2, 2) + " - ", fText); if (dtWork.Rows[j]["EndMonthID"].ToString() != "" && dtWork.Rows[j]["EndMonthID"].ToString() != "0") { if (dtWork.Rows[j]["EndMonthID"].ToString().Trim() == "13") tblDetail[j, 0].InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2879, strUserLanguage), fText); else tblDetail[j, 0].InsertTextAfter(CCLib.Common.Strings.GetShortMonth(Convert.ToInt32(dtWork.Rows[j]["EndMonthID"]), strUserLanguage) + " " + dtWork.Rows[j]["EndYear"].ToString().Substring(2, 2), fText); } tblDetail[j, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; tblDetail[j, 1].PreferredWidth = 70; tblDetail[j, 1].InsertTextAfter(dtWork.Rows[j]["Title"].ToString(), fText); tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblDetail[j, 1].InsertTextAfter(dtWork.Rows[j]["Company"].ToString(), fTextStrong); tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblDetail[j, 1].InsertTextAfter(dtWork.Rows[j]["City"].ToString(), fText); if ((dtWork.Rows[j]["City"].ToString() != "") && (dtWork.Rows[j]["StateProv"].ToString() != "")) { tblDetail[j, 1].InsertTextAfter(", ", fText); } tblDetail[j, 1].InsertTextAfter(dtWork.Rows[j]["StateProv"].ToString(), fText); if (dtWork.Rows[j]["ExpDesc"].ToString() != "") { tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); //tblDetail[j, 1].InsertTextAfter(ch.ToString() + " ", fBullet); tblDetail[j, 1].InsertTextAfter("» " + dtWork.Rows[j]["ExpDesc"].ToString().Replace("\n", "\n» "), fText); } if (j < dtWork.Rows.Count - 1) tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); } Cell4.InsertBreakAfter(Element.BreakType.TextWrap); } } } break; case "Education": if (drPortSettings["RBEducation" + intMenuGrade].ToString() == "True") { if (dsSections.Tables["Education"] != null) { dtEdu = dsSections.Tables["Education"]; if (dtEdu.Rows.Count > 0) { tbl.AddRows(1); TableCell Cell5 = tbl[tbl.NumRows - 1, 0]; TableCell Cell6 = tbl[tbl.NumRows - 1, 1]; Cell5.InsertTextAfter("Education", fBold); Table tblDetail = Cell6.InsertTableAfter(dtEdu.Rows.Count, 2); for (int j = 0; j < dtEdu.Rows.Count; j++) { tblDetail[j, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblDetail[j, 0].PreferredWidth = 30; if (dtEdu.Rows[j]["StartMonthID"].ToString() != "0" && dtEdu.Rows[j]["StartMonthID"].ToString() != "") tblDetail[j, 0].InsertTextAfter(CCLib.Common.Strings.GetShortMonth(Convert.ToInt32(dtEdu.Rows[j]["StartMonthID"]), strUserLanguage) + " " + dtEdu.Rows[j]["StartYear"].ToString().Substring(2, 2) + " - ", fText); if (dtEdu.Rows[j]["EndMonthID"].ToString() != "" && dtEdu.Rows[j]["EndMonthID"].ToString() != "0") { if (dtEdu.Rows[j]["EndMonthID"].ToString().Trim() == "13") tblDetail[j, 0].InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2879, strUserLanguage), fText); else tblDetail[j, 0].InsertTextAfter(CCLib.Common.Strings.GetShortMonth(Convert.ToInt32(dtEdu.Rows[j]["EndMonthID"]), strUserLanguage) + " " + dtEdu.Rows[j]["EndYear"].ToString().Substring(2, 2), fText); } tblDetail[j, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; tblDetail[j, 1].PreferredWidth = 70; tblDetail[j, 1].InsertTextAfter(dtEdu.Rows[j]["School"].ToString(), fText); tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblDetail[j, 1].InsertTextAfter(dtEdu.Rows[j]["Degree"].ToString(), fTextStrong); tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblDetail[j, 1].InsertTextAfter(dtEdu.Rows[j]["City"].ToString(), fText); if ((dtEdu.Rows[j]["City"].ToString() != "") && (dtEdu.Rows[j]["StateProv"].ToString() != "")) { tblDetail[j, 1].InsertTextAfter(", ", fText); } tblDetail[j, 1].InsertTextAfter(dtEdu.Rows[j]["StateProv"].ToString(), fText); if (dtEdu.Rows[j]["EduDesc"].ToString() != "") { tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblDetail[j, 1].InsertTextAfter(ch.ToString() + " ", fBullet); tblDetail[j, 1].InsertTextAfter(dtEdu.Rows[j]["EduDesc"].ToString(), fText); } if (j < dtEdu.Rows.Count - 1) tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); } Cell6.InsertBreakAfter(Element.BreakType.TextWrap); } } } break; case "VolunteerExperience": if (strCommunityHrs == "True") { if (dsSections.Tables["VolunteerExperience"] != null) { dtComm = dsSections.Tables["VolunteerExperience"]; if (dtComm.Rows.Count > 0) { tbl.AddRows(1); TableCell Cell7 = tbl[tbl.NumRows - 1, 0]; TableCell Cell8 = tbl[tbl.NumRows - 1, 1]; Cell7.InsertTextAfter(CCLib.Common.Strings.GenerateLanguageText(5369, strUserLanguage, false, strPortTypeID), fBold); Table tblDetail = Cell8.InsertTableAfter(dtComm.Rows.Count, 2); for (int j = 0; j < dtComm.Rows.Count; j++) { tblDetail[j, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblDetail[j, 0].PreferredWidth = 30; if (dtComm.Rows[j]["StartMonthID"].ToString() != "0" && dtComm.Rows[j]["StartMonthID"].ToString() != "") tblDetail[j, 0].InsertTextAfter(CCLib.Common.Strings.GetShortMonth(Convert.ToInt32(dtComm.Rows[j]["StartMonthID"]), strUserLanguage) + " " + dtComm.Rows[j]["StartYear"].ToString().Substring(2, 2) + " - ", fText); if (dtComm.Rows[j]["EndMonthID"].ToString() != "" && dtComm.Rows[j]["EndMonthID"].ToString() != "0") { if (dtComm.Rows[j]["EndMonthID"].ToString().Trim() == "13") tblDetail[j, 0].InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2879, strUserLanguage), fText); else tblDetail[j, 0].InsertTextAfter(CCLib.Common.Strings.GetShortMonth(Convert.ToInt32(dtComm.Rows[j]["EndMonthID"]), strUserLanguage) + " " + dtComm.Rows[j]["EndYear"].ToString().Substring(2, 2), fText); } tblDetail[j, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; tblDetail[j, 1].PreferredWidth = 70; tblDetail[j, 1].InsertTextAfter(dtComm.Rows[j]["Company"].ToString(), fText); tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblDetail[j, 1].InsertTextAfter(dtComm.Rows[j]["Title"].ToString(), fTextStrong); tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblDetail[j, 1].InsertTextAfter(dtComm.Rows[j]["City"].ToString(), fText); if ((dtComm.Rows[j]["City"].ToString() != "") && (dtComm.Rows[j]["StateProv"].ToString() != "")) { tblDetail[j, 1].InsertTextAfter(", ", fText); } tblDetail[j, 1].InsertTextAfter(dtComm.Rows[j]["StateProv"].ToString(), fText); if (dtComm.Rows[j]["ExpDesc"].ToString() != "") { tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); //tblDetail[j, 1].InsertTextAfter(ch.ToString() + " ", fBullet); tblDetail[j, 1].InsertTextAfter("» " + dtComm.Rows[j]["ExpDesc"].ToString().Replace("\n", "\n» "), fText); } if (j < dtComm.Rows.Count - 1) tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); } Cell8.InsertBreakAfter(Element.BreakType.TextWrap); } } } break; case "Organization": if (strExtraOrg == "True") { if (dsSections.Tables["Organization"] != null) { dtOrg = dsSections.Tables["Organization"]; if (dtPortfolio.Rows[0]["ResumeSections"].ToString().IndexOf("OrgComments") > 0) { if (dtOrg.Rows.Count > 0) { tbl.AddRows(1); TableCell Cell3 = tbl[tbl.NumRows - 1, 0]; TableCell Cell4 = tbl[tbl.NumRows - 1, 1]; Cell3.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(5399, strUserLanguage), fBold); Table tblDetail = Cell4.InsertTableAfter(dtOrg.Rows.Count, 2); for (int j = 0; j < dtOrg.Rows.Count; j++) { tblDetail[j, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblDetail[j, 0].PreferredWidth = 30; if (dtOrg.Rows[j]["OrgStartMonth"].ToString() != "0" && dtOrg.Rows[j]["OrgStartMonth"].ToString() != "") tblDetail[j, 0].InsertTextAfter(CCLib.Common.Strings.GetShortMonth(Convert.ToInt32(dtOrg.Rows[j]["OrgStartMonth"]), strUserLanguage) + " " + dtOrg.Rows[j]["OrgStartYear"].ToString().Substring(2, 2) + " - ", fText); if (dtOrg.Rows[j]["OrgEndMonth"].ToString() != "" && dtOrg.Rows[j]["OrgEndMonth"].ToString() != "0") { if (dtOrg.Rows[j]["OrgEndMonth"].ToString().Trim() == "13") tblDetail[j, 0].InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2879, strUserLanguage), fText); else tblDetail[j, 0].InsertTextAfter(CCLib.Common.Strings.GetShortMonth(Convert.ToInt32(dtOrg.Rows[j]["OrgEndMonth"]), strUserLanguage) + " " + dtOrg.Rows[j]["OrgEndYear"].ToString().Substring(2, 2), fText); } tblDetail[j, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; tblDetail[j, 1].PreferredWidth = 70; tblDetail[j, 1].InsertTextAfter(dtOrg.Rows[j]["MyActivity"].ToString(), fTextStrong); tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); if (dtOrg.Rows[j]["OrgDescription"].ToString() != "") { tblDetail[j, 1].InsertTextAfter(ch.ToString() + " ", fBullet); tblDetail[j, 1].InsertTextAfter(dtOrg.Rows[j]["OrgDescription"].ToString(), fText); } if (j < dtOrg.Rows.Count - 1) tblDetail[j, 1].InsertBreakAfter(Element.BreakType.TextWrap); } Cell4.InsertBreakAfter(Element.BreakType.TextWrap); } } else { if (dtOrg.Rows.Count > 0) { tbl.AddRows(1); TableCell Cell11 = tbl[tbl.NumRows - 1, 0]; TableCell Cell12 = tbl[tbl.NumRows - 1, 1]; Cell11.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(5399, strUserLanguage), fBold); string strOrg = ""; for (int m = 0; m < dtOrg.Rows.Count; m++) { strOrg = strOrg + dtOrg.Rows[m]["MyActivity"].ToString() + ", "; } if (strOrg.Length > 0) strOrg = strOrg.Substring(0, strOrg.Length - 2); Table tblOrg = Cell12.InsertTableAfter(1, 1); tblOrg[0, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblOrg[0, 0].PreferredWidth = 100; tblOrg[0, 0].InsertTextAfter(strOrg, fText); Cell12.InsertBreakAfter(Element.BreakType.TextWrap); } } } } break; case "Award": if (drPortSettings["RBAwards" + intMenuGrade].ToString() == "True") { if (dsSections.Tables["Award"] != null) { dtAward = dsSections.Tables["Award"]; if (dtAward.Rows.Count > 0) { tbl.AddRows(1); TableCell Cell9 = tbl[tbl.NumRows - 1, 0]; TableCell Cell10 = tbl[tbl.NumRows - 1, 1]; Cell9.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(5398, strUserLanguage), fBold); Table tblDetail = Cell10.InsertTableAfter(dtAward.Rows.Count, 2); for (int m = 0; m < dtAward.Rows.Count; m++) { DateTime d = (DateTime)dtAward.Rows[m]["AwardDate"]; string y = d.Year.ToString().Substring(2, 2); string mm = CCLib.Common.Strings.GetShortMonth(d.Month, strUserLanguage); tblDetail[m, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblDetail[m, 0].PreferredWidth = 5; tblDetail[m, 0].VertAlignment = TableCell.VerticalAlignment.Top; tblDetail[m, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; tblDetail[m, 1].PreferredWidth = 95; tblDetail[m, 1].VertAlignment = TableCell.VerticalAlignment.Bottom; //tblDetail[m, 0].InsertTextAfter("", fText); tblDetail[m, 0].InsertTextAfter(ch.ToString(), fBullet); tblDetail[m, 1].InsertTextAfter(dtAward.Rows[m]["AwardName"].ToString() + " (" + mm + " " + y + ")", fText); } Cell10.InsertBreakAfter(Element.BreakType.TextWrap); } } } break; case "Extracurricular": if (strInterHobbies == "True") { if (dsSections.Tables["Extracurricular"] != null) { dtHobby = dsSections.Tables["Extracurricular"]; if (dtPortfolio.Rows[0]["ResumeSections"].ToString().IndexOf("ExtraComments") > 0) { if (dtHobby.Rows.Count > 0) { tbl.AddRows(1); TableCell Cell11 = tbl[tbl.NumRows - 1, 0]; TableCell Cell12 = tbl[tbl.NumRows - 1, 1]; Cell11.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(4037, strUserLanguage), fBold); Table tblDetail = Cell12.InsertTableAfter(dtHobby.Rows.Count, 2); for (int m = 0; m < dtHobby.Rows.Count; m++) { tblDetail[m, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblDetail[m, 0].PreferredWidth = 5; tblDetail[m, 0].VertAlignment = TableCell.VerticalAlignment.Top; tblDetail[m, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; tblDetail[m, 1].PreferredWidth = 95; tblDetail[m, 1].VertAlignment = TableCell.VerticalAlignment.Bottom; tblDetail[m, 0].InsertTextAfter(ch.ToString(), fBullet); tblDetail[m, 1].InsertTextAfter(dtHobby.Rows[m]["MyActivity"].ToString(), fText); if (dtHobby.Rows[m]["IntDescription"].ToString().Length > 0) tblDetail[m, 1].InsertTextAfter(" - " + dtHobby.Rows[m]["IntDescription"].ToString(), fText); } Cell12.InsertBreakAfter(Element.BreakType.TextWrap); } } else { if (dtHobby.Rows.Count > 0) { tbl.AddRows(1); TableCell Cell11 = tbl[tbl.NumRows - 1, 0]; TableCell Cell12 = tbl[tbl.NumRows - 1, 1]; Cell11.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(4037, strUserLanguage), fBold); string strExtra = ""; for (int m = 0; m < dtHobby.Rows.Count; m++) { strExtra = strExtra + dtHobby.Rows[m]["MyActivity"].ToString() + ", "; } if (strExtra.Length > 0) strExtra = strExtra.Substring(0, strExtra.Length - 2); Table tblExtra = Cell12.InsertTableAfter(1, 1); tblExtra[0, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblExtra[0, 0].PreferredWidth = 100; tblExtra[0, 0].InsertTextAfter(strExtra, fText); Cell12.InsertBreakAfter(Element.BreakType.TextWrap); } } } } break; case "Skill": if (drPortSettings["RBSkills" + intMenuGrade].ToString() == "True") { if (dsSections.Tables["Skill"] != null) { dtSkill = dsSections.Tables["Skill"]; if (dtPortfolio.Rows[0]["ResumeSections"].ToString().IndexOf("SkillsComments") > 0) { if (dtSkill.Rows.Count > 0) { tbl.AddRows(1); TableCell Cell13 = tbl[tbl.NumRows - 1, 0]; TableCell Cell14 = tbl[tbl.NumRows - 1, 1]; Cell13.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2883, strUserLanguage), fBold); Table tblDetail = Cell14.InsertTableAfter(dtSkill.Rows.Count, 2); for (int m = 0; m < dtSkill.Rows.Count; m++) { tblDetail[m, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblDetail[m, 0].PreferredWidth = 5; tblDetail[m, 0].VertAlignment = TableCell.VerticalAlignment.Top; tblDetail[m, 1].CellWidthUnits = TableCell.WidthUnits.Percentage; tblDetail[m, 1].PreferredWidth = 95; tblDetail[m, 1].VertAlignment = TableCell.VerticalAlignment.Bottom; tblDetail[m, 0].InsertTextAfter(ch.ToString(), fBullet); tblDetail[m, 1].InsertTextAfter(dtSkill.Rows[m]["Skill" + strUserLanguage].ToString(), fText); if (dtSkill.Rows[m]["SkillDesc"].ToString().Length > 0) tblDetail[m, 1].InsertTextAfter(" - " + dtSkill.Rows[m]["SkillDesc"].ToString(), fText); } Cell14.InsertBreakAfter(Element.BreakType.TextWrap); } } else { if (dtSkill.Rows.Count > 0) { tbl.AddRows(1); TableCell Cell13 = tbl[tbl.NumRows - 1, 0]; TableCell Cell14 = tbl[tbl.NumRows - 1, 1]; Cell13.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2883, strUserLanguage), fBold); string strSkill2 = ""; string strSkill1 = ""; string strSkill3 = ""; for (int m = 0; m < dtSkill.Rows.Count; m++) { if (dtSkill.Rows[m]["SkillCategoryID"].ToString() == "2") strSkill2 += dtSkill.Rows[m]["Skill" + strUserLanguage].ToString() + ", "; if (dtSkill.Rows[m]["SkillCategoryID"].ToString() == "1") strSkill1 += dtSkill.Rows[m]["Skill" + strUserLanguage].ToString() + ", "; if (dtSkill.Rows[m]["SkillCategoryID"].ToString() == "3") strSkill3 += dtSkill.Rows[m]["Skill" + strUserLanguage].ToString() + ", "; } Table tblSkill = Cell14.InsertTableAfter(1, 2); if (strSkill2.Length > 0) { strSkill2 = strSkill2.Substring(0, strSkill2.Length - 2); tblSkill.AddRows(1); TableCell cSkill1 = tblSkill[tblSkill.NumRows - 1, 0]; TableCell cSkill2 = tblSkill[tblSkill.NumRows - 1, 1]; cSkill1.CellWidthUnits = TableCell.WidthUnits.Percentage; cSkill1.PreferredWidth = 5; cSkill1.VertAlignment = TableCell.VerticalAlignment.Top; cSkill2.CellWidthUnits = TableCell.WidthUnits.Percentage; cSkill2.PreferredWidth = 95; cSkill2.VertAlignment = TableCell.VerticalAlignment.Bottom; cSkill1.InsertTextAfter(ch.ToString(), fBullet); cSkill2.InsertTextAfter(strSkill2, fText); } if (strSkill1.Length > 0) { strSkill1 = strSkill1.Substring(0, strSkill1.Length - 2); tblSkill.AddRows(1); TableCell cSkill3 = tblSkill[tblSkill.NumRows - 1, 0]; TableCell cSkill4 = tblSkill[tblSkill.NumRows - 1, 1]; cSkill3.CellWidthUnits = TableCell.WidthUnits.Percentage; cSkill3.PreferredWidth = 5; cSkill3.VertAlignment = TableCell.VerticalAlignment.Top; cSkill4.CellWidthUnits = TableCell.WidthUnits.Percentage; cSkill4.PreferredWidth = 95; cSkill4.VertAlignment = TableCell.VerticalAlignment.Bottom; cSkill3.InsertTextAfter(ch.ToString(), fBullet); cSkill4.InsertTextAfter(strSkill1, fText); } if (strSkill3.Length > 0) { strSkill3 = strSkill3.Substring(0, strSkill3.Length - 2); tblSkill.AddRows(1); TableCell cSkill5 = tblSkill[tblSkill.NumRows - 1, 0]; TableCell cSkill6 = tblSkill[tblSkill.NumRows - 1, 1]; cSkill5.CellWidthUnits = TableCell.WidthUnits.Percentage; cSkill5.PreferredWidth = 5; cSkill5.VertAlignment = TableCell.VerticalAlignment.Top; cSkill6.CellWidthUnits = TableCell.WidthUnits.Percentage; cSkill6.PreferredWidth = 95; cSkill6.VertAlignment = TableCell.VerticalAlignment.Bottom; cSkill5.InsertTextAfter(ch.ToString(), fBullet); cSkill6.InsertTextAfter(strSkill3, fText); } //tblSkill.DeleteRows(0, 0); Cell14.InsertBreakAfter(Element.BreakType.TextWrap); } } } } break; case "Additional": if (strAdditionalInfo == "True") { if (dtPortfolio.Rows[0]["AddInfo"].ToString() != "") { tbl.AddRows(1); TableCell Cell15 = tbl[tbl.NumRows - 1, 0]; TableCell Cell16 = tbl[tbl.NumRows - 1, 1]; Cell15.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2884, strUserLanguage), fBold); Table tblAdd = Cell16.InsertTableAfter(1, 1); tblAdd[0, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblAdd[0, 0].PreferredWidth = 100; tblAdd[0, 0].InsertTextAfter(dtPortfolio.Rows[0]["AddInfo"].ToString().Trim(), fText); Cell16.InsertBreakAfter(Element.BreakType.TextWrap); } } break; case "Reference": if (drPortSettings["RBReferences" + intMenuGrade].ToString() == "True") { if (dsSections.Tables["Reference"] != null) { dtRef = dsSections.Tables["Reference"]; if (dtPortfolio.Rows[0]["ResumeReference"].ToString().ToUpper() == "YES") { if (dtRef.Rows.Count > 0) { tbl.AddRows(1); TableCell Cell17 = tbl[tbl.NumRows - 1, 0]; TableCell Cell18 = tbl[tbl.NumRows - 1, 1]; Cell17.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2885, strUserLanguage), fBold); Table tblRef = Cell18.InsertTableAfter(dtRef.Rows.Count, 1); for (int m = 0; m < dtRef.Rows.Count; m++) { tblRef[m, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblRef[m, 0].PreferredWidth = 100; tblRef[m, 0].InsertTextAfter(dtRef.Rows[m]["ReferenceName"].ToString(), fTextStrong); tblRef[m, 0].InsertBreakAfter(Element.BreakType.TextWrap); tblRef[m, 0].InsertTextAfter(dtRef.Rows[m]["Title"].ToString(), fText); tblRef[m, 0].InsertBreakAfter(Element.BreakType.TextWrap); tblRef[m, 0].InsertTextAfter(dtRef.Rows[m]["CompanySchool"].ToString(), fText); if (dtRef.Rows[m]["Address1"].ToString() != "") { tblRef[m, 0].InsertBreakAfter(Element.BreakType.TextWrap); tblRef[m, 0].InsertTextAfter(dtRef.Rows[m]["Address1"].ToString(), fText); } if (dtRef.Rows[m]["Address2"].ToString() != "") { tblRef[m, 0].InsertBreakAfter(Element.BreakType.TextWrap); tblRef[m, 0].InsertTextAfter(dtRef.Rows[m]["Address2"].ToString(), fText); } if ((dtRef.Rows[m]["City"].ToString() != "") || (dtRef.Rows[m]["StateProv"].ToString() != "")) { tblRef[m, 0].InsertBreakAfter(Element.BreakType.TextWrap); tblRef[m, 0].InsertTextAfter(dtRef.Rows[m]["City"].ToString() + "," + dtRef.Rows[m]["StateProv"].ToString(), fText); } if (dtRef.Rows[m]["PostalZip"].ToString() != "") { tblRef[m, 0].InsertBreakAfter(Element.BreakType.TextWrap); tblRef[m, 0].InsertTextAfter(dtRef.Rows[m]["PostalZip"].ToString(), fText); } if (dtRef.Rows[m]["Phone"].ToString() != "") { tblRef[m, 0].InsertBreakAfter(Element.BreakType.TextWrap); tblRef[m, 0].InsertTextAfter(dtRef.Rows[m]["Phone"].ToString(), fText); } if (dtRef.Rows[m]["EmailAddress"].ToString() != "") { tblRef[m, 0].InsertBreakAfter(Element.BreakType.TextWrap); tblRef[m, 0].InsertTextAfter(dtRef.Rows[m]["EmailAddress"].ToString(), fText); } if (m < dtRef.Rows.Count - 1) tblRef[m, 0].InsertBreakAfter(Element.BreakType.TextWrap); } Cell18.InsertBreakAfter(Element.BreakType.TextWrap); } } else { tbl.AddRows(1); TableCell Cell17 = tbl[tbl.NumRows - 1, 0]; TableCell Cell18 = tbl[tbl.NumRows - 1, 1]; Cell17.InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2885, strUserLanguage), fBold); Table tblRef = Cell18.InsertTableAfter(1, 1); tblRef[0, 0].CellWidthUnits = TableCell.WidthUnits.Percentage; tblRef[0, 0].PreferredWidth = 100; tblRef[0, 0].InsertTextAfter(CCLib.Common.Strings.GeneratelanguageText(2886, strUserLanguage), fText); Cell18.InsertBreakAfter(Element.BreakType.TextWrap); } } } break; default: break; } } //tbl.DeleteRows(0, 0); } string targetfile = ConfigurationManager.AppSettings["strResumeLocation"] + "word\\Resume_Word_" + strPortfolioID + "_Professional.doc"; if (File.Exists(ConfigurationManager.AppSettings["strResumeLocation"] + "word\\Resume_Word_" + strPortfolioID + "_Professional.doc")) File.Delete(ConfigurationManager.AppSettings["strResumeLocation"] + "word\\Resume_Word_" + strPortfolioID + "_Professional.doc"); wordApp.Save(doc, targetfile); } }