public IHttpActionResult DeleteTableKucun(string goodsName) { testEntities1 testEntities1Obj = new testEntities1(); testEntities1Obj.Configuration.ProxyCreationEnabled = false; List <kucun> list = testEntities1Obj.kucun.ToList(); kucun obj1 = testEntities1Obj.kucun.Find(goodsName); //kucun obj = new kucun() //{ // 商品名称 = data //}; testEntities1Obj.Entry <kucun>(obj1).State = EntityState.Deleted; int res = testEntities1Obj.SaveChanges(); if (res > 0) { return(Json(new { action = true })); } else { return(Json(new { action = false })); } }
public IHttpActionResult UpdateTableKucun1(string goodsName, int goodsNum) { testEntities1 testEntities1Obj = new testEntities1(); testEntities1Obj.Configuration.ProxyCreationEnabled = false; List <kucun> list = testEntities1Obj.kucun.ToList(); kucun obj1 = testEntities1Obj.kucun.Find(goodsName); obj1.数量 = goodsNum; //string[] data = new string[2]; //kucun obj = new kucun() //{ // 商品名称 = goodsName, // 数量 = goodsNum //}; //testEntities1Obj.Entry<kucun>(obj).State = EntityState.Modified; int res = testEntities1Obj.SaveChanges(); if (res > 0) { return(Json(new { action = true })); } else { return(Json(new { action = false })); } }
public IHttpActionResult SelectGoods() { testEntities1 testEntities1Obj = new testEntities1(); testEntities1Obj.Configuration.ProxyCreationEnabled = false; List <goods> list = testEntities1Obj.goods.ToList(); return(Json <List <goods> >(list)); }
public JsonResult SelectTableCustomer() { testEntities1 testEntities1Obj = new testEntities1(); testEntities1Obj.Configuration.ProxyCreationEnabled = false; List <customer> list = testEntities1Obj.customer.ToList(); return(Json(new { ok = true, my = list }, JsonRequestBehavior.AllowGet)); }
public IHttpActionResult SelectCustomer() { testEntities1 testEntities1Obj = new testEntities1(); testEntities1Obj.Configuration.ProxyCreationEnabled = false; List <customer> list = testEntities1Obj.customer.ToList(); return(Json <List <customer> >(list)); }
public IHttpActionResult SelectKucun() { testEntities1 testEntities1Obj = new testEntities1(); testEntities1Obj.Configuration.ProxyCreationEnabled = false; List <kucun> list = testEntities1Obj.kucun.ToList(); return(Json(list)); }
public JsonResult SelectTableKucun() { testEntities1 testEntities1Obj = new testEntities1(); testEntities1Obj.Configuration.ProxyCreationEnabled = false; List <kucun> list = testEntities1Obj.kucun.ToList(); return(Json(list, JsonRequestBehavior.AllowGet)); }
public IHttpActionResult SelectOneGoods(string SupplierTel) { testEntities1 testEntities1Obj = new testEntities1(); testEntities1Obj.Configuration.ProxyCreationEnabled = false; supplier obj = testEntities1Obj.supplier.Find(SupplierTel); return(Json(obj)); }
public object Delete(int id) { var db = new testEntities1(); var x = db.TestUsers.ToList(); TestUser currUser = x.Where(s => s.Id.Equals(id)).FirstOrDefault(); if(currUser != null) db.TestUsers.Remove(currUser); db.SaveChanges(); return new { error = "no error" }; }
public void UpdateUser(int id, [FromBody]TestUser value) { var db = new testEntities1(); var x = db.TestUsers.ToList(); TestUser currUser = x.Where(s => s.Id.Equals(id)).FirstOrDefault(); if (currUser != null) { currUser.FirstName = value.FirstName; currUser.LastName = value.LastName; currUser.StreetNumber = value.StreetNumber; currUser.StreetName = value.StreetName; currUser.Email = value.Email; currUser.State = value.State; currUser.CitySuburb = value.CitySuburb; currUser.Postcode = value.Postcode; } db.SaveChanges(); }
public JsonResult DeleteTableKucun(string data) { kucun obj = new kucun() { 商品名称 = data, }; testEntities1 testentities1obj = new testEntities1(); testentities1obj.Entry <kucun>(obj).State = EntityState.Deleted; int res = testentities1obj.SaveChanges(); if (res > 0) { return(Json(new { action = true })); } else { return(Json(new { action = false })); } }
public JsonResult InsertinTableKucun(string[] data) { kucun obj = new kucun() { 商品名称 = data[0], 数量 = int.Parse(data[1]) }; testEntities1 testEntities1Obj = new testEntities1(); testEntities1Obj.kucun.Add(obj); int res = testEntities1Obj.SaveChanges(); if (res > 0) { return(Json(new { action = true })); } else { return(Json(new { action = false })); } }
public JsonResult UpdateTableKucun(string[] data) { kucun obj = new kucun() { 商品名称 = data[0], 数量 = int.Parse(data[1]) }; testEntities1 testentities1obj = new testEntities1(); testentities1obj.Entry <kucun>(obj).State = EntityState.Modified; int res = testentities1obj.SaveChanges(); if (res > 0) { return(Json(new { action = true })); } else { return(Json(new { action = false })); } }
public IHttpActionResult InsertinTableKucun(string goodsName, int goodsNum) { kucun obj = new kucun() { 商品名称 = goodsName, 数量 = goodsNum }; testEntities1 testEntities1Obj = new testEntities1(); testEntities1Obj.kucun.Add(obj); int res = testEntities1Obj.SaveChanges(); if (res > 0) { return(Json(new { action = true })); } else { return(Json(new { action = false })); } }
public JsonResult SelectTableBuyin() { testEntities1 testEntities1Obj = new testEntities1(); //supplier buyinlObj = new supplier(); //buyinlObj.供应商全称 = "5"; //buyinlObj.供应商电话 = "6"; //kucun obj = new kucun() //{ // 商品名称 = "hahaha", // 数量 = 21 //}; //testEntities1Obj.kucun.Add(obj); //testEntities1Obj.SaveChanges(); //var obj=from a in testEntities1Obj.kucun //string a = "goods";. testEntities1Obj.Configuration.ProxyCreationEnabled = false; List <buyin> list = testEntities1Obj.buyin.ToList(); return(Json(new { ok = true, my = list }, JsonRequestBehavior.AllowGet)); }
public ActionResult Login(Login_Model model) { if (ModelState.IsValid) { using (testEntities1 dataContext = new testEntities1()) { RegisterUser user = dataContext.RegisterUsers.Where(query => query.Email.Equals(model.Email) && query.Password.Equals(model.Password)).SingleOrDefault(); if (user != null) { FormsAuthentication.SetAuthCookie(model.Email, false); Session["Email"] = user.Email.ToString(); return(RedirectToAction("Index")); } else { //If the username and password combination is not present in DB then error message is shown. ModelState.AddModelError("Failure", "Wrong Username and password combination !"); return(View()); } } } return(View(model)); }
public List<TestUser> Get(int id) { var db = new testEntities1(); var x = db.TestUsers.ToList(); return x; }
public void AddUsers([FromBody]TestUser value) { var db = new testEntities1(); db.TestUsers.Add(value); db.SaveChanges(); }
public HomeController() { cnx = new testEntities1(); }