public JSON GenerateFieldWorkAuthorizationMemo(FieldWorkAuthMemo Param) { JSON returnJSON = new JSON(); Application app = new Application(); object misValue = System.Reflection.Missing.Value; if (File.Exists(FormController.ServerPathTempForms() + Param.FileName + ".docx")) { File.Delete(FormController.ServerPathTempForms() + Param.FileName + ".docx"); } try { File.Copy(FormController.ServerPathFormsTemplate() + "Field Work Authorization Memorandum.docx", FormController.ServerPathTempForms() + Param.FileName + ".docx"); Document doc = app.Documents.Open(FormController.ServerPathTempForms() + Param.FileName + ".docx"); Dictionary <string, string> bookmarks = new Dictionary <string, string> { { "ToName", GenFunct.ToTitleCase($"{Param.Employee.EmployeeFirstName} {Param.Employee.EmployeeMiddleName}. {Param.Employee.EmployeeLastName} {Param.Employee.EmployeeSuffix}") }, { "ToPosition", Param.Position.PositionDescription }, { "Subject", Param.Subject }, { "Date", Param.Date }, { "DateOfFW", Param.DateOfFieldWork }, { "TimeOfFW", $"{DateTime.Parse(Param.FromTimeOfFiedWork).ToString(@"hh\:mm tt")} to {DateTime.Parse(Param.ToTimeOfFiedWork).ToString(@"hh\:mm tt")}" }, { "ProceedDirectlyFromResidence", Param.ProceedDirectlyFromResidence }, { "PersonToSee", GenFunct.ToTitleCase($"{Param.PersonToSee.FirstName} {Param.PersonToSee.MiddleName}. {Param.PersonToSee.LastName} {Param.PersonToSee.Suffix}") }, { "OfficeBusinessName", Param.OfficeBusinessName }, { "CompleteAddress", Param.CompleteAddress }, { "Purpose", Param.Purpose }, { "OtherInstruction", Param.OtherInstruction }, }; FormToWord.ApplyDataToBookmark(bookmarks, doc); doc.Save(); doc.ExportAsFixedFormat(FormController.ServerPathTempForms() + Param.FileName + ".pdf", WdExportFormat.wdExportFormatPDF); doc.Close(); app.Quit(); LLFCForm LLFCFormObj = new LLFCForm(); LLFCFormObj.FormDownloadFile = Param.FileName; returnJSON.FormData = LLFCFormObj; } catch (Exception ex) { app.Quit(); returnJSON.Message = $"Error Occured: {ex.Message}"; } return(returnJSON); }
public JSON GenerateJobOfferForSupervisoryAndRankAndFile(JobOfferForOfficer Param) { JSON returnJSON = new JSON(); Application app = new Application(); object misValue = System.Reflection.Missing.Value; if (File.Exists(FormController.ServerPathTempForms() + Param.Filename + ".docx")) { File.Delete(FormController.ServerPathTempForms() + Param.Filename + ".docx"); } try { File.Copy(FormController.ServerPathFormsTemplate() + "Job Offer For Supervisory And Rank & File.docx", FormController.ServerPathTempForms() + Param.Filename + ".docx"); Document doc = app.Documents.Open(FormController.ServerPathTempForms() + Param.Filename + ".docx"); Dictionary <string, string> bookmarks = new Dictionary <string, string> { { "Date", Param.Date }, { "PersonName", GenFunct.ToTitleCase($"{Param.PersonName.FirstName} {Param.PersonName.MiddleName}. {Param.PersonName.LastName} {Param.PersonName.Suffix}") }, { "PositionTitle", Param.Position.PositionDescription }, { "SalaryGrade", $"{Param.SalaryGrade} / {Param.SalaryGradeStep}" }, { "MonthlySalary", Param.MonthlySalary }, { "GroupUnit", Param.GroupUnit }, { "StartDate", Param.StartDate }, { "WorkIn", Param.WorkIn }, { "WorkOut", Param.WorkOut }, }; FormToWord.ApplyDataToBookmark(bookmarks, doc); doc.Save(); doc.ExportAsFixedFormat(FormController.ServerPathTempForms() + Param.Filename + ".pdf", WdExportFormat.wdExportFormatPDF); doc.Close(); app.Quit(); LLFCForm LLFCFormObj = new LLFCForm(); LLFCFormObj.FormDownloadFile = Param.Filename; returnJSON.FormData = LLFCFormObj; } catch (Exception ex) { app.Quit(); returnJSON.Message = $"Error Occured: {ex.Message}"; } return(returnJSON); }
public JSON GenerateRequestForPayment(RequestForPayment Param) { JSON returnJSON = new JSON(); Application app = new Application(); object misValue = System.Reflection.Missing.Value; if (File.Exists(FormController.ServerPathTempForms() + Param.FileName + ".docx")) { File.Delete(FormController.ServerPathTempForms() + Param.FileName + ".docx"); } try { File.Copy(FormController.ServerPathFormsTemplate() + "Request for Payment.docx", FormController.ServerPathTempForms() + Param.FileName + ".docx"); Document doc = app.Documents.Open(FormController.ServerPathTempForms() + Param.FileName + ".docx"); Dictionary <string, string> bookmarks = new Dictionary <string, string> { { "RequestDate", Param.RequestDate }, { "Payee", Param.Payee }, { "AmountInWords", $"{NumberToText.Convert(Param.AmountInValue)} Pesos" }, { "AmountInValue", "₱ " + String.Format("{0:n}", Param.AmountInValue) }, { "Purpose", Param.Purpose }, { "DueDate", Param.DueDate }, { "PreparedBy", GenFunct.ToTitleCase($"{Param.PreparedBy.FirstName} {Param.PreparedBy.MiddleName}. {Param.PreparedBy.LastName} {Param.PreparedBy.Suffix}") }, { "FormOfPayment", GetFormOfPaymentDescription(Param.FormOfPaymentID, Param.OtherFormOfPayment) }, //{ "OtherFormOfPayment", Param.OtherFormOfPayment }, { "RecommendedBy", GenFunct.ToTitleCase($"{Param.RecommendedBy.FirstName} {Param.RecommendedBy.MiddleName}. {Param.RecommendedBy.LastName} {Param.RecommendedBy.Suffix}") } }; FormToWord.ApplyDataToBookmark(bookmarks, doc); doc.Save(); doc.Close(); app.Quit(); LLFCForm LLFCFormObj = new LLFCForm(); LLFCFormObj.FormDownloadFile = Param.FileName; returnJSON.FormData = LLFCFormObj; } catch (Exception ex) { app.Quit(); returnJSON.Message = $"Error Occured: {ex.Message}"; } return(returnJSON); }
public JSON GeneratePurchaseRequest(PurchaseRequest Param) { JSON returnJSON = new JSON(); Application app = new Application(); object misValue = System.Reflection.Missing.Value; if (File.Exists(FormController.ServerPathTempForms() + Param.FileName + ".docx")) { File.Delete(FormController.ServerPathTempForms() + Param.FileName + ".docx"); } try { File.Copy(FormController.ServerPathFormsTemplate() + "Purchase Request.docx", FormController.ServerPathTempForms() + Param.FileName + ".docx"); Document doc = app.Documents.Open(FormController.ServerPathTempForms() + Param.FileName + ".docx"); Dictionary <string, string> bookmarks = new Dictionary <string, string> { { "GroupUnit", Param.GroupUnit.GroupUnitDescription }, { "Date", Param.Date }, { "Purpose", Param.Purpose }, { "Attachments", Param.Attachments } }; Table PurchaseItemRequest = doc.Tables[2]; int TableRowCount = PurchaseItemRequest.Rows.Count; int itemCount = Param.Items.Count; for (int i = 0; i <= TableRowCount; i++) { int row = i + 2; PurchaseItemRequest.Cell(row, 1).Range.Text = Param.Items[i].Quantity.ToString(); PurchaseItemRequest.Cell(row, 2).Range.Text = Param.Items[i].Unit.ToString(); PurchaseItemRequest.Cell(row, 3).Range.Text = Param.Items[i].ItemDescription.ToString(); PurchaseItemRequest.Cell(row, 4).Range.Text = Param.Items[i].EstimatedUnitCost.ToString(); PurchaseItemRequest.Cell(row, 5).Range.Text = Param.Items[i].EstimatedCost.ToString(); itemCount = itemCount - 1; if (itemCount == 0) { break; } } FormToWord.ApplyDataToBookmark(bookmarks, doc); doc.Save(); doc.ExportAsFixedFormat(FormController.ServerPathTempForms() + Param.FileName + ".pdf", WdExportFormat.wdExportFormatPDF); doc.Close(); app.Quit(); LLFCForm LLFCFormObj = new LLFCForm(); LLFCFormObj.FormDownloadFile = Param.FileName; returnJSON.FormData = LLFCFormObj; } catch (Exception ex) { app.Quit(); returnJSON.Message = $"Error Occured: {ex.Message}"; } return(returnJSON); }
public JSON GenerateWebsiteJobRequest(WebsiteJobRequest Param) { JSON returnJSON = new JSON(); Application app = new Application(); object misValue = System.Reflection.Missing.Value; if (File.Exists(FormController.ServerPathTempForms() + Param.FileName + ".docx")) { File.Delete(FormController.ServerPathTempForms() + Param.FileName + ".docx"); } try { File.Copy(FormController.ServerPathFormsTemplate() + "Website Job Request Form.docx", FormController.ServerPathTempForms() + Param.FileName + ".docx"); Document doc = app.Documents.Open(FormController.ServerPathTempForms() + Param.FileName + ".docx"); Dictionary <string, string> bookmarks = new Dictionary <string, string> { { "RequestedBy", GenFunct.ToTitleCase($"{Param.RequestedBy.EmployeeFirstName} {Param.RequestedBy.EmployeeMiddleName}. {Param.RequestedBy.EmployeeLastName} {Param.RequestedBy.EmployeeSuffix}") }, { "ConfirmedBy", GenFunct.ToTitleCase($"{Param.ConfirmedBy.EmployeeFirstName} {Param.ConfirmedBy.EmployeeMiddleName}. {Param.ConfirmedBy.EmployeeLastName} {Param.ConfirmedBy.EmployeeSuffix}") }, }; Table JobRequestContents = doc.Tables[1]; int TableRowCount = JobRequestContents.Rows.Count; int itemCount = Param.WebsiteContentRequest.Count; for (int i = 0; i <= TableRowCount; i++) { int row = i + 2; JobRequestContents.Cell(row, 1).Range.Text = Param.WebsiteContentRequest[i].ContentRequest.ToString(); JobRequestContents.Cell(row, 2).Range.Text = Param.WebsiteContentRequest[i].Comments.ToString(); itemCount = itemCount - 1; if (itemCount == 0) { break; } } FormToWord.ApplyDataToBookmark(bookmarks, doc); doc.Save(); doc.ExportAsFixedFormat(FormController.ServerPathTempForms() + Param.FileName + ".pdf", WdExportFormat.wdExportFormatPDF); doc.Close(); app.Quit(); LLFCForm LLFCFormObj = new LLFCForm(); LLFCFormObj.FormDownloadFile = Param.FileName; returnJSON.FormData = LLFCFormObj; } catch (Exception ex) { app.Quit(); returnJSON.Message = $"Error Occured: {ex.Message}"; } return(returnJSON); }
public JSON GenerateITAccessRequest(ITAccessRequest Param) { JSON returnJSON = new JSON(); Application app = new Application(); object misValue = System.Reflection.Missing.Value; if (File.Exists(FormController.ServerPathTempForms() + Param.FileName + ".docx")) { File.Delete(FormController.ServerPathTempForms() + Param.FileName + ".docx"); } try { File.Copy(FormController.ServerPathFormsTemplate() + "IT Access Request.docx", FormController.ServerPathTempForms() + Param.FileName + ".docx"); Document doc = app.Documents.Open(FormController.ServerPathTempForms() + Param.FileName + ".docx"); Dictionary <string, string> bookmarks = new Dictionary <string, string> { { "EmployeeName", GenFunct.ToTitleCase($"{Param.Employee.EmployeeFirstName} {Param.Employee.EmployeeMiddleName}. {Param.Employee.EmployeeLastName} {Param.Employee.EmployeeSuffix}") }, { "EmployeeCode", Param.Employee.EmployeeCode.ToString() }, { "Position", Param.Position.PositionDescription }, { "GroupUnit", Param.GroupUnit.GroupUnitDescription }, }; if (Param.LLFCEmail.Selected == 1) { IfYes(bookmarks, "LLFCEmailYes", "LLFCEmailRemarks", Param.LLFCEmail.Remarks); } else { IfYes(bookmarks, "LLFCEmailNo", "LLFCEmailRemarks", Param.LLFCEmail.Remarks); } if (Param.Internet.Selected == 1) { IfYes(bookmarks, "InternetYes", "InternetRemarks", Param.Internet.Remarks); } else { IfYes(bookmarks, "InternetNo", "InternetRemarks", Param.Internet.Remarks); } if (Param.MainEntrance.Selected == 1) { IfYes(bookmarks, "MainEntranceYes", "MainEntranceRemarks", Param.MainEntrance.Remarks); } else { IfYes(bookmarks, "MainEntranceNo", "MainEntranceRemarks", Param.MainEntrance.Remarks); } if (Param.SecurityRoom.Selected == 1) { IfYes(bookmarks, "SecurityRoomYes", "SecurityRoomRemarks", Param.SecurityRoom.Remarks); } else { IfYes(bookmarks, "SecurityRoomNo", "SecurityRoomRemarks", Param.SecurityRoom.Remarks); } if (Param.ServerRoom.Selected == 1) { IfYes(bookmarks, "ServerRoomYes", "ServerRoomRemarks", Param.ServerRoom.Remarks); } else { IfYes(bookmarks, "ServerRoomNo", "ServerRoomRemarks", Param.ServerRoom.Remarks); } if (Param.PrinterBlackCopy.Selected == 1) { IfYes(bookmarks, "PrinterBlackYes", "PrinterBlackRemarks", Param.PrinterBlackCopy.Remarks); } else { IfYes(bookmarks, "PrinterBlackNo", "PrinterBlackRemarks", Param.LLFCEmail.Remarks); } if (Param.PrinterColoredCopy.Selected == 1) { IfYes(bookmarks, "PrinterColoredYes", "PrinterColoredRemarks", Param.PrinterColoredCopy.Remarks); } else { IfYes(bookmarks, "PrinterColoredNo", "PrinterColoredRemarks", Param.PrinterColoredCopy.Remarks); } if (Param.Telephone.Selected == 1) { IfYes(bookmarks, "TelephoneYes", "TelephoneRemarks", Param.Telephone.Remarks); } else { IfYes(bookmarks, "TelephoneNo", "TelephoneRemarks", Param.Telephone.Remarks); } if (Param.Biometrics.Selected == 1) { IfYes(bookmarks, "BiometricsYes", "BiometricsRemarks", Param.Biometrics.Remarks); } else { IfYes(bookmarks, "BiometricsNo", "BiometricsRemarks", Param.Biometrics.Remarks); } if (Param.Jeonsoft.Selected == 1) { IfYes(bookmarks, "JPSYes", "JPSRemarks", Param.Jeonsoft.Remarks); } else { IfYes(bookmarks, "JPSNo", "JPSRemarks", Param.Jeonsoft.Remarks); } if (Param.DMS.Selected == 1) { IfYes(bookmarks, "DMSYes", "DMSRemarks", Param.DMS.Remarks); } else { IfYes(bookmarks, "DMSNo", "DMSRemarks", Param.DMS.Remarks); } if (Param.FMS.Selected == 1) { IfYes(bookmarks, "FMSYes", "FMSRemarks", Param.FMS.Remarks); } else { IfYes(bookmarks, "FMSNo", "FMSRemarks", Param.FMS.Remarks); } if (Param.Jet.Selected == 1) { IfYes(bookmarks, "JetReportsYes", "JetReportsRemarks", Param.Jet.Remarks); } else { IfYes(bookmarks, "JetReportsNo", "JetReportsRemarks", Param.Jet.Remarks); } FormToWord.ApplyDataToBookmark(bookmarks, doc); doc.Save(); doc.ExportAsFixedFormat(FormController.ServerPathTempForms() + Param.FileName + ".pdf", WdExportFormat.wdExportFormatPDF); doc.Close(); app.Quit(); LLFCForm LLFCFormObj = new LLFCForm(); LLFCFormObj.FormDownloadFile = Param.FileName; returnJSON.FormData = LLFCFormObj; } catch (Exception ex) { app.Quit(); returnJSON.Message = $"Error Occured: {ex.Message}"; } return(returnJSON); }
public JSON GenerateITIssuance(ITIssuance Param) { JSON returnJSON = new JSON(); Application app = new Application(); object misValue = System.Reflection.Missing.Value; if (File.Exists(FormController.ServerPathTempForms() + Param.FileName + ".docx")) { File.Delete(FormController.ServerPathTempForms() + Param.FileName + ".docx"); } try { File.Copy(FormController.ServerPathFormsTemplate() + "IT Issuance.docx", FormController.ServerPathTempForms() + Param.FileName + ".docx"); Document doc = app.Documents.Open(FormController.ServerPathTempForms() + Param.FileName + ".docx"); Dictionary <string, string> bookmarks = new Dictionary <string, string> { { "ControlNumber", Param.ControlNumber }, { "Date", Param.Date }, { "IssuedTo", GenFunct.ToTitleCase($"{Param.EmployeeFullName.EmployeeFirstName} {Param.EmployeeFullName.EmployeeMiddleName}. {Param.EmployeeFullName.EmployeeLastName} {Param.EmployeeFullName.EmployeeSuffix}") }, { "Unit", Param.GroupUnit.GroupUnitDescription }, }; Table EquipmentSpec = doc.Tables[2]; int TableRowCount = EquipmentSpec.Rows.Count; int itemCount = Param.EquipmentSpecification.Count; for (int i = 0; i <= TableRowCount; i++) { int row = i + 2; EquipmentSpec.Cell(row, 1).Range.Text = Param.EquipmentSpecification[i].Quantity.ToString(); EquipmentSpec.Cell(row, 2).Range.Text = Param.EquipmentSpecification[i].Unit.ToString(); EquipmentSpec.Cell(row, 3).Range.Text = Param.EquipmentSpecification[i].Particulars.ToString(); EquipmentSpec.Cell(row, 4).Range.Text = Param.EquipmentSpecification[i].AcquisitionCost.ToString(); EquipmentSpec.Cell(row, 5).Range.Text = Param.EquipmentSpecification[i].PropertyNumber.ToString(); itemCount = itemCount - 1; if (itemCount == 0) { break; } } FormToWord.ApplyDataToBookmark(bookmarks, doc); doc.Save(); doc.Close(); app.Quit(); LLFCForm LLFCFormObj = new LLFCForm(); LLFCFormObj.FormDownloadFile = Param.FileName; returnJSON.FormData = LLFCFormObj; } catch (Exception ex) { app.Quit(); returnJSON.Message = $"Error Occured: {ex.Message}"; } return(returnJSON); }