public async Task <ActionResult> DeleteConfirmed(int id)
{
sal_SalesCart sal_SalesCart = await db.sal_SalesCart.FindAsync(id);
db.sal_SalesCart.Remove(sal_SalesCart);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "SalesCartID,ItemID,ItemName,ItemQuantity,ItemPrice,TotalItemsPrice,SourceID,SourceName,SalesCartType,SalesCartDate")] sal_SalesCart sal_SalesCart)
{
if (ModelState.IsValid)
{
db.Entry(sal_SalesCart).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(sal_SalesCart));
}
// GET: CustomerFromInventoryCart/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
sal_SalesCart sal_SalesCart = await db.sal_SalesCart.FindAsync(id);
if (sal_SalesCart == null)
{
return(HttpNotFound());
}
return(View(sal_SalesCart));
}
public async Task <ActionResult> DeleteCartItem(int id)
{
int status = 0;
try
{
sal_SalesCart SaleCartitem = db.sal_SalesCart.Find(id);
// Old item
var SaleItem = db.sal_SaleItems.Where(I => I.ItemID == SaleCartitem.ItemID).FirstOrDefault();
var OldQuantity = SaleItem.SaleItemsQuantity;
SaleItem.SaleItemsQuantity = OldQuantity + SaleCartitem.ItemQuantity;
await db.SaveChangesAsync();
// Old item
// remove from cart
db.sal_SalesCart.Remove(SaleCartitem);
await db.SaveChangesAsync();
// remove from cart
status = 1;
}
catch (Exception)
{
status = 4;
throw;
}
return(new JsonResult {
Data = new { status = status }
});;
}
// GET: SalesCart/Details/5
public async Task <JsonResult> InsertSalesCart(sal_SalesCart SalesCart, int?SalesCartType)
{
int status = 0;
try
{
// Get item details from items table
var PointOfSale = Session["PointOfSaleID"].ToString();
int PointOfSaleID = int.Parse(PointOfSale);
var Item = db.sal_SaleItems.Where(I => I.ItemID == SalesCart.ItemID && I.PointOfSaleID == PointOfSaleID).FirstOrDefault();
var ItemInventoryOldQuantity = Item.SaleItemsQuantity;
// Get item details from items table
// Salse Cart Item
var v = db.sal_SalesCart.Where(I => I.ItemID == SalesCart.ItemID && I.SalesCartType == SalesCartType).FirstOrDefault();
// Salse Cart Item
var newQnatity = SalesCart.ItemQuantity;
if ((ItemInventoryOldQuantity - newQnatity) >= 0)
{
// Update item in sales cart
if (v != null)
{
var cartOldQuantity = v.ItemQuantity;
if (cartOldQuantity + SalesCart.ItemQuantity <= Item.SaleItemsQuantity)
{
v.ItemQuantity = cartOldQuantity + SalesCart.ItemQuantity;
var TotalItemsPrice = (cartOldQuantity + SalesCart.ItemQuantity) * Item.ItemSalePrice;
v.TotalItemsPrice = TotalItemsPrice;
db.SaveChanges();
status = 1; // success
}
else
{
status = 3; //Quantity error
}
}
// insert new item in sales cart
else
{
if (SalesCart.ItemQuantity <= Item.SaleItemsQuantity)
{
SalesCart.ItemPrice = Item.ItemSalePrice;
SalesCart.TotalItemsPrice = SalesCart.ItemQuantity * Item.ItemSalePrice;
SalesCart.SalesCartType = SalesCartType;
db.sal_SalesCart.Add(SalesCart);
await db.SaveChangesAsync();
status = 1; // success
}
else
{
status = 3; //Quantity error
}
}
}
// New Quantity > inventory Quantity
else
{
status = 3; // errror
}
}
catch (Exception)
{
status = 4;
throw;
}
return(new JsonResult {
Data = new { status = status }
});
//return Json(SalesCart);
}
public async Task <JsonResult> UpdatetSalesCart(sal_SalesCart SalesCart, string TotalItemsPrice, int?SalesCartType)
{
int status = 0;
try
{
var v = db.sal_SalesCart.Where(I => I.ItemID == SalesCart.ItemID && I.SalesCartType == SalesCartType).FirstOrDefault();
// Get item details from items table
var PointOfSale = Session["PointOfSaleID"].ToString();
int PointOfSaleID = int.Parse(PointOfSale);
var SaleItem = db.sal_SaleItems.Where(I => I.ItemID == SalesCart.ItemID && I.PointOfSaleID == PointOfSaleID).FirstOrDefault();
var ItemInventoryQuantity = SaleItem.SaleItemsQuantity;
var CartOldQuantity = v.ItemQuantity;
// Get item details from items table
// Depet (+) Update
if (SalesCart.ItemQuantity > CartOldQuantity)
{
var newQuantity = SalesCart.ItemQuantity + CartOldQuantity;
// Check Item Quantity in Point Of Sale
if (ItemInventoryQuantity - newQuantity >= 0)
{
v.ItemQuantity = SalesCart.ItemQuantity;
v.TotalItemsPrice = SalesCart.TotalItemsPrice;
db.SaveChanges();
// SaleItem.SaleItemsQuantity = ItemInventoryQuantity - newQuantity;
//await db.SaveChangesAsync();
status = 1;
}
// Cart Quantity > Item Quantity
else
{
status = 3;
}
}
// Cart quantity > new quantity (-)
else if (CartOldQuantity > SalesCart.ItemQuantity)
{
var newQuantity = CartOldQuantity - SalesCart.ItemQuantity;
if (ItemInventoryQuantity - newQuantity >= 0)
{
v.ItemQuantity = SalesCart.ItemQuantity;
v.TotalItemsPrice = SalesCart.TotalItemsPrice;
await db.SaveChangesAsync();
status = 1;
}
else
{
status = 3;
}
}
else // not (+) and not (-)
{
status = 1;
}
}
catch (Exception e)
{
status = 4;
}
return(new JsonResult {
Data = new { status = status }
});
//return Json(SalesCart);
}
