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;
}
}
