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 }
            });
        }
예제 #2
0
        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"));
        }
예제 #3
0
        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));
        }
예제 #4
0
        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 }
            });
        }
예제 #6
0
        // 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));
        }