public ActionResult Delete(int?id)
{
using (ShoppingCartDAL service = new ShoppingCartDAL())
{
return(RedirectToAction("Index"));
}
}
public JsonResult Delete(int id)
{
var CusUserSession = (CusUserLogin)Session[CommonConstants.CusUserSession];
if (CusUserSession != null)
{
var _sc = new ShoppingCartDAL().FindByCus(CusUserSession.CustomerID);
if (_sc != null)
{
var scDetail = new ShoppingCartDetailDAL().FindByProductID(_sc.ShoppingCartID, id);
new ShoppingCartDetailDAL().Delete(scDetail.ShoppingCartDetailID);
}
}
else if (CusUserSession == null)
{
var sessionCart = (List <CartItem>)Session[CartSession];
sessionCart.RemoveAll(x => x.Product.ProductID == id);
Session[CartSession] = sessionCart;
}
return(Json(new
{
status = true
}));
}
public ActionResult EditPost(ShoppingCarts shop)
{
using (ShoppingCartDAL service = new ShoppingCartDAL())
{
return(RedirectToAction("Index"));
}
}
public ActionResult AddToCart(int id)
{
//cek apakah user sudah login
if (Session["username"] == null)
{
if (User.Identity.IsAuthenticated)
{
Session["username"] = User.Identity.Name;
}
else
{
var tempUser = Guid.NewGuid().ToString();
Session["username"] = tempUser;
//return RedirectToAction("Login", "Account");
}
}
using (ShoppingCartDAL scService = new ShoppingCartDAL())
{
var newShoppingCart = new ShoppingCarts
{
CartID = Session["username"].ToString(),
Quantity = 1,
id_barang = id,
DateCreated = DateTime.Now
};
scService.TambahCart(newShoppingCart);
}
return(RedirectToAction("Index"));
}
public JsonResult DeleteAll()
{
var CusUserSession = (CusUserLogin)Session[CommonConstants.CusUserSession];
if (CusUserSession != null)
{
var _sc = new ShoppingCartDAL().FindByCus(CusUserSession.CustomerID);
if (_sc != null)
{
var listSCDetail = new ShoppingCartDetailDAL().ListByShoppingCartID(_sc.ShoppingCartID);
foreach (var item in listSCDetail)
{
new ShoppingCartDetailDAL().Delete(item.ShoppingCartDetailID);
}
new ShoppingCartDAL().Delete(_sc.ShoppingCartID);
}
}
else if (CusUserSession == null)
{
Session[CartSession] = null;
}
return(Json(new
{
status = true
}));
}
public static bool AddShoppingCartBatchIn(string productid, string detailsid, int quantity, EnumDocType ordertype, string remark, string guid, string userid, string operateip)
{
if (string.IsNullOrEmpty(guid))
{
guid = userid;
}
return(ShoppingCartDAL.AddShoppingCartBatchIn(productid, detailsid, quantity, (int)ordertype, remark, guid, userid, operateip));
}
public ActionResult Edit(int id)
{
using (ShoppingCartDAL service = new ShoppingCartDAL())
{
var shop = service.GetItemByID(id);
return(View(shop));
}
}
// GET: ShoppingCarts
public ActionResult Index()
{
using (ShoppingCartDAL scService = new ShoppingCartDAL())
{
string username =
Session["username"] != null ? Session["username"].ToString() : string.Empty;
return(View(scService.GetAllData(username).ToList()));
}
}
/// <summary>
/// 加入购物车
/// </summary>
/// <returns></returns>
public static bool AddShoppingCart(EnumDocType ordertype, string productid, string detailsid, decimal quantity, string unitid, string depotid, string taskid, string remark, string guid, string orderAttrID, string userid, string operateip)
{
if (string.IsNullOrEmpty(guid))
{
guid = userid;
}
return(ShoppingCartDAL.AddShoppingCart((int)ordertype, productid, detailsid, quantity, unitid, depotid, taskid,
remark, guid, orderAttrID, userid, operateip));
}
public static bool DeleteBook(string isbn)
{
result = ShoppingCartDAL.Delete(isbn);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取购物车列表
/// </summary>
public static List <ProductDetail> GetShoppingCart(EnumDocType ordertype, string guid, string userid)
{
DataTable dt = ShoppingCartDAL.GetShoppingCart((int)ordertype, guid, userid);
List <ProductDetail> list = new List <ProductDetail>();
foreach (DataRow dr in dt.Rows)
{
ProductDetail model = new ProductDetail();
model.FillData(dr);
list.Add(model);
}
return(list);
}
/// <summary>
/// 返回购物车页面代码
/// 登录之后才会有页面，这一点一定要记住
/// </summary>
/// <returns></returns>
public string GetShoppingCartHtmls()
{
int UserId = int.Parse(cookieHelper.GetCookie("UserId"));//若有，一定大于0
if (UserId > 0)
{
return(ShoppingCartDAL.GetShoppingCartHtmls(UserId, page));
}
else
{
return("");
}
}
// GET: Admin/ShoppingCarts/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var shoppingCart = new ShoppingCartDAL().ViewDetail(id);
if (shoppingCart == null)
{
return(HttpNotFound());
}
return(View(shoppingCart));
}
public ActionResult CheckOut()
{
if (User.Identity.IsAuthenticated)
{
using (ShoppingCartDAL service = new ShoppingCartDAL())
{
string username = Session["username"] != null ? Session["username"].ToString() : string.Empty;
return(View(service.GetAllData(username).ToList()));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
/// <summary>
/// 获取购物车列表
/// </summary>
public static List <ProductDetail> GetShoppingCart(EnumDocType ordertype, string guid, string userid)
{
DataTable dt = ShoppingCartDAL.GetShoppingCart((int)ordertype, guid, userid);
List <ProductDetail> list = new List <ProductDetail>();
foreach (DataRow dr in dt.Rows)
{
ProductDetail model = new ProductDetail();
model.FillData(dr);
if (!string.IsNullOrEmpty(model.UnitID))
{
model.UnitName = new ProductsBusiness().GetUnitByID(model.UnitID).UnitName;
}
list.Add(model);
}
return(list);
}
public JsonResult Update(string cartModel)
{
var CusUserSession = (CusUserLogin)Session[CommonConstants.CusUserSession];
var jsonCart = new JavaScriptSerializer().Deserialize <List <CartItem> >(cartModel);
if (CusUserSession != null)
{
var _sc = new ShoppingCartDAL().FindByCus(CusUserSession.CustomerID);
if (_sc != null)
{
var _dal = new ShoppingCartDetailDAL();
var listSCDetail = new ShoppingCartDetailDAL().ListByShoppingCartID(_sc.ShoppingCartID);
foreach (var item in listSCDetail)
{
var jsonItem = jsonCart.SingleOrDefault(x => x.Product.ProductID == item.Product.ProductID);
if (jsonItem != null)
{
item.Quantity = jsonItem.Quantity;
}
var _result = _dal.Update(item);
}
}
}
else if (CusUserSession == null)
{
var sessionCart = (List <CartItem>)Session[CartSession];
foreach (var item in sessionCart)
{
var jsonItem = jsonCart.SingleOrDefault(x => x.Product.ProductID == item.Product.ProductID);
if (jsonItem != null)
{
item.Quantity = jsonItem.Quantity;
}
}
Session[CartSession] = sessionCart;
}
return(Json(new
{
status = true
}));
}
public ActionResult Edit([Bind(Include = "ShoppingCartID,CustomerID,ShoppingDate,ExpireDate,Note,CreateDate,CreateUser,ModifiedDate,ModifiedUser,IsActive")] ShoppingCart shoppingCart)
{
var UserSession = (UserLogin)Session[TechDeviShopVs002.Common.CommonConstants.USER_SESSION];
if (ModelState.IsValid)
{
var _dal = new ShoppingCartDAL();
shoppingCart.ModifiedUser = UserSession.UserID;
var _result = _dal.Update(shoppingCart);
if (_result)
{
return(RedirectToAction("Index", "ShoppingCarts"));
}
else
{
ModelState.AddModelError("", "Cập nhật giỏ hàng ko thành công");
}
}
return(View(shoppingCart));
}
public ActionResult Payment()
{
var cart = Session[CartSession];
var CusUserSession = (CusUserLogin)Session[CommonConstants.CusUserSession];
if (CusUserSession != null)
{
var list = new List <CartItem>();
var _sc = new ShoppingCartDAL().FindByCus(CusUserSession.CustomerID);
if (_sc != null)
{
int scid = _sc.ShoppingCartID;
var listSCD = new ShoppingCartDetailDAL().ListByShoppingCartID(scid).ToList();
if (listSCD != null)
{
foreach (var item in listSCD)
{
CartItem cIt = new CartItem();
cIt.ShoppingCartID = item.ShoppingCartID;
cIt.ShoppingCartDetailID = item.ShoppingCartDetailID;
cIt.Product = item.Product;
cIt.Quantity = (int)item.Quantity;
list.Add((CartItem)cIt);
}
}
}
return(View(list));
}
else
{
var list = new List <CartItem>();
if (cart != null)
{
list = (List <CartItem>)cart;
}
return(View(list));
}
}
/// <summary>
/// 删除购物车记录
/// </summary>
/// <param name="autoid"></param>
/// <param name="userid"></param>
/// <param name="clientid"></param>
/// <returns></returns>
public static bool DeleteCart(string autoid, string userid)
{
return(ShoppingCartDAL.DeleteCart(autoid, userid));
}
public static bool UpdateCartPrice(string autoid, decimal price, string userid)
{
return(ShoppingCartDAL.UpdateCartPrice(autoid, price, userid));
}
/// <summary>
/// 编辑购物车产品数量
/// </summary>
/// <param name="autoid"></param>
/// <param name="quantity"></param>
/// <returns></returns>
public static bool UpdateCartQuantity(string autoid, int quantity, string userid)
{
return(ShoppingCartDAL.UpdateCartQuantity(autoid, quantity, userid));
}
public ActionResult AddItem(int productId, int quantity)
{
var CusUserSession = (CusUserLogin)Session[CommonConstants.CusUserSession];
var product = new ProductDAL().ViewDetail(productId);
var cart = Session[CartSession];
if (CusUserSession == null)
{
if (cart != null)
{
var list = (List <CartItem>)cart;
if (list.Exists(x => x.Product.ProductID == productId))
{
foreach (var item in list)
{
if (item.Product.ProductID == productId)
{
item.Quantity += quantity;
}
}
}
else
{
//tạo mới đối tượng cart item
var item = new CartItem();
item.Product = product;
item.Quantity = quantity;
list.Add(item);
}
//Gán vào session
Session[CartSession] = list;
}
else
{
//tạo mới đối tượng cart item
var item = new CartItem();
item.Product = product;
item.Quantity = quantity;
var list = new List <CartItem>();
list.Add(item);
//Gán vào session
Session[CartSession] = list;
}
}
else if (CusUserSession != null) //cusUserSession != null;
{
var _sc = new ShoppingCartDAL().FindByCus(CusUserSession.CustomerID);
if (_sc != null)
{
int _scID = _sc.ShoppingCartID;
//var list = (List<CartItem>)cart;
var _dal = new ShoppingCartDetailDAL();
//foreach (var item in list)
//{
// _scID = item.ShoppingCartID;
//}
//if (list.Exists(x => x.Product.ProductID == productId))
//{
// foreach (var item in list)
// {
// if (item.Product.ProductID == productId)
// {
// item.Quantity += quantity;
// }
// }
//}
//else
//{
// //tạo mới đối tượng cart item
// var item = new CartItem();
// item.Product = product;
// item.Quantity = quantity;
// item.ShoppingCartID = _scID;
// list.Add(item);
//}
var listSCDetail = new ShoppingCartDetailDAL().ListByShoppingCartID(_scID);
if (listSCDetail.Exists(x => x.Product.ProductID == productId))
{
foreach (var item in listSCDetail)
{
if (item.Product.ProductID == productId)
{
item.Quantity += quantity;
}
var _result = _dal.Update(item);
}
}
else
{
//tạo mới shopping cartdetail
var scDetailitem = new ShoppingCartDetail();
scDetailitem.ShoppingCartID = _scID;
scDetailitem.ProductID = product.ProductID;
scDetailitem.ProductName = product.ProductName;
scDetailitem.Quantity = quantity;
scDetailitem.UnitPrice = product.Price;
scDetailitem.PromotionPrice = product.PromotionPrice;
var _result = _dal.Insert(scDetailitem);
}
////Gán vào session
//Session[CartSession] = list;
}
else if (_sc == null)//cart == null
{
//tạo mới giỏ hàng, giỏ hàng chi tiết;
var _shoppingCart = new ShoppingCart();
_shoppingCart.ShoppingDate = DateTime.Now;
_shoppingCart.CustomerID = CusUserSession.CustomerID;
_shoppingCart.CreateUser = CusUserSession.CustomerID;
_shoppingCart.IsActive = true;
var _scart = new ShoppingCartDAL().Insert(_shoppingCart);
var _shoppingCartDetail = new ShoppingCartDetail();
_shoppingCartDetail.ShoppingCartID = _scart;
_shoppingCartDetail.ProductID = product.ProductID;
_shoppingCartDetail.ProductName = product.ProductName;
_shoppingCartDetail.Quantity = quantity;
_shoppingCartDetail.UnitPrice = product.Price;
_shoppingCartDetail.PromotionPrice = product.PromotionPrice;
var _scartDetail = new ShoppingCartDetailDAL().Insert(_shoppingCartDetail);
////tạo mới đối tượng cart item
//var item = new CartItem();
//item.Product = product;
//item.Quantity = quantity;
//item.ShoppingCartID = _shoppingCart.ShoppingCartID;
//var list = new List<CartItem>();
//list.Add(item);
////Gán vào session
//Session[CartSession] = list;
}
}
return(RedirectToAction("Index"));
}
public ActionResult Payment(string shipName, string mobile, string address, string email)
{
var CusUserSession = (CusUserLogin)Session[TechDeviShopVs002.Common.CommonConstants.CusUserSession];
var _sc = new ShoppingCartDAL().FindByCus(CusUserSession.CustomerID);
var order = new Order();
order.CustomerID = CusUserSession.CustomerID;
order.OrderDate = DateTime.Now;
order.Address = address;
order.CusPhone = mobile;
order.CusName = shipName;
order.CusEmail = email;
order.ShipperID = 1;
order.ShippingMethodID = 2;
order.OrderStatusID = 1;
order.IsActive = true;
try
{
var id = new OrderDAL().Insert(order);
//var cart = (List<CartItem>)Session[CartSession];
int scid = _sc.ShoppingCartID;
var listSCD = new ShoppingCartDetailDAL().ListByShoppingCartID(scid).ToList();
decimal total = 0;
foreach (var item in listSCD)
{
//Create order detail;
var orderDetail = new OrderDetail();
orderDetail.ProductID = item.Product.ProductID;
orderDetail.OrderID = id;
orderDetail.ProductName = item.Product.ProductName;
orderDetail.ProductCode = item.Product.ProductCode;
orderDetail.UnitPrice = item.Product.Price;
orderDetail.PromotionPrice = item.Product.PromotionPrice;
orderDetail.Quantity = item.Quantity;
orderDetail.IsActive = true;
var detailDal = new OrderDetailsDAL().Insert(orderDetail);
//End Shopping Cart
var spcart = new ShoppingCartDAL().ViewDetail(item.ShoppingCartID);
spcart.ExpireDate = DateTime.Now;
var spcartResult = new ShoppingCartDAL().Update(spcart);
//calculated total price;
total += (item.Product.Price.GetValueOrDefault(0) * (int)item.Quantity);
}
string content = System.IO.File.ReadAllText(Server.MapPath("~/Assets/Client/template/neworder.html"));
content = content.Replace("{{CustomerName}}", shipName);
content = content.Replace("{{Phone}}", mobile);
content = content.Replace("{{Email}}", email);
content = content.Replace("{{Address}}", address);
content = content.Replace("{{Total}}", total.ToString("N0"));
var toEmail = ConfigurationManager.AppSettings["ToEmailAddress"].ToString();
new MailHelper().SendMail(email, "Đơn hàng mới từ OnlineShop", content);
new MailHelper().SendMail(toEmail, "Đơn hàng mới từ OnlineShop", content);
}
catch (Exception)
{
//ghi log
return(Redirect("/loi-thanh-toan"));
}
return(Redirect("/hoan-thanh"));
}
