public ActionResult ResetPassword(ResetPassModel mod) { using (TimchurDatabaseEntities ent = new TimchurDatabaseEntities()) { bool valid = ent.Users.Where(x => x.IDCardNumber == mod.Id && x.Email == mod.Email).Count() > 0; bool exist = false; foreach (String s in LoginController.email_key.Keys) { if (s.CompareTo(mod.Email) == 0) { exist = true; } } bool key_email_validation = exist && LoginController.email_key[mod.Email].CompareTo(mod.Key) == 0; if (valid && key_email_validation) { Cache.gen_lock.WaitOne(); var my_use = ent.Users.Where(x => x.IDCardNumber == mod.Id && x.Email == mod.Email); foreach (Users use in my_use) { use.Password = mod.NewPass.ToString(); } ent.SaveChanges(); Cache.gen_lock.ReleaseMutex(); ModelState.AddModelError("הצליח", "שינוי פרטים הצליח"); return(View(mod)); } else { ModelState.AddModelError("שגיאה", "פרטים לא נכונים, אנא וודא את השדות ושלח שוב"); return(View(mod)); } } }
public ActionResult CancelTichur(TCanData can) { Cache.gen_lock.WaitOne(); try { using (TimchurDatabaseEntities ent = new TimchurDatabaseEntities()) { Tichurim tic = ent.Tichurim.Where(x => x.TichurNumber == can.id).FirstOrDefault(); foreach (SuppliersTichurim sti in tic.SuppliersTichurim) { if (sti.Suppliers.SuppliersClusetrs.Where(x2 => x2.ClusetrID == tic.ClusterID).First().LastTimeInList == tic.DateTimeCreated) { sti.Suppliers.SuppliersClusetrs.Where(x2 => x2.ClusetrID == tic.ClusterID).First().LastTimeInList = sti.Suppliers.SuppliersClusetrs.Where(x2 => x2.ClusetrID == tic.ClusterID).First().FormarLastTimeInList; } } tic.UpdatedUserID = ent.Users.Where(x => x.IDCardNumber == User.Identity.Name).First().ID; tic.DateTimeUpdated = DateTime.Now; tic.StatusID = 2; tic.UpdatedComment = can.comment; ent.SaveChanges(); Cache.gen_lock.ReleaseMutex(); return(Json("ביטול תיחור הצליח")); } } catch (Exception e) { Cache.gen_lock.ReleaseMutex(); return(Json("ביטול תיחור נכשל")); } }
public void AddAuctionOperation() { int?id = -1; Cache.gen_lock.WaitOne(); try { using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { entity.Auctions.Add(((Auctions)SingletonCache.Instance().Storage[Context.User.Identity.Name])); entity.SaveChanges(); } using (TimchurDatabaseEntities entity2 = new TimchurDatabaseEntities()) { string strm = ((Auctions)(SingletonCache.Instance().Storage[Context.User.Identity.Name])).AuctionNumber; id = entity2.Auctions.Where(x => x.AuctionNumber == 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()); }
/// <summary> /// Saves the stored update of a unit into the database, /// and sends a cache message of the operation's completion status. /// </summary> public void editUnitOperation() { int?id = -1; Cache.gen_lock.WaitOne(); UnitFModel mf = null; if (SingletonCache.Instance().Storage.ContainsKey(Context.User.Identity.Name)) { mf = ((UnitFModel)SingletonCache.Instance().Storage[Context.User.Identity.Name]); } try { using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { var original = entity.Units.Find(mf.unit.ID); if (original != null) { entity.UnitsAuctions.RemoveRange(entity.UnitsAuctions.Where(x => x.UnitID == mf.unit.ID)); if (mf.Limitations != null) { foreach (int i in mf.Limitations) { UnitsAuctions ua = new UnitsAuctions(); ua.AuctionID = i; ua.UnitID = mf.unit.ID; entity.UnitsAuctions.Add(ua); } } entity.Entry(original).CurrentValues.SetValues(((UnitFModel)SingletonCache.Instance().Storage[Context.User.Identity.Name]).unit); entity.SaveChanges(); } } using (TimchurDatabaseEntities entity2 = new TimchurDatabaseEntities()) { int strm = mf.unit.ID; id = entity2.Units.Where(x => x.ID == strm).First().ID; } SingletonCache.Instance().last_msg[Context.User.Identity.Name] = "בפעולה האחרונה, יחידה עודכה במערכת"; } catch (Exception e) { System.Diagnostics.Trace.Write(e.ToString()); SingletonCache.Instance().last_msg[Context.User.Identity.Name] = "בפעולה האחרונה, עדכון יחידה נכשל במערכת"; } SingletonCache.Instance().Storage[Context.User.Identity.Name] = null; 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()); }
/// <summary> /// Saves the stored update of an auction into the database, /// and sends a cache message of the operation's completion status. /// </summary> public void EditAuctionOperation() { int?id = -1; Cache.gen_lock.WaitOne(); try { using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { var original = entity.Auctions.Find(((Auctions)SingletonCache.Instance().Storage[Context.User.Identity.Name]).ID); if (original != null) { Auctions curr = ((Auctions)SingletonCache.Instance().Storage[Context.User.Identity.Name]); entity.Entry(original).CurrentValues.SetValues(((Auctions)SingletonCache.Instance().Storage[Context.User.Identity.Name])); entity.SaveChanges(); } entity.SaveChanges(); } using (TimchurDatabaseEntities entity2 = new TimchurDatabaseEntities()) { string strm = ((Auctions)(SingletonCache.Instance().Storage[Context.User.Identity.Name])).AuctionNumber; id = entity2.Auctions.Where(x => x.AuctionNumber == strm).First().ID; } SingletonCache.Instance().last_msg[Context.User.Identity.Name] = "בפעולה האחרונה, מכרז עודכן במערכת"; } catch (Exception e) { System.Diagnostics.Trace.Write(e.ToString()); SingletonCache.Instance().last_msg[Context.User.Identity.Name] = "בפעולה האחרונה, עדכון מכרז נכשל"; } SingletonCache.Instance().Storage[Context.User.Identity.Name] = null; 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 EditClusetrOperation() { int?id = -1; Cache.gen_lock.WaitOne(); try { using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { var original = entity.Clusetrs.Find(((Clusetrs)SingletonCache.Instance().Storage[Context.User.Identity.Name]).ID); if (original != null) { entity.Entry(original).CurrentValues.SetValues(((Clusetrs)SingletonCache.Instance().Storage[Context.User.Identity.Name])); entity.SaveChanges(); } entity.SaveChanges(); } using (TimchurDatabaseEntities entity2 = new TimchurDatabaseEntities()) { byte strm = ((Clusetrs)(SingletonCache.Instance().Storage[Context.User.Identity.Name])).DisplayNumber.Value; id = entity2.Clusetrs.Where(x => x.DisplayNumber == 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()); }
/// <summary> /// Saves the stored creation of a unit into the database, /// and sends a cache message of the operation's completion status. /// </summary> public void AddUnitOperation() { int?id = -1; Cache.gen_lock.WaitOne(); UnitFModel mf = ((UnitFModel)SingletonCache.Instance().Storage[Context.User.Identity.Name]); try { using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { entity.Units.Add(mf.unit); entity.SaveChanges(); } using (TimchurDatabaseEntities entity2 = new TimchurDatabaseEntities()) { string strm = mf.unit.Name; id = entity2.Units.Where(x => x.Name == strm).First().ID; if (mf.Limitations != null) { foreach (int i in mf.Limitations) { UnitsAuctions ua = new UnitsAuctions(); ua.AuctionID = i; ua.UnitID = id; entity2.UnitsAuctions.Add(ua); } } entity2.SaveChanges(); } SingletonCache.Instance().last_msg[Context.User.Identity.Name] = "בפעולה האחרונה, יחידה נוספה למערכת"; } catch (Exception e) { System.Diagnostics.Trace.Write(e.ToString()); SingletonCache.Instance().last_msg[Context.User.Identity.Name] = "בפעולה האחרונה, הוספת יחידה נכשלה"; } SingletonCache.Instance().Storage[Context.User.Identity.Name] = null; 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()); }
/// <summary> /// Saves the stored creation of a cluster into the database, /// and sends a cache message of the operation's completion status. /// </summary> public void AddClusterOperation() { int?id = -1; Cache.gen_lock.WaitOne(); try { using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { entity.Clusters.Add(((Clusters)SingletonCache.Instance().Storage[Context.User.Identity.Name])); entity.SaveChanges(); } using (TimchurDatabaseEntities entity2 = new TimchurDatabaseEntities()) { byte strm = ((Clusters)(SingletonCache.Instance().Storage[Context.User.Identity.Name])).DisplayNumber.Value; id = entity2.Clusters.Where(x => x.DisplayNumber == strm).First().ID; } SingletonCache.Instance().last_msg[Context.User.Identity.Name] = "בפעולה האחרונה, סל נוסף למערכת"; } catch (Exception e) { System.Diagnostics.Trace.Write(e.ToString()); SingletonCache.Instance().last_msg[Context.User.Identity.Name] = "בפעולה האחרונה, הוספת סל נכשלה"; } SingletonCache.Instance().Storage[Context.User.Identity.Name] = null; 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 ActionResult GetByTichurNumber(TNData data) { using (TimchurDatabaseEntities ent = new TimchurDatabaseEntities()) { Users use = ent.Users.Where(x => x.IDCardNumber == User.Identity.Name).First(); bool f = User.IsInRole("Admin"); string uni_fin = User.IsInRole("Admin") ? data.unit_field : use.UnitID.ToString(); int tem = 0; if (uni_fin != null) { tem = Int32.Parse(uni_fin); } if (tem == 0 || ent.Tichurim.Where(x => x.UnitID == tem && x.TichurNumber == data.id && (f || x.StatusID == 1)).Count() == 0) { GenModel failRes = new GenModel(); failRes.data = new List <string[]>(); failRes.data.Add(new string[] { "תיחור אינו קיים בתוך השרת(או תחת היחידה הנתונה של המשתמש או שהוכנסה)" }); failRes.Status = "error"; return(Json(failRes)); } if (!User.IsInRole("User")) { if (data.unit_field == null) { GenModel failRes = new GenModel(); failRes.data = new List <string[]>(); failRes.data.Add(new string[] { "אנא בחר ערך בשדה יחידה" }); failRes.Status = "error"; return(Json(failRes)); } } Tichurim tic = ent.Tichurim.Where(x => x.UnitID == tem && x.TichurNumber == data.id && (f || x.StatusID == 1)).First(); if (ent.UnitsAuctions.Where(x => x.UnitID == tem && x.AuctionID == tic.Clusetrs.AuctionID).Count() > 0) { if (User.IsInRole("User")) { Cache.gen_lock.WaitOne(); ent.Tichurim.Where(x => x.UnitID == tem && x.TichurNumber == data.id && x.StatusID == 1).First().DateTimeSelected = DateTime.Now; ent.SaveChanges(); Cache.gen_lock.ReleaseMutex(); } tic = ent.Tichurim.Where(x => x.UnitID == tem && x.TichurNumber == data.id && (f || x.StatusID == 1)).First(); GenModel Res = new GenModel(); Res.Status = "K"; Res.data = new List <string[]>(); Res.data.Add(new string[] { "מספר שורה", "מס' בתוצאת שליפה", "יחידה", "מס' מכרז", "שם מכרז", "תיחור", "מספר סל", "שם סל", "שם ספק", "ח.פ", "איש קשר", "אימייל", "טלפון", "תאריך ושעה" }); int i = 0; foreach (SuppliersTichurim st in tic.SuppliersTichurim) { Suppliers sup = ent.Suppliers.Where(x => x.ID == st.SupplierID).First(); i++; Res.data.Add(new string[] { i.ToString(), st.PositionInList.ToString(), tic.Units.Name, tic.Clusetrs.Auctions.AuctionNumber, tic.Clusetrs.Auctions.Name, tic.TichurNumber, tic.Clusetrs.DisplayNumber.Value.ToString(), tic.Clusetrs.Name, sup.Name, sup.CompanyNumber, sup.ContactName, sup.EmailAddress, sup.PhoneNumber, tic.DateTimeCreated.Value.ToString() }); } return(Json(Res)); } else { GenModel failRes = new GenModel(); failRes.data = new List <string[]>(); failRes.data.Add(new string[] { "משתמש אינו רשאי לצפות בתיחור" }); failRes.Status = "error"; return(Json(failRes)); } } }
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()); }