Example #1
0
        public JsonResult AjaxMethod(string name)
        {
            //var rol = User.Identity.Name;
            //if (rol == "1")
            //{
            Total_cash_made person = new Total_cash_made
            {
                total = name
            };

            return(Json(person));

            //}
        }
Example #2
0
        public JsonResult setTempData(string name)
        {
            //ViewData.Remove("calculated");
            //var a = "'";
            //var b = "'";
            var c = name;

            Total_cash_made person = new Total_cash_made
            {
                total = c
            };

            //ViewData["calculated"] = name;

            return(Json(person));
        }
Example #3
0
        public IActionResult sell_Item(int id_finish, float quantity_sold, float submit_price, float Total_cash_made, string date)
        {
            DateTime date_ = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, E_Africa_standard_time);



            var check_if_exists = _context.sold_items.FirstOrDefault(x => x.Item_id.ToString() == id_finish.ToString() && x.DateTime == today);
            var shop_itemss     = _context.Shop_items.FirstOrDefault(x => x.id == id_finish);

            //LETS CHECK IF WE SOLD SIMILAR ITEM TODAY
            if (check_if_exists != null)
            {
                //WE HAVE SOLD SIMILAR ITEM TODAY

                var initial_quantity      = shop_itemss.Quantity;
                var initial_sold_quantity = check_if_exists.quantity_sold;
                if (initial_quantity <= 0)
                {
                    Total_cash_made person = new Total_cash_made
                    {
                        total = "Unable to sell the item.Stock running low"
                    };
                    return(Json(person));
                }
                else
                {
                    //LETS FIND TOTAL COST PRICE PER ITEM
                    float initial_cost_price_total = check_if_exists.Total_Cost_cash;
                    float total_cost_price         = shop_itemss.Cost_price * quantity_sold;
                    float final_cost_price         = initial_cost_price_total + total_cost_price;


                    //

                    //LETS SUBTRACT ITEMS
                    float new_quantity = initial_quantity + quantity_sold;
                    //LETS ADD SOLD ITEMS
                    float new_sold_quantity = initial_sold_quantity + quantity_sold;
                    //LETS GET INITIAL TOTAL CAS
                    float initial_total_cash = check_if_exists.Total_cash_made;
                    //LETS ADD TOTAL CASH
                    var new_total_cash = initial_total_cash + Total_cash_made;

                    //LETS UPDATE FIELDS
                    check_if_exists.DateTime              = today;
                    check_if_exists.Total_cash_made       = new_total_cash;
                    check_if_exists.quantity_sold         = new_sold_quantity;
                    check_if_exists.Total_Cost_cash       = final_cost_price;
                    _context.Entry(check_if_exists).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
                    _context.SaveChanges();

                    //LETS UPDATE  REMAINING QUANTITY
                    var   change_r  = _context.Shop_items.FirstOrDefault(x => x.id == id_finish);
                    float initial_q = change_r.Quantity;
                    float new_Q     = initial_q - quantity_sold;
                    change_r.Quantity = new_Q;
                    _context.Entry(change_r).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
                    _context.SaveChanges();
                    Total_cash_made person = new Total_cash_made
                    {
                        total = new_sold_quantity.ToString()
                    };
                    return(Json(person));
                }
            }
            else
            {
                //WE HAVENT SOLD ANY ITEM
                //LETS UPDATE QUANTITY
                //LETS UPDATE  REMAINING QUANTITY
                var   change_r  = _context.Shop_items.FirstOrDefault(x => x.id == id_finish);
                float initial_q = change_r.Quantity;
                float new_Q     = initial_q - quantity_sold;
                change_r.Quantity = new_Q;
                _context.Entry(change_r).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
                _context.SaveChanges();
                Total_cash_made person = new Total_cash_made
                {
                    total = "Sales have been done successfully sent to your printer."
                };
                //LETS FIND TOTAL COST PRICE PER ITEM
                var   check_if_exists1 = _context.sold_items.FirstOrDefault(x => x.Item_id.ToString() == id_finish.ToString() && x.DateTime == date);
                float final_cost_price;
                if (check_if_exists1 == null)
                {
                    float initial_cost_price_total = 0;
                    float total_cost_price         = shop_itemss.Cost_price * quantity_sold;
                    final_cost_price = initial_cost_price_total + total_cost_price;
                }
                else
                {
                    float initial_cost_price_total = check_if_exists1.Total_Cost_cash;
                    float total_cost_price         = shop_itemss.Cost_price * quantity_sold;
                    final_cost_price = initial_cost_price_total + total_cost_price;
                }



                //LETS CREATE NEW DOCUMENT FOR NEW DATES
                sold_items x = new sold_items
                {
                    Item_id         = id_finish,
                    quantity_sold   = quantity_sold,
                    Total_cash_made = Total_cash_made,
                    Total_Cost_cash = final_cost_price,
                    DateTime        = today
                };
                _context.Add(x);
                _context.SaveChanges();
                return(Json(person));
            }
        }