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 DeleteConfirmed(int id) { farmer farmer = db.farmers.Find(id); db.farmers.Remove(farmer); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "farmerid,farmername,cropid")] farmer farmer) { if (ModelState.IsValid) { db.Entry(farmer).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.cropid = new SelectList(db.crops, "cropid", "cropname", farmer.cropid); return(View(farmer)); }
public ActionResult Create([Bind(Include = "farmerid,farmername,cropid")] farmer farmer) { if (ModelState.IsValid) { db.farmers.Add(farmer); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.cropid = new SelectList(db.crops, "cropid", "cropname", farmer.cropid); return(View(farmer)); }
// GET: farmers/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } farmer farmer = db.farmers.Find(id); if (farmer == null) { return(HttpNotFound()); } return(View(farmer)); }
// GET: farmers/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } farmer farmer = db.farmers.Find(id); if (farmer == null) { return(HttpNotFound()); } ViewBag.cropid = new SelectList(db.crops, "cropid", "cropname", farmer.cropid); return(View(farmer)); }
//[HttpGet] //public ActionResult Add() //{ // ViewBag.Ifboss = Session["Ifboss"].ToString(); // ViewBag.Msid = Session["Msid"].ToString(); // farmer col = new farmer(); // return View(col); //} //[HttpPost] public ActionResult add(farmer col, string sysflag, int?page, string orderdata, string orderdata1) { ModelState.Clear(); page = ((!page.HasValue || page < 1) ? 1 : page); ViewBag.page = page; if (string.IsNullOrWhiteSpace(orderdata)) { orderdata = "farmerno"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qfarmername = "", qfarmerno = ""; if (!string.IsNullOrWhiteSpace(Request["qfarmername"])) { qfarmername = Request["qfarmername"].Trim(); ViewBag.qfarmername = qfarmername; } if (!string.IsNullOrWhiteSpace(Request["qfarmerno"])) { qfarmerno = Request["qfarmerno"].Trim(); ViewBag.qfarmerno = qfarmerno; } if (sysflag != "A") { farmer newcol = new farmer(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); /* * SqlConnection conn = dbobj.get_conn("Aitag_DBContext"); * SqlDataReader dr; * SqlCommand sqlsmd = new SqlCommand(); * sqlsmd.Connection = conn; * string sqlstr = "select * from farmer where 1<>1"; * sqlsmd.CommandText = sqlstr; * dr = sqlsmd.ExecuteReader(); * * if (dr.Read()) * { * * ModelState.AddModelError("", "no"); * return View(col); * } * dr.Close(); * dr.Dispose(); * sqlsmd.Dispose(); * conn.Close(); * conn.Dispose(); */ col.comid = Session["comid"].ToString(); col.bmodid = Session["tempid"].ToString(); //col.badddate = DateTime.Now; col.bmoddate = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.farmer.Add(col); con.SaveChanges(); //系統LOG檔 //================================================= // SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext"); string sysrealsid = Request["sysrealsid"].ToString(); string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2"); string sysnote = "農戶姓名:" + col.farmername; dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag); sysconn.Close(); sysconn.Dispose(); //================================================= } string tmpform = ""; tmpform = "<body onload=qfr1.submit();>"; tmpform += "<form name='qfr1' action='/farmer/List' method='post'>"; tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>"; tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>"; tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>"; tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>"; tmpform += "<input type=hidden id='qfarmername' name='qfarmername' value='" + qfarmername + "'>"; tmpform += "<input type=hidden id='qfarmerno' name='qfarmerno' value='" + qfarmerno + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); // return RedirectToAction("List"); } } }
public ActionResult Edit(farmer chks, string sysflag, int?page, string orderdata, string orderdata1) { ModelState.Clear(); page = ((!page.HasValue || page < 1) ? 1 : page); ViewBag.page = page; if (string.IsNullOrWhiteSpace(orderdata)) { orderdata = "farmerno"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qfarmername = "", qfarmerno = ""; if (!string.IsNullOrWhiteSpace(Request["qfarmername"])) { qfarmername = Request["qfarmername"].Trim(); ViewBag.qfarmername = qfarmername; } if (!string.IsNullOrWhiteSpace(Request["qfarmerno"])) { qfarmerno = Request["qfarmerno"].Trim(); ViewBag.qfarmerno = qfarmerno; } if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.farmer.Where(r => r.farmerno == chks.farmerno).FirstOrDefault(); farmer efarmers = con.farmer.Find(chks.farmerno); if (efarmers == null) { return(HttpNotFound()); } return(View(efarmers)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldmsid = Request["oldmsid"]; using (Aitag_DBContext con = new Aitag_DBContext()) { NDcommon dbobj = new NDcommon(); //chks.comid = Session["comid"].ToString(); chks.bmodid = Session["tempid"].ToString(); chks.bmoddate = DateTime.Now; con.Entry(chks).State = EntityState.Modified; con.SaveChanges(); //系統LOG檔 //================================================= // SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext"); string sysrealsid = Request["sysrealsid"].ToString(); string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2"); string sysnote = "農戶姓名:" + chks.farmername; dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag); sysconn.Close(); sysconn.Dispose(); //================================================= string tmpform = ""; tmpform = "<body onload=qfr1.submit();>"; tmpform += "<form name='qfr1' action='/farmer/List' method='post'>"; tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>"; tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>"; tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>"; tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>"; tmpform += "<input type=hidden id='qfarmername' name='qfarmername' value='" + qfarmername + "'>"; tmpform += "<input type=hidden id='qfarmerno' name='qfarmerno' value='" + qfarmerno + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }