// DELETE
public void Deletea_Supplier(int id)
{
using (ShopDBEntities db = new ShopDBEntities())
{
a_Supplier a_Supplier = db.a_Supplier.Find(id);
db.a_Supplier.Remove(a_Supplier);
db.SaveChanges();
}
}
// SELECT * FROM a_Supplier WHERE Id = Id
public a_SupplierViewModel Geta_SupplierById(int id)
{
using (ShopDBEntities db = new ShopDBEntities())
{
a_Supplier a_Supplier = db.a_Supplier.Find(id);
a_SupplierViewModel Model = new a_SupplierViewModel();
Model.ID = a_Supplier.ID;
Model.Code = a_Supplier.Code;
Model.Name = a_Supplier.Name;
Model.City = a_Supplier.City;
return(Model);
}
}
