Ejemplo n.º 1
0
        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;
        
        }
Ejemplo n.º 2
0
        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);
            }

        }
Ejemplo n.º 3
0
        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();

        }