public ActionResult CTR080_QuotationForCancelContractMemorandum(int iDocID) { IContractDocumentHandler contractDocHandler = ServiceContainer.GetService <IContractDocumentHandler>() as IContractDocumentHandler; List <RPTCancelContractMemoDo> rptList = contractDocHandler.GetRptCancelContractMemoData(iDocID); List <RPTCancelContractMemoDetailDo> rptListDetail = contractDocHandler.GetRptCancelContractMemoDetail(iDocID); bool isShowDefaultData = false; if (rptListDetail == null || rptListDetail.Count == 0) { rptListDetail = GetDefaultCancelContractMemoDetailData(); isShowDefaultData = true; } ReportDocument rptH = new ReportDocument(); string path = ReportUtil.GetReportPath("Reports/CTR080_QuotationForCancelContractMemorandum.rpt", Server.MapPath("/")); //string path = ReportUtil.GetReportTemplatePath("CTR080_QuotationForCancelContractMemorandum.rpt"); rptH.Load(path); rptH.SetDataSource(rptList); rptH.Subreports["CTR080_1"].SetDataSource(rptListDetail); rptH.SetParameterValue("ShowDefaultData", isShowDefaultData, "CTR080_1"); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); return(File(stream, "application/pdf")); }
public ActionResult TestReports() { IContractDocumentHandler hand = ServiceContainer.GetService <IContractDocumentHandler>() as IContractDocumentHandler; IList <RPTChangeNoticeDo> list = hand.GetRptChangeNoticeData(0); //IList<Presentation.Contract.Models.RPTChangeNoticeDo> listRpt = new List<Presentation.Contract.Models.RPTChangeNoticeDo>(); //foreach(RPTChangeNoticeDo r in list){ // var t = new Presentation.Contract.Models.RPTChangeNoticeDo(); // t=CommonUtil.CloneObject<RPTChangeNoticeDo, Presentation.Contract.Models.RPTChangeNoticeDo>(r); // listRpt.Add(t); //} ReportDocument rptH = new ReportDocument(); //var path = ReportUtil.GetReportPath("Reports/CTR020_ChangeNotice.rpt",Server.MapPath("/")); //string path = ReportUtil.GetReportTemplatePath("CTR020_ChangeNotice.rpt"); string path = PathUtil.GetPathValue(PathUtil.PathName.ReportTempatePath, "CTR020_ChangeNotice.rpt"); rptH.Load(path); rptH.SetDataSource(list); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); return(File(stream, "application/pdf")); }
public ActionResult CTR020_ChangeNotice(int iDocID) { try { IContractDocumentHandler contractDocHandler = ServiceContainer.GetService <IContractDocumentHandler>() as IContractDocumentHandler; List <RPTChangeNoticeDo> rptList = contractDocHandler.GetRptChangeNoticeData(iDocID); IDocumentHandler documentHandler = ServiceContainer.GetService <IDocumentHandler>() as IDocumentHandler; //doDocumentDataGenerate doDoc = new doDocumentDataGenerate(); //if (rptList.Count > 0) //{ // doDoc.DocumentNo = rptList[0].DocNo; // doDoc.DocumentCode = rptList[0].DocumentCode; // doDoc.DocumentData = rptList; //} //Stream stream = documentHandler.GenerateDocument(doDoc); string path = ReportUtil.GetReportPath("Reports/CTR020_ChangeNotice.rpt", Server.MapPath("/")); //string path = ReportUtil.GetReportTemplatePath("CTR020_ChangeNotice.rpt"); ReportDocument rptH = new ReportDocument(); rptH.Load(path); rptH.SetDataSource(rptList); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); return(File(stream, "application/pdf")); } catch (Exception ex) { throw; } }
public ActionResult CTR090_CoverLetter(int iDocID) { try { IContractDocumentHandler contractDocHandler = ServiceContainer.GetService <IContractDocumentHandler>() as IContractDocumentHandler; List <RPTCoverLetterDo> rptListCover = contractDocHandler.GetRptCoverLetterData(iDocID); List <RPTInstrumentDetailDo> rptListInst = contractDocHandler.GetRptInstrumentDetailData(iDocID); ReportDocument rptH = new ReportDocument(); string path = ReportUtil.GetReportPath("Reports/CTR090_CoverLetter.rpt", Server.MapPath("/")); //string path = ReportUtil.GetReportTemplatePath("CTR090_CoverLetter.rpt"); rptH.Load(path); rptH.SetDataSource(rptListCover); rptH.Subreports["CTR090_1"].SetDataSource(rptListInst); rptH.Subreports["CTR090_2"].SetDataSource(rptListInst); rptH.Subreports["CTR090_3"].SetDataSource(rptListInst); rptH.SetParameterValue("FlagOn", FlagType.C_FLAG_ON); rptH.SetParameterValue("ShowInstrument", (rptListInst != null && rptListInst.Count > 0)); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); //IDocumentHandler documentHandler = ServiceContainer.GetService<IDocumentHandler>() as IDocumentHandler; //doDocumentDataGenerate doDoc = new doDocumentDataGenerate(); //if (rptListCover.Count > 0) //{ // rptListCover[0].DocumentCode = "CTR090"; // doDoc.DocumentNo = rptListCover[0].DocNo; // doDoc.DocumentCode = rptListCover[0].DocumentCode; // doDoc.DocumentData = rptListCover; //} //List<ReportParameterObject> listSubReportDataSource = new List<ReportParameterObject>(); //listSubReportDataSource.Add(new ReportParameterObject() { SubReportName = "CTR090_1", Value = rptListInst }); //listSubReportDataSource.Add(new ReportParameterObject() { SubReportName = "CTR090_2", Value = rptListInst }); //listSubReportDataSource.Add(new ReportParameterObject() { SubReportName = "CTR090_3", Value = rptListInst }); //doDoc.SubReportDataSource = listSubReportDataSource; //List<ReportParameterObject> listMainReportParam = new List<ReportParameterObject>(); //listMainReportParam.Add(new ReportParameterObject() { ParameterName = "FlagOn", Value = FlagType.C_FLAG_ON }); //doDoc.MainReportParam = listMainReportParam; //doDoc.SubReportParam = null; //Stream stream = documentHandler.GenerateDocument(doDoc); return(File(stream, "application/pdf")); } catch (Exception ex) { throw ex; } }
public ActionResult CTR_GenerateReport(int?iDocID, string strDocNo, string strDocumentCode) { ObjectResultData res = new ObjectResultData(); IContractDocumentHandler conDocHandler = ServiceContainer.GetService <IContractDocumentHandler>() as IContractDocumentHandler; try { conDocHandler.CreateContractReport(iDocID, strDocNo, strDocumentCode); } catch (Exception ex) { res.AddErrorMessage(ex); } return(Json(res)); }
public ActionResult CTR070_ChangeFeeMemorandum(int iDocID) { IContractDocumentHandler contractDocHandler = ServiceContainer.GetService <IContractDocumentHandler>() as IContractDocumentHandler; List <RPTChangeFeeMemoDo> rptList = contractDocHandler.GetRptChangeFeeMemoData(iDocID); ReportDocument rptH = new ReportDocument(); string path = ReportUtil.GetReportPath("Reports/CTR070_ChangeFeeMemorandum.rpt", Server.MapPath("/")); //string path = ReportUtil.GetReportTemplatePath("CTR070_ChangeFeeMemorandum.rpt"); rptH.Load(path); rptH.SetDataSource(rptList); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); return(File(stream, "application/pdf")); }
public ActionResult CTR011_ContractThai(int iDocID) { IContractDocumentHandler contractDocHandler = ServiceContainer.GetService <IContractDocumentHandler>() as IContractDocumentHandler; List <RPTContractReportDo> rptList = contractDocHandler.GetRptContractReportData(iDocID); ReportDocument rptH = new ReportDocument(); string path = ReportUtil.GetReportPath("Reports/CTR011_ContractThai.rpt", Server.MapPath("/")); //string path = ReportUtil.GetReportTemplatePath("CTR011_ContractThai.rpt"); rptH.Load(path); rptH.SetDataSource(rptList); rptH.Subreports["CTR011_1"].SetDataSource(rptList); rptH.SetParameterValue("FlagOn", FlagType.C_FLAG_ON, "CTR011_1"); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); return(File(stream, "application/pdf")); }
///<summary> ///Purpose : Generate contract doc OCC ///Parameters: strCode = FN0000000017 /// strOCC = AA ///Expected : Return contract doc occ that is 02. ///</summary> public string Case2() { IContractDocumentHandler target = ServiceContainer.GetService <IContractDocumentHandler>() as IContractDocumentHandler; string strCode = "FN0000000017"; string strOCC = "AA"; string expected = "02"; string actual; try { actual = target.GenerateDocOCC(strCode, strOCC); } catch (ApplicationErrorException ex) { actual = ex.ErrorResult.Message.Code; } catch (Exception ex) { actual = ex.StackTrace; } return(string.Format(RESULT_FORMAT, 2, expected, actual, CompareResult_String(expected, actual))); }
/// <summary> /// Register data /// </summary> /// <param name="dt"></param> /// <returns></returns> private bool CTS190_Register(dtContractDocHeader dt) { List <tbt_ContractDocument> lsInsert = null; //Add by Jutarat A. on 12032013 List <tbt_ContractDocument> dtUpdate = null; //Add by Jutarat A. on 12032013 try { IContractDocumentHandler handlerCD = ServiceContainer.GetService <IContractDocumentHandler>() as IContractDocumentHandler; if (dt.IsCreateFlag) { // **tt** Create dt tbt_ContractDocument and update some field follow DDS (in case create) tbt_ContractDocument dtInsert = new tbt_ContractDocument(); dtInsert.ContractCode = dt.ContractCode; dtInsert.OCC = dt.OCC; dtInsert.DocumentCode = dt.DocumentCode; dtInsert.ContractOfficeCode = dt.ContractOfficeCode; dtInsert.OperationOfficeCode = dt.OperationOfficeCode; dtInsert.DocStatus = dt.DocStatus; dtInsert.DocAuditResult = dt.DocAuditResult; dtInsert.CollectDocDate = dt.CollectDocDate; dtInsert.IssuedDate = dt.IssuedDate; // Generate new Doc OCC string newDocOCC = ""; newDocOCC = handlerCD.GenerateDocOCC(dt.ContractCode, dt.OCC); dtInsert.ContractDocOCC = newDocOCC; dtInsert.DocNo = string.Format("{0}-{1}-{2}", dt.ContractCode, dt.OCC, newDocOCC); // Keep back dt.DocNo = string.Format("{0}-{1}-{2}", dt.ContractCode, dt.OCC, newDocOCC); //List<tbt_ContractDocument> lsInsert = new List<tbt_ContractDocument>(); lsInsert = new List <tbt_ContractDocument>(); //Modify by Jutarat A. on 12032013 lsInsert.Add(dtInsert); // Insert : InsertTbt_ContractDocument ** handlerCD.InsertTbt_ContractDocument(lsInsert); // Call UpdateContractBasic CTS190_UpdateContractBasicData(lsInsert); } else { // **tt** Get dt tbt_ContractDocument from handler and update some field follow DDS (in case update) //List<tbt_ContractDocument> dtUpdate = new List<tbt_ContractDocument>(); dtUpdate = new List <tbt_ContractDocument>(); //Modify by Jutarat A. on 12032013 if (dt.IsContractFlag.Value == true) { dtUpdate = handlerCD.GetContractDocHeaderByContractCode(dt.ContractCode, dt.OCC, dt.ContractDocOCC); } else { dtUpdate = handlerCD.GetContractDocHeaderByQuotationCode(dt.QuotationTargetCode, dt.Alphabet, dt.ContractDocOCC); } if (dtUpdate.Count == 0) { return(false); } for (int i = 0; i < dtUpdate.Count; i++) { dtUpdate[i].DocStatus = dt.DocStatus; dtUpdate[i].DocAuditResult = dt.DocAuditResult; dtUpdate[i].CollectDocDate = dt.CollectDocDate; } if (dtUpdate.Count > 1) { dtUpdate.RemoveRange(1, dtUpdate.Count - 1); } // Keep back dt.DocNo = dtUpdate[0].DocNo; // Set Not user status int isUpdated = handlerCD.SetNotUsedStatus(dtUpdate[0].ContractCode, dtUpdate[0].OCC, ContractDocStatus.C_CONTRACT_DOC_STATUS_NOT_USED, ContractDocStatus.C_CONTRACT_DOC_STATUS_COLLECTED, false, null); // Update : UpdateTbt_ContractDocument ** List <tbt_ContractDocument> tt_Updated = handlerCD.UpdateTbt_ContractDocument(dtUpdate); // Call UpdateContractBasic CTS190_UpdateContractBasicData(dtUpdate); // Update RentalSecurityBasic CTS190_UpdateRentalSecurityBasic(dtUpdate); // Update SalesBasic CTS190_UpdateSaleBasic(dtUpdate); // Update about PO (Recursive) if (dt.DocumentCode == DocumentCode.C_DOCUMENT_CODE_CONTRACT_EN || dt.DocumentCode == DocumentCode.C_DOCUMENT_CODE_CONTRACT_TH) { List <tbt_ContractDocument> dtContractDoc = handlerCD.GetContractDocHeaderByContractCode(dt.ContractCode, ParticularOCC.C_PARTICULAR_OCC_PO, null); if (dtContractDoc.Count == 0) { dtContractDocHeader dtPO = new dtContractDocHeader(); dtPO.IsCreateFlag = true; dtPO.IsContractFlag = false; dtPO.ContractCode = dtUpdate[0].ContractCode; dtPO.OCC = ParticularOCC.C_PARTICULAR_OCC_PO; dtPO.DocumentCode = DocumentCode.C_DOCUMENT_CODE_PO; dtPO.ContractOfficeCode = dtUpdate[0].ContractOfficeCode; dtPO.OperationOfficeCode = dtUpdate[0].OperationOfficeCode; dtPO.IssuedDate = CommonUtil.dsTransData.dtOperationData.ProcessDateTime; dtPO.DocStatus = ContractDocStatus.C_CONTRACT_DOC_STATUS_ISSUED; dtPO.DocAuditResult = DocAuditResult.C_DOC_AUDIT_RESULT_NO_NEED_TO_RECEIVE; // Recursive CTS190_Register(dtPO); } } } return(true); } catch (Exception ex) { //Add by Jutarat A. on 12032013 string source = "SIMS web application"; string logName = "(CTS190)Application"; string logDetail = ex.ToString(); if (!EventLog.SourceExists(source)) { EventLog.CreateEventSource(source, logName); } if (lsInsert != null && lsInsert.Count > 0) { logDetail = String.Format("{0} : {1}", ex.ToString(), CommonUtil.ConvertToXml_Store <tbt_ContractDocument>(lsInsert)); } else if (dtUpdate != null && dtUpdate.Count > 0) { logDetail = String.Format("{0} : {1}", ex.ToString(), CommonUtil.ConvertToXml_Store <tbt_ContractDocument>(dtUpdate)); } EventLog objLog = new EventLog(); objLog.Source = source; objLog.Log = logName; objLog.WriteEntry(logDetail, EventLogEntryType.Error); //End Add throw ex; } }
public ActionResult CTR060_CancelContractMemorandum(int iDocID) { try { IContractDocumentHandler contractDocHandler = ServiceContainer.GetService <IContractDocumentHandler>() as IContractDocumentHandler; List <RPTCancelContractMemoDo> rptList = contractDocHandler.GetRptCancelContractMemoData(iDocID); List <RPTCancelContractMemoDetailDo> rptListDetail = contractDocHandler.GetRptCancelContractMemoDetail(iDocID); ReportDocument rptH = new ReportDocument(); string path = ReportUtil.GetReportPath("Reports/CTR060_CancelContractMemorandum.rpt", Server.MapPath("/")); //string path = ReportUtil.GetReportTemplatePath("CTR060_CancelContractMemorandum.rpt"); rptH.Load(path); rptH.SetDataSource(rptList); rptH.Subreports["CTR060_1"].SetDataSource(rptListDetail); rptH.SetParameterValue("AutoBillingTypeNone", AutoTransferBillingType.C_AUTO_TRANSFER_BILLING_TYPE_NONE, "CTR060_1"); rptH.SetParameterValue("AutoBillingTypeAll", AutoTransferBillingType.C_AUTO_TRANSFER_BILLING_TYPE_ALL, "CTR060_1"); rptH.SetParameterValue("AutoBillingTypePartial", AutoTransferBillingType.C_AUTO_TRANSFER_BILLING_TYPE_PARTIAL, "CTR060_1"); rptH.SetParameterValue("BankBillingTypeNone", BankTransferBillingType.C_BANK_TRANSFER_BILLING_TYPE_NONE, "CTR060_1"); rptH.SetParameterValue("BankBillingTypeAll", BankTransferBillingType.C_BANK_TRANSFER_BILLING_TYPE_ALL, "CTR060_1"); rptH.SetParameterValue("BankBillingTypePartial", BankTransferBillingType.C_BANK_TRANSFER_BILLING_TYPE_PARTIAL, "CTR060_1"); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); rptH.Close(); //IDocumentHandler documentHandler = ServiceContainer.GetService<IDocumentHandler>() as IDocumentHandler; //doDocumentDataGenerate doDoc = new doDocumentDataGenerate(); //if (rptList.Count > 0) //{ // doDoc.DocumentNo = rptList[0].DocNo; // doDoc.DocumentCode = rptList[0].DocumentCode; // doDoc.DocumentData = rptList; //} //List<ReportParameterObject> listSubReportDataSource = new List<ReportParameterObject>(); //listSubReportDataSource.Add(new ReportParameterObject() { SubReportName = "CTR060_1", Value = rptListDetail }); //doDoc.SubReportDataSource = listSubReportDataSource; //doDoc.MainReportParam = null; //List<ReportParameterObject> listSubReportParam = new List<ReportParameterObject>(); //listSubReportParam.Add(new ReportParameterObject() { ParameterName = "AutoBillingTypeNone", Value = AutoTransferBillingType.C_AUTO_TRANSFER_BILLING_TYPE_NONE, SubReportName = "CTR060_1" }); //listSubReportParam.Add(new ReportParameterObject() { ParameterName = "AutoBillingTypeAll", Value = AutoTransferBillingType.C_AUTO_TRANSFER_BILLING_TYPE_ALL, SubReportName = "CTR060_1" }); //listSubReportParam.Add(new ReportParameterObject() { ParameterName = "AutoBillingTypePartial", Value = AutoTransferBillingType.C_AUTO_TRANSFER_BILLING_TYPE_PARTIAL, SubReportName = "CTR060_1" }); //listSubReportParam.Add(new ReportParameterObject() { ParameterName = "BankBillingTypeNone", Value = BankTransferBillingType.C_BANK_TRANSFER_BILLING_TYPE_NONE, SubReportName = "CTR060_1" }); //listSubReportParam.Add(new ReportParameterObject() { ParameterName = "BankBillingTypeAll", Value = BankTransferBillingType.C_BANK_TRANSFER_BILLING_TYPE_ALL, SubReportName = "CTR060_1" }); //listSubReportParam.Add(new ReportParameterObject() { ParameterName = "BankBillingTypePartial", Value = BankTransferBillingType.C_BANK_TRANSFER_BILLING_TYPE_PARTIAL, SubReportName = "CTR060_1" }); //doDoc.SubReportParam = listSubReportParam; //// doDoc2 //List<RPTCoverLetterDo> rptListCover = contractDocHandler.GetRptCoverLetterData(100); // iDocID = 100 , fixed to 100 for test //List<RPTInstrumentDetailDo> rptListInst = contractDocHandler.GetRptInstrumentDetailData(100); // iDocID = 100 , fixed to 100 for test //doDocumentDataGenerate doDoc2 = new doDocumentDataGenerate(); //if (rptListCover.Count > 0) //{ // rptListCover[0].DocumentCode = "CTR090"; // doDoc2.DocumentNo = rptListCover[0].DocNo; // doDoc2.DocumentCode = rptListCover[0].DocumentCode; // doDoc2.DocumentData = rptListCover; //} //List<ReportParameterObject> listSubReportDataSource2 = new List<ReportParameterObject>(); //listSubReportDataSource2.Add(new ReportParameterObject() { SubReportName = "CTR090_1", Value = rptListInst }); //listSubReportDataSource2.Add(new ReportParameterObject() { SubReportName = "CTR090_2", Value = rptListInst }); //listSubReportDataSource2.Add(new ReportParameterObject() { SubReportName = "CTR090_3", Value = rptListInst }); //doDoc2.SubReportDataSource = listSubReportDataSource2; //List<ReportParameterObject> listMainReportParam2 = new List<ReportParameterObject>(); //listMainReportParam2.Add(new ReportParameterObject() { ParameterName = "FlagOn", Value = FlagType.C_FLAG_ON }); //doDoc2.MainReportParam = listMainReportParam2; //doDoc2.SubReportParam = null; //Stream stream = documentHandler.GenerateDocument(doDoc, doDoc2); return(File(stream, "application/pdf")); } catch (Exception ex) { throw ex; } }