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