public async Task<VehicleModel> SearchMPAIP(string splate, string schasis, string sengineNo)
{
M_PAIP vehicle = new M_PAIP();
VehicleModel vehiclemodel = new VehicleModel();
vehicle = rctpl_db.M_PAIP.Where(r => r.PLATE_NO.Equals(splate) && (r.SERIAL_NO.Equals(schasis) || r.MOTOR_NO.Equals(sengineNo))).FirstOrDefault();
if (vehicle != null)
{
vehiclemodel.papin = vehicle.PAPIN;
vehiclemodel.plateno = vehicle.PLATE_NO;
vehiclemodel.chasisno = vehicle.SERIAL_NO;
vehiclemodel.engineno = vehicle.MOTOR_NO;
vehiclemodel.yearmodel = vehicle.MODEL_YR;
vehiclemodel.make = vehicle.MAKE;
vehiclemodel.series = vehicle.SERIES;
vehiclemodel.color = vehicle.COLOR;
vehiclemodel.unladed_weight = vehicle.UN_WEIGHT;
vehiclemodel.mvfile = vehicle.MV_FILENO;
}
else {
return null;
}
return vehiclemodel;
}
private bool Save_TbillChrgD(string chrgno, string vehiclecode, string papin, string name, string invoiceNum, string region, M_PAIP mpaip, string transtype)
{
try
{
TBL_VEHICLES myvehicle = (TBL_VEHICLES)TempData["myvehicle"];
T_BILLCHRGD tbillchrgD = new T_BILLCHRGD();
tbillchrgD.BCHCHRGNO = chrgno;
tbillchrgD.BCDSERIES = 1;
tbillchrgD.BCDITMCD = myvehicle.SERVICE_CODE;
tbillchrgD.BCDESC = myvehicle.SERVICE_TYPE;
tbillchrgD.BCDQTY = 1; //- quantity , usually 1 lng plge, unless mgadd ng ibng charges
//tbillchrgD.BCDSP = not needed
tbillchrgD.BCDPATCOVER = myvehicle.TOTAL_AMOUNT; // total amount po ito, same xa sa BCDPATBAL, ang difference lng nila ung, BCDPATBAL mg 0 kpg bayad na
tbillchrgD.BCDPATBAL = myvehicle.TOTAL_AMOUNT;
tbillchrgD.BCDTPPCOVER = 0; //for AR amount po sana to, kso ang treatment sa AR prang CASH n din, kya 0 value nlng muna
tbillchrgD.DISCCD = "0"; //discount , if applicable
// tbillchrgD.TPCD = 0;TPCD - agent code
tbillchrgD.BCDTPPTAG = "2"; //2 is for web
//tbillchrgD.COLORNUM = if paid
tbillchrgD.BCDSINO = invoiceNum; //invoice Number
tbillchrgD.DOC_STAMP = myvehicle.DOC_STAMP;
tbillchrgD.E_VAT = myvehicle.VAT;
tbillchrgD.LGT = myvehicle.LGT;
tbillchrgD.SUM_INSIRED = myvehicle.SUM_INSURED;
tbillchrgD.COMP_FEE = myvehicle.COMP_FEE;
tbillchrgD.CERT_FEE = myvehicle.CERT_FEE;
tbillchrgD.BASIC_PREMIUM = myvehicle.BASIC_PREMIUM;
// tbillchrgD.DOC_OR = OR Number
// tbillchrgD.COI = COI Number
tbillchrgD.COMMISSION = 0;
//tbillchrgD.AUTHEN_CODE
tbillchrgD.TAX_AMT = 0;
tbillchrgD.WITH_COM = "1";
tbillchrgD.W_TAX = 0;
tbillchrgD.W_TAX_NET = 0;
//tbillchrgD.NO_DAYS for pro rata
tbillchrgD.PRO_RATA = "0";
tbillchrgD.REG_TYPE = "CTPL";
tbillchrgD.TRANS_TYPE = transtype;
tbillchrgD.REGION = region;
tbillchrgD.VEHICLE_NUMBER = myvehicle.VEHICLE_NUMBER;
tbillchrgD.VEHICLE_CODE = myvehicle.VEHICLE_CODE;
tbillchrgD.REF_NUM = invoiceNum;
rctpl_db.T_BILLCHRGD.Add(tbillchrgD);
rctpl_db.SaveChanges();
COCModel mycoc = new COCModel();
mycoc.papin = papin;
mycoc.name = name;
mycoc.bchrgno = chrgno;
mycoc.plateNo = mpaip.PLATE_NO;
mycoc.chasis = mpaip.SERIAL_NO;
mycoc.invoicenum = invoiceNum;
mycoc.YearCoverage = myvehicle.PACKAGE_DESC;
mycoc.DOC_STAMP = myvehicle.DOC_STAMP;
mycoc.E_VAT = myvehicle.VAT;
mycoc.LGT = myvehicle.LGT;
mycoc.SUM_INSIRED = myvehicle.SUM_INSURED;
mycoc.COMP_FEE = myvehicle.COMP_FEE;
mycoc.CERT_FEE = myvehicle.CERT_FEE;
mycoc.BASIC_PREMIUM = myvehicle.BASIC_PREMIUM;
mycoc.VEHICLE_NUMBER = myvehicle.VEHICLE_NUMBER;
mycoc.VEHICLE_CODE = myvehicle.VEHICLE_CODE;
mycoc.TOTAL_AMOUNT = myvehicle.TOTAL_AMOUNT;
TempData["COCData"] = mycoc;
myclass.myMainCOC = mycoc;
//Save data to T_SINO Tables
Save_TSino(chrgno, invoiceNum, Convert.ToDecimal(myvehicle.TOTAL_AMOUNT));
return true;
}
catch (DbEntityValidationException ex)
{
string errorMessages = string.Join("; ", ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage));
throw new DbEntityValidationException(errorMessages);
}
}
public async Task<ActionResult> COCSubmit(M_PAIP mpaip, string transtype, string papinNo)
{
try
{
string mypapin;
string myInvoiceNum = "NV" + Yfunction.generateSerial(7, myElement);
string chrgno = "BH" + Yfunction.generateSerial(12, myElement);
mpaip.PAREGISTER = rctpl_function.GetServerDate();//DateTime.Now;
if (papinNo == "NO PAPIN" || papinNo == "")
{
mypapin = Yfunction.generateSerial(12, myElement);
mpaip.PAPIN = mypapin;
}
else {
mypapin = papinNo;
mpaip.PAPIN = papinNo;
}
TBL_VEHICLES Svehicle = new TBL_VEHICLES();
Svehicle = rctpl_db.TBL_VEHICLES.Where(r => r.VEHICLE_CODE.Equals(mpaip.VEHICLE_TYPE)).FirstOrDefault();
TempData["myvehicle"] = Svehicle;
if (ModelState.IsValid)
{
if (papinNo == "NO PAPIN" || papinNo == "")
{
//check if vehicle class is LTO or NON-LTO based on vehicle Class
if (mpaip.VEHICLE_CLASS == "PV" || mpaip.VEHICLE_CLASS == "CV" || mpaip.VEHICLE_CLASS == "MC")
{
mpaip.NON_LTO = "0";
}
else {
mpaip.NON_LTO = "1";
}
mpaip.COMP_ID="MLY";
//mpaip.VEHICLE_CLASS = Svehicle.SERVICE_CODE;
mpaip.VEHICLE_TYPE = Svehicle.SERVICE_CODE;
mpaip.COVERAGE_YR = Svehicle.YEAR_COVERAGE.ToString();
mpaip.TAX_TYPE ="1";
mpaip.BLT_FILENO = "-";
rctpl_db.M_PAIP.Add(mpaip);
await rctpl_db.SaveChangesAsync();
}
Save_TbillChrgH(mypapin, chrgno);
Save_TbillChrgD(chrgno, mpaip.VEHICLE_TYPE, mypapin, mpaip.PALNAME, myInvoiceNum, mpaip.PLACE_ISSUED, mpaip, transtype);
return RedirectToAction("ClientPayments", "COC");
}
}
catch (DbEntityValidationException ex)
{
string errorMessages = string.Join("; ", ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage));
throw new DbEntityValidationException(errorMessages);
}
return View();
}