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