public IActionResult Create(Models.tbls.customer.customer model) { if (ModelState.IsValid) { var x = db.TblCustomers.Find(model.Id); if (x == null) { x = new web_db.TblCustomer { Id = Guid.NewGuid(), FkSalmali = User._getuserSalMaliDef(), Code = (db.TblCustomers.Where(a => a.FkSalmali == User._getuserSalMaliDef()).Max(a => (int?)a.Code) ?? 0) + 1 }; db.TblCustomers.Add(x); } x.Addras = model.Addras ?? ""; x.IdOtherSystem = model.IdOtherSystem ?? ""; x.IsEnable = model.IsEnable; x.Mob = model.Mob ?? ""; x.NationalCode = model.NationalCode ?? ""; x.Title = model.Title; db.SaveChanges(); return(RedirectToAction("Index", new { txt = "ثبت موفق" })); } return(View(model)); }
public IActionResult RePassword(string password, string newPassword, string reNewPassword) { if (newPassword != reNewPassword) { ViewBag.error = "تکرار رمز عبور اشتباه است"; return(View()); } var x = db.TblUsers.Find(User._getuserid()); ViewBag.BalanceCode = x.BalanceCode; if (x.Password != password) { ViewBag.error = "رمز عبور اشتباه است"; return(View()); } x.Password = newPassword; db.SaveChanges(); ViewBag.txt = "ثبت انجام شد"; return(View()); }
public IActionResult setinjuryDef(Guid id, Guid defContract, Guid[] FkInjury, string submitall = "") { var pp = db.TblPortages.Find(id); if ((pp.FkSalmali != User._getuserSalMaliDef()) || (pp.IsEnd) || (pp.IsDel)) { return(RedirectToAction("index")); } db.TblPortageInjuries.RemoveRange(db.TblPortageInjuries.Where(a => a.FkPortage == id)); foreach (var item in FkInjury) { db.TblPortageInjuries.Add(new web_db._Weighing.TblPortageInjury { FkPortage = id, FkInjury = item }); } if (submitall.IsEmpty() == false) { foreach (var itemr in db.TblPortageRows.Where(a => a.FkPortage == id && a.FkContract == defContract)) { db.TblPortageRowInjuries.RemoveRange(db.TblPortageRowInjuries.Where(a => a.FkPortageRow == itemr.Id)); foreach (var item in FkInjury) { db.TblPortageRowInjuries.Add(new web_db._Weighing.TblPortageRowInjury { FkPortageRow = itemr.Id, FkInjury = item }); } } } db.SaveChanges(); return(RedirectToAction("view", new { id = id, openkind = 1 })); }
public IActionResult Create(web_db._temp.TblTemp temp) { if (ModelState.IsValid && (temp.FkuserTaiid.HasValue == false)) { var xx = db.TblTemps.Any(a => (a.Date == temp._Date.ToDate() && (a.Id != temp.Id)) && a.FkSalMali == User._getuserSalMaliDef() ); if (xx == false) { var x = db.TblTemps.Any(a => a.Id == temp.Id); if (x == false) { temp.Id = Guid.NewGuid(); temp.FkuserAdd = User._getuserid().Value; temp.FkSalMali = User._getuserSalMaliDef(); db.TblTemps.Add(temp); } else { db.TblTemps.Update(temp); } db.SaveChanges(); return(RedirectToAction(nameof(Index))); } } return(View(temp)); }
public IActionResult Create(web_db.TblGroup model) { try { var x = db.TblGroups.Find(model.Id); if (x == null) { x = new web_db.TblGroup { Id = Guid.NewGuid() }; db.TblGroups.Add(x); } x.IsActive = model.IsActive; x.Title = model.Title; x.Fklocation = model.Fklocation; x.Class = model.Class; db.SaveChanges(); ViewBag.txt = "ثبت انجام شد"; Models.cl._ListGroup = db.TblGroups.OrderBy(a => a.Title).ToList(); return(RedirectToAction(nameof(Index))); } catch { ViewBag.error = "ثبت انجام نشد"; } return(View(model)); }
public IActionResult SyncDoc() { { using (var dbdoc = new web_dbDocument.db_Context()) { using (var db = new web_db.sardweb_Context()) { foreach (var item in db.TblDocuments.Take(100)) { dbdoc.TblDocuments.Add(new web_dbDocument.TblDocument { Date = item.Date, FkP = item.FkP, FkPortage = item.FkPortage, fkuser = item.fkuser, Format = item.Format, Id = item.Id, Image = item.Image, Kind = item.Kind }); db.Remove(item); } db.SaveChanges(); dbdoc.SaveChanges(); } } } return(RedirectToAction("Index")); }
public static bool RemoveFullPortage(Guid id, web_db.sardweb_Context db) { var portage = db.TblPortages.Find(id); var contypeclone = db.TblContractTypes.Single(a => a.Id == portage.FkContracttype); #region rem PortageRows foreach (var item in db.TblPortageRows.Where(a => a.FkPortage == portage.Id)) { db.TblPortageRowInjuries.RemoveRange(db.TblPortageRowInjuries.Where(a => a.FkPortageRow == item.Id)); db.TblPortageRows.Remove(item); } #endregion #region rem images var dbdoc = new web_dbDocument.db_Context(); dbdoc.TblDocuments.RemoveRange(dbdoc.TblDocuments.Where(a => a.FkPortage == portage.Id)); db.TblPortages.Remove(portage); #endregion db.SaveChanges(); dbdoc.SaveChanges(); return(true); }
public IActionResult Acc(Guid fktype, bool refresh = false) { var sal = User._getuserSalMaliDef(); var ctype = db.TblContractTypes.Find(fktype); if (refresh) { //using (var scope = new TransactionScope(TransactionScopeOption.Required, // new System.TimeSpan(0, 15, 0))) //{ scope.Complete(); //} foreach (var item in db.TblPortages.Where(a => a.FkSalmali == User._getuserSalMaliDef() && a.FkContracttype == fktype)) { Models.cl.refPortageAccMoney(db, item.Id); } db.SaveChanges(); } var x = from n in db.TblCustomers.Include(a => a.TblPortageMoneys) where n.FkSalmali == sal let bascul = n.TblPortageMoneys.Where(a => a.FkContractType == fktype && a.Kind == "bascul").Sum(a => (decimal?)a.PriceSum) let kargar = n.TblPortageMoneys.Where(a => a.FkContractType == fktype && a.Kind == "kargar").Sum(a => (decimal?)a.PriceSum) let packing = n.TblPortageMoneys.Where(a => a.FkContractType == fktype && a.Kind == "packing").Sum(a => (decimal?)a.PriceSum) let product = n.TblPortageMoneys.Where(a => a.FkContractType == fktype && a.Kind == "product").Sum(a => (decimal?)a.PriceSum) select new Models.customerAcc(n, db) { bascul = bascul, kargar = kargar, packing = packing, product = product, }; ViewBag.ctype = ctype; return(View(x.ToList())); }
public IActionResult Create(web_db._Weighing.TblCar model, IFormFile file) { if (!ModelState.IsValid) { ViewBag.error = "ثبت انجام نشد - فیلد ها را درست پر کنید"; return(View(model)); } try { var x = db.TblCars.Find(model.Id); if (x == null) { x = new web_db._Weighing.TblCar { Id = model.Id, PriceTowBascol = 0 }; db.TblCars.Add(x); } x.Title = model.Title; x.IsDel = model.IsDel; x.PriceTowBascol = model.PriceTowBascol; var dbdoc = new web_dbDocument.db_Context(); if (file != null) { var r = dbdoc.TblDocuments.FirstOrDefault(a => a.FkP == x.Id); if (r == null) { r = new web_dbDocument.TblDocument { Date = DateTime.Now, FkP = x.Id, fkuser = User._getuserid(), Id = Guid.NewGuid(), Kind = "Image" }; dbdoc.TblDocuments.Add(r); } r.Image = file.ToByteArray().imgTosmall(); } db.SaveChanges(); dbdoc.SaveChanges(); ViewBag.txt = "ثبت انجام شد"; Models.cl._ListCar = db.TblCars.OrderBy(a => a.Title).ToList(); return(RedirectToAction(nameof(Index))); } catch { ViewBag.error = "ثبت انجام نشد"; } return(View(model)); }
public static void _refstoreOne(web_db.sardweb_Context db, Guid fkportage) { var x = db.TblPortageRows.Where(a => a.FkPortage == fkportage); var por = db.TblPortages.Find(fkportage); var contype = web_sard.Models.cl._ListContractType(por.FkSalmali).Single(a => a.Id == por.FkContracttype); por.WeightNet = (por.Weight1 - por.Weight2).gadrmotlagh(); if (Models.tbls.portage.kindPortage.listkindcontract.Single(a => a.code == por.KindCode).Manfi) { por.WeightNet = -por.WeightNet; } por.PackingCount = x.Sum(a => a.Count); por.PackingOfWeight = (double?)(por.WeightNet / por.PackingCount).gadrmotlagh(); por.OtcodeResid = ""; db.TblPortageMoneys.RemoveRange(db.TblPortageMoneys.Where(a => a.FkPortage == por.Id)); decimal ss = 0; foreach (var item in x) { var sc = Models.cl.getWeightScale(item.FkProduct, item.FkPacking); item.WeightOne = sc * por.PackingOfWeight; if (item.WeightOne.HasValue) { ss += (decimal)item.WeightOne * item.Count; } } foreach (var item in x) { if (item.WeightOne.HasValue) { item.WeightOne = item.WeightOne * (double)(por.WeightNet / ss); } } db.SaveChanges(); _refstoreTow(db, fkportage); }
public static bool RemoveFullContract(Guid id, web_db.sardweb_Context db) { try { db.TblContractPackings.RemoveRange(db.TblContractPackings.Where(a => a.FkContract == id)); db.TblContractProducts.RemoveRange(db.TblContractProducts.Where(a => a.FkContract == id)); db.TblContracts.Remove(db.TblContracts.Find(id)); db.SaveChanges(); return(true); } catch { return(false); } }
public IActionResult Create(web_db._Weighing.TblPacking model, List <web_db._Weighing.TblContractType.KindCotractTypeEnum> _ForContractType) { if (!ModelState.IsValid) { ViewBag.txt = "ثبت انجام نشد - فیلد ها را درست پر کنید"; return(View(model)); } try { var x = db.TblPackings.Find(model.Id); if (x == null) { x = new web_db._Weighing.TblPacking { Id = model.Id }; db.TblPackings.Add(x); } x.Code = model.Code; x.IsActive = model.IsActive; x.Title = model.Title; x.WightEmpty = model.WightEmpty; x.WightFull = model.WightFull; x.ForContractType(_ForContractType); x.WightScale = model.WightScale; x.WightScale = x.WightScale == 0 ? null : x.WightScale; x.OtcodeKala = model.OtcodeKala; x.OtcodeVahedShomaresh = model.OtcodeVahedShomaresh; x.OtcodeKalaAcc = model.OtcodeKalaAcc; x.IsNotAc = model.IsNotAc; db.SaveChanges(); ViewBag.txt = "ثبت انجام شد"; Models.cl._ListPacking = db.TblPackings.OrderBy(a => a.Code).ToList(); return(RedirectToAction(nameof(Index))); } catch { ViewBag.error = "ثبت انجام نشد"; } return(View(model)); }
//public static bool RemoveFullPortage(Guid id, web_db.sardweb_Context db) //{ // var portage = db.TblPortages.Find(id); // var contypeclone = db.TblContractTypes.Single(a => a.Id == portage.FkContracttype); // #region rem PortageRows // foreach (var item in db.TblPortageRows.Where(a => a.FkPortage == portage.Id)) // { // db.TblPortageRowInjuries.RemoveRange(db.TblPortageRowInjuries.Where(a => a.FkPortageRow == item.Id)); // db.TblPortageRows.Remove(item); // } // #endregion // #region rem images // db.TblDocuments.RemoveRange(db.TblDocuments.Where(a => a.FkPortage == portage.Id)); // db.TblPortages.Remove(portage); // #endregion // db.SaveChanges(); // if (contypeclone.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane) // { // var x = db.TblPortageRows.Where(a => a.FkPortage == portage.Id); // foreach (var item in x.Select(a => a.FkContract).Distinct()) // { // Models.cl.refTblStoreLogcontractSardKhane(item.Value, db); // } // } // else if (contypeclone.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad) // { // Models.cl.refTblStoreLogcontractTypeSabad(contypeclone.Id , db); // } // return true; //} //public static bool RemoveFullContract(Guid id, web_db.sardweb_Context db) //{ // try // { // db.TblContractPackings.RemoveRange(db.TblContractPackings.Where(a => a.FkContract == id)); // db.TblContractProducts.RemoveRange(db.TblContractProducts.Where(a => a.FkContract == id)); // db.TblContracts.Remove(db.TblContracts.Find(id)); // db.SaveChanges(); // return true; // } // catch // { // return false; // } //} public static async Task <Guid?> AddPayvastCustomerAsync(web_db.sardweb_Context db, string CellPhone, int sal) { var Mali_KindOT = (Models.cl._conf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Mali_KindOT) ?? new web_db.TblConf()).Value; var Mali_UrlOT = (Models.cl._conf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Mali_UrlOT) ?? new web_db.TblConf()).Value; var Mali_UserOT = (Models.cl._conf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Mali_UserOT) ?? new web_db.TblConf()).Value; var Mali_PassOT = (Models.cl._conf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Mali_PassOT) ?? new web_db.TblConf()).Value; ApiPaivast.AccountingServiceSoapClient vv = new AccountingServiceSoapClient(AccountingServiceSoapClient.EndpointConfiguration.AccountingServiceSoap, Mali_UrlOT); var c = await vv.GetCustomerIdByCellPhoneAsync(CellPhone : CellPhone); var idc = c; var cid = await vv.GetCustomerInfoAsync(idc, Mali_UserOT, Mali_PassOT); if (cid != null) { string txt = "ثبت موفق"; var row = db.TblCustomers.FirstOrDefault(a => a.FkSalmali == sal && a.IdOtherSystem == cid.Id.ToString()); if (row == null) { row = new web_db.TblCustomer { Id = Guid.NewGuid(), FkSalmali = sal, IdOtherSystem = cid.Id.ToString(), IsEnable = true, Code = (db.TblCustomers.Where(a => a.FkSalmali == sal).Max(a => (int?)a.Code) ?? 0) + 1, }; db.TblCustomers.Add(row); txt = "بروزرسانی موفق"; } row.IsEnable = true; row.Addras = ""; row.Mob = CellPhone; row.NationalCode = cid.NationalCode; row.Title = cid.Name.ToPersianChars(); db.SaveChanges(); return(row.Id); } return(null); }
public static bool RemoveFullPortage(Guid id, web_db.sardweb_Context db) { var portage = db.TblPortages.Find(id); var contypeclone = db.TblContractTypes.Single(a => a.Id == portage.FkContracttype); #region rem PortageRows foreach (var item in db.TblPortageRows.Where(a => a.FkPortage == portage.Id)) { db.TblPortageRowInjuries.RemoveRange(db.TblPortageRowInjuries.Where(a => a.FkPortageRow == item.Id)); db.TblPortageRows.Remove(item); } #endregion #region rem images var dbdoc = new web_dbDocument.db_Context(); dbdoc.TblDocuments.RemoveRange(dbdoc.TblDocuments.Where(a => a.FkPortage == portage.Id)); db.TblPortages.Remove(portage); #endregion db.SaveChanges(); dbdoc.SaveChanges(); if (contypeclone.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane) { var x = db.TblPortageRows.Where(a => a.FkPortage == portage.Id); foreach (var item in x.Select(a => a.FkContract).Distinct()) { Models.cl.refTblStoreLogcontractSardKhane(item.Value, db); } } return(true); }
public IActionResult Create(web_db._temp.TblTempRow temp) { if (ModelState.IsValid) { var x = db.TblTempRows.Any(a => a.Id == temp.Id); if (x == false) { temp.Id = Guid.NewGuid(); temp.DateAdd = DateTime.Now; db.TblTempRows.Add(temp); } else { db.TblTempRows.Update(temp); } db.SaveChanges(); return(RedirectToAction(nameof(Index))); } return(View(temp)); }
public static void _refstoreTow(web_db.sardweb_Context db, Guid fkportage) { var x = db.TblPortageRows.Where(a => a.FkPortage == fkportage); var por = db.TblPortages.Find(fkportage); por.WeightNet = (por.Weight1 - por.Weight2).gadrmotlagh(); if (Models.tbls.portage.kindPortage.listkindcontract.Single(a => a.code == por.KindCode).Manfi) { por.WeightNet = -por.WeightNet; } var contype = web_sard.Models.cl._ListContractType(por.FkSalmali).Single(a => a.Id == por.FkContracttype); if (contype.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad) { Models.cl.refTblStoreLogcontractTypeSabad(contype.Id, db); } db.SaveChanges(); }
public IActionResult Create(web_db._Weighing.TblInjury model, List <web_db._Weighing.TblContractType.KindCotractTypeEnum> _ForContractType) { if (!ModelState.IsValid) { ViewBag.txt = "ثبت انجام نشد - فیلد ها را درست پر کنید"; return(View(model)); } try { var x = db.TblInjuries.Find(model.Id); if (x == null) { x = new web_db._Weighing.TblInjury { Id = model.Id }; db.TblInjuries.Add(x); } x.IsActive = model.IsActive; x.Title = model.Title; x.forIn = model.forIn; x.forOut = model.forOut; x.ForContractType(_ForContractType); db.SaveChanges(); ViewBag.txt = "ثبت انجام شد"; Models.cl._ListInjury = db.TblInjuries.OrderBy(a => a.Ord).ToList(); return(RedirectToAction(nameof(Index))); } catch { ViewBag.error = "ثبت انجام نشد"; } return(View(model)); }
public IActionResult Create(Models.tbls.contract.contract model, bool sendSMS) { var sal = User._getuserSalMaliDef(); var ContractType = db.TblContractTypes.Find(model.FkContractType); var x = db.TblContracts.Find(model.Id); if (ContractType.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad) { var conf = ContractType.ConfigASabad(); ModelState.Remove("WeightMaxIn"); ModelState.Remove("WeightMaxOut"); ModelState.Remove("prodoctsId"); if (conf.IsEntry == false) { ModelState.Remove("CountMaxIn"); } if (conf.IsExit == false) { ModelState.Remove("CountMaxOut"); } { ModelState.Remove("WeightMaxOut"); ModelState.Remove("PercentForOut"); } if (ModelState.IsValid) { { var x2 = db.TblContracts.Where(a => a.Code == model.Code && a.FkSalmali == sal); if (x2.Any() && x2.Single().Id != x.Id) { x.Code = Convert.ToInt64((db.TblContracts.Where(a => a.FkSalmali == sal).Max(a => (long?)a.Code) ?? 0) + 1); } } if (x == null) { x = new web_db._Weighing.TblContract { Date = DateTime.Now.Date, Dateadd = DateTime.Now, FkContractType = model.FkContractType, FkSalmali = User._getuserSalMaliDef(), FkUsAdd = User._getuserid().Value, Id = Guid.NewGuid(), FkCustomer = model.FkCustomer }; db.TblContracts.Add(x); } else { x.FkUsEdit = User._getuserid(); x.Dateedit = DateTime.Now; } x.Code = model.Code; x.Azdate = model.Azdate.ToDate(); x.Tadate = model.Tadate.ToDate(); x.WeightMaxIn = model.WeightMaxIn; x.CountMaxIn = model.CountMaxIn; x.WeightMaxOut = model.WeightMaxOut; x.CountMaxOut = model.CountMaxOut; x.PercentForOut = model.PercentForOut; x.IsEndVrud = model.isEndVrud; x.IsEndXroj = model.isEndXroj; x.Txt = model.Txt ?? ""; x.PriceOfBoxIn = model.PriceOfBoxIn ?? 0; x.PriceOfBoxOut = model.PriceOfBoxOut ?? 0; x.PriceOfKiloIn = model.PriceOfKiloIn ?? 0; x.PriceOfKiloOut = model.PriceOfKiloOut ?? 0; db.TblContractPackings.RemoveRange(db.TblContractPackings.Where(a => a.FkContract == x.Id)); foreach (var item in model.packingsId) { db.TblContractPackings.Add(new web_db._Weighing.TblContractPacking { FkContract = x.Id, FkPacking = item }); } if (sendSMS) { x.SendSms = true; } db.SaveChanges(); ViewBag.txt = "ثبت انجام شد"; return(RedirectToAction(nameof(Index), new { idtype = model.FkContractType })); } 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.ASabad, true)).ToList(); ViewData["type"] = ContractType; ViewBag.error = "لطفا موارد را درست پر کنید"; return(View(model)); } return(null); }
public IActionResult Add(web_db._note.TblNote model, _UserRol._Rolls[] roll, Guid[] us, string delete, string date = "") { var row = db.TblNotes.Find(model.Id); if (delete.IsEmpty() == false) { if (row != null) { if (User._getRolAny(_UserRol._Rolls.TempAdmin)) { db.TblNoteRows.RemoveRange(db.TblNoteRows.Where(a => a.FkTblNote == row.Id)); db.TblNoteDates.RemoveRange(db.TblNoteDates.Where(a => a.FkTblNote == row.Id)); db.TblNoteRolls.RemoveRange(db.TblNoteRolls.Where(a => a.FkTblNote == row.Id)); db.TblNotes.Remove(row); db.SaveChanges(); } } return(Redirect(Request.UrlReferer())); } if (row == null) { row = new web_db._note.TblNote { Id = Guid.NewGuid(), DateAdd = DateTime.Now, FkuserAdd = User._getuserid().Value, }; db.TblNotes.Add(row); } if ((row.FkuserAdd != User._getuserid()) && User._getRolAny(_UserRol._Rolls.TempAdmin) == false) { return(Redirect(Request.UrlReferer())); } row.Txt = model.Txt.Trim(); row.Caption = model.Caption.Trim(); db.TblNoteRows.RemoveRange(db.TblNoteRows.Where(a => a.FkTblNote == row.Id)); db.TblNoteDates.RemoveRange(db.TblNoteDates.Where(a => a.FkTblNote == row.Id)); db.TblNoteRolls.RemoveRange(db.TblNoteRolls.Where(a => a.FkTblNote == row.Id)); List <web_db._note.TblNoteRoll> rols = new List <web_db._note.TblNoteRoll>(); if (User._getRolAny(_UserRol._Rolls.NoteAdmin)) { foreach (var item in roll) { var z = new web_db._note.TblNoteRoll { ForUserroll = item.ToString(), Id = Guid.NewGuid(), FkTblNote = row.Id }; db.TblNoteRolls.Add(z); rols.Add(z); } foreach (var item in us) { var z = new web_db._note.TblNoteRoll { ForUserId = item, Id = Guid.NewGuid(), FkTblNote = row.Id }; db.TblNoteRolls.Add(z); rols.Add(z); } } if (User._getRolAny(_UserRol._Rolls.NoteAdmin) == false || ((roll.Any() == false) && (us.Any() == false))) { var z = new web_db._note.TblNoteRoll { ForUserId = User._getuserid(), Id = Guid.NewGuid(), FkTblNote = row.Id }; db.TblNoteRolls.Add(z); rols.Add(z); } foreach (var itemd in model.TblNoteDates) { if (itemd._ToDate.IsEmpty() || itemd._FromDate.IsEmpty()) { break; } itemd.FromDate = itemd._FromDate.ToDate(); itemd.ToDate = itemd._ToDate.ToDate(); db.TblNoteDates.Add(new web_db._note.TblNoteDate { Id = Guid.NewGuid(), FromDate = itemd.FromDate, SendSms = itemd.SendSms, KindBesorat = itemd.KindBesorat, ToDate = itemd.ToDate, FkTblNote = row.Id }); List <DateTime> dates = new List <DateTime>(); var d = itemd.FromDate.Value; while (itemd.ToDate >= d) { dates.Add(d); switch (itemd.KindBesorat) { case web_db._note.TblNoteDate.Kind.Harroz: d = d.AddDays(1); break; case web_db._note.TblNoteDate.Kind.HarHafte: d = d.AddDays(7); break; case web_db._note.TblNoteDate.Kind.Har2Hafte: d = d.AddDays(7); break; case web_db._note.TblNoteDate.Kind.Har4Week: d = d.AddDays(7 * 4); break; case web_db._note.TblNoteDate.Kind.HarMah: d = d.ToPersianAddMonths(1); break; default: break; } } foreach (var item in dates) { foreach (var itemr in rols) { db.TblNoteRows.Add(new web_db._note.TblNoteRows { Date = item, ForUserId = itemr.ForUserId, ForUserroll = itemr.ForUserroll, Id = Guid.NewGuid(), FkTblNote = row.Id, SendSms = itemd.SendSms, }); } } } db.SaveChanges(); return(Redirect(Request.UrlReferer())); }
public IActionResult CreateIN(Guid idtype, int kindPortage, Models.tbls.portage.portage model) { ModelState.Remove("Weight2"); ModelState.Remove("Date2date"); ModelState.Remove("Date2time"); ModelState.Remove("Customer.Mob"); ModelState.Remove("Customer.NationalCode"); ModelState.Remove("Customer.Code"); ModelState.Remove("Customer.Title"); ModelState.Remove("Customer.Id"); ModelState.Remove("FkCarTbl"); var kindPortageenum = (web_sard.Areas.ASurting.Models.tbls.portage.kindPortage.kindPortageEnum)kindPortage; if (kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.InFromSardkhane || kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.OutToSardkhane || kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.InFromAnbar || kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.OutToAnbar) { ModelState.Remove("CarShMashin"); ModelState.Remove("FkCar"); ModelState.Remove("CarRanande"); ModelState.Remove("CarTell"); ModelState.Remove("Weight1IsBascul"); ModelState.Remove("Weight1"); } var typecontract = db.TblContractTypes.Find(idtype); if (typecontract.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASurting) { var conf = typecontract.ConfigASurting(); if (ModelState.IsValid) { var x = db.TblPortages.Find(model.Id); if (x == null) { model.Code = (db.TblPortages.Where(a => a.FkSalmali == User._getuserSalMaliDef() && a.FkContracttype == idtype && a.KindCode == kindPortage).Max(a => (long?)a.Code) ?? 0) + 1; x = new web_db._Weighing.TblPortage { FkSalmali = User._getuserSalMaliDef(), Code = model.Code, Dateadd1 = DateTime.Now, FkContracttype = idtype, FkUsAdd1 = User._getuserid().Value, Id = model.Id, KindCode = kindPortage, KindTitle = Models.tbls.portage.kindPortage.listkindcontract.Find(a => a.code == kindPortage).txt, }; db.TblPortages.Add(x); } else { x.Dateedit1 = DateTime.Now; x.FkUsEdit1 = User._getuserid().Value; } x.CarMashin = model.CarMashin ?? ""; x.CarRanande = model.CarRanande ?? ""; x.CarShMashin = model.CarShMashin ?? ""; x.CarTell = model.CarTell ?? ""; x.FkCar = model.FkCar; x.CarMashin = (web_sard.Models.cl._ListCar.SingleOrDefault(a => a.Id == model.FkCar) ?? new web_db._Weighing.TblCar()).Title; x._FkContractMain = model._FkContractMain; x.FkCustomer = db.TblContracts.Find(model._FkContractMain).FkCustomer; x.Weight1 = model.Weight1; x.Weight1IsBascul = model.Weight1IsBascul; x.Txt = model.Txt; x.Date1 = model.Date1date.ToDate().AddHours(model.Date1time.Hours).AddMinutes(model.Date1time.Minutes); x.IsDel = false; x.IsPermitOk = null; x.FkUsPermit = null; x.TxtPermit = ""; var dbdoc = new web_dbDocument.db_Context(); #region captureDorbinBaskul if (kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.In || kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.Out) { if (x.Weight1 != model.Weight1) { var z = web_sard.Models.cl.captureDorbinBaskul(); if (z != null) { dbdoc.TblDocuments.Add(new web_dbDocument.TblDocument { Date = DateTime.Now, FkP = x.Id, Id = Guid.NewGuid(), Image = z, Kind = "InBaskul", Format = "" }); } } } #endregion #region PeerSardKhane if (kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.InFromSardkhane || kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.OutToSardkhane) { var xpkind = (kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.InFromSardkhane ? web_sard.Areas.ASardKhane.Models.tbls.portage.kindPortage.kindPortageEnum.OutToSurt : web_sard.Areas.ASardKhane.Models.tbls.portage.kindPortage.kindPortageEnum.InFromSurt); foreach (var item in web_sard.Models.cl._ListContractType(x.FkSalmali).Where(a => a.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane)) { var xp = db.TblPortages.Find(x._FkPortagePeer); if (xp == null) { xp = new web_db._Weighing.TblPortage { FkSalmali = User._getuserSalMaliDef(), Code = model.Code, _FkPortagePeer = x.Id, Dateadd1 = DateTime.Now, FkContracttype = item.Id, FkUsAdd1 = User._getuserid().Value, Id = Guid.NewGuid(), KindCode = (int)xpkind, KindTitle = web_sard.Areas.ASardKhane.Models.tbls.portage.kindPortage.listkindcontract.Find(a => a.code == (int)xpkind).txt, }; xp.Code = (db.TblPortages.Where(a => a.FkSalmali == User._getuserSalMaliDef() && a.FkContracttype == item.Id && a.KindCode == (int)xpkind).Max(a => (long?)a.Code) ?? 0) + 1; db.TblPortages.Add(xp); x._FkPortagePeer = xp.Id; } else { xp.Dateedit1 = DateTime.Now; xp.FkUsEdit1 = User._getuserid().Value; } xp.CarMashin = x.CarMashin ?? ""; xp.CarRanande = x.CarRanande ?? ""; xp.CarShMashin = x.CarShMashin ?? ""; xp.CarTell = x.CarTell ?? ""; xp.FkCar = x.FkCar; xp.CarMashin = (web_sard.Models.cl._ListCar.SingleOrDefault(a => a.Id == model.FkCar) ?? new web_db._Weighing.TblCar()).Title; xp.FkCustomer = x.FkCustomer; xp.Weight1 = x.Weight1; xp.Weight1IsBascul = x.Weight1IsBascul; xp.Txt = x.Txt; xp.Date1 = x.Date1; xp.IsDel = false; xp.IsPermitOk = null; xp.FkUsPermit = null; xp.TxtPermit = ""; } } #endregion #region PeerAnbar if (kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.InFromAnbar || kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.OutToAnbar) { var xpkind = (kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.InFromAnbar ? web_sard.Areas.ASabad.Models.tbls.portage.kindPortage.kindPortageEnum.OutToSurt : web_sard.Areas.ASabad.Models.tbls.portage.kindPortage.kindPortageEnum.InFromSurt); foreach (var item in web_sard.Models.cl._ListContractType(x.FkSalmali).Where(a => a.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad)) { var xp = db.TblPortages.SingleOrDefault(a => a.FkContracttype == item.Id && a.Id == x._FkPortagePeer); if (xp == null) { xp = new web_db._Weighing.TblPortage { FkSalmali = User._getuserSalMaliDef(), Code = model.Code, Dateadd1 = DateTime.Now, FkContracttype = item.Id, FkUsAdd1 = User._getuserid().Value, _FkPortagePeer = x.Id, Id = Guid.NewGuid(), KindCode = (int)xpkind, KindTitle = web_sard.Areas.ASabad.Models.tbls.portage.kindPortage.listkindcontract.Find(a => a.code == (int)xpkind).txt, }; xp.Code = (db.TblPortages.Where(a => a.FkSalmali == User._getuserSalMaliDef() && a.FkContracttype == item.Id && a.KindCode == (int)xpkind).Max(a => (long?)a.Code) ?? 0) + 1; db.TblPortages.Add(xp); x._FkPortagePeer = xp.Id; } else { xp.Dateedit1 = DateTime.Now; xp.FkUsEdit1 = User._getuserid().Value; } xp.CarMashin = x.CarMashin ?? ""; xp.CarRanande = x.CarRanande ?? ""; xp.CarShMashin = x.CarShMashin ?? ""; xp.CarTell = x.CarTell ?? ""; xp.FkCar = x.FkCar; xp.CarMashin = (web_sard.Models.cl._ListCar.SingleOrDefault(a => a.Id == model.FkCar) ?? new web_db._Weighing.TblCar()).Title; xp.FkCustomer = x.FkCustomer; xp.Weight1 = x.Weight1; xp.Weight1IsBascul = x.Weight1IsBascul; xp.Txt = x.Txt; xp.Date1 = x.Date1; xp.IsDel = false; xp.IsPermitOk = null; xp.FkUsPermit = null; xp.TxtPermit = ""; } } #endregion ViewBag.error = checkportage(x); if (((string)ViewBag.error).IsEmpty()) { db.SaveChanges(); dbdoc.SaveChanges(); _refstoreTow(x.Id); if (kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.InFromSardkhane || kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.OutToSardkhane) { ASardKhane.Models.cl._refstoreTow(db, x.Id); } if (kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.InFromAnbar || kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.OutToAnbar) { ASabad.Models.cl._refstoreTow(db, x.Id); } return(RedirectToAction("index", new { idtype = x.FkContracttype })); } } ViewData["type"] = db.TblContractTypes.Find(idtype); ViewData["kindPortage"] = kindPortage; var intosard = false; if ((kindPortage == (int)Models.tbls.portage.kindPortage.kindPortageEnum.InFromSardkhane) || (kindPortage == (int)Models.tbls.portage.kindPortage.kindPortageEnum.OutToSardkhane)) { intosard = true; } ViewBag.contrs = (from n in db.TblContracts.Include(a => a.FkContractTypeNavigation).Include(a => a.FkCustomerNavigation) where n.FkSalmali == typecontract.FkSalmali && n.FkContractType == idtype //&& //(intosard == false ? true : (n._FkContractPeer.HasValue)) orderby n.Code ascending select n).ToList(); return(View(model)); } return(null); }
public async Task <IActionResult> Index(int p, web_db._queu.TblQueu model, string captcha, List <Guid> Product, List <Guid> Packing) { if (model.mob.IsMobile() == false) { ViewBag.error = "شماره موبایل اشتباه است"; p = 0; } if (p == 0) { } else if (p == 1) { if (web_lib.stat.Captcha.CheckCaptcha(this.HttpContext, captcha) == false) { ViewBag.error = "متن امنیتی اشتباه است"; var Captcha = new web_lib.stat.Captcha(this.HttpContext); ViewBag.Captcha = Captcha.ImageAsBaseSrc; p = 0; return(View()); } var row = db.TblQueus.FirstOrDefault(a => a.mob == model.mob && a.KindQueu == web_db._queu.TblQueu.QueuEnum.Empty); if (row == null) { row = new web_db._queu.TblQueu { Id = Guid.NewGuid(), mob = model.mob, date = DateTime.Now, Code = (db.TblQueus.Max(a => (long?)a.Code) ?? 0) + 1, KindQueu = web_db._queu.TblQueu.QueuEnum.Empty, Addras = "", codemeli = "", CodeMahsuls = "", Weight = 0, Name = "", Txt = "", }; db.TblQueus.Add(row); } if (row.datecodesend.HasValue == false || (DateTime.Now - row.datecodesend.Value > TimeSpan.FromMinutes(15))) { await sendsmsAsync(row); } db.SaveChanges(); model = row; } else { var row = db.TblQueus.SingleOrDefault(a => a.Id == model.Id); var z = db.TblProducts.Where(a => Product.Contains(a.Id)).Select(a => a.Title).ToList(); z.AddRange(db.TblPackings.Where(a => Packing.Contains(a.Id)).Select(a => a.Title).ToList()); Product.AddRange(Packing); row.CodeMahsuls = Product.ToJson(); if (row.codesend != model.codesend) { ViewBag.error = "کد ارسالی به موبایل اشتباه است "; p = 1; } else { 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.Name = model.Name; row.Txt = model.Txt; db.SaveChanges(); await sendsmsloginAsync(row); } model = row; } ViewBag.p = p; model.codesend = null; if (p == 0) { var Captcha = new web_lib.stat.Captcha(this.HttpContext); ViewBag.Captcha = Captcha.ImageAsBaseSrc; return(View(model)); } else if (p == 1) { ViewBag.listPacking = db.TblPackings.AsEnumerable().Where(a => a.ForContractType().Contains(web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane) && a.IsActive == true) .OrderBy(a => a.Code).ToList(); ViewBag.listProduct = db.TblProducts.Where(a => a.IsActive).OrderBy(a => a.Ord).ToList(); return(View("indexEdit", model)); } else { return(RedirectToAction("success", new { model.Id })); } }
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 static void refTblStoreLogcontractSardKhane(Guid fkcontract, web_db.sardweb_Context db) { var rowOK = new List <Guid>(); //Add { var contr = db.TblContracts.Find(fkcontract); var contrType = db.TblContractTypes.Find(contr.FkContractType); var x = db.TblPortageRows.Include(a => a.FkPortageNavigation).Where(a => a.FkContract == fkcontract && (a.FkPortage.HasValue ? (a.FkPortageNavigation.IsEnd && a.FkPortageNavigation.IsDel == false) : true)).AsEnumerable(); contr.SumInCount = x.Where(a => a.FkPortageNavigation.KindCode == (int)kindPortage.kindPortageEnum.In || a.FkPortageNavigation.KindCode == (int)kindPortage.kindPortageEnum.InBack).Sum(a => a.Count); contr.SumInWeight = x.Where(a => a.FkPortageNavigation.KindCode == (int)kindPortage.kindPortageEnum.In || a.FkPortageNavigation.KindCode == (int)kindPortage.kindPortageEnum.InBack).Sum(a => (decimal?)(a.Count * a.WeightOne)); contr.SumOutCount = x.Where(a => a.FkPortageNavigation.KindCode == (int)kindPortage.kindPortageEnum.Out || a.FkPortageNavigation.KindCode == (int)kindPortage.kindPortageEnum.OutBack).Sum(a => a.Count); contr.SumOutWeight = x.Where(a => a.FkPortageNavigation.KindCode == (int)kindPortage.kindPortageEnum.Out || a.FkPortageNavigation.KindCode == (int)kindPortage.kindPortageEnum.OutBack).Sum(a => (decimal?)(a.Count * a.WeightOne)); if (contrType.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane) { var xx = x.GroupBy(a => new { a.FkContract, a.FkLocation1, a.FkLocation2, a.FkLocation3, a.FkPacking, a.FkProduct }).ToList(); foreach (var item in xx) { var iall = db.TblStoreLogs.Where(a => a.FkContractType == contrType.Id && a.FkSalmali == contr.FkSalmali && a.FkContract == item.Key.FkContract && a.FkLocation1 == item.Key.FkLocation1 && a.FkLocation2 == item.Key.FkLocation2 && a.FkLocation3 == item.Key.FkLocation3 && a.FkPacking == item.Key.FkPacking && a.FkProduct == item.Key.FkProduct ); if (iall.Count() > 1) { db.TblStoreLogs.RemoveRange(iall); db.SaveChanges(); } var i = db.TblStoreLogs.SingleOrDefault(a => a.FkContractType == contrType.Id && a.FkSalmali == contr.FkSalmali && a.FkContract == item.Key.FkContract && a.FkLocation1 == item.Key.FkLocation1 && a.FkLocation2 == item.Key.FkLocation2 && a.FkLocation3 == item.Key.FkLocation3 && a.FkPacking == item.Key.FkPacking && a.FkProduct == item.Key.FkProduct ); if (i == null) { i = new web_db._Weighing.TblStoreLog { Id = Guid.NewGuid(), FkContract = fkcontract, FkContractType = contrType.Id, FkCustomer = contr.FkCustomer, FkLocation1 = item.Key.FkLocation1, FkLocation2 = item.Key.FkLocation2, FkLocation3 = item.Key.FkLocation3, FkPacking = item.Key.FkPacking, FkProduct = item.Key.FkProduct, FkSalmali = contr.FkSalmali, }; db.TblStoreLogs.Add(i); } i.Count = item.Sum(a => a.Count); i.Weight = item.Sum(a => a.Count * (decimal?)a.WeightOne); i.CountIn = item.Where(a => a.FkPortage.HasValue && a.Count > 0).Sum(a => a.Count); i.CountOut = item.Where(a => a.FkPortage.HasValue && a.Count < 0).Sum(a => a.Count); i.CountMovement = item.Where(a => a.FkPortage.HasValue == false).Sum(a => a.Count); i.WeightIn = item.Where(a => a.FkPortage.HasValue && a.Count > 0).Sum(a => a.Count * (decimal?)a.WeightOne); i.WeightOut = item.Where(a => a.FkPortage.HasValue && a.Count < 0).Sum(a => a.Count * (decimal?)a.WeightOne); i.WeightMovement = item.Where(a => a.FkPortage.HasValue == false).Sum(a => a.Count * (decimal?)a.WeightOne); rowOK.Add(i.Id); } } db.TblStoreLogs.RemoveRange(db.TblStoreLogs.Where(a => a.FkContract == fkcontract && (rowOK.Contains(a.Id) == false))); } }
public async Task <IActionResult> Login(string username, string password, string Captcha, int p) { ViewBag.username = username; ViewBag.p = 1; if (web_lib.stat.Captcha.CheckCaptcha(this.HttpContext, Captcha) == false) { ViewBag.error = "متن امنیتی اشتباه است"; var captcha = new web_lib.stat.Captcha(this.HttpContext); ViewBag.Captcha = captcha.ImageAsBaseSrc; return(View()); } if (username.IsEmpty() || username.IsCodemeli() == false) { ViewBag.error = "کد ملی اشتباه است"; var captcha = new web_lib.stat.Captcha(this.HttpContext); ViewBag.Captcha = captcha.ImageAsBaseSrc; return(View()); } // var def = db.TblConfigs.First(); var x = db.TblCustomers.OrderByDescending(a => a.FkSalmali).FirstOrDefault(a => /*a.FkSalmali == def.SalMaliMain*/ a.NationalCode == username); if (x == null) { ViewBag.error = "کد ملی شما در سیستم ثبت نیست"; var captcha = new web_lib.stat.Captcha(this.HttpContext); ViewBag.Captcha = captcha.ImageAsBaseSrc; return(View()); } if (p == 1) { if (x.Datesendpassword.HasValue == false) { await sendsmsAsync(x); db.SaveChanges(); ViewBag.p = 2; ViewBag.txt = "رمز عبور برای شما ارسال گردید"; } else { //ViewBag.txt = "رمز عبور قبلا برای شما ارسال گردیده"; ViewBag.p = 2; if (x.Datesendpassword.HasValue == false || ((DateTime.Now - x.Datesendpassword.Value) > TimeSpan.FromMinutes(5))) { await sendsmsAsync(x); db.SaveChanges(); ViewBag.txt = "رمز عبور برای شما ارسال گردید"; } else { ViewBag.error = "رمز عبور قبلا برای شما ارسال گردیده"; } } } else if (p == 2) { if (x.Password == password) { x.Dateloginlast = DateTime.Now; db.SaveChanges(); var claims = new List <Claim> { new Claim(ClaimTypes.NameIdentifier, x.NationalCode.ToString()), new Claim(ClaimTypes.Name, x.NationalCode.ToString()), }; ClaimsIdentity userIdentity = new ClaimsIdentity(claims, "login"); ClaimsPrincipal principal = new ClaimsPrincipal(userIdentity); await HttpContext.SignInAsync(principal); await sendsmsloginAsync(x); return(Redirect("/")); } else { ViewBag.p = 2; ViewBag.txt = "رمز عبوراشتباه است"; } } else if (p == 3) { ViewBag.p = 2; if (x.Datesendpassword.HasValue == false || ((DateTime.Now - x.Datesendpassword.Value) > TimeSpan.FromMinutes(5))) { await sendsmsAsync(x); db.SaveChanges(); ViewBag.txt = "رمز عبور برای شما ارسال گردید"; } else { ViewBag.error = "رمز عبور قبلا برای شما ارسال گردیده"; } } return(View()); }
public IActionResult Create(Models.tbls.location.location model) { if (!ModelState.IsValid) { ViewBag.error = "ثبت انجام نشد - فیلد ها را درست پرکنید"; return(View(model)); } try { var row = db.TblLocations.Find(model.Id); if (row == null) { row = new web_db._Weighing.TblLocation(); if (model.FkP != null) { row.Kind = db.TblLocations.Find(model.FkP).Kind + 1; } else { row.Kind = 1; } row.Id = Guid.NewGuid(); row.FkP = model.FkP; /**/ //row.Code = (db.TblLocations.Where(a => (a.FkP ?? Guid.Empty) == idp).Max(a => (int?)a.Code) ?? 0) + 1; db.TblLocations.Add(row); } row.Code = model.Code; // row.ord = 0; row.Title = model.Title; row.Isdell = false; row.Wight = model.wight; row.ForProduct = model.ForProduct; row.OtcodeAnbar = model.OtcodeAnbar; if (row.Wight == 0) { row.Wight = null; } // row.CodeFull = row.Code.ToString(); { var z = db.TblLocations.FirstOrDefault(a => a.CodeFull == row.CodeFull); if (z != null && z.Id != row.Id) { ViewBag.error = "ثبت انجام نشد - کد تکراری میباشد "; return(View(model)); } } { row.CodeFull = row.Code.ToString(); var rowp = db.TblLocations.Find(row.FkP); if (rowp != null) { row.CodeFull = rowp.Code + "-" + row.CodeFull; if (rowp != null) { var rowpp = db.TblLocations.Find(rowp.FkP); if (rowpp != null) { row.CodeFull = rowpp.Code + "-" + row.CodeFull; } } } } db.SaveChanges(); Models.cl._ListLocation = db.TblLocations.OrderBy(a => a.Code).ToList(); ViewBag.txt = "ثبت انجام شد "; return(RedirectToAction(nameof(Index))); } catch (Exception e) { } ViewBag.error = "ثبت انجام نشد "; return(View(model)); }
public IActionResult CreateIN(Guid idtype, int kindPortage, Models.tbls.portage.portage model) { ModelState.Remove("Weight2"); ModelState.Remove("Date2date"); ModelState.Remove("Date2time"); ModelState.Remove("Customer.Mob"); ModelState.Remove("Customer.NationalCode"); ModelState.Remove("Customer.Code"); ModelState.Remove("Customer.Title"); ModelState.Remove("Customer.Id"); ModelState.Remove("FkCarTbl"); var typecontract = db.TblContractTypes.Find(idtype); if (typecontract.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad) { ModelState.Remove("Weight1"); var conf = typecontract.ConfigASabad(); if (ModelState.IsValid) { var x = db.TblPortages.Find(model.Id); if (x == null) { model.Code = (db.TblPortages.Where(a => a.FkSalmali == User._getuserSalMaliDef() && a.FkContracttype == idtype && a.KindCode == kindPortage).Max(a => (long?)a.Code) ?? 0) + 1; x = new web_db._Weighing.TblPortage { FkSalmali = User._getuserSalMaliDef(), Code = model.Code, Dateadd1 = DateTime.Now, FkContracttype = idtype, FkUsAdd1 = User._getuserid().Value, Id = model.Id, KindCode = kindPortage, KindTitle = Models.tbls.portage.kindPortage.listkindcontract.Find(a => a.code == kindPortage).txt, }; db.TblPortages.Add(x); } else { x.Dateedit1 = DateTime.Now; x.FkUsEdit1 = User._getuserid().Value; } x.CarMashin = model.CarMashin; x.CarRanande = model.CarRanande; x.CarShMashin = model.CarShMashin; x.CarTell = model.CarTell; x.FkCar = model.FkCar; x.CarMashin = cl._ListCar.Single(a => a.Id == model.FkCar).Title; x.FkCustomer = model.FkCustomer; var dbdoc = new web_dbDocument.db_Context(); if (x.Weight1 != model.Weight1) { var z = cl.captureDorbinBaskul(); if (z != null) { dbdoc.TblDocuments.Add(new web_dbDocument.TblDocument { Date = DateTime.Now, FkP = x.Id, Id = Guid.NewGuid(), Image = z, Kind = "InBaskul", Format = "" }); } } x.Weight1 = model.Weight1; x.Weight1IsBascul = model.Weight1IsBascul; x.Txt = model.Txt; x.Date1 = model.Date1date.ToDate().AddHours(model.Date1time.Hours).AddMinutes(model.Date1time.Minutes); x.IsDel = false; x.IsPermitOk = null; x.FkUsPermit = null; x.TxtPermit = ""; ViewBag.error = checkportage(x); if (((string)ViewBag.error).IsEmpty()) { db.SaveChanges(); dbdoc.SaveChanges(); Models.cl._refstoreTow(db, x.Id); return(RedirectToAction("index", new { idtype = x.FkContracttype })); } } ViewData["type"] = db.TblContractTypes.Find(idtype); ViewData["kindPortage"] = kindPortage; ViewData["listcustumer"] = cus(typecontract, model); return(View(model)); } return(null); }
public IActionResult Create(Models.tbls.user.user model) { var x = db.TblUsers.Find(model.Id); if (x != null) { ModelState.Remove("Password"); } if (!ModelState.IsValid) { ViewBag.error = "ثبت انجام نشد"; return(View(model)); } if (x == null) { x = new web_db.TblUser { Id = model.Id, IsDel = false, Salmalidef = User._getuserSalMaliDef() }; db.TblUsers.Add(x); } try { x.Mob = model.Mob; if (model.Password.IsEmpty() == false) { x.Password = model.Password; } x.Roles = string.Join(',', model.Roles); x.Title = model.Title; x.Username = model.Username; x.IsActive = model.isActive; foreach (var item in model.Permis) { var z = db.TblUserPermis.SingleOrDefault(a => a.FkUser == x.Id && a.FkPortageType == item.FkPortageType); if (z == null) { z = new web_db.TblUserPermi { FkPortageType = item.FkPortageType, FkUser = x.Id }; db.TblUserPermis.Add(z); } z.IsIn = item.IsIn; z.IsInBack = item.IsInBack; z.IsOut = item.IsOut; z.IsOutBack = item.IsOutBack; z.IsReport = item.IsReport; z.IsType = z.IsIn || z.IsInBack || z.IsOut || z.IsOutBack; } try { db.SaveChanges(); ViewBag.txt = "ثبت انجام شد"; return(RedirectToAction(nameof(ListUser))); } catch (Exception e) { ViewBag.error = e.Message; } } catch { } return(View(model)); }