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));
}
