public JsonResult Edit(string para01, string para02, string para03, string para04, string para05) { string id = para01; string name = para02; string salary = para03; string sex = para04; string phone = para05; int intSalary; int.TryParse(salary, out intSalary); EMPLOYEE eMPLOYEE = db.EMPLOYEE.Find(id); eMPLOYEE.EMPLOYEE_NAME = name; eMPLOYEE.SALARY = intSalary; eMPLOYEE.SEX = sex; eMPLOYEE.PHONE_NUMBER = phone; db.Entry(eMPLOYEE).State = EntityState.Modified; try { db.SaveChanges(); } catch (Exception ex) { throw; } var list = db.EMPLOYEE.Select(n => new { EMPLOYEE_ID = n.EMPLOYEE_ID, EMPLOYEE_NAME = n.EMPLOYEE_NAME, SEX = n.SEX, PHONE_NUMBER = n.PHONE_NUMBER, SALARY = n.SALARY }); return(Json(new { code = 0, msg = "", count = 1000, data = list }, JsonRequestBehavior.AllowGet)); }
public JsonResult Edit(string para01, string para02, string para03) { string id = para01; string spo_money = para02; string date = para03; int money; int.TryParse(spo_money, out money); SUPPORT sUPPORT = db.SUPPORT.Find(id); sUPPORT.SPONSOR_ID = id; sUPPORT.MONEY = money; sUPPORT.SUPPORT_DATE = Convert.ToDateTime(date); db.Entry(sUPPORT).State = EntityState.Modified; try { db.SaveChanges(); } catch (Exception ex) { throw; } var list = db.SUPPORT.Select(n => new { SPONSOR_ID = n.SPONSOR_ID, SPONSOR_NAME = n.SPONSOR.SPONSOR_NAME, INCOME_ID = n.INCOME_ID, MONEY = n.MONEY, SUPPORT_DATE = n.SUPPORT_DATE }); return(Json(new { code = 0, msg = "", count = 1000, data = list }, JsonRequestBehavior.AllowGet)); }
public JsonResult Edit(string para01, string para02, string para03) { string id = para01; string name = para02; string number = para03; SUPPLIER sUPPLIER = db.SUPPLIER.Find(id); sUPPLIER.SUPPLIER_ID = id; sUPPLIER.SUPPLIER_NAME = name; sUPPLIER.PHONE_NUMBER = number; db.Entry(sUPPLIER).State = EntityState.Modified; try { db.SaveChanges(); } catch (Exception ex) { throw; } var list = db.SUPPLIER.Select(n => new { SUPPLIER_ID = n.SUPPLIER_ID, SUPPLIER_NAME = n.SUPPLIER_NAME, PHONE_NUMBER = n.PHONE_NUMBER }); return(Json(new { code = 0, msg = "", count = 1000, data = list }, JsonRequestBehavior.AllowGet)); }
public JsonResult Create(string para01, string para02, string para03) { string employee_id = para01; string expense_id = para02; string date = para03; SALARY newSalary = new SALARY(); newSalary.EXPENSE_ID = expense_id; newSalary.EMPLOYEE_ID = employee_id; newSalary.SALARY_DATE = Convert.ToDateTime(date); EMPLOYEE myEmployee = db.EMPLOYEE.Find(employee_id); EXPENSE myExpense = db.EXPENSE.Find(expense_id); myExpense.MONEY = myExpense.MONEY + myEmployee.SALARY; db.Entry(myExpense).State = EntityState.Modified; db.SALARY.Add(newSalary); db.SaveChanges(); var list = db.SALARY.Include(s => s.EMPLOYEE).Include(s => s.EXPENSE).Select(n => new { EMPLOYEE_ID = n.EMPLOYEE_ID, EMPLOYEE_NAME = n.EMPLOYEE.EMPLOYEE_NAME, SALARY_DATE = n.SALARY_DATE, SALARY = n.EMPLOYEE.SALARY, EXPENSE_ID = n.EXPENSE_ID }); return(Json(new { code = 0, msg = "", count = 1000, data = list }, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit([Bind(Include = "SHELF_ID,SHELF_AREA")] SHELF sHELF) { if (ModelState.IsValid) { db.Entry(sHELF).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sHELF)); }
public ActionResult Edit([Bind(Include = "INCOME_ID,MONEY,INCOME_DATE,TYPE")] INCOME iNCOME) { if (ModelState.IsValid) { db.Entry(iNCOME).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(iNCOME)); }
public ActionResult Edit([Bind(Include = "SPONSOR_ID,SPONSOR_NAME,PHONE_NUMBER")] SPONSOR sPONSOR) { if (ModelState.IsValid) { db.Entry(sPONSOR).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sPONSOR)); }
public ActionResult Edit([Bind(Include = "EXPENSE_ID,EXPENSE_DATE,MONEY,TYPE")] EXPENSE eXPENSE) { if (ModelState.IsValid) { db.Entry(eXPENSE).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(eXPENSE)); }
public ActionResult Edit([Bind(Include = "PRODUCT_ID,SUPPLIER_ID,PRODUCT_NAME,EXP,PURCHASE_PRICE,SELL_PRICE,TOTAL")] PRODUCT_ATTRIBUTE pRODUCT_ATTRIBUTE) { if (ModelState.IsValid) { db.Entry(pRODUCT_ATTRIBUTE).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SUPPLIER_ID = new SelectList(db.SUPPLIER, "SUPPLIER_ID", "SUPPLIER_NAME", pRODUCT_ATTRIBUTE.SUPPLIER_ID); return(View(pRODUCT_ATTRIBUTE)); }
public ActionResult Edit([Bind(Include = "PLAN_ID,PRODUCT_ID,PLAN_NUM")] PLAN pLAN) { if (ModelState.IsValid) { db.Entry(pLAN).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.PRODUCT_ID = new SelectList(db.PRODUCT_ATTRIBUTE, "PRODUCT_ID", "SUPPLIER_ID", pLAN.PRODUCT_ID); return(View(pLAN)); }
public ActionResult Edit([Bind(Include = "BATCH_ID,LOT_DATE,INCOME_ID,MONEY,LOT_NUMBER")] SALES_LOT sALES_LOT) { if (ModelState.IsValid) { db.Entry(sALES_LOT).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.INCOME_ID = new SelectList(db.INCOME, "INCOME_ID", "TYPE", sALES_LOT.INCOME_ID); return(View(sALES_LOT)); }
public ActionResult Edit([Bind(Include = "BATCH_ID,PRODUCT_ID,PRODUCT_DATE,DISCOUNT,BATCH_NUMBER")] PRODUCT pRODUCT) { if (ModelState.IsValid) { db.Entry(pRODUCT).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.PRODUCT_ID = new SelectList(db.PRODUCT_ATTRIBUTE, "PRODUCT_ID", "SUPPLIER_ID", pRODUCT.PRODUCT_ID); return(View(pRODUCT)); }
public ActionResult Edit([Bind(Include = "SPONSOR_ID,INCOME_ID,SUPPORT_DATE,MONEY")] SUPPORT sUPPORT) { if (ModelState.IsValid) { db.Entry(sUPPORT).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.INCOME_ID = new SelectList(db.INCOME, "INCOME_ID", "TYPE", sUPPORT.INCOME_ID); ViewBag.SPONSOR_ID = new SelectList(db.SPONSOR, "SPONSOR_ID", "SPONSOR_NAME", sUPPORT.SPONSOR_ID); return(View(sUPPORT)); }
public ActionResult Edit([Bind(Include = "EXPENSE_ID,EMPLOYEE_ID,SALARY_DATE")] SALARY sALARY) { if (ModelState.IsValid) { db.Entry(sALARY).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.EMPLOYEE_ID = new SelectList(db.EMPLOYEE, "EMPLOYEE_ID", "EMPLOYEE_NAME", sALARY.EMPLOYEE_ID); ViewBag.EXPENSE_ID = new SelectList(db.EXPENSE, "EXPENSE_ID", "TYPE", sALARY.EXPENSE_ID); return(View(sALARY)); }
public ActionResult Edit([Bind(Include = "STOCK_ID,BATCH_ID,PLAN_ID,EXPENSE_ID,STOCK_NUM,STOCK_DATE")] STOCK sTOCK) { if (ModelState.IsValid) { db.Entry(sTOCK).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.EXPENSE_ID = new SelectList(db.EXPENSE, "EXPENSE_ID", "TYPE", sTOCK.EXPENSE_ID); ViewBag.PLAN_ID = new SelectList(db.PLAN, "PLAN_ID", "PRODUCT_ID", sTOCK.PLAN_ID); ViewBag.BATCH_ID = new SelectList(db.PRODUCT, "BATCH_ID", "PRODUCT_ID", sTOCK.BATCH_ID); return(View(sTOCK)); }
public JsonResult EditAllDiscount(string para01, string para02) { string product_id = para01; decimal discount; decimal.TryParse(para02, out discount); discount = discount / 100; var myProduct = db.PRODUCT.Where(n => n.PRODUCT_ID == product_id); foreach (var x in myProduct) { PRODUCT testProduct = db.PRODUCT.Find(x.BATCH_ID); testProduct.BATCH_ID = x.BATCH_ID; testProduct.PRODUCT_ID = x.PRODUCT_ID; testProduct.PRODUCT_DATE = x.PRODUCT_DATE; testProduct.BATCH_NUMBER = x.BATCH_NUMBER; testProduct.SHEIF_ID = x.SHEIF_ID; db.Entry(testProduct).State = EntityState.Modified; db.SaveChanges(); } try { db.SaveChanges(); } catch (Exception ex) { throw; } var list1 = db.PRODUCT.Include(n => n.PRODUCT_ATTRIBUTE).Select(n => new { BATCH_ID = n.BATCH_ID, PRODUCT_ID = n.PRODUCT_ID, PRODUCT_NAME = n.PRODUCT_ATTRIBUTE.PRODUCT_NAME, DISCOUNT = n.DISCOUNT }); return(Json(new { code = 0, msg = "", count = 1000, data = list1 }, JsonRequestBehavior.AllowGet)); }
public JsonResult Edit(string para01, string para02, string para03, string para04, string para05, string para06) { string v_id = para01; string name = para02; string sex = para03; string phone = para04; string credits = para05; string e_id = para06; int intCredits; int.TryParse(credits, out intCredits); /* * if (id == null) * { * return Json(null); * } */ VIP vIP = db.VIP.Find(v_id); /* * if (eMPLOYEE == null) * { * //return Json(null); * } */ vIP.VIP_NAME = name; vIP.SEX = sex; vIP.PHONE_NUMBER = phone; vIP.CREDITS = intCredits; vIP.EMPLOYEE_ID = e_id; db.Entry(vIP).State = EntityState.Modified; try { db.SaveChanges(); } catch (Exception ex) { throw; } var list = db.VIP.Select(n => new { VIP_ID = n.VIP_ID, VIP_NAME = n.VIP_NAME, SEX = n.SEX, PHONE_NUMBER = n.PHONE_NUMBER, CREDITS = n.CREDITS, EMPLOYEE_ID = n.EMPLOYEE_ID }); return(Json(new { code = 0, msg = "", count = 1000, data = list })); }
public JsonResult editRecord(string para01, string para02, string para03, string para04, string para05, string para06, string para07) { string p_id = para01; string name = para02; string s_id = para03; string p_price = para04; string s_price = para05; string exp = para06; string total = para07; int p_p; int.TryParse(p_price, out p_p); int s_p; int.TryParse(s_price, out s_p); int int_exp; int.TryParse(exp, out int_exp); int int_tot; int.TryParse(total, out int_tot); PRODUCT_ATTRIBUTE newPRODUCT_ATTRIBUTE = db.PRODUCT_ATTRIBUTE.Find(p_id); newPRODUCT_ATTRIBUTE.PRODUCT_NAME = name; newPRODUCT_ATTRIBUTE.SUPPLIER_ID = s_id; newPRODUCT_ATTRIBUTE.PURCHASE_PRICE = p_p; newPRODUCT_ATTRIBUTE.SELL_PRICE = s_p; newPRODUCT_ATTRIBUTE.EXP = int_exp; newPRODUCT_ATTRIBUTE.TOTAL = int_tot; db.Entry(newPRODUCT_ATTRIBUTE).State = EntityState.Modified; try { db.SaveChanges(); } catch (Exception ex) { throw; } var list = db.PRODUCT_ATTRIBUTE.Select(n => new { PRODUCT_ID = n.PRODUCT_ID, PRODUCT_NAME = n.PRODUCT_NAME, SUPPLIER_ID = n.SUPPLIER_ID, PURCHASE_PRICE = n.PURCHASE_PRICE, SELL_PRICE = n.SELL_PRICE, EXP = n.EXP, TOTAL = n.TOTAL }); return(Json(new { code = 0, msg = "", count = 1000, data = list }, JsonRequestBehavior.AllowGet)); }
public JsonResult Edit(string para01, string para02, string para03, string para04, string para05, string para06) { string plan_id = para01; string pro_id = para02; string pro_name = para03; string sup_id = para04; string purchase = para05; string plan_number = para06; int pur; int.TryParse(purchase, out pur); int plan_num; int.TryParse(plan_number, out plan_num); PLAN pLAN = db.PLAN.Find(plan_id); pLAN.PLAN_ID = plan_id; pLAN.PRODUCT_ID = pro_id; pLAN.PRODUCT_ATTRIBUTE.PRODUCT_NAME = pro_name; pLAN.PRODUCT_ATTRIBUTE.SUPPLIER_ID = sup_id; pLAN.PRODUCT_ATTRIBUTE.PURCHASE_PRICE = pur; pLAN.PLAN_NUM = plan_num; db.Entry(pLAN).State = EntityState.Modified; try { db.SaveChanges(); } catch (Exception ex) { throw; } var list = db.PLAN.Include(n => n.PRODUCT_ATTRIBUTE).Select(n => new { PLAN_ID = n.PLAN_ID, PRODUCT_ID = n.PRODUCT_ID, PRODUCT_NAME = n.PRODUCT_ATTRIBUTE.PRODUCT_NAME, SUPPLIER_ID = n.PRODUCT_ATTRIBUTE.SUPPLIER_ID, PURCHASE_PRICE = n.PRODUCT_ATTRIBUTE.PURCHASE_PRICE, PLAN_NUM = n.PLAN_NUM }); return(Json(new { code = 0, msg = "", count = 1000, data = list }, JsonRequestBehavior.AllowGet)); }
public JsonResult editShelf(string para01, string para02) { string shelf_id = para01; string shelf_area = para02; SHELF myShelf = db.SHELF.Find(shelf_id); myShelf.SHELF_AREA = shelf_area; db.Entry(myShelf).State = EntityState.Modified; try { db.SaveChanges(); } catch (Exception ex) { throw; } var list2 = db.SHELF.Where(n => n.SHELF_ID != "0").Select(n => new { SHELF_ID = n.SHELF_ID, SHELF_AREA = n.SHELF_AREA }); return(Json(new { code = 0, msg = "", count = 1000, data = list2 }, JsonRequestBehavior.AllowGet)); }