public bool UpdateProduct(product product) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { //data.products.Attach(product); //data.Entry(product).State = EntityState.Modified; //getItem.id = product.id; var getItem = data.products.Single(p => p.id == product.id);//get the specific product getItem.id_manufacturer = product.id_manufacturer; getItem.id_save = product.id_save; getItem.name = product.name; getItem.sale_price = product.sale_price; getItem.number = product.number; getItem.image = product.image; getItem.product_info = product.product_info; data.SaveChanges(); return(true); } } catch (Exception e) { Debug.WriteLine(e); return(false); } }
public bool DeleteProduct(int id) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { var product = data.products.Single(p => p.id == id); var exportBill_Detail = data.export_bill_detail.Where(e => e.id_product == id).ToList(); foreach (var item in exportBill_Detail) { data.export_bill_detail.Remove(item); } var importBill_Detail = data.import_bill_detail.Where(i => i.id_product == id).ToList(); foreach (var item in importBill_Detail) { data.import_bill_detail.Remove(item); } data.products.Remove(product); data.SaveChanges(); return(true); } } catch (Exception e) { Debug.WriteLine(e); return(false); } }
public bool UpdateUser(user user) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { //Code first //data.Entry(user).State = EntityState.Modified; //data.SaveChanges(); //return true; //////////// Code change var getItem = data.users.Single(p => p.id == user.id); getItem.id_role = user.id_role; getItem.address = user.address; getItem.email = user.email; getItem.name = user.name; getItem.password = user.password; getItem.phone_number = user.phone_number; data.SaveChanges(); return(true); } } catch (Exception e) { Debug.WriteLine(e); return(false); } }
public bool DeleteUser(int id) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { var user = data.users.Single(u => u.id == id); var exportBill = data.export_bill.Where(e => e.id_user == id).ToList(); foreach (var item in exportBill) { var exportBill_Detail = data.export_bill_detail.Where(e => e.id_export_bill == item.id).ToList(); foreach (var item2 in exportBill_Detail) { data.export_bill_detail.Remove(item2); } data.export_bill.Remove(item); } data.users.Remove(user); data.SaveChanges(); return(true); } } catch (Exception e) { Debug.WriteLine(e); return(false); } }
public product GetProductById(int id) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { var my_product = data.products.First(s => s.id == id); return(my_product); } } catch (Exception e) { Debug.WriteLine(e); return(null); } }
public List <role> GetAllRole() { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { var my_role = (data.roles.Select(p => p)).ToList(); return(my_role); } } catch (Exception e) { Debug.WriteLine(e); return(null); } }
public role GetRoleWithId(int id) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { var my_save = data.roles.First(s => s.id == id); return(my_save); } } catch (Exception e) { Debug.WriteLine(e); return(null); } }
public List <user> GetAllUser() { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { var my_data = (data.users.Select(p => p)).ToList(); return(my_data); } } catch (Exception e) { Debug.WriteLine(e); return(null); } }
public List <product> GetProductByNameManu(string nameManu) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { var my_product = data.products.AsNoTracking().Where(p => p.manufacturer.name == nameManu).ToList(); return(my_product); } } catch (Exception e) { Debug.WriteLine(e); return(null); } }
public user GetUserById(int id) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { var my_data = data.users.First(s => s.id == id); return(my_data); } } catch (Exception e) { Debug.WriteLine(e); return(null); } }
public List <user> GetUserByName(string name) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { var my_data = data.users.AsNoTracking() .Where(u => u.name.ToUpper().Contains(name) || u.name.ToLower().Contains(name)).ToList(); return(my_data); } } catch (Exception e) { Debug.WriteLine(e); return(null); } }
public List <user> FindUserByEmail(string email) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { var my_data = data.users.AsNoTracking() .Where(u => u.email.ToUpper().Contains(email) || u.email.ToLower().Contains(email)).ToList(); return(my_data); } } catch (Exception e) { Debug.WriteLine(e); return(null); } }
public user GetUserByEmail(string email) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { var my_data = data.users.AsNoTracking() .Where(u => u.email == email).FirstOrDefault(); return(my_data); } } catch (Exception e) { Debug.WriteLine(e); return(null); } }
public bool UpdateRole(role s) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { data.Entry(s).State = EntityState.Modified; data.SaveChanges(); return(true); } } catch (Exception e) { Debug.WriteLine(e); return(false); } }
public List <product> GetProductByIdManuAndNameProduct(int idManu, string namePro) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { var my_product = data.products.AsNoTracking() .Where(p => p.id_manufacturer == idManu && p.name.Contains(namePro)).ToList(); return(my_product); } } catch (Exception e) { Debug.WriteLine(e); return(null); } }
public List <product> GetProductSave() { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { var my_product = data.products.AsNoTracking() .OrderByDescending(p => p.save.percent_save).Take(18).ToList(); return(my_product); } } catch (Exception e) { Debug.WriteLine(e); return(null); } }
public bool AddProduct(product product) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { data.products.Add(product); data.SaveChanges(); return(true); } } catch (Exception e) { Debug.WriteLine(e); return(false); } }
public List <product> GetAllProduct() { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { var my_product = (data.products.Select(p => p)).ToList(); return(my_product); } } catch (Exception e) { Debug.WriteLine(e); return(null); } }
public bool AddUser(user user) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { data.users.Add(user); data.SaveChanges(); return(true); } } catch (Exception e) { Debug.WriteLine(e); return(false); } }
public bool AddRole(role s) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { data.roles.Add(s); data.SaveChanges(); return(true); } } catch (Exception e) { Debug.WriteLine(e); return(false); } }
public List <product> GetProductByName(string n) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { var my_product = data.products.AsNoTracking() .Where(p => p.name.ToUpper().Contains(n) || p.name.ToLower().Contains(n)).ToList(); return(my_product); } } catch (Exception e) { Debug.WriteLine(e); return(null); } }
public bool CheckUser(string email, string pass) { try { using (QLBH_PHONE_Entities data = new QLBH_PHONE_Entities()) { var my_data = data.users.AsNoTracking() .Where(u => u.email == email && u.password == pass).FirstOrDefault(); if (my_data == null) { return(false); } return(true); } } catch (Exception e) { Debug.WriteLine(e); return(false); } }