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