public void deleteAllProduct(Models.DataClassesDataContext data) { ShoppingCardHelper.getInstance().deleteAllOrderDetails(data); data.tbl_items.DeleteAllOnSubmit(data.tbl_items); data.SubmitChanges(); }
public void deleteAllOrders(Models.DataClassesDataContext data) { deleteAllOrderDetails(data); data.tbl_orders.DeleteAllOnSubmit(data.tbl_orders); data.SubmitChanges(); }
public bool signUp(Models.DataClassesDataContext data, string email, string password , string fullname, string phone, string address , DateTime birthday, Constants.Gender gender) { bool doesAccountToAddExist = checkThisMemberAccountExist(data, email, password); if (!doesAccountToAddExist) { Models.tbl_member account = new Models.tbl_member(); account.email = email; account.address = address; account.date_added = DateTime.Now; account.last_modified = DateTime.Now; account.name = fullname; account.password = password; account.status = (byte)Constants.AccountStatus.INACTIVE; account.birthday = birthday; account.gender = (byte)gender; account.phone = phone; data.tbl_members.InsertOnSubmit(account); data.SubmitChanges(); //Send email to activate account EmailHelper.getInstance().sendActivatingMail(email); return(true); } return(false); }
public void deleteAllProductCategory(Models.DataClassesDataContext data) { deleteAllProduct(data); data.tbl_item_categories.DeleteAllOnSubmit(data.tbl_item_categories); data.SubmitChanges(); }
public void deleteAllNewsCategory(Models.DataClassesDataContext data) { deleteAllNews(data); data.tbl_news_categories.DeleteAllOnSubmit(data.tbl_news_categories); data.SubmitChanges(); }
// // GET: /Product/ public ActionResult showAllProducts() { var db = new Models.DataClassesDataContext(); List<Models.product> productList = db.products.ToList(); ViewData.Model = productList; return View(); }
public string getPasswordOfMemberAccount(Models.DataClassesDataContext data, string email) { var result = data.tbl_members.Where(a => a.email.Equals(email)); if (result.Count() > 0) { return(result.Single().password); } return(""); }
public bool checkThisMemberAccountExist(Models.DataClassesDataContext data, string email, string password, bool checkActive) { var result = data.tbl_members.Where(a => a.email.Equals(email) && a.password == password); if (result.Count() <= 0 || (checkActive && result.Single().status != (int)Constants.AccountStatus.ACTIVE)) { return(false); } return(true); }
public bool checkThisAdminAccountExist(Models.DataClassesDataContext data, string username, string password) { var result = data.tbl_admins.Where(a => a.username.Equals(username) && a.password == password); if (result.Count() > 0) { return(true); } return(false); }
public List <Models.tbl_item> getProductHot(Models.DataClassesDataContext data) { var result = data.tbl_items.Where(a => a.hot == 1).OrderByDescending(a => a.date_added); if (result.Count() < 1) { return(new List <Models.tbl_item>()); } return(result.ToList()); }
public Models.tbl_news_category getOneNewsCategory(Models.DataClassesDataContext data, string categoryName) { var itemCategory = from ic in data.tbl_news_categories where ic.name.Equals(categoryName) select ic; if (itemCategory == null || !itemCategory.Any()) { return(new Models.tbl_news_category()); } return(itemCategory.Single()); }
public ActionResult Index() { UserModel AdminList = new UserModel(); using (Models.DataClassesDataContext DT = new Models.DataClassesDataContext()) { AdminList.userList = DT.UserRoleView.Select(s => new UserList1 { Email = s.Email, UserId = s.UserId }).ToList(); AdminList.myId = Session["userId"].ToString(); } return(View(AdminList)); }
public List <ShoppingCardItemModel> getListShoppingCardItemModelFromListOrderDetails(Models.DataClassesDataContext data, List <Models.tbl_order_detail> listOrderDetails) { List <ShoppingCardItemModel> result = new List <ShoppingCardItemModel>(); foreach (var orderDetail in listOrderDetails) { Models.tbl_item item = ProductHelper.getInstance().getProductById(data, orderDetail.id_product.Value); ShoppingCardItemModel model = new ShoppingCardItemModel(); model.id = orderDetail.id_product.Value; model.name = item.name; model.image = item.image; model.quantity = orderDetail.quantity.Value; model.price = item.price.HasValue ? item.price.Value : 0; model.total = model.price * model.quantity; model.orderid = orderDetail.id_order.HasValue ? orderDetail.id_order.Value : 0; model.modelid = orderDetail.id; result.Add(model); } return(result); }
public void deleteAllSupporters(Models.DataClassesDataContext data) { data.tbl_supports.DeleteAllOnSubmit(data.tbl_supports); data.SubmitChanges(); }
public int getOrderAmount(Models.DataClassesDataContext data) { return(data.tbl_orders.Count()); }
public int getPaidOrderAmount(Models.DataClassesDataContext data) { return(data.tbl_orders.Where(n => n.status == (int)Constants.OrderStatus.PAID).Count()); }
public List <Models.tbl_new> getListNewsByCategory(Models.DataClassesDataContext data, int parent) { return(data.tbl_news.OrderByDescending(a => a.date_added).Where(n => n.parent == parent).ToList()); }
public int getProductCategoryAmount(Models.DataClassesDataContext data) { return(data.tbl_item_categories.Count()); }
public Models.tbl_item getProductById(Models.DataClassesDataContext data, int id) { Models.tbl_item result = data.tbl_items.Where(n => n.id == id).Single(); return(result); }
//This method gets all records in tbl_news which has parent name == Constants.NEWS_CATEGORY_NAME_POLICY public List <Models.tbl_new> getListAllPolicy(Models.DataClassesDataContext data) { Models.tbl_news_category newsCategory = getOneNewsCategory(data, Constants.NEWS_CATEGORY_NAME_POLICY); return(data.tbl_news.OrderByDescending(a => a.date_added).Where(n => n.parent.Value == newsCategory.id).ToList()); }
public Models.tbl_news_category getNewsCategoryById(Models.DataClassesDataContext data, int id) { Models.tbl_news_category result = data.tbl_news_categories.Where(n => n.id == id).Single(); return(result); }
public Models.tbl_new getNewsById(Models.DataClassesDataContext data, int id) { Models.tbl_new result = data.tbl_news.Where(n => n.id == id).Single(); return(result); }
public int getNewsCategoryAmount(Models.DataClassesDataContext data) { return(data.tbl_news_categories.Count()); }
public List <Models.tbl_item> getListAllProducts(Models.DataClassesDataContext data) { return(data.tbl_items.OrderByDescending(a => a.date_added).ToList()); }
public List <Models.tbl_image> getAllSlideImages(Models.DataClassesDataContext data) { var result = data.tbl_images.Where(a => a.status == 1).OrderByDescending(a => a.last_modified); return(result.ToList()); }
public void deleteAllModules(Models.DataClassesDataContext data) { data.tbl_modules.DeleteAllOnSubmit(data.tbl_modules); data.SubmitChanges(); }
public List <Models.tbl_item> getListOtherProductsByCategory(Models.DataClassesDataContext data, int id, int parent) { return(data.tbl_items.OrderByDescending(a => a.date_added).Where(n => n.parent == parent && n.id != id).ToList()); }
public List <Models.tbl_module> getHomeModule(Models.DataClassesDataContext data) { var result = data.tbl_modules.Where(a => a.type == 2 && a.name_visible.Contains("1996")).OrderByDescending(a => a.date_added); return(result.ToList()); }
public void deleteAllNews(Models.DataClassesDataContext data) { data.tbl_news.DeleteAllOnSubmit(data.tbl_news); data.SubmitChanges(); }
public List <Models.tbl_support> getAllSupporters(Models.DataClassesDataContext data) { return(data.tbl_supports.ToList()); }
public int getNewsAmount(Models.DataClassesDataContext data) { return(data.tbl_news.Count()); }