public ActionResult DeleteConfirmed(int id) { tbl_productAnbar tbl_productAnbar = db.tbl_productAnbar.Find(id); db.tbl_productAnbar.Remove(tbl_productAnbar); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,productId,anbarId,number,minOrder,maxOrder,ghafase,location,days")] tbl_productAnbar tbl_productAnbar) { if (ModelState.IsValid) { db.Entry(tbl_productAnbar).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbl_productAnbar)); }
public ActionResult Create([Bind(Include = "Id,productId,anbarId,number,minOrder,maxOrder,ghafase,location,days")] tbl_productAnbar tbl_productAnbar) { if (ModelState.IsValid) { db.tbl_productAnbar.Add(tbl_productAnbar); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbl_productAnbar)); }
public ActionResult Edit([Bind(Include = "Id,productId,anbarId,number,minOrder,maxOrder,lastYearOrder,lastMonthOrder")] tbl_productAnbar tbl_productAnbar) { if (ModelState.IsValid) { tbl_productAnbar.lastYearOrder = int.Parse(persianDateClass.getPersianDateTime("yyyy")); tbl_productAnbar.lastMonthOrder = int.Parse(persianDateClass.getPersianDateTime("mm")); db.Entry(tbl_productAnbar).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbl_productAnbar)); }
// GET: productStore/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_productAnbar tbl_productAnbar = db.tbl_productAnbar.Find(id); if (tbl_productAnbar == null) { return(HttpNotFound()); } return(View(tbl_productAnbar)); }
public int insertProductAnbar(int anbarId, int maxProductAllow, int productId) { var tpa = new tbl_productAnbar(); tpa.anbarId = anbarId; tpa.days = 2; tpa.lastMonthOrder = int.Parse(anbardari.Models.Tools.persianDateClass.getPersianDateTime("mm")); tpa.lastYearOrder = int.Parse(anbardari.Models.Tools.persianDateClass.getPersianDateTime("yyyy")); tpa.maxOrder = maxProductAllow; tpa.productId = productId; db.tbl_productAnbar.Add(tpa); return(db.SaveChanges()); }
public JsonResult saveMaxNumberOfProduct(int productid, int number) { int res = -1; try { Database db = new Database(); var userid = int.Parse(Session["userid"].ToString()); var user = db.tbl_users.Where(u => u.Id == userid).FirstOrDefault(); var anbarProduct = db.tbl_productAnbar.Where(x => x.anbarId == user.anbarId && x.productId == productid ).FirstOrDefault(); if (anbarProduct == null) { var ap = new tbl_productAnbar(); ap.days = 2; ap.anbarId = (int)user.anbarId; ap.productId = productid; ap.maxOrder = number; ap.lastYearOrder = int.Parse(persianDateClass.getPersianDateTime("yyyy")); ap.lastMonthOrder = int.Parse(persianDateClass.getPersianDateTime("mm")); db.tbl_productAnbar.Add(ap); res = db.SaveChanges(); } else { anbarProduct.maxOrder = number; db.Entry(anbarProduct).State = EntityState.Modified; res = db.SaveChanges(); } return(Json(res)); } catch (Exception ex) { return(Json(res)); } }
public ActionResult Create([Bind(Include = "Id,orderId,date,time,anbar1,anbar2,price,state,barcode")] tbl_order tbl_order) { int userid = 0; try { userid = int.Parse(Session["userid"].ToString()); } catch (Exception ex) { return(Redirect("~/Home/")); } var currentUser = db.tbl_users.Where(x => x.Id == userid).FirstOrDefault(); if (!currentUser.admin && !currentUser.anbardar) { tbl_order.anbar1 = 1; if (currentUser.anbarId == null || currentUser.anbarId == 0) { return(View()); } tbl_order.anbar2 = currentUser.anbarId; if (string.IsNullOrEmpty(currentUser.pic)) { Session["alert"] = "danger"; Session["message"] = "شما هنوز امضای خود را بارگزاری نکرده اید.برای بارگزاری امضا <a href='/home/profile/" + currentUser.Id + "'>اینجا</a> را کلیک کنید"; return(View()); } } else { return(View()); } var date = Request.Form["date"].ToString(); var time = Request.Form["time"].ToString(); ModelState.Remove("date"); ModelState.Remove("time"); ModelState.Remove("barcode"); ModelState.Remove("orderId"); if (date != "") { tbl_order.date = int.Parse(tools.toEnglishNumber(date).Replace("/", "")); } if (time != "") { tbl_order.time = int.Parse(tools.toEnglishNumber(time).Replace(":", "")); } tbl_order.barcode = date.Replace("/", "") + new Random().Next(10000, 99999).ToString() + time.Replace(":", ""); int order = 1; if (db.tbl_order.ToList().Count > 0) { order = (int)db.tbl_order.OrderByDescending(x => x.orderId).FirstOrDefault().Id; } tbl_order.orderId = db.tbl_order.ToList().Count > 0 ? order + 1 : 1; if (ModelState.IsValid) { db.tbl_order.Add(tbl_order); var n = db.SaveChanges(); if (n > 0) { var orderId = db.tbl_order.Where(x => x.barcode == tbl_order.barcode).First().Id; var productIds = Request.Form["productId"]; var productNumbers = Request.Form["productNumber"]; var productArray = productIds.Split(','); var numberArray = productNumbers.Split(','); for (int i = 0; i < productArray.Length; i++) { try { var pid = int.Parse(productArray[i]); var product = db.tbl_product.Where(x => x.Id == pid).First(); var tblOProduct = new tbl_orderProduct(); tblOProduct.description = ""; tblOProduct.numberDarkhasti = int.Parse(numberArray[i]); tblOProduct.number = 0; tblOProduct.orderId = orderId; tblOProduct.personId = currentUser.Id; tblOProduct.price = 0; tblOProduct.productId = product.Id; tblOProduct.state = false; db.tbl_orderProduct.Add(tblOProduct); var y = db.SaveChanges(); if (y > 0) { var isLimited = db.tbl_productAnbar.Where(x => x.productId == product.Id && x.anbarId == currentUser.anbarId).FirstOrDefault(); if (isLimited == null) { var tpa = new tbl_productAnbar(); tpa.anbarId = (int)currentUser.anbarId; tpa.days = 2; tpa.lastMonthOrder = int.Parse(persianDateClass.getPersianDateTime("mm")); tpa.lastYearOrder = int.Parse(persianDateClass.getPersianDateTime("yyyy")); tpa.maxOrder = product.maxOrder; tpa.productId = product.Id; db.tbl_productAnbar.Add(tpa); db.SaveChanges(); } else { isLimited.lastMonthOrder = int.Parse(persianDateClass.getPersianDateTime("mm")); isLimited.lastYearOrder = int.Parse(persianDateClass.getPersianDateTime("yyyy")); db.Entry(isLimited).State = EntityState.Modified; db.SaveChanges(); } } } catch (Exception ex) { } } } return(RedirectToAction("Index")); } return(View(tbl_order)); }