public IActionResult AddCartDetail([FromBody] DTO.AccessoryJSON acc)
{
string msg;
Dictionary <string, DTO.Accessory> shoppingCart = HttpContext.Session.GetCollectionFromJson <Dictionary <string, DTO.Accessory> >("cart");
if (shoppingCart == null)
{
shoppingCart = new Dictionary <string, DTO.Accessory>();
}
AccessoryDAO dao = new AccessoryDAO(_context);
DTO.Accessory dto = dao.FindByPrimaryKey(acc.AccId);
dto.Quantity = int.Parse(acc.Quantity);
if (DTO.ShoppingCart.AddCart(dto, shoppingCart))
{
msg = "Added to cart";
}
else
{
msg = "Available quantity is not enough to buy.";
}
var obj = new
{
msg = msg,
count = shoppingCart.Count
};
HttpContext.Session.SetCollectionAsJson("cart", shoppingCart);
return(new JsonResult(obj));
}
public IActionResult GetRelatedAccessories([FromBody] DTO.Accessory acc)
{
AccessoryDAO dao = new AccessoryDAO(_context);
List <DTO.Accessory> list = dao.FindRelatedAccessories(acc.AccCatId, acc.AccId);
return(new JsonResult(list));
}
public IActionResult AddCart([FromBody] string accID)
{
string msg;
Dictionary <string, DTO.Accessory> cart = HttpContext.Session.GetCollectionFromJson <Dictionary <string, DTO.Accessory> >("cart") ?? new Dictionary <string, DTO.Accessory>();
AccessoryDAO dao = new AccessoryDAO(_context);
DTO.Accessory dto = dao.FindByPrimaryKey(accID);
dto.Quantity = 1;
if (DTO.ShoppingCart.AddCart(dto, cart))
{
msg = "Added to cart";
}
else
{
msg = "Available quantity is not enough to buy";
}
var obj = new
{
msg = msg,
count = cart.Count
};
HttpContext.Session.SetCollectionAsJson("cart", cart);
return(new JsonResult(obj));
}
public IActionResult CheckAccIDExisted([FromBody] string id)
{
AccessoryDAO dao = new AccessoryDAO(_context);
bool isExisted = dao.CheckExisted(id);
return(new JsonResult(isExisted));
}
public IActionResult FindByAccCatID(string accCatIDSearch, int?pageNumber)
{
AccessoryDAO dao = new AccessoryDAO(_context);
List <DTO.Accessory> list = dao.FindAllAccByAccCatID(accCatIDSearch, pageNumber);
return(View("Index", list));
}
public IActionResult FindLatestAccessories()
{
AccessoryDAO dao = new AccessoryDAO(_context);
List <DTO.Accessory> list = dao.FindLatestAccessories();
return(new JsonResult(list));
}
public IActionResult FindAccById(string accIdSearch)
{
AccessoryDAO dao = new AccessoryDAO(_context);
DTO.Accessory dto = dao.FindByPrimaryKey(accIdSearch);
if (dto != null)
{
FavoriteDAO fDAO = new FavoriteDAO(_context);
int countFav = fDAO.CountFavoriteByAccId(accIdSearch);
AccessoryCategoryDAO acDAO = new AccessoryCategoryDAO(_context);
string accCat = acDAO.FindByPrimaryKey(dto.AccCatId);
if (accCat.Equals(""))
{
ViewData["msg"] = "Load category of accessory failed";
return(View("Error Page"));
}
ViewData["countFav"] = countFav;
ViewData["accCatName"] = accCat;
ViewData["accIdSearch"] = accIdSearch;
return(View(dto));
}
else
{
ViewData["msg"] = "Accessory load failed";
return(View("Error Page"));
}
}
public IActionResult RestoreStorage([FromBody] string accTranID)
{
AccessoryDAO accDAO = new AccessoryDAO(_context);
TransactionRelDAO trDAO = new TransactionRelDAO(_context);
List <AccessoryTransactionRel> tranList = trDAO.FindByAccTranID(accTranID);
List <DTO.Accessory> accList = new List <DTO.Accessory>();
foreach (AccessoryTransactionRel tranRel in tranList)
{
DTO.Accessory accDTO = accDAO.FindByPrimaryKey(tranRel.AccId);
accDTO.Quantity += tranRel.Quantity + accDTO.AvailableQuantity;
accList.Add(accDTO);
}
string msg;
if (accDAO.Restore(accList))
{
msg = "Restore all canceled accessories success";
}
else
{
msg = "Restore all canceled accessories failed";
}
return(new JsonResult(msg));
}
public IActionResult Index()
{
PrincipalDAO dao = new PrincipalDAO(_context);
string username = HttpContext.Session.GetString("USER");
Principal dto = dao.FindByUsername(username);
if (dto != null)
{
ViewData["deliveryAddress"] = dto.Address;
ViewData["deliveryPhone"] = dto.Phone;
}
else
{
ViewData["msg"] = "Load checkout failed";
return(View("Error Page"));
}
Dictionary <string, DTO.Accessory> shoppingCart = HttpContext.Session.GetCollectionFromJson <Dictionary <string, DTO.Accessory> >("cart");
Dictionary <string, DTO.Accessory> cart = new Dictionary <string, DTO.Accessory>();
foreach (var item in shoppingCart)
{
string id = item.Key;
DTO.Accessory dtoSession = item.Value;
AccessoryDAO accDAO = new AccessoryDAO(_context);
DTO.Accessory accDTO = accDAO.FindByPrimaryKey(id);
accDTO.Quantity = dtoSession.Quantity;
cart.Add(id, accDTO);
}
return(View(cart));
}
public async Task <IActionResult> GetAllAccessory()
{
using (var accessoryDAO = new AccessoryDAO())
{
return(Json((await accessoryDAO.ReadAll(false))
.ToArray()));
}
}
public async Task <IActionResult> GetaccessorySearchResult(string keyword)
{
using (var accessoryDAO = new AccessoryDAO()){
return(Json((accessoryDAO.Context.Accessory
.Include(x => x.Product)
.Where(x => x.Product.Name.IndexOf(keyword, StringComparison.OrdinalIgnoreCase) != -1))
.ToArray()));
}
}
public IActionResult LoadCart()
{
Dictionary <string, DTO.Accessory> shoppingCart = HttpContext.Session.GetCollectionFromJson <Dictionary <string, DTO.Accessory> >("cart");
Dictionary <string, DTO.Accessory> cart = new Dictionary <string, DTO.Accessory>();
foreach (var item in shoppingCart)
{
string id = item.Key;
DTO.Accessory dtoSession = item.Value;
AccessoryDAO dao = new AccessoryDAO(_context);
DTO.Accessory accDTO = dao.FindByPrimaryKey(id);
accDTO.Quantity = dtoSession.Quantity;
cart.Add(id, accDTO);
}
return(new JsonResult(cart));
}
public IActionResult FindAccByLikeName([FromBody] DTO.AccSearchObj accSearch)
{
AccessoryDAO dao = new AccessoryDAO(_context);
List <DTO.Accessory> list;
if (accSearch.IsDeleteSearch.Equals("All"))
{
list = dao.FindAllAccByLikeName(accSearch.AccNameSearch);
}
else if (accSearch.IsDeleteSearch.Equals("True"))
{
list = dao.FindAccByLikeName(accSearch.AccNameSearch, true);
}
else
{
list = dao.FindAccByLikeName(accSearch.AccNameSearch, false);
}
return(new JsonResult(list));
}
public IActionResult UpdateAcc([FromBody] DTO.AccessoryJSON acc)
{
AccessoryDAO dao = new AccessoryDAO(_context);
Accessory dto = new Accessory
{
AccId = acc.AccId,
AccName = acc.AccName,
AccCatId = acc.AccCatId,
Brand = acc.Brand,
Description = acc.Description,
Price = Double.Parse(acc.Price),
StartSellingDate = DateTime.Parse(acc.StartSellingDate),
Image = acc.Image,
AvailableQuantity = int.Parse(acc.AvailableQuantity),
SalePercent = double.Parse(acc.SalePercent),
IsDelete = acc.IsDelete.Equals("true") ? true : false
};
bool result = dao.Update(dto);
return(new JsonResult(result));
}
public AccessoryDaoDemo()
{
accessoryDAO = new AccessoryDAO();
}
public IActionResult CheckOut([Bind("DeliveryAddress", "DeliveryPhone")] DTO.Transaction tran)
{
string generateAccTranID()
{
string id;
Random rd = new Random();
TransactionDAO dao = new TransactionDAO(_context);
do
{
id = "AT";
for (int i = 0; i < 4; i++)
{
id += rd.Next(10);
}
} while (dao.CheckExisted(id));
return(id);
}
AccessoryDAO accDAO = new AccessoryDAO(_context);
string userName = HttpContext.Session.GetString("USER");
Dictionary <string, DTO.Accessory> shoppingCart = HttpContext.Session.GetCollectionFromJson <Dictionary <string, DTO.Accessory> >("cart");
foreach (var item in shoppingCart)
{
string id = item.Key;
DTO.Accessory dtoSession = item.Value;
DTO.Accessory accDTO = accDAO.FindByPrimaryKey(id);
if (accDTO.IsDelete || accDTO.AvailableQuantity == 0 || accDTO.AvailableQuantity < dtoSession.Quantity)
{
return(RedirectToAction("Index", "ShoppingCart"));
}
}
TransactionDAO tranDAO = new TransactionDAO(_context);
string accTranID = generateAccTranID();
DTO.Transaction tranDTO = new DTO.Transaction(accTranID, userName, tran.DeliveryPhone, tran.DeliveryAddress, 0);
tranDAO.Insert(tranDTO);
double total = 0;
List <DTO.Accessory> list = new List <DTO.Accessory>();
foreach (var item in shoppingCart)
{
string id = item.Key;
DTO.Accessory dtoSession = item.Value;
DTO.Accessory accDTO = accDAO.FindByPrimaryKey(id);
DTO.TransactionRel tranRelDTO = new DTO.TransactionRel(id, accTranID, accDTO.AccName, accDTO.AccCatId, accDTO.Brand, accDTO.Description, accDTO.Image, accDTO.Price, accDTO.SalePercent, accDTO.StartSellingDate, dtoSession.Quantity, accDTO.AccCatName);
TransactionRelDAO tranRelDAO = new TransactionRelDAO(_context);
tranRelDAO.Insert(tranRelDTO);
accDTO.AvailableQuantity -= dtoSession.Quantity;
total += dtoSession.Quantity * accDTO.Price * (1 - accDTO.SalePercent);
list.Add(accDTO);
}
accDAO.Update(list);
total = (double)Math.Round(total * 100) / 100;
tranDTO.TotalPrice = total;
tranDAO.UpdateTotalPrice(total, accTranID);
shoppingCart.Clear();
HttpContext.Session.SetCollectionAsJson("cart", shoppingCart);
return(RedirectToAction("UserDetails", "Principal"));
}
public IActionResult Index(int?pageNumber)
{
AccessoryDAO dao = new AccessoryDAO(_context);
return(View(dao.FindAllAcc(pageNumber)));
}
public IActionResult FindByLikeName(string accSearch, int?pageNumber)
{
AccessoryDAO dao = new AccessoryDAO(_context);
return(View("Index", dao.FindAccByLikeName(accSearch, false, pageNumber)));
}