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