public ActionResult AddToCart(int id)
{
Product product = new DBShop().Products.Find(id);
int quantity = Int16.Parse(Request["quantity"]);
ViewBag.product = product;
List <Cart> cartList;
Cart cart;
//Nếu sản phẩm giảm giá
decimal totalPrice;
if (product.TopDecrease == "true")
{
totalPrice = quantity * (Decimal)product.DecreasePrice;
}
else
{
totalPrice = quantity * (Decimal)product.Price;
}
if (Session["cart"] != null)
{
cartList = Session["cart"] as List <Cart>;
cart = new Cart(cartList.Count, product, quantity, totalPrice);
}
else
{
cartList = new List <Cart>();
cart = new Cart(0, product, quantity, totalPrice);
}
cartList.Add(cart);
Session["cart"] = cartList;
return(RedirectToAction("Index"));
}
/* FIND GENRE BY ID */
public static Genre Find_By_ID(int ID)
{
using (var db = new DBShop())
{
var tmp = db.DbGenre.Find(ID);
db.Dispose();
return(tmp);
}
}
/* FIND GENRE BY NAME */
public static Genre Find_By_Name(string Genre)
{
using (var db = new DBShop())
{
var tmp = db.DbGenre.Where(item => item.genre == Genre).FirstOrDefault();
db.Dispose();
return(tmp);
}
}
/* GET ALL GENRE */
public static List <Genre> Get_All_Genre()
{
using (var db = new DBShop())
{
var tmp = db.DbGenre.Where(item => item.flag == false).OrderBy(item => item.genre).ToList();
db.Dispose();
return(tmp);
}
}
/* RESTORE GENRE WERE DELETED */
public static List <Genre> Restore_Genre()
{
using (var db = new DBShop())
{
var tmp = db.DbGenre.Where(item => item.flag == true).ToList();
db.Dispose();
return(tmp);
}
}
/* CREATE GENRE */
public static void Create_Genre(string Name_Genre)
{
using (var db = new DBShop())
{
db.DbGenre.Add(new Genre {
genre = Name_Genre, flag = false
});
db.SaveChanges();
db.Dispose();
}
}
/* UPDATE GENRE */
public static void Update_Genre(int id, string Name_Genre)
{
using (var db = new DBShop())
{
var tmp = db.DbGenre.Find(id);
tmp.genre = Name_Genre;
db.Entry(tmp).State = EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
}
/*DELETE GENRE */
public static void Lock_Genre(int id)
{
using (var db = new DBShop())
{
var tmp = db.DbGenre.Find(id);
tmp.flag = true;
db.Entry(tmp).State = EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
}
/* RESTORE GENRE */
public static void Unlock_Genre(int id)
{
using (var db = new DBShop())
{
var tmp = db.DbGenre.Where(item => item.id == id && item.flag == true).FirstOrDefault();
tmp.flag = false;
db.Entry(tmp).State = EntityState.Modified;
db.SaveChanges();
db.Dispose();
}
}
public ActionResult BookManager()
{
if ((string)Session["role"] == "admin" || (string)Session["role"] == "staff")
{
using (var db = new DBShop())
{
int page_number = db.DbBook.Where(item => item.flag == false).Count();
ViewBag.PageNumber = (page_number / page_size) + (page_number % page_size == 0 ? 0 : 1);
ViewBag.Genre = GenreAction.Get_All_Genre();
db.Dispose();
}
return(View());
}
else
{
return(Redirect("~/Book/ShowBook"));
}
}
/* LIST CUSTOMER */
public ActionResult Index()
{
if (Session["id"] != null && ((string)Session["role"] == "admin" || Convert.ToInt32(Session["id"]) == 1))
{
using (var db = new DBShop())
{
int page_number = db.DbCustomer.Where(item => item.flag == false).Count();
db.Dispose();
ViewBag.Page = page_number / page_size + (page_number % page_size == 0 ? 0 : 1);
}
return(View());
}
else
{
return(Redirect("~/Book/ShowBook"));
}
//ViewBag.Customer = CustomerAction.Show_Customer();
//ViewBag.ID = Id;
}
/* GET CUSTOMER BY ID */
public ActionResult Customer_Info(int ID)
{
if (Session["id"] != null)
{
using (var db = new DBShop())
{
int page = db.DbBill.Count();
ViewBag.Customer = CustomerAction.Find_Customer(ID);
ViewBag.Page = page / page_size + (page % page_size == 0 ? 0 : 1);
db.Dispose();
}
return(View());
}
else
{
return(Redirect("~/Book/ShowBook"));
}
}
/* RESTORE DATA */
public ActionResult RestoreData()
{
if ((string)Session["role"] == "admin")
{
using (var db = new DBShop())
{
int page_customer = db.DbCustomer.Where(item => item.flag == true).Count();
int page_book = db.DbBook.Where(item => item.flag == true).Count();
db.Dispose();
ViewBag.Customer = page_customer / page_size + (page_customer % page_size == 0 ? 0 : 1);
ViewBag.Book = page_book / page_size + (page_book % page_size == 0 ? 0 : 1);
ViewBag.Genre = GenreAction.Restore_Genre();
}
return(View());
}
else
{
return(Redirect("~/Book/ShowBook"));
}
}
public ActionResult ShowBook()
{
using (var db = new DBShop())
{
int page_number = db.DbBook.Where(item => item.flag == false).Count();
ViewBag.PageNumber = (page_number / page_size) + (page_number % page_size == 0 ? 0 : 1);
db.Dispose();
}
if (Session["id"] == null)
{
if (ReportAction.Find_Month(DateTime.Now.Month) != null)
{
ReportAction.Change_Visit(1, DateTime.Now.Month);
}
else
{
ReportAction.Create_Visit(1, DateTime.Now.Month);
}
}
return(View());
}
public ProductService(DBShop dBShop)
{
dB = dBShop;
}
public MainMenuService(DBShop dBShop)
{
dB = dBShop;
}
public PropertyService(DBShop dBShop)
{
dB = dBShop;
}
public BannerService(DBShop dBShop)
{
dB = dBShop;
}
public CategoryService(DBShop dBShop)
{
dB = dBShop;
}
public BrandService(DBShop dBShop)
{
dB = dBShop;
}
public FavoriteService(DBShop dBShop)
{
dB = dBShop;
}
public CommentService(DBShop dBShop)
{
dB = dBShop;
}
public GalleryService(DBShop dBShop)
{
dB = dBShop;
}
public AddressService(DBShop dBShop)
{
dB = dBShop;
}
public ProductDetailService(DBShop dBShop)
{
dB = dBShop;
}
public UserService(DBShop dBShop)
{
dB = dBShop;
}
