public async Task <ActionResult> ReverseAll(int id) { int status = 1; sal_Reciept Reciept = await db.sal_Reciept.FindAsync(id); List <sal_Sales> Sales = db.sal_Sales.Where(I => I.RecieptNo == Reciept.RecieptNo).ToList(); // 1: Return Reciept Items Quantities into Inventory var PointOfSaleId = Reciept.PointOfSaleID; foreach (var item in Sales) { Functions.Functions.ReturnSalesItem(item.SalesItemsID, PointOfSaleId, item.SaleQuantity); sal_Sales sales = await db.sal_Sales.FindAsync(item.SaleID); sales.SaleIsReturned = true; sales.SaleReturnedDate = DateTime.Now; } Reciept.RecieptIsReturned = true; Reciept.RecieptReturnDate = DateTime.Now; await db.SaveChangesAsync(); return(new JsonResult { Data = new { status = status } }); }
public async Task <ActionResult> DeleteConfirmed(int id) { sal_Sales sal_Sales = await db.sal_Sales.FindAsync(id); db.sal_Sales.Remove(sal_Sales); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Edit([Bind(Include = "SaleID,SalePrice,RecieptNo,SalesItemsID,ItemName,ItemSalePrice,ItemPurchasePrice,SaleQuantity,ItemTotalSaleAmount,SaleIsReturned,SaleReturnedDate,SaleDate,UpLoaded")] sal_Sales sal_Sales) { if (ModelState.IsValid) { db.Entry(sal_Sales).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(sal_Sales)); }
public async Task <ActionResult> Create([Bind(Include = "SaleID,SalesItemsID,SaleQuantity,SalePrice,RecieptNo,SaleIsReturned,SaleReturnedDate,SaleDate")] sal_Sales sal_Sales) { if (ModelState.IsValid) { db.sal_Sales.Add(sal_Sales); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(sal_Sales)); }
public async Task <ActionResult> ReverseOne(int id) { int status = 1; sal_Sales Sales = await db.sal_Sales.FindAsync(id); db.sal_Sales.Remove(Sales); await db.SaveChangesAsync(); return(new JsonResult { Data = new { status = status } }); }
// GET: SalesDetailReport/Details/5 public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } sal_Sales sal_Sales = await db.sal_Sales.FindAsync(id); if (sal_Sales == null) { return(HttpNotFound()); } return(View(sal_Sales)); }