public static void DeleteCustomer(int id) { using (var _context = new DBLaptopEntities()) { _context.Delete_Customer(id); } }
public static bool CreateCustomer(Customer cus) { using (var _context = new DBLaptopEntities()) { var dbcust = (from c in _context.Customers where c.accountName == cus.accountName select c).SingleOrDefault(); if (dbcust == null) { _context.C_Customers( cus.accountName, cus.passWord, cus.idCusAuthe, cus.FirstName, cus.LastName, cus.Sex, cus.Address, cus.phoneNumber, cus.Email, cus.dateRegistation, cus.dateActivated); return(true); } else { return(false); } } }
public static void EditCustomer(Customer cus) { using (var _context = new DBLaptopEntities()) { _context.Update_Customers(cus.idUser, cus.accountName, cus.passWord, cus.idCusAuthe, cus.FirstName, cus.LastName, cus.Sex, cus.Address, cus.phoneNumber, cus.Email, cus.dateRegistation, cus.dateActivated); } }
public static bool ValidEmail(string email) { using (var _context = new DBLaptopEntities()) { string x = "select dbo.vaValidEmail(" + "'" + email + "'" + ")"; var res = _context.Database.SqlQuery <bool>("select dbo.vaValidEmail(" + "'" + email + "'" + ")").FirstOrDefault(); return(res); } }
public static Customer ViewDetail(int id) { using (var _context = new DBLaptopEntities()) { var dbcus = _context.F_getCustomerByID(id).ToList <Customer>(); var cus = dbcus.FirstOrDefault(); return(cus); } }
public static IEnumerable <Customer> ListAllPaging(string searchString, int page, int pageSize) { using (var _context = new DBLaptopEntities()) { IQueryable <Customer> model = _context.Customers; if (!string.IsNullOrEmpty(searchString)) { model = model.Where(x => x.accountName.Contains(searchString) || x.accountName.Contains(searchString)); } return(model.OrderByDescending(x => x.accountName).ToPagedList(page, pageSize)); } }
public static bool AddCate(string cateName, string cateDescription) { try { using (var _context = new DBLaptopEntities()) { var dbAddCate = _context.Add_new_Cate(cateName, cateDescription); return(true); } } catch { return(false); } }
public static List <Category> searchCate(string name) { using (var _context = new DBLaptopEntities()) { var dbsearch = _context.search_Cate(name); List <Category> categories = new List <Category>(); foreach (var item in dbsearch) { categories.Add(new Category { cateName = item.cateName, cateDescription = item.cateDescription, ID = item.ID }); } return(categories); } }
public static bool get01cate(int id) { try { using (var _context = new DBLaptopEntities()) { var dbget01cate = _context.get_a_cate(id); return(true); } } catch { return(false); } }
public static bool DelCate(int id) { try { using (var _context = new DBLaptopEntities()) { var dbAddCate = _context.del_cate(id); return(true); } } catch { return(false); } }
public static List <Category> ViewCate() { using (var _context = new DBLaptopEntities()) { var listviewCate = _context.view_list_Category.ToList(); List <Category> categories = new List <Category>(); foreach (var item in listviewCate) { categories.Add(new Category { cateName = item.cateName, cateDescription = item.cateDescription, ID = item.ID }); } return(categories); } }
public static List <Brand> SearchBrands(string name) { using (var _context = new DBLaptopEntities()) { var dbsearch = _context.search_Brand(name); List <Brand> brand = new List <Brand>(); foreach (var item in dbsearch) { brand.Add(new Brand { brandName = item.brandName, brandDescription = item.brandDescription, ID = item.ID }); } return(brand); } }
public static bool AddBrands(string brandName, string brandDescription, string brandHomePage) { try { using (var _context = new DBLaptopEntities()) { var dbAddCate = _context.Add_new_Brand(brandName, brandDescription, brandHomePage); return(true); } } catch { return(false); } }
public static List <Brand> ViewBrands() { using (var _context = new DBLaptopEntities()) { var listViewBrands = _context.view_list_Brand.ToList(); List <Brand> brand = new List <Brand>(); foreach (var item in listViewBrands) { brand.Add(new Brand { brandName = item.brandName, brandDescription = item.brandDescription, brandHomePage = item.brandHomePage, ID = item.ID }); } return(brand); } }
public static bool EditCate(int id, string cateName, string cateDes) { try { using (var _context = new DBLaptopEntities()) { var dbedit = _context.edit_cate(id, cateName, cateDes); return(true); } } catch { return(false); } return(true); }
public static bool EditBrands(int id, string brandName, string brandDescription, string brandHomePage) { try { using (var _context = new DBLaptopEntities()) { var dbedit = _context.edit_Brands(id, brandName, brandDescription, brandHomePage); return(true); } } catch { return(false); } return(true); }