private void IndexBtn_Click(object sender, RibbonControlEventArgs e) { try { XLDocument.currentDoc.Save(); //populate description string desc = XLDocument.ReadParameter("DocType"); desc += " to "; desc += XLDocument.ReadBookmark("Addressee"); string str = XLDocument.ReadParameter("CRMid"); XLMain.Client client = new XLMain.Client(); if (str != "") { client = XLMain.Client.FetchClient(str); } else { ClientForm cForm = new ClientForm(); cForm.ShowDialog(); client = cForm.selectedClient; } XLMain.Staff writer = new XLMain.Staff(); string writerID = XLDocument.ReadParameter("Sender"); if (writerID == "") { writer = XLMain.Staff.StaffFromUser(Environment.UserName); } else { writer = XLMain.Staff.StaffFromUser(XLDocument.ReadParameter("Sender")); } VCForm myForm = new VCForm(writer, client, XLDocument.currentDoc.FullName, desc, XLDocument.ReadParameter("VCStatus")); myForm.ShowDialog(); //collect result from form XLVirtualCabinet.BondResult outcome = myForm.outcome; if (outcome.ExitCode == 0) { XLDocument.EndDocument(); xlTaskPane1.Dispose(); } else { MessageBox.Show("Unable to index document, please index manually. Error code: " + outcome.ExitCode.ToString() + "-" + outcome.StandardOutput.ToString()); } //close the dialog in any event. } catch (Exception ex) { MessageBox.Show("Error calling the VC integration. Error code: " + ex.ToString()); XLtools.LogException("IndexBtn", ex.ToString()); } }
private void UpdateDatebtn_Click(object sender, RibbonControlEventArgs e) { string date = XLDocument.ReadBookmark("Date"); //check to see if bookmark exists, if not just insert date. if (String.IsNullOrEmpty(date)) { XLDocument.InsertText(DateTime.Now.ToString("d MMMM yyyy")); } else { XLDocument.UpdateBookmark("Date", DateTime.Now.ToString("d MMMM yyyy")); XLDocument.UpdateBookmark("Date2", DateTime.Now.ToString("d MMMM yyyy")); } }
private void UpdateRefBtn_Click(object sender, RibbonControlEventArgs e) { string fileID = XLDocument.GetFileID(); if (fileID == DateTime.Now.ToString("yyyy-MM-dd")) { MessageBox.Show("Unable to find FileID. If the document has not yet been placed in VC click First Index."); } else { string ourRef = XLDocument.ReadBookmark("OurRef"); //check to see if bookmark exists, if not just insert date. if (String.IsNullOrEmpty(ourRef)) { XLDocument.InsertText(fileID); } else { ourRef += @"/" + fileID; XLDocument.UpdateBookmark("OurRef", ourRef); } } }
public static string CheckBookmark(string defaultString, string bName, int bold = 2) { try { string rtnString = ""; string bValue = XLDocument.ReadBookmark(bName); if (bValue != "") { rtnString = bValue; } else { rtnString = defaultString; UpdateBookmark(bName, rtnString, bold); } return(rtnString); } catch (Exception e) { MessageBox.Show("Unable to check bookmark"); XLtools.LogException("CheckBookmark", e.ToString()); return(null); } }
public static string CheckParamter(string defaultString, string pName) { try { string rtnString = ""; string pValue = XLDocument.ReadBookmark(pName); if (pValue != "") { rtnString = pValue; } else { rtnString = defaultString; UpdateParameter(pName, rtnString); } return(rtnString); } catch (Exception e) { MessageBox.Show("Unable to check parameter"); XLtools.LogException("CheckParameter", e.ToString()); return(null); } }
private void ApproveBtn_Click(object sender, RibbonControlEventArgs e) { try { Microsoft.Office.Interop.Word._Application app = Globals.ThisAddIn.Application; XLDocument.ChangeStatus("Approved"); XLMain.Client client = null; string fileID = XLDocument.GetFileID(); if (String.IsNullOrEmpty(fileID)) { return; } if (XLDocument.ReadParameter("CRMid") != null) { client = XLMain.Client.FetchClient(XLDocument.ReadParameter("CRMid")); } else { //if the document param doesn't exist get the index data from VC client = XLVirtualCabinet.GetClientFromIndex(fileID); } XLMain.Staff writer = new XLMain.Staff(); string writerID = XLDocument.ReadParameter("Sender"); if (writerID == "") { writer = XLMain.Staff.StaffFromUser(Environment.UserName); } else { writer = XLMain.Staff.StaffFromUser(XLDocument.ReadParameter("Sender")); } StaffSelectForm myForm = new XLForms.StaffSelectForm(client, writer); myForm.ShowDialog(); XLMain.EntityCouplet staff = myForm.selectedStaff; if (myForm.DialogResult == DialogResult.OK) { if (staff == null) { //make blank if no staff selected staff.name = ""; } string commandfileloc = ""; if (XLDocument.ReadBookmark("Date") == "") { commandfileloc = XLVirtualCabinet.Reindex(fileID, staff.name, XLDocument.ReadParameter("VCStatus")); } else { string docDate = XLDocument.ReadBookmark("Date"); commandfileloc = XLVirtualCabinet.Reindex(fileID, staff.name, XLDocument.ReadParameter("VCStatus"), docDate); } XLVirtualCabinet.BondResult result = XLVirtualCabinet.LaunchCabi(commandfileloc, true); if (result.ExitCode != 0) { MessageBox.Show("Reindex failed please complete manually"); } else { app.ActiveDocument.Save(); app.ActiveWindow.Close(); } } } catch (Exception ex) { MessageBox.Show("Unable to approve document"); XLtools.LogException("ApproveBtn", ex.ToString()); } }
private void ForwardBtn_Click(object sender, RibbonControlEventArgs e) { try { XLMain.Client client = null; string fileID = XLDocument.GetFileID(); if (String.IsNullOrEmpty(fileID)) { return; } if (XLDocument.ReadParameter("CRMid") != null) { client = XLMain.Client.FetchClient(XLDocument.ReadParameter("CRMid")); } else { //if the document param doesn't exist get the index data from VC client = XLVirtualCabinet.GetClientFromIndex(fileID); } XLMain.Staff writer = new XLMain.Staff(); string writerID = XLDocument.ReadParameter("Sender"); if (writerID == "") { writer = XLMain.Staff.StaffFromUser(Environment.UserName); } else { writer = XLMain.Staff.StaffFromUser(XLDocument.ReadParameter("Sender")); } StaffSelectForm myForm = new StaffSelectForm(client, writer); myForm.ShowDialog(); XLMain.EntityCouplet staff = myForm.selectedStaff; string commandfileloc = ""; if (XLDocument.ReadBookmark("Date") == "") { commandfileloc = XLVirtualCabinet.Reindex(XLDocument.GetFileID(), staff.name); } else { string docDate = XLDocument.ReadBookmark("Date"); commandfileloc = XLVirtualCabinet.Reindex(XLDocument.GetFileID(), staff.name, docDate: docDate); } //MessageBox.Show(commandfileloc); XLVirtualCabinet.BondResult result = XLVirtualCabinet.LaunchCabi(commandfileloc, true); if (result.ExitCode != 0) { MessageBox.Show("Reindex failed please complete manually."); } else { XLDocument.EndDocument(); } } catch (Exception ex) { MessageBox.Show("Unable to forward document"); XLtools.LogException("ForwardBtn", ex.ToString()); } }