public ActionResult EditSupplier(int?id) { if (id == null) { return(View("EditSupplier")); } using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { Suppliers sup = entity.Suppliers.Where(x => x.ID == id).First(); if (sup == null) { return(View("EditSupplier")); } else { SupplierFModel fm = new SupplierFModel(); fm.supliers = sup; List <int?> fl = new List <int?>(); foreach (SuppliersClusetrs ua in sup.SuppliersClusetrs) { if (ua.Statuses.ID == 1) { fl.Add(ua.ClusetrID); } } fm.Limitions = fl; return(View("EditSupplier", fm)); } } }
public ActionResult EditSupplier(SupplierFModel sup) { if (ModelState.IsValid) { SingletonCache.Instance().Storage[User.Identity.Name] = sup; return(RedirectToAction("ESupplierLoadingScreen", "Main")); } else { return(View(sup)); } }
public ActionResult AddSupplier(SupplierFModel sup) { if (ModelState.IsValid) { using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { int cou = entity.Suppliers.Count(x => x.Name == sup.supliers.Name); if (cou != 0) { ModelState.AddModelError("Exist", "יחידה בעלת מספר זה כבר קיים."); return(View(sup)); } else { SingletonCache.Instance().Storage[User.Identity.Name] = sup; return(RedirectToAction("SupplierLoadingScreen", "Main")); } } } else { return(View(sup)); } }
public ActionResult ESupplierLoadingScreen(SupplierFModel target) { return(View(target)); }
public void editSupplierOperation() { int?id = -1; Cache.gen_lock.WaitOne(); SupplierFModel mf = ((SupplierFModel)SingletonCache.Instance().Storage[Context.User.Identity.Name]); try { using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { var original = entity.Suppliers.Find(mf.supliers.ID); if (original != null) { if (mf.Limitions != null) { foreach (int i in mf.Limitions) { SuppliersClusetrs ua = new SuppliersClusetrs(); if (entity.SuppliersClusetrs.Where(x => x.ClusetrID == i && x.SupplierID == mf.supliers.ID).Count() > 0) { entity.SuppliersClusetrs.Where(x => x.ClusetrID == i && x.SupplierID == mf.supliers.ID).First().StatusID = 1; } else { ua.ClusetrID = i; ua.SupplierID = id; ua.FormarLastTimeInList = new DateTime(2000, 1, 1); ua.LastTimeInList = new DateTime(2000, 1, 1); ua.StatusID = 1; entity.SuppliersClusetrs.Add(ua); } } } foreach (SuppliersClusetrs sc in entity.SuppliersClusetrs.Where(x => !mf.Limitions.Contains(x.ClusetrID) && x.SupplierID == mf.supliers.ID)) { sc.StatusID = 2; } if (mf.ActualEmail == null) { mf.supliers.EmailAddress = ""; } else { mf.supliers.EmailAddress = mf.ActualEmail; } mf.supliers.PhoneNumber = mf.Prefix + mf.ActualNumber; entity.Entry(original).CurrentValues.SetValues(((SupplierFModel)SingletonCache.Instance().Storage[Context.User.Identity.Name]).supliers); entity.SaveChanges(); } } using (TimchurDatabaseEntities entity2 = new TimchurDatabaseEntities()) { int strm = mf.supliers.ID; id = entity2.Suppliers.Where(x => x.ID == strm).First().ID; } SingletonCache.Instance().last_msg[Context.User.Identity.Name] = "בפעולה האחרונה,יחידה עודכה במערכת"; } catch (Exception e) { SingletonCache.Instance().last_msg[Context.User.Identity.Name] = "בפעולה האחרונה,הוספת יחידה נכשלה במערכת"; } Cache.gen_lock.ReleaseMutex(); string str = Context.User.Identity.Name; string msg = ""; if (SingletonCache.Instance().last_msg.Keys.Contains(str)) { msg = SingletonCache.Instance().last_msg[str]; } string to_s = string.Format("סטאטוס:" + msg); Clients.Caller.sendMessage(id.Value.ToString()); }
public void AddSupplierOperation() { int?id = -1; Cache.gen_lock.WaitOne(); SupplierFModel mf = ((SupplierFModel)SingletonCache.Instance().Storage[Context.User.Identity.Name]); try { using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { if (mf.ActualEmail == null) { mf.supliers.EmailAddress = ""; } else { mf.supliers.EmailAddress = mf.ActualEmail; } mf.supliers.PhoneNumber = mf.Prefix + mf.ActualNumber; entity.Suppliers.Add(mf.supliers); entity.SaveChanges(); } using (TimchurDatabaseEntities entity2 = new TimchurDatabaseEntities()) { string strm = mf.supliers.Name; id = entity2.Suppliers.Where(x => x.Name == strm).First().ID; if (mf.Limitions != null) { foreach (int i in mf.Limitions) { SuppliersClusetrs ua = new SuppliersClusetrs(); ua.ClusetrID = i; ua.SupplierID = id; ua.FormarLastTimeInList = new DateTime(2000, 1, 1); ua.LastTimeInList = new DateTime(2000, 1, 1); ua.StatusID = 1; entity2.SuppliersClusetrs.Add(ua); } } entity2.SaveChanges(); } SingletonCache.Instance().last_msg[Context.User.Identity.Name] = "בפעולה האחרונה,ספק נוספה למערכת"; } catch (Exception e) { SingletonCache.Instance().last_msg[Context.User.Identity.Name] = "בפעולה האחרונה,הוספת ספק נכשלה"; } Cache.gen_lock.ReleaseMutex(); string str = Context.User.Identity.Name; string msg = ""; if (SingletonCache.Instance().last_msg.Keys.Contains(str)) { msg = SingletonCache.Instance().last_msg[str]; } string to_s = string.Format("סטאטוס:" + msg); Clients.Caller.sendMessage(id.Value.ToString()); }