public async Task OnPostAddBillsProducts(string productid) { ProductBills p = new ProductBills(); p.ProductCode = Convert.ToInt32(productid); p.UserId = _UserManager.GetUserId(HttpContext.User); p.code = ""; DbContext.Add(p); await DbContext.SaveChangesAsync(); }
public async Task <IActionResult> Addproducttobill(string code) { ProductBills p = new ProductBills(); p.ProductCode = Convert.ToInt32(code); p.UserId = _UserManager.GetUserId(HttpContext.User); p.code = ""; // p.Id = 457; await DbContext.ProductBills.AddAsync(p); await DbContext.SaveChangesAsync(); return(Json(p)); }
public ActionResult Edit_bill(EditBillViewModel model) { // var b = DbContext.ProductBills.Where(x => x.code == _UserManager.GetUserId(HttpContext.User) && x.code == "").ToList(); string ids = ""; float totalcost = 0; int id = model.products_ids[0]; Bills bill = new Bills(); bill.date = model.bill.date; bill.Discount = model.bill.Discount; bill.Taxes = model.bill.Taxes; bill.Id = model.bill.Id; bill.user = model.bill.user; // bill.cost = totalcost; bill.date = DateTime.UtcNow.ToString(); bill.Taxes = Convert.ToInt32(model.bill.Taxes); string UserId = DbContext.ProductBills.Where(u => u.ProductCode == id).FirstOrDefault().UserId; var removed_product = DbContext.ProductBills.Where(u => u.code == bill.Id.ToString()).ToList(); foreach (var p in removed_product) { DbContext.ProductBills.Remove(p); } DbContext.SaveChanges(); int j = 0; foreach (var p in model.products_ids) { for (int i = 0; i < model.products[j].Quantity; i++) { ids += p + " "; ProductBills pr = new ProductBills(); pr.code = model.bill.Id.ToString(); pr.UserId = UserId; pr.ProductCode = p; DbContext.ProductBills.Add(pr); } DbContext.SaveChanges(); j++; } bill.products_ids = ids; string[] b = ids.Split(' '); foreach (var p in b) { if (p == "") { continue; } Product p1 = DbContext.Store.Where(x => x.Id.ToString() == p).ToList()[0]; totalcost += p1.SellingPrice; } float z = 100; float tt = totalcost; int y1 = (Convert.ToInt32(model.bill.Discount)); float t = y1 / z; float m = (totalcost * t); totalcost -= m; y1 = Convert.ToInt32(model.bill.Taxes); t = y1 / z; m = (tt * t); totalcost += m; bill.cost = totalcost; DbContext.Bills.Update(bill); DbContext.SaveChanges(); return(RedirectToAction("Bill", new { Bill_Id = bill.Id })); }