// INSERT INTO a_Product VALUE a_Product public void CreateNewa_Product(Xsis_Shop_ViewModels.a_ProductViewModel a_Product) { using (ShopDBEntities db = new ShopDBEntities()) { Xsis_Shop_Models.a_Product Model = new Xsis_Shop_Models.a_Product(); Model.Code = a_Product.Code; Model.Name = a_Product.Name; db.a_Product.Add(Model); db.SaveChanges(); } }
// UPDATE public void Updatea_Product(Xsis_Shop_ViewModels.a_ProductViewModel a_Product) { using (ShopDBEntities db = new ShopDBEntities()) { Xsis_Shop_Models.a_Product Model = new Xsis_Shop_Models.a_Product(); Model.ID = a_Product.ID; Model.Code = a_Product.Code; Model.Name = a_Product.Name; db.Entry(Model).State = EntityState.Modified; db.SaveChanges(); } }
// SELECT * FROM a_Product WHERE Id = Id public a_ProductViewModel Geta_ProductById(int id) { using (ShopDBEntities db = new ShopDBEntities()) { a_Product a_Product = db.a_Product.Find(id); Xsis_Shop_ViewModels.a_ProductViewModel Model = new Xsis_Shop_ViewModels.a_ProductViewModel(); Model.ID = a_Product.ID; Model.Code = a_Product.Code; Model.Name = a_Product.Name; return(Model); } }
// SELECT * FROM a_Product public List <Xsis_Shop_ViewModels.a_ProductViewModel> GetAlla_Product() { using (ShopDBEntities db = new ShopDBEntities()) { var Lista_Product = db.a_Product.ToList(); List <Xsis_Shop_ViewModels.a_ProductViewModel> ListView = new List <Xsis_Shop_ViewModels.a_ProductViewModel>(); foreach (var a_Product in Lista_Product) { Xsis_Shop_ViewModels.a_ProductViewModel Model = new Xsis_Shop_ViewModels.a_ProductViewModel(); Model.ID = a_Product.ID; Model.Code = a_Product.Code; Model.Name = a_Product.Name; ListView.Add(Model); } return(ListView); } }
public List <Xsis_Shop_ViewModels.a_ProductViewModel> GetAlla_Product(string Name) { using (ShopDBEntities db = new ShopDBEntities()) { List <Xsis_Shop_Models.a_Product> Lista_Product; bool NullName = string.IsNullOrWhiteSpace(Name); Name = NullName ? " " : Name.ToLower(); if (NullName) // NULL { Lista_Product = db.a_Product.ToList(); } else if (NullName) // Hanya Name { Lista_Product = db.a_Product.Where(p => ( p.Name == Name )).ToList(); } else // Semua Terisi { Lista_Product = ( from p in db.a_Product where ((p.Name == Name)) select p ).ToList(); } List <Xsis_Shop_ViewModels.a_ProductViewModel> ListView = new List <Xsis_Shop_ViewModels.a_ProductViewModel>(); foreach (var a_Product in Lista_Product) { Xsis_Shop_ViewModels.a_ProductViewModel Model = new Xsis_Shop_ViewModels.a_ProductViewModel(); Model.ID = a_Product.ID; Model.Code = a_Product.Code; Model.Name = a_Product.Name; ListView.Add(Model); } return(ListView); } }