public ActionResult certification(string barcode, string randno, string codno, string codid) { try { ViewBag.barcode = barcode; looknumber look = _db.lookNumber.Where(e => e.barcode == barcode).SingleOrDefault(); certifyorder certiFyorder = _db.certifYorder.Where(e => e.codno == codno).SingleOrDefault(); List <viewcertifycheckdet> viewCertifycheckdet = _db.viewCertifycheckdet.Where(e => e.farmerno == certiFyorder.farmerno).ToList(); farmer Farmer = _db.Farmer.Where(e => e.farmerno == certiFyorder.farmerno).SingleOrDefault(); barcodeRule rule = _db.BarcodeRule.Where(e => e.barcode == barcode).SingleOrDefault(); ViewBag.applicant = Farmer.farmername; ViewBag.faddr = Farmer.faddr; ViewBag.position = rule.positionRule + 1; Farmer = _db.Farmer.Where(e => e.farmerno == certiFyorder.vendno).SingleOrDefault(); ViewBag.vendor = Farmer.farmername; certificationViewModel certificationViewM = new Models.certificationViewModel(); certificationViewM.certifYorder = certiFyorder; certificationViewM.Farmer = Farmer; certificationViewM.lookNumber = look; certificationViewM.viewCertifycheckdet = viewCertifycheckdet; return(View(certificationViewM)); } catch { return(RedirectToAction("certifynon")); } }
public ActionResult certifyformdo(string barcode) { certifystampstock cer = _db.Certifystampstock.Where(e => e.barcode == barcode && e.ifrand == "n").SingleOrDefault(); looknumber look = _db.lookNumber.Where(e => e.barcode == barcode).SingleOrDefault(); string item = ""; if (cer == null) { return(RedirectToAction("certifynon", "certify")); } else { if (look != null) { look.lookno += 1; look.bmoddate = DateTime.Now; _db.Entry(look).State = System.Data.Entity.EntityState.Modified; _db.SaveChanges(); } else { looknumber _looknumber = new looknumber() { barcode = barcode, lookno = 1, bmoddate = DateTime.Now }; _db.lookNumber.Add(_looknumber); _db.SaveChanges(); } } return(RedirectToAction("certification", "certify", new { @barcode = barcode, @randno = item, @codno = cer.codno, @codid = cer.codid })); }