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");
}
}
}
}
