public async Task <IActionResult> PutDepartment(int id, [FromBody] cartModel department)
{
if (id != department.CartyId)
{
return(BadRequest());
}
_context.Entry(department).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (id != department.CartyId)
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
//show the quantity and for an item in cart table
public ActionResult Edit(int id)
{
SqlConnection con = new SqlConnection(constring);
String q = "SELECT * from Cart where ID=@id";
con.Open();
SqlCommand cmd = new SqlCommand(q, con);
cmd.Parameters.AddWithValue("@id", id);
cmd.ExecuteNonQuery();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
cartModel ob = new cartModel();
if (dt.Rows.Count == 1)
{
ob.name = dt.Rows[0][1].ToString();
ob.id = Convert.ToInt32(dt.Rows[0][0].ToString());
ob.price = Convert.ToDouble(dt.Rows[0][2].ToString());
ob.quantity = Convert.ToInt32(dt.Rows[0][3].ToString());
ob.category = dt.Rows[0][4].ToString();
ob.totalprice = Convert.ToDouble(dt.Rows[0][5].ToString());
}
return(View(ob));
}
public ActionResult Cart(cartModel ob)
{
SqlConnection con = new SqlConnection(constring);
String q1 = "select count(Product_Name) from Cart where UserId = " + ob.userid +
" and Product_Name LIKE '" + ob.name + "'";
SqlCommand cmd1 = new SqlCommand(q1, con);
con.Open();
int cnt = Convert.ToInt32(cmd1.ExecuteScalar());
con.Close();
if (cnt == 0)
{
String q = "INSERT into Cart(Product_Name,Price,quantity,Category,UserId) " +
"values(@name,@price,@quantity,@category,@userid)";
SqlCommand cmd = new SqlCommand(q, con);
con.Open();
cmd.Parameters.AddWithValue("@name", ob.name);
cmd.Parameters.AddWithValue("@price", ob.price);
cmd.Parameters.AddWithValue("@quantity", ob.quantity);
cmd.Parameters.AddWithValue("@category", ob.category);
cmd.Parameters.AddWithValue("@userid", ob.userid);
cmd.ExecuteNonQuery();
con.Close();
return(RedirectToAction("Index", "Cart"));
}
else
{
String q3 = "Select quantity from Cart where Product_Name = '" + ob.name + "'" +
"and UserId = " + ob.userid;
SqlCommand cmd3 = new SqlCommand(q3, con);
con.Open();
int quantityno = Convert.ToInt32(cmd3.ExecuteScalar());
int quantityupdated = quantityno + ob.quantity;
con.Close();
String q2 = "Update Cart set Quantity=" + quantityupdated + " where Product_Name = '" + ob.name + "'" +
"and UserId = " + ob.userid;
SqlCommand cmd2 = new SqlCommand(q2, con);
con.Open();
cmd2.ExecuteNonQuery();
con.Close();
return(RedirectToAction("Index", "Cart"));
}
}
public static List <cartModel> XoaSPTrongCart(int idSP, List <cartModel> li)
{
cartModel item = li.SingleOrDefault(x => x.maSP == idSP);
if (item != null)
{
li.Remove(item);
cartModel.tongTien -= item.thanhTien;
cartModel.tongSoHang -= item.soLuong;
}
return(li);
}
public static List <cartModel> SuaSoLuong(int id, int SLMoi, List <cartModel> li)
{
cartModel item = li.SingleOrDefault(x => x.maSP == id);
if (item != null)
{
cartModel.tongTien -= item.thanhTien;
cartModel.tongSoHang -= item.soLuong;
item.soLuong = SLMoi;
cartModel.tongTien += item.donGia;
cartModel.tongSoHang += item.soLuong;
}
return(li);
}
public ActionResult Edit(cartModel ob)
{
SqlConnection con = new SqlConnection(constring);
String q = "Update Cart set Quantity=@quantity where ID= @id";
SqlCommand cmd = new SqlCommand(q, con);
con.Open();
cmd.Parameters.AddWithValue("@id", ob.id);
cmd.Parameters.AddWithValue("@quantity", ob.quantity);
cmd.ExecuteNonQuery();
return(RedirectToAction("Index"));
}
public static List <cartModel> Them1SPVaoCart(int idSP, List <cartModel> li)
{
using (var ctx = new CoffeeHouseDbContext())
{
var query = ctx.sanphams.Where(x => x.masp == idSP).FirstOrDefault();
if (li.FirstOrDefault(x => x.maSP == idSP) != null)
{
cartModel item = li.FirstOrDefault(x => x.maSP == idSP);
int index = li.IndexOf(item);
item.soLuong++;
cartModel.tongTien += item.donGia;
if (index != -1)
{
li[index] = item;
}
return(li);
}
else
{
cartModel cart = new cartModel();
cart.maSP = (int)query.masp;
cart.tenSP = query.tensp;
cart.Hinh = query.hinhanh;
cart.donGiaKM = (int)query.giakm;
cart.donGiaGoc = (int)query.gia;
if (query.giakm != 0)
{
cart.donGia = (int)query.giakm;
}
else
{
cart.donGia = (int)query.gia;
}
cart.soLuong = 1;
cartModel.tongTien += cart.donGia;
cartModel.tongSoHang += 1;
li.Add(cart);
return(li);
}
}
//var query = new CoffeeHouseDbContext().sanphams.Where(x => x.masp == idSP).FirstOrDefault();
}
public JsonResult Index(string ItemId)
{
cartModel cartModel = new cartModel();
Item item = eCartDbEntities.Items.Single(a => a.ItemId.ToString() == ItemId);
if (Session["cartCounter"] != null)
{
cartModels = Session["cartItem"] as List <cartModel>;
}
//to check if item is in cart so as to increment quantity or add a new one
if (cartModels.Any(model => model.ItemId == ItemId))
{
cartModel = cartModels.Single(model => model.ItemId == ItemId);
cartModel.Quantity = cartModel.Quantity + 1;
cartModel.Total = cartModel.Quantity * cartModel.UnitPrice;
}
else
{
//if it does not exist then we add
cartModel.ItemId = ItemId;
cartModel.ImagePath = item.ImagePath;
cartModel.ItemName = item.ItemName;
cartModel.Quantity = 1;
cartModel.Total = item.ItemPrice;
cartModel.UnitPrice = item.ItemPrice;
cartModels.Add(cartModel);
}
//using session because of the http request once it is not there the list will be empty
//so with session it will not be empty for that particular session
//after adding to cartModels then add to session
Session["cartCounter"] = cartModels.Count;
Session["cartItem"] = cartModels;
return(Json(new { Success = true, Counter = cartModels.Count }, JsonRequestBehavior.AllowGet));
}
public static List <cartModel> ThemNSPVaoCart(int id, List <cartModel> li, int sl)
{
var query = new CoffeeHouseDbContext().sanphams.Where(x => x.masp == id).FirstOrDefault();
if (li.FirstOrDefault(x => x.maSP == id) != null)
{
cartModel item = li.FirstOrDefault(x => x.maSP == id);
item.soLuong += sl;
cartModel.tongTien += item.donGia * sl;
//return "ok";
return(li);
}
else
{
cartModel cart = new cartModel();
cart.maSP = (int)query.masp;
cart.tenSP = query.tensp;
cart.Hinh = query.hinhanh;
cart.donGiaKM = (int)query.giakm;
cart.donGiaGoc = (int)query.gia;
if (query.giakm != 0)
{
cart.donGia = (int)query.giakm;
}
else
{
cart.donGia = (int)query.gia;
}
cart.soLuong = sl;
cartModel.tongTien += cart.donGia * sl;
cartModel.tongSoHang += sl;
li.Add(cart);
//return "ok";
return(li);
}
}
public ActionResult Cart()
{
cartModel ob = new cartModel();
return(View(ob));
}
