public string delete(int ide) { DataBaseOneEntities1 db = new DataBaseOneEntities1(); APITable at = db.APITables.Single(x => x.id == ide); db.APITables.Remove(at); db.SaveChanges(); return("yes"); }
public string update(int ide, string ename) { DataBaseOneEntities1 db = new DataBaseOneEntities1(); APITable at = db.APITables.Single(x => x.id == ide); at.name = ename; db.SaveChanges(); return("yes"); }
public IHttpActionResult display() { List <APITable> li = new List <APITable>(); using (var a = new DataBaseOneEntities1()) { li = a.APITables.ToList(); } return(Ok(li)); }
public IHttpActionResult search(int ide) { List <APITable> li = new List <APITable>(); using (var a = new DataBaseOneEntities1()) { li = a.APITables.Where(x => x.id == ide).ToList(); } return(Ok(li)); }
public string insert(int ide, string ename, string eplace, int ephone) { DataBaseOneEntities1 db = new DataBaseOneEntities1(); APITable at = new APITable(); at.id = ide; at.name = ename; at.place = eplace; at.ph = ephone; db.APITables.Add(at); db.SaveChanges(); return("yes"); }