public static object GetData(dynamic para) { var db = new RazorPageDemo.Models.CRMContext(); var ret = from c in db.Employee select c; return(ret.ToList()); }
public static object DelDataItem(dynamic para) { var db = new RazorPageDemo.Models.CRMContext(); var ID = (int)para.id; var ret = from c in db.Employee where c.Id == ID select c; if (ret.Count() == 1) { ret.FirstOrDefault().IsValid = false; } db.SaveChanges(); return(true); }
public static object AddNew(dynamic para) { var db = new RazorPageDemo.Models.CRMContext(); var item = new RazorPageDemo.Models.Employee() { Address = para.address, IsValid = true, Memo = para.memo, Name = para.name, Phone = para.phone, PictureUrl = para.pictureUrl, Title = para.title, }; db.Employee.Add(item); db.SaveChanges(); return(item.Id); }
public static object Edit(dynamic para) { var ID = (int)para.id; var db = new RazorPageDemo.Models.CRMContext(); var ret = from c in db.Employee where c.Id == ID select c; if (ret.Count() == 1) { ret.FirstOrDefault().Address = para.address; ret.FirstOrDefault().IsValid = para.isValid; ret.FirstOrDefault().Memo = para.memo; ret.FirstOrDefault().Name = para.name; ret.FirstOrDefault().Phone = para.address; ret.FirstOrDefault().Title = para.title; } db.SaveChanges(); return(true); }