public ActionResult PrintLTO(string tCOI, string LTOType, string PrefixLTO) { var ListLTO = (from chrgd in db.T_BILLCHRGD from mpaip in db.M_PAIP from chrgh in db.T_BILLCHRGH where chrgd.BCHCHRGNO == chrgh.BCHCHRGNO && mpaip.PAPIN == chrgh.PAPIN && chrgd.COLORNUM != null && chrgd.COI == tCOI && mpaip.NON_LTO == LTOType select new { chrgh.BCHDTE, mpaip.PALNAME, mpaip.FIRST_NAME, mpaip.MIDDLE_NAME, mpaip.COMPANY_NAME, mpaip.BY_COMPNAME, chrgd.BCDPATCOVER, chrgd.BCDSERIES, chrgd.SUM_INSIRED, chrgd.BCDTPPCOVER, chrgd.BCHCHRGNO, mpaip.MODEL_YR, chrgd.COI, chrgd.AUTHEN_CODE, chrgd.BCDSINO, mpaip.PAADDRESS, mpaip.PLATE_NO, mpaip.NON_LTO, mpaip.MAKE, mpaip.SERIAL_NO, mpaip.COLOR, mpaip.UN_WEIGHT, mpaip.COMP_ID, chrgd.INCEPTION_FROM, chrgd.INCEPTION_TO, mpaip.MOTOR_NO, chrgd.COLORNUM, mpaip.SERVICE_TYPE, mpaip.SEATING_CAPACITY, mpaip.MV_FILENO, chrgd.PRNT, chrgd.DATE_PRINTED, chrgd.COC_SERIES}).FirstOrDefault(); var listR_SGSI = (from sgseries in db.R_SGSI where sgseries.PREFIX == PrefixLTO select sgseries).FirstOrDefault(); var m_CompID = (from compid in db.M_COMPANY select compid.COMP_ID).FirstOrDefault(); decimal currentSERIES = Convert.ToDecimal(listR_SGSI.SGSERIES) + 1; var prefix = listR_SGSI.PREFIX; var PolicyNo = prefix + currentSERIES.ToString("0000000"); var CertOfCover = m_CompID + currentSERIES.ToString("0000000"); LTO oLTO = new LTO(); oLTO.AUTHENCODE = ListLTO.AUTHEN_CODE; oLTO.BCDPATCOVER = Convert.ToDecimal(ListLTO.BCDPATCOVER); oLTO.BCDSERIES = ListLTO.BCDSERIES; oLTO.BCDSINO = ListLTO.BCDSINO; oLTO.BCDTPPCOVER = Convert.ToDecimal(ListLTO.BCDTPPCOVER); oLTO.BCHCHRGNO = ListLTO.BCHCHRGNO; oLTO.BCHDTE = Convert.ToDateTime(ListLTO.BCHDTE); oLTO.ByCOMPNAME = ListLTO.BY_COMPNAME.ToString(); //Incremented COC oLTO.COCSERIES = CertOfCover; oLTO.COI = PolicyNo; //sdkjhaskdhaskjhdkasj oLTO.COLOR = ListLTO.COLOR; oLTO.COLORNUM = ListLTO.COLORNUM; oLTO.CompanyName = ListLTO.COMPANY_NAME; oLTO.COMPID = ListLTO.COMP_ID; oLTO.DATEPRINTED = Convert.ToDateTime(ListLTO.DATE_PRINTED); oLTO.FirstName = ListLTO.FIRST_NAME; oLTO.INCEPTIONFROM = Convert.ToDateTime(ListLTO.INCEPTION_FROM); oLTO.INCEPTIONTO = Convert.ToDateTime(ListLTO.INCEPTION_TO); oLTO.MAKE = ListLTO.MAKE; oLTO.MiddleName = ListLTO.MIDDLE_NAME; oLTO.MODELYR = ListLTO.MODEL_YR; oLTO.MOTORNO = ListLTO.MOTOR_NO; oLTO.MVFILENO = ListLTO.MV_FILENO; oLTO.NONLTO = ListLTO.NON_LTO.ToString(); oLTO.PAADDRESS = ListLTO.PAADDRESS; oLTO.PALNAME = ListLTO.PALNAME; oLTO.PLATENO = ListLTO.PLATE_NO; oLTO.PRNT = ListLTO.PRNT; oLTO.SEATINGCAPACITY = ListLTO.SEATING_CAPACITY; oLTO.SERIALNO = ListLTO.SERIAL_NO; //Add to encryption string notEncrypted = "PAT COVER: " + oLTO.BCDPATCOVER + " PLATE: " + oLTO.PLATENO + " AUTHENTICATION CODE: " + oLTO.AUTHENCODE ; if (ListLTO.SERVICE_TYPE == null) { oLTO.SERVICETYPE = ""; } else { oLTO.SERVICETYPE = ListLTO.SERVICE_TYPE; } oLTO.SUMINSIRED = Convert.ToDecimal(ListLTO.SUM_INSIRED); oLTO.UNWEIGHT = ListLTO.UN_WEIGHT; //Missing encryption for reference //Increments and updates SGSERIES //return View(); //updateSGSERIES(PrefixLTO); return generateLTORPT(oLTO, LTOType); }
public ActionResult generateLTORPT(LTO listLTOObject, string ltoTypeParam) { List<LTO> ltoList = new List<LTO>(); ltoList.Add(listLTOObject); var path = ""; switch (ltoTypeParam) { case "0": path = crpathLTO; break; case "1": path = crpathNONLTO; break; default: break; } if (ltoTypeParam == "0") { RptLTO rptH = new RptLTO(); rptH.FileName = Server.MapPath(path); rptH.Load(); rptH.SetDataSource(ltoList); rptH.SetParameterValue("encodedField", generateEncodedField()); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); return File(stream, "application/pdf"); } else if (ltoTypeParam == "1") { RptNonLTO rptNON = new RptNonLTO(); rptNON.FileName = Server.MapPath(path); rptNON.Load(); rptNON.SetDataSource(ltoList); rptNON.SetParameterValue("encodedField", generateEncodedField()); Stream stream = rptNON.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); return File(stream, "application/pdf"); } else { return null; } }