public IActionResult Confirm(web_CusDB.tblReqContractRow model, bool sms, string Txtsms, Guid[] mahsulss, web_CusDB.tblReqContractRow.ResEnum kind) { var dbcus = new web_CusDB.db_Context(); var db = new web_db.sardweb_Context(); var x = dbcus.tblReqContracts.Include(a => a.tblReqContractRows) .Include(a => a.tblCus).SingleOrDefault(a => a.Id == model.Id); x._LasttblReqContractRows = x.tblReqContractRows.OrderByDescending(a => a.Date).First(); var z = db.TblProducts.Where(a => mahsulss.Contains(a.Id)).Select(a => a.Title).ToList(); z.AddRange(db.TblPackings.Where(a => mahsulss.Contains(a.Id)).Select(a => a.Title).ToList()); model.CodeMahsuls = mahsulss.ToJson(); model.Mahsuls = string.Join(',', z); dbcus.tblReqContractRows.Add(new web_CusDB.tblReqContractRow { Id = Guid.NewGuid(), CodeMahsuls = model.CodeMahsuls, Mahsuls = model.Mahsuls, Date = DateTime.Now, ResDate = DateTime.Now, ResTxt = model.ResTxt, ResUserId = User._getuserid(), TblReqContractId = x.Id, Vaziat = kind, WeightCount = model.WeightCount }); //var row = db.tbl.Find(id); //row.WeightConfirm = WeightConfirm; //row.KindQueu = kind; //row.TxtReq = TxtReq; if (sms && Txtsms.IsEmpty() == false && Txtsms.Length > 5) { Models.cl._listSmsForSend.Add(new Models.cl.SmsForSend { number = x.tblCus.Mob, txt = Txtsms }); } dbcus.SaveChanges(); return(RedirectToAction(nameof(List))); }
public IActionResult New(web_db._Weighing.TblContractType.KindCotractTypeEnum?Kind = null) { ViewBag.Kind = Kind; var row = new web_CusDB.tblReqContractRow(); var dbweb = new web_db.sardweb_Context(); if (Kind == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane) { ViewBag.listPacking = dbweb.TblPackings.AsEnumerable().Where(a => a.ForContractType().Contains(web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane) && a.IsActive == true) .OrderBy(a => a.Code).ToList(); } else if (Kind == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad) { ViewBag.listPacking = dbweb.TblPackings.AsEnumerable().Where(a => a.ForContractType().Contains(web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad) && a.IsActive == true) .OrderBy(a => a.Code).ToList(); } ViewBag.listProduct = dbweb.TblProducts.Where(a => a.IsActive).OrderBy(a => a.Ord).ToList(); ViewBag.US_WeightMax = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightMax) ?? new web_db.TblConf()).Value; ViewBag.US_WeightMin = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightMin) ?? new web_db.TblConf()).Value; ViewBag.US_WeightVahed = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightVahed) ?? new web_db.TblConf()).Value; ViewBag.US_WeightZarib = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightZarib) ?? new web_db.TblConf()).Value; var Kinds = dbweb.TblContractTypes.Where(a => a.FkSalmali == dbweb.TblSalMalis.SingleOrDefault(a => a.IsOpen && a.IsOrginal).Id).Select(a => a.KindCotractType).Distinct().ToList(); Kinds.Remove(web_db._Weighing.TblContractType.KindCotractTypeEnum.ABaskul); ViewBag.kinds = Kinds; return(View(row)); }
public IActionResult New(web_db._Weighing.TblContractType.KindCotractTypeEnum Kind, web_CusDB.tblReqContractRow model, List <Guid> Product, List <Guid> Packing) { var dbweb = new web_db.sardweb_Context(); if (Kind == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane) { if (!Product.Any()) { ModelState.AddModelError("CodeMahsuls", "محصولات انتخاب نشده است"); } if (!Packing.Any()) { ModelState.AddModelError("CodeMahsuls", "سبد انتخاب نشده است"); } } else if (Kind == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad) { if (!Packing.Any()) { ModelState.AddModelError("CodeMahsuls", "سبد انتخاب نشده است"); } } if (model.WeightCount < 10) { ModelState.AddModelError("WeightCount", "مقدار اشتباه است"); } if (ModelState.IsValid) { var db = new web_CusDB.db_Context(); var row = new web_CusDB.tblReqContract { Code = (db.tblReqContracts.Max(a => (long?)a.Code) ?? 0) + 1, DateAdd = DateTime.Now, DateLast = DateTime.Now, Id = Guid.NewGuid(), KindContract = Kind, tblCusId = User._getuserId().Value, }; db.tblReqContracts.Add(row); var p = new List <Guid>(); p.AddRange(Product); p.AddRange(Packing); var z = dbweb.TblProducts.Where(a => Product.Contains(a.Id)).Select(a => a.Title).ToList(); z.AddRange(dbweb.TblPackings.Where(a => Packing.Contains(a.Id)).Select(a => a.Title).ToList()); db.tblReqContractRows.Add(new web_CusDB.tblReqContractRow { CodeMahsuls = p.ToJson(), Date = row.DateLast, Id = Guid.NewGuid(), Vaziat = web_CusDB.tblReqContractRow.ResEnum.Save, WeightCount = model.WeightCount, TblReqContractId = row.Id, Mahsuls = string.Join(',', z) }); db.SaveChanges(); var dbmain = new web_db.sardweb_Context(); sms sms = new sms() { numfrom = dbmain.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Main_NumSms).Value, password = dbmain.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Main_PassSms).Value, username = dbmain.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Main_UserSms).Value, }; var us = db.TblCustomers.Find(User._getuserId().Value); sms.sendsmsAsync(us.Mob, (dbmain.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Main_SherkatName) ?? new web_db.TblConf()).Value + @$ " درخواست شما با کد " + row.Code.ToString() + " ثبت گردید"); return(RedirectToAction("Index")); } if (Kind == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane) { ViewBag.listPacking = dbweb.TblPackings.AsEnumerable().Where(a => a.ForContractType().Contains(web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane) && a.IsActive == true) .OrderBy(a => a.Code).ToList(); } else if (Kind == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad) { ViewBag.listPacking = dbweb.TblPackings.AsEnumerable().Where(a => a.ForContractType().Contains(web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad) && a.IsActive == true) .OrderBy(a => a.Code).ToList(); } ViewBag.listProduct = dbweb.TblProducts.Where(a => a.IsActive).OrderBy(a => a.Ord).ToList(); ViewBag.US_WeightMax = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightMax) ?? new web_db.TblConf()).Value; ViewBag.US_WeightMin = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightMin) ?? new web_db.TblConf()).Value; ViewBag.US_WeightVahed = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightVahed) ?? new web_db.TblConf()).Value; ViewBag.US_WeightZarib = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightZarib) ?? new web_db.TblConf()).Value; ViewBag.Kind = Kind; var Kinds = dbweb.TblContractTypes.Where(a => a.FkSalmali == dbweb.TblSalMalis.SingleOrDefault(a => a.IsOpen && a.IsOrginal).Id).Select(a => a.KindCotractType).Distinct().ToList(); Kinds.Remove(web_db._Weighing.TblContractType.KindCotractTypeEnum.ABaskul); ViewBag.kinds = Kinds; return(View(model)); }
public IActionResult Edit(web_CusDB.tblReqContract model, Guid[] mahsulss) { var dbcus = new web_CusDB.db_Context(); var db = new web_db.sardweb_Context(); if (ModelState.IsValid) { var row = dbcus.tblReqContracts.Find(model.Id); var rowcus = dbcus.TblCustomers.SingleOrDefault(a => model.tblCus.CodeMelli == a.CodeMelli); { if (rowcus == null) { if (row != null) { rowcus = dbcus.TblCustomers.Find(row.tblCusId); } else { rowcus = new web_CusDB.tblCus { Id = Guid.NewGuid(), dateAdd = DateTime.Now }; dbcus.TblCustomers.Add(rowcus); } } rowcus.CodeMelli = model.tblCus.CodeMelli; rowcus.Addras = model.tblCus.Addras; rowcus.Mob = model.tblCus.Mob; rowcus.Name = model.tblCus.Name; } if (row == null) { row = new web_CusDB.tblReqContract { Id = Guid.NewGuid(), Code = (dbcus.tblReqContracts.Max(a => (long?)a.Code) ?? 0) + 1, DateAdd = DateTime.Now, KindContract = model.KindContract, }; dbcus.tblReqContracts.Add(row); var z = db.TblProducts.Where(a => mahsulss.Contains(a.Id)).Select(a => a.Title).ToList(); z.AddRange(db.TblPackings.Where(a => mahsulss.Contains(a.Id)).Select(a => a.Title).ToList()); model._LasttblReqContractRows.CodeMahsuls = mahsulss.ToJson(); model._LasttblReqContractRows.Mahsuls = string.Join(',', z); var rowrow = new web_CusDB.tblReqContractRow { Id = Guid.NewGuid(), CodeMahsuls = model._LasttblReqContractRows.CodeMahsuls, Mahsuls = model._LasttblReqContractRows.Mahsuls, Date = DateTime.Now, Vaziat = web_CusDB.tblReqContractRow.ResEnum.Save, WeightCount = model._LasttblReqContractRows.WeightCount, ResUserId = User._getuserid(), TblReqContractId = row.Id }; dbcus.tblReqContractRows.Add(rowrow); } row.tblCusId = rowcus.Id; // var z = db.TblProducts.Where(a => mahsulss.Contains(a.Id)).Select(a => a.Title).ToList(); // z.AddRange(db.TblPackings.Where(a => mahsulss.Contains(a.Id)).Select(a => a.Title).ToList()); // row.Addras = model.Addras; // row.Mahsuls = string.Join(',', z); // row.Weight = model.Weight; // row.codemeli = model.codemeli; // row.KindQueu = web_db._queu.TblQueu.QueuEnum.Save; // row.CodeMahsuls = model.CodeMahsuls; // row.Name = model.Name; // row.Txt = model.Txt; dbcus.SaveChanges(); return(RedirectToAction(nameof(List))); } return(View()); }