public IActionResult Edit(Guid?id, web_db._Weighing.TblContractType.KindCotractTypeEnum?kindcontract = null) { 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 == id); if (x == null) { try { x = new web_CusDB.tblReqContract() { KindContract = kindcontract.Value }; } catch { return(RedirectToAction(nameof(List))); } } else { x._LasttblReqContractRows = x.tblReqContractRows.OrderByDescending(a => a.Date).First(); x._Contract = db.TblContracts.Find(x.ContractId); } return(View(x)); }
public async Task <IActionResult> Edit(web_CusDB.tblCus model) { if (model.CodeMelli.IsCodemeli() == false) { ModelState.AddModelError("CodeMelli", "کد ملی اشتباه است"); } if (ModelState.IsValid) { var db = new web_CusDB.db_Context(); var us = db.TblCustomers.Single(a => a.Id == User._getuserId()); us.Name = model.Name; us.CodeMelli = model.CodeMelli; us.Addras = model.Addras; us.CodeCusMainSystem = us.checkCodeCusMain().Code; db.SaveChanges(); await LoginAuth._loginAsync(this.HttpContext, us); return(RedirectToAction("Index")); } return(View(model)); }
public IActionResult Index() { var db = new web_CusDB.db_Context(); var us = db.TblCustomers.Single(a => a.Id == User._getuserId()); return(View(us)); }
public IActionResult Confirm(Guid id, web_CusDB.tblReqContractRow.ResEnum kind) { var dbcus = new web_CusDB.db_Context(); var db = new web_db.sardweb_Context(); ViewBag.kind = kind; var x = dbcus.tblReqContracts.Include(a => a.tblReqContractRows).Include(a => a.tblCus).SingleOrDefault(a => a.Id == id); x._LasttblReqContractRows = x.tblReqContractRows.OrderByDescending(a => a.Date).First(); ViewBag.ash = web_CusDB.tblCus.checkCodeCusMain(x.tblCus); // var x = db.TblQueus.Find(id); // if ((x.WeightConfirm??0)==0) // { // x.WeightConfirm = x.Weight; // } //var shname= _mySettings.GetValue<string>("txtPortagesms"); ViewBag.Txtsms = @$ "وضعیت درخواست شما به ({kind.ToKPvalusAttr().Description}) تغییر کرد. کد درخواست: {x.Code} "; return(View(x._LasttblReqContractRows)); }
public void OnAuthorization(AuthorizationFilterContext context) { //try //{ var user = context.HttpContext.User; if (!user.Identity.IsAuthenticated) { return; } var d = user._getuserlastdate(); if (d.HasValue == false || (d + new TimeSpan(0, 0, 30) < DateTime.Now)) { using (var db = new web_CusDB.db_Context()) { var v = user._getuserId(); var vv = db.TblCustomers.ToList(); var us = vv.SingleOrDefault(a => a.Id == v); _loginAsync(context.HttpContext, us).Wait(); } } //} //catch //{ // return; //} }
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 Edit() { var db = new web_CusDB.db_Context(); var us = db.TblCustomers.Single(a => a.Id == User._getuserId()); us.CodeCusMainSystem = us.checkCodeCusMain().Code; if (us.CodeCusMainSystem.HasValue) { db.SaveChanges(); } if (User._getuserIsProfileOK() && us.CodeCusMainSystem.HasValue) { return(RedirectToAction("Index")); } return(View(us)); }
public IActionResult Index() { var kiloview = true; // Models.cl._conf.Any(a => a.Key == web_db.TblConf.KeyEnum.US_WeightViewEnable && a.Value == true.ToString()); var db = new web_db.sardweb_Context(); var us = new web_CusDB.db_Context().TblCustomers.Single(a => a.Id == User._getuserId()); var x = (from n in db.TblContracts let s = db.TblSalMalis.FirstOrDefault(a => a.Id == n.FkSalmali) let c = db.TblCustomers.FirstOrDefault(a => a.Id == n.FkCustomer) where ((c.NationalCode.Equals(us.CodeMelli)) && (c.Mob.Trim().Equals(us.Mob.Trim()))) && (s.IsOrginal == true) select new web_sard.Models.tbls.contract.contract(n, db, true, false, null, kiloview)).ToList(); ViewBag.sals = db.TblSalMalis.Where(a => a.IsOrginal == true).OrderByDescending(a => a.SalAz).ToList(); return(View(x)); }
public IActionResult Index() { var db = new web_CusDB.db_Context(); var dbweb = new web_db.sardweb_Context(); var x = db.tblReqContracts.Where(a => a.tblCusId == User._getuserId()).OrderByDescending(a => a.DateLast).ToList(); foreach (var item in x) { item._Contract = dbweb.TblContracts.Include(a => a.FkContractTypeNavigation).SingleOrDefault(a => a.Id == item.ContractId); item._LasttblReqContractRows = db.tblReqContractRows.OrderBy(a => a.Date).Last(a => a.TblReqContractId == item.Id); } ViewBag.US_WeightZarib = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightZarib) ?? new web_db.TblConf()).Value.ToInt(1); return(View(x)); }
public IActionResult contract(Guid id) { var kiloview = true;// Models.cl._conf.Any(a => a.Key == web_db.TblConf.KeyEnum.US_WeightViewEnable && a.Value == true.ToString()); var db = new web_db.sardweb_Context(); var dbdoc = new web_dbDocument.db_Context(); var us = new web_CusDB.db_Context().TblCustomers.Single(a => a.Id == User._getuserId()); var x = db.TblContracts.Find(id); var port = db.TblPortages.Include(a => a.TblPortageRows).Where(a => a.TblPortageRows.Any(s => s.FkContract == id)).Select(a => a.Id).Distinct().ToList(); if (port == null) { port = new List <Guid>(); } ViewBag.listiamges = dbdoc.TblDocuments.Where(a => (port.Contains(a.FkP ?? Guid.Empty) || port.Contains(a.FkPortage ?? Guid.Empty)) && (a.Kind.Contains("Sign") == false)).ToList(); ViewBag.kiloview = kiloview;// Models.cl._conf.Any(a => a.Key == web_db.TblConf.KeyEnum.US_WeightViewEnable && a.Value == true.ToString()); return(View(new web_sard.Models.tbls.contract.contract(x, db, true, true, null, kiloview))); }
public IActionResult List(web_db._Weighing.TblContractType.KindCotractTypeEnum kindcontract = web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane, web_CusDB.tblReqContractRow.ResEnum id = web_CusDB.tblReqContractRow.ResEnum.Save) { ViewBag.kindcontract = kindcontract; ViewBag.id = id; var dbcus = new web_CusDB.db_Context(); { var xx = dbcus.tblReqContracts.Include(s => s.tblReqContractRows).Where(a => a.tblReqContractRows.Any() == false); if (xx.Any()) { dbcus.tblReqContracts.RemoveRange(xx); dbcus.SaveChanges(); } } var x = dbcus.tblReqContracts.Include(a => a.tblReqContractRows).OrderBy(a => a.DateLast).Include(a => a.tblCus) .Where(a => a.KindContract == kindcontract && a.tblReqContractRows. OrderByDescending(s => s.Date).First().Vaziat == id).ToList(); foreach (var item in x) { item._LasttblReqContractRows = item.tblReqContractRows.OrderByDescending(a => a.Date).First(); } return(View(x)); }
public IActionResult SyncCusSystem() { { using (var dbCus = new web_CusDB.db_Context()) { using (var db = new web_db.sardweb_Context()) { long code = (dbCus.tblReqContracts.Max(a => (long?)a.Code) ?? 0); foreach (var item in db.TblQueus.Where(a => (a.KindQueu == web_db._queu.TblQueu.QueuEnum.Save) || (a.KindQueu == web_db._queu.TblQueu.QueuEnum.IsActive)).Take(100)) { code++; var con = dbCus.tblReqContracts.Find(item.Id); if (con == null) { var cus = dbCus.TblCustomers.SingleOrDefault(a => a.Mob == item.mob && a.CodeMelli == item.codemeli); if (cus == null) { cus = new web_CusDB.tblCus { CodeMelli = item.codemeli, dateAdd = item.date, Addras = item.Addras, Id = Guid.NewGuid(), Mob = item.mob, Name = item.Name, }; dbCus.TblCustomers.Add(cus); } con = new web_CusDB.tblReqContract { Code = (code), DateAdd = item.date, ContractId = item.ContractID, KindContract = web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane, Id = item.Id, IsEdit = false, tblCusId = cus.Id, DateLast = DateTime.Now, }; dbCus.tblReqContracts.Add(con); dbCus.tblReqContractRows.Add(new web_CusDB.tblReqContractRow { CodeMahsuls = item.CodeMahsuls, Date = item.date, Id = Guid.NewGuid(), Vaziat = web_CusDB.tblReqContractRow.ResEnum.Save, WeightCount = item.Weight ?? 0, TblReqContractId = con.Id, Mahsuls = item.Mahsuls, }); // db.Remove(item); } } db.SaveChanges(); dbCus.SaveChanges(); } } } return(RedirectToAction("Index")); }
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 async Task <IActionResult> Login(string mob, string code) { if (mob.IsEmpty()) { return(View( )); } if (mob.IsMobile()) { ViewBag.mob = mob; var db = new web_CusDB.db_Context(); var us = db.TblCustomers.SingleOrDefault(a => a.Mob == mob); if (code.IsEmpty()) { if (this.Request.googleRecapch3Check(web_CusDB.stat.CapchSecretKey) == false) { ViewBag.mob = null; ViewBag.err = "لطفاً تایید کنید که ربات نیستید."; ModelState.AddModelError(string.Empty, "لطفاً تایید کنید که ربات نیستید."); return(View()); } if (us == null) { us = new web_CusDB.tblCus { Id = Guid.NewGuid(), Mob = mob, dateAdd = DateTime.Now, Addras = "", CodeMelli = "", Name = "", CodeCusMainSystemAcc = "" }; db.TblCustomers.Add(us); } if (us._DateCodeSms.GetValueOrDefault().AddMinutes(2) > DateTime.Now) { ViewBag.txt = "کد قبلا برای شما ارسال گردیده است"; return(View()); } 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, }; us._CodeSMS = new Random().Next(1000, 99999); us._DateCodeSms = DateTime.Now; db.SaveChanges(); sms.sendsmsAsync(mob, (dbmain.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Main_SherkatName) ?? new web_db.TblConf()).Value + @$ " کد ورود به سایت: " + us._CodeSMS.ToString()); ViewBag.txt = "کد برای شما ارسال گردید"; return(View()); } else { if (us._CodeSMS.ToString() == code) { us.CodeCusMainSystem = web_CusDB.tblCus.checkCodeCusMain(us).Code; us.dateLast = DateTime.Now; db.SaveChanges(); await LoginAuth._loginAsync(HttpContext, us); return(RedirectToAction("index", "home")); } else { ViewBag.txt = "کد ارسالی اشتباه است"; return(View()); } } } else { ViewBag.txt = "شماره موبایل اشتباه است"; return(View()); } }
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()); }
public IActionResult Create(Guid id, Guid idtype, Guid?idreq) { var sal = User._getuserSalMaliDef(); var x = db.TblContracts.Find(id); Models.tbls.contract.contract model; if (x != null) { idtype = (Guid)x.FkContractType; if (x.FkSalmali != sal) { return(RedirectToAction(nameof(Index), new { idtype = idtype })); } model = new Models.tbls.contract.contract(x, db, true); } else { x = new web_db._Weighing.TblContract(); var s = db.TblSalMalis.Find(sal); if (s != null) { x.Azdate = s.SalAz.Date; x.Tadate = s.SalTa.Date; } model = new Models.tbls.contract.contract(x, db, true); model.Code = Convert.ToInt64((db.TblContracts.Where(a => a.FkSalmali == sal).Max(a => (long?)a.Code) ?? 0) + 1); model.FkContractType = idtype; if (idreq.IsEmpty() == false) { var dbcus = new web_CusDB.db_Context(); var req = dbcus.tblReqContracts.Include(a => a.tblCus).SingleOrDefault(a => a.Id == idreq); if (req == null || req.ContractId.HasValue) { return(Redirect(this.HttpContext.Request.UrlReferer())); } else { var cus = req.tblCus.checkCodeCusMain(); if (cus == null) { ViewBag.ret = this.Request.UrlReferer(); return(View("NoUser")); } var reqrow = dbcus.tblReqContractRows.Where(a => a.TblReqContractId == req.Id).OrderByDescending(a => a.Date).First(); var zarib = (web_sard.Models.cl._conf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightZarib) ?? new web_db.TblConf()).Value.ToInt(1); model.WeightMaxIn = ((int)reqrow.WeightCount) * zarib; var CodeMahsuls = reqrow.CodeMahsuls.FromJson <Guid[]>(); model.prodocts = web_sard.Models.cl._ListProduct.Where(a => CodeMahsuls.Contains(a.Id)).Select( a => new web_sard.Models.tbls.alltbl { code = a.Code, key = a.Id, title = a.Title }).ToList(); model.prodoctsId = model.prodocts.Select(a => a.key).ToList(); idtype = db.TblContractTypes. FirstOrDefault(a => a.FkSalmali == User._getuserSalMaliDef() && a.KindCotractType == req.KindContract).Id; model.FkContractType = idtype; model.FkCustomer = cus.Id; model.TblCustumer = cus; model.Custumer = cus.Title; } } } ViewData["type"] = db.TblContractTypes.Find(idtype); ViewData["idreq"] = idreq; ViewData["listcustumer"] = db.TblCustomers.Include(a => a.TblContracts).Where(a => a.FkSalmali == User._getuserSalMaliDef() && a.IsEnable).OrderBy(a => a.Code).Select(a => new web_sard.Models.tbls.customer.customer(a, db, web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane, false)).ToList(); return(View(model)); }