public ActionResult AddBillsContent(BillsContent _BillContent, Bills _bill, string barcodeProduct, Produt_Price pro_price, int Quantity, string Client_ID) { bool res = s.Users(); if (res == true) { if (Session["flag"].ToString() == "true") { _bill.date = DateTime.Now; var ClintID = _db.Clients.Where(p => p.name == Client_ID).FirstOrDefault(); _bill.Client_ID = ClintID.Client_ID; Session["CLientID"] = ClintID.Client_ID; _bill.Cate_Id = 1; _bill.User_ID = int.Parse(Session["userID"].ToString()); _bill.Viewed = true; _db.Bills.Add(_bill); _db.SaveChanges(); } var LastId = _db.Bills.OrderByDescending(u => u.Id).FirstOrDefault(); _BillContent.Bill_ID = LastId.Id; // _BillContent.Price = price; _BillContent.Quantity = _BillContent.Quantity; var prodids = _db.Products.Where(d => d.name == barcodeProduct).Select(f => f.Pro_id).FirstOrDefault(); _BillContent.Product_ID = prodids; _BillContent.Cost = _db.Produt_Price.Where(s => s.Pro_ID == prodids).Select(p => p.cost).FirstOrDefault(); _BillContent.Viewed = true; _db.BillsContent.Add(_BillContent); _db.SaveChanges(); //edit quntity var proQuantity = _db.Produt_Price.Where(s => s.Pro_ID == prodids).FirstOrDefault(); Produt_Price model = _db.Produt_Price.Find(proQuantity.Prd_Pri_ID); model.Quantity = model.Quantity - Quantity; model.Store_Id = 1; model.Pro_ID = prodids; model.Minmum = model.Minmum; model.many_price = model.many_price; model.Price = model.Price; model.cost = model.cost; _db.Entry(model).State = EntityState.Modified; _db.SaveChanges(); Session["flag"] = "false"; return(RedirectToAction("Purchases")); } return(RedirectToAction("HavntAccess", "Employee")); }
//public JsonResult SaveDataInDatabase(Produt_Price model, bool active) //{ // var result = false; // try // { // Produt_Price pro = _db.Produt_Price.SingleOrDefault(x => x.Prd_Pri_ID == model.Prd_Pri_ID); // pro.cost = model.cost; // pro.Price = model.Price; // pro.Quantity = model.Quantity; // pro.Minmum = model.Minmum; // pro.Discount = model.Discount; // pro.many_price = model.many_price; // pro.active = model.active; // pro.Pro_ID = model.Pro_ID; // _db.SaveChanges(); // result = true; // } // catch (Exception ex) // { // throw ex; // } // return Json(result, JsonRequestBehavior.AllowGet); //} #endregion #region save new product public JsonResult SaveProduct(string Cat, string barcode, string name, decimal?cost, decimal?Price, decimal?Quantity, decimal?Minmum, decimal?Discount, bool active) { Products modelProduct = new Products(); modelProduct.name = name; modelProduct.barcode = barcode; // modelProduct.active = active ??default(bool); modelProduct.Cate_ID = _db.ProductCategory.Where(p => p.name == Cat).Select(f => f.Cate_ID).FirstOrDefault(); _db.Products.Add(modelProduct); _db.SaveChanges(); Produt_Price modelPrice = new Produt_Price(); modelPrice.Pro_ID = modelProduct.Pro_id; modelPrice.cost = cost ?? default(decimal); modelPrice.Price = Price ?? default(decimal); modelPrice.Quantity = Quantity ?? default(decimal); modelPrice.Minmum = Minmum ?? default(decimal); modelPrice.Discount = Discount ?? default(decimal); modelPrice.active = active; _db.Produt_Price.Add(modelPrice); _db.SaveChanges(); bool result = true; return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult GetBillById(int Pro_id) { Produt_Price model = _db.Produt_Price.Where(x => x.Pro_ID == Pro_id).SingleOrDefault(); string value = string.Empty; value = JsonConvert.SerializeObject(model, Formatting.Indented, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); return(Json(value, JsonRequestBehavior.AllowGet)); }
public JsonResult ReturnValue(int Pro_id) { List <Produt_Price> result = new List <Produt_Price>(); var model = _db.Produt_Price.Where(i => i.Pro_ID == Pro_id); // decimal result = model.Quantity; foreach (var item in model) { Produt_Price mo = new Produt_Price(); mo.Prd_Pri_ID = item.Prd_Pri_ID; mo.Quantity = item.Quantity; mo.Minmum = item.Minmum; mo.cost = item.cost; mo.Price = item.Price; result.Add(mo); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult ReturnValueByName(string name) { List <Produt_Price> result = new List <Produt_Price>(); var model = _db.Products.Where(i => i.name == name).FirstOrDefault(); var model2 = _db.Produt_Price.Where(i => i.Pro_ID == model.Pro_id).ToList(); // decimal result = model.Quantity; foreach (var item in model2) { Produt_Price mo = new Produt_Price(); mo.Prd_Pri_ID = item.Prd_Pri_ID; mo.Quantity = item.Quantity; mo.Minmum = item.Minmum; mo.cost = item.cost; mo.Price = item.Price; result.Add(mo); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteContentRecordOfBuy(int BillsContent_ID, Produt_Price _proPrice) { bool result = false; var Stu = _db.BillsContent.SingleOrDefault(x => x.BillsContent_ID == BillsContent_ID); var model = _db.Produt_Price.Where(p => p.Pro_ID == Stu.Product_ID).FirstOrDefault(); if (Stu != null) { Stu.IsDeleted = true; _db.SaveChanges(); model.Quantity = model.Quantity - Stu.Quantity; _db.Entry(model).State = EntityState.Modified; _db.SaveChanges(); result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult saveReturnFatora(BillsContent content, string pro, Produt_Price pro_price, int Quantity, int price, int Bill_ID, Bills bill) { // bool result = true; int userID = int.Parse(Session["userID"].ToString()); // printer name string PrinterID = _db.Users.Where(d => d.Id == userID).Select(f => f.printer_name).FirstOrDefault(); string printerName = _db.PrintType.Where(id => id.ID.ToString() == PrinterID).Select(f => f.PrinterName).FirstOrDefault(); content.Price = price; var GetProID = _db.Products.Where(i => i.name == pro).FirstOrDefault(); content.Product_ID = GetProID.Pro_id; content.Quantity = -1 * Quantity; _db.BillsContent.Add(content); _db.SaveChanges(); //edit quantity pro_price = _db.Produt_Price.Where(p => p.Pro_ID == GetProID.Pro_id).FirstOrDefault(); pro_price.Quantity = pro_price.Quantity + Quantity; _db.Entry(pro_price).State = EntityState.Modified; _db.SaveChanges(); //edit all price decimal res = 0; var model = _db.BillsContent.Where(s => s.Bill_ID == Bill_ID).ToList(); foreach (var item in model) { res += item.Quantity * item.Price; } bill = _db.Bills.Where(p => p.Id == Bill_ID).FirstOrDefault(); bill.price = res; _db.Entry(bill).State = EntityState.Modified; _db.SaveChanges(); var usernameID = _db.Bills.Where(d => d.Id == Bill_ID).Select(f => f.User_ID).FirstOrDefault(); //print ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Report/ReturnBill.rpt"))); rd.SetDataSource(_db.BillsContent.Where(d => d.Bill_ID == Bill_ID).Select(p => new { id = p.Bill_ID, Quantity = Quantity, Price = price, User_ID = _db.Users.Where(d => d.Id == usernameID).Select(f => f.name).FirstOrDefault(), Pro_ID = pro, Expr2 = price * Quantity, //info many_price = _db.PLaceInfo.Select(f => f.Img).FirstOrDefault(), active = _db.PLaceInfo.Select(f => f.PlaceName).FirstOrDefault(), status = _db.PLaceInfo.Select(f => f.Number).FirstOrDefault(), }).ToList()); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); rd.PrintOptions.PrinterName = printerName; rd.PrintToPrinter(1, false, 0, 0); rd.Refresh(); return(RedirectToAction("ReturnBill")); //return File(stream, "aaplication/pdf", "فاتوره بيع.pdf"); }