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