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()); }
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 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)); } } }
private void SignInAsync(LoginModel user, bool isPersistent) { AuthenticationManager.SignOut(DefaultAuthenticationTypes.ExternalCookie); using (var conn = new TimchurDatabaseEntities()) { Users User = conn.Users.Where(s => (s.IDCardNumber).ToString() == user.Username).FirstOrDefault <Users>(); string role = "User"; if (User.Roles.ID == 1) { role = "User"; } else { role = "Admin"; } var identity = new ClaimsIdentity(new[] { new Claim(ClaimTypes.Name, User.IDCardNumber), new Claim(ClaimTypes.GivenName, User.FullName), new Claim(ClaimTypes.Role, role) }, "ApplicationCookie"); SingletonCache.Instance().last_msg[User.IDCardNumber] = null; AuthenticationManager.SignIn( new AuthenticationProperties() { IsPersistent = isPersistent }, identity); } //צריך להוסיף להוציא שם מהמסד }
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("ביטול תיחור נכשל")); } }
/// <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()); }
public ActionResult EditUnit(int?id) { if (id == null) { return(View("EditUnit")); } using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { Units uni = entity.Units.Where(x => x.ID == id).First(); if (uni == null) { return(View("EditUnit")); } else { List <int?> fl = new List <int?>(); foreach (UnitsAuctions ua in uni.UnitsAuctions) { fl.Add(ua.AuctionID); } UnitFModel fm = new UnitFModel(); fm.unit = uni; fm.Limitions = fl; return(View("EditUnit", fm)); } } }
public ActionResult MangSuppliers() { db = new TimchurDatabaseEntities(); List <Suppliers> li = db.Suppliers.OrderBy(s => s.Name).OrderBy(s => s.SuppliersClusetrs.FirstOrDefault().Clusetrs.Auctions.AuctionNumber).OrderBy(s => s.SuppliersClusetrs.FirstOrDefault().Clusetrs.DisplayNumber).ToList(); /** load from database user list **/ /** transform loaded data into model fit for edit + present **/ return(View(li)); }
public ActionResult MangAuctions() { db = new TimchurDatabaseEntities(); List <Auctions> li = db.Auctions.OrderBy(s => s.AuctionNumber).ToList(); /** load from database user list **/ /** transform loaded data into model fit for edit + present **/ return(View(li)); }
public bool Authenticate(string username, string Password) { Users user; using (var context = new TimchurDatabaseEntities()) { user = context.Users.Where(s => (s.IDCardNumber).ToString() == username).Where(s => (s.Password) == Password).FirstOrDefault <Users>(); } if (user == null) { return(false); } return(true); }
/// <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()); }
public ActionResult GetCluByAuc(int auctionId) { using (TimchurDatabaseEntities ent = new TimchurDatabaseEntities()) { List <SelectListItem> li = new List <SelectListItem>(); foreach (Clusetrs clu in ent.Clusetrs.Where(x => x.AuctionID == auctionId && x.StatusID == 1).OrderBy(x => x.DisplayNumber)) { li.Add(new SelectListItem() { Value = clu.ID.ToString(), Text = clu.DisplayNumber + "-" + clu.Name }); } return(Json(li)); } }
/// <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 ActionResult EditUser(int?id) { if (id == null) { return(View("EditUser")); } using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { Users use = entity.Users.Where(x => x.ID == id).First(); if (use == null) { return(View("EditUser")); } else { return(View("EditUser", use)); } } }
public ActionResult EditAuction(int?id) { if (id == null) { return(View("EditAuction")); } using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { Auctions auc = entity.Auctions.Where(x => x.ID == id).First(); if (auc == null) { return(View("EditAuction")); } else { return(View("EditAuction", auc)); } } }
public ActionResult EditClusetr(int?id) { if (id == null) { return(View("EditClusetr")); } using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { Clusetrs clu = entity.Clusetrs.Where(x => x.ID == id).First(); if (clu == null) { return(View("EditClusetr")); } else { return(View("EditClusetr", clu)); } } }
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 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 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 AddUnit(UnitFModel uni) { if (ModelState.IsValid) { using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { int cou = entity.Units.Count(x => x.Name == uni.unit.Name); if (cou != 0) { ModelState.AddModelError("Exist", "יחידה בעלת מספר זה כבר קיים."); return(View(uni)); } else { SingletonCache.Instance().Storage[User.Identity.Name] = uni; return(RedirectToAction("UnitLoadingScreen", "Main")); } } } else { return(View(uni)); } }
public ActionResult AddClusetr(Clusetrs clu) { if (ModelState.IsValid) { using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { int cou = entity.Clusetrs.Count(x => x.DisplayNumber == clu.DisplayNumber); if (cou != 0) { ModelState.AddModelError("Exist", "ספק בעל מספר זה כבר קיים."); return(View(clu)); } else { SingletonCache.Instance().Storage[User.Identity.Name] = clu; return(RedirectToAction("ClusetrLoadingScreen", "Main")); } } } else { return(View(clu)); } }
public ActionResult AddAuction(Auctions auc) { if (ModelState.IsValid) { using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { int cou = entity.Auctions.Count(x => x.AuctionNumber == auc.AuctionNumber); if (cou != 0) { ModelState.AddModelError("Exist", "מכרז בעל מספר זה כבר קיים."); return(View(auc)); } else { SingletonCache.Instance().Storage[User.Identity.Name] = auc; return(RedirectToAction("AuctionLoadingScreen", "Main")); } } } else { return(View(auc)); } }
public ActionResult AddUser(Users use) { if (ModelState.IsValid) { using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities()) { int cou = entity.Users.Count(x => x.IDCardNumber == use.IDCardNumber); if (cou != 0) { ModelState.AddModelError("Exist", "המשתמש בעל תעודת הזהות הזאת כבר קיים."); return(View(use)); } else { SingletonCache.Instance().Storage[User.Identity.Name] = use; return(RedirectToAction("UserLoadingScreen", "Main")); } } } else { return(View(use)); } }
public TablePullResult TichurAlgorithem(TichurInfo input) { using (TimchurDatabaseEntities ent = new TimchurDatabaseEntities()) { // Checking for duplicate tichurs Database.Tichurim check = ent.Tichurim.Where(x => x.TichurNumber == input.TichurNumber).FirstOrDefault(); if (ent.Tichurim.Where(x => x.TichurNumber == input.TichurNumber).Count() != 0 && check.UnitID == input.UnitID && check.StatusID == 1) { throw new DuplicateKeyException(check); } TablePullResult res = new TablePullResult(); int suppliersRemaining = 0; if (ent.Clusetrs.Where(x => x.ID == input.CluestrID).FirstOrDefault() != null) { suppliersRemaining = ent.Clusetrs.Where(x => x.ID == input.CluestrID).FirstOrDefault().SuppliersInTichur.Value; } var sortByUsagePre = (from sup in ent.Suppliers join supcluc in ent.SuppliersClusetrs on sup.ID equals supcluc.SupplierID where supcluc.ClusetrID == input.CluestrID && sup.StatusID == 1 orderby supcluc.LastTimeInList select new { Sup = sup, SupCl = supcluc }); var sortByUsage = sortByUsagePre.AsExpandable().GroupBy(x => DbFunctions.AddMilliseconds(x.SupCl.LastTimeInList, -x.SupCl.LastTimeInList.Value.Millisecond)).OrderBy(x => x.Key); //Date-grouped iterator var itr = sortByUsage.GetEnumerator(); itr.MoveNext(); var rnd = new Random(); while (suppliersRemaining > 0) { //oldest group of suppliers var dateGroup = itr.Current; //Need to pick a random subset of the suppliers if (dateGroup.Count() < suppliersRemaining) { var shuffled = dateGroup.OrderBy(i => rnd.Next()); // Going over the shuffled list until enough are extracted foreach (var supplier in shuffled) { res.table.Add(supplier.Sup.ID.ToString()); if (--suppliersRemaining == 0) { break; } } itr.MoveNext(); } else { //Need at least one entire dategroup - adding all suppliers in current set. foreach (var supplier in dateGroup) { res.table.Add(supplier.Sup.ID.ToString()); } suppliersRemaining -= dateGroup.Count(); itr.MoveNext(); } } return(res); } }
public ActionResult GetByTichurDates(TEBDData data) { DateTime to; string[] to_str = data.To.Split('/'); to = new DateTime(Int32.Parse(to_str[2]), Int32.Parse(to_str[0]), Int32.Parse(to_str[1])); DateTime from; string[] from_str = data.From.Split('/'); from = new DateTime(Int32.Parse(from_str[2]), Int32.Parse(from_str[0]), Int32.Parse(from_str[1])); if (from > to) { GenModel failRes = new GenModel(); failRes.data = new List <string[]>(); failRes.data.Add(new string[] { "טווח תאריכים אינו תקין" }); failRes.Status = "error"; return(Json(failRes)); } using (TimchurDatabaseEntities ent = new TimchurDatabaseEntities()) { GenModel Res = new GenModel(); 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); } int i; if (User.IsInRole("User")) { if (data.clu_field == null && data.auc_field == null) { Res = new GenModel(); Res.Status = "K"; Res.data = new List <string[]>(); Res.data.Add(new string[] { "", "", "", "", "", "", "", "", "" }); i = 0; foreach (Tichurim tic in ent.Tichurim.Where(x => (f || x.StatusID == 1) && x.UnitID == tem && x.DateTimeCreated <to && x.DateTimeCreated> from).OrderBy(x => x.DateTimeCreated)) { Res.data.Add(new string[] { i.ToString(), tic.Units.Name, tic.Clusetrs.Auctions.AuctionNumber, tic.Clusetrs.Auctions.Name, tic.TichurNumber, tic.Clusetrs.DisplayNumber.Value.ToString(), tic.Clusetrs.Name, tic.DateTimeCreated.Value.ToString(), tic.Statuses.Name }); i++; } return(Json(Res)); } else if (data.clu_field == null) { Res = new GenModel(); Res.Status = "K"; Res.data = new List <string[]>(); Res.data.Add(new string[] { "", "", "", "", "", "", "", "", "" }); i = 0; int al = Int32.Parse(data.auc_field); foreach (Tichurim tic in ent.Tichurim.Where(x => (f || x.StatusID == 1) && x.Clusetrs.AuctionID == al && x.UnitID == tem && x.DateTimeCreated <to && x.DateTimeCreated> from).OrderBy(x => x.DateTimeCreated)) { Res.data.Add(new string[] { i.ToString(), tic.Units.Name, tic.Clusetrs.Auctions.AuctionNumber, tic.Clusetrs.Auctions.Name, tic.TichurNumber, tic.Clusetrs.DisplayNumber.Value.ToString(), tic.Clusetrs.Name, tic.DateTimeCreated.Value.ToString(), tic.Statuses.Name }); i++; } return(Json(Res)); } else if (data.auc_field == null) { Res = new GenModel(); Res.Status = "K"; Res.data = new List <string[]>(); Res.data.Add(new string[] { "", "", "", "", "", "", "", "", "" }); i = 0; int cl = Int32.Parse(data.clu_field); foreach (Tichurim tic in ent.Tichurim.Where(x => (f || x.StatusID == 1) && x.ClusterID == cl && x.UnitID == tem && x.DateTimeCreated <to && x.DateTimeCreated> from).OrderBy(x => x.DateTimeCreated)) { Res.data.Add(new string[] { i.ToString(), tic.Units.Name, tic.Clusetrs.Auctions.AuctionNumber, tic.Clusetrs.Auctions.Name, tic.TichurNumber, tic.Clusetrs.DisplayNumber.Value.ToString(), tic.Clusetrs.Name, tic.DateTimeCreated.Value.ToString(), tic.Statuses.Name }); i++; } return(Json(Res)); } else { Res = new GenModel(); Res.Status = "K"; Res.data = new List <string[]>(); Res.data.Add(new string[] { "", "", "", "", "", "", "", "", "" }); i = 0; int al = Int32.Parse(data.auc_field); int cl = Int32.Parse(data.clu_field); foreach (Tichurim tic in ent.Tichurim.Where(x => (f || x.StatusID == 1) && x.Clusetrs.AuctionID == al && x.ClusterID == cl && x.UnitID == tem && x.DateTimeCreated <to && x.DateTimeCreated> from).OrderBy(x => x.DateTimeCreated)) { Res.data.Add(new string[] { i.ToString(), tic.Units.Name, tic.Clusetrs.Auctions.AuctionNumber, tic.Clusetrs.Auctions.Name, tic.TichurNumber, tic.Clusetrs.DisplayNumber.Value.ToString(), tic.Clusetrs.Name, tic.DateTimeCreated.Value.ToString(), tic.Statuses.Name }); i++; } return(Json(Res)); } } if (data.unit_field == null) { if (data.clu_field == null && data.auc_field == null) { Res = new GenModel(); Res.Status = "K"; Res.data = new List <string[]>(); Res.data.Add(new string[] { "", "", "", "", "", "", "", "", "" }); i = 0; foreach (Tichurim tic in ent.Tichurim.Where(x => (f || x.StatusID == 1) && x.DateTimeCreated <to && x.DateTimeCreated> from).OrderBy(x => x.DateTimeCreated)) { Res.data.Add(new string[] { i.ToString(), tic.Units.Name, tic.Clusetrs.Auctions.AuctionNumber, tic.Clusetrs.Auctions.Name, tic.TichurNumber, tic.Clusetrs.DisplayNumber.Value.ToString(), tic.Clusetrs.Name, tic.DateTimeCreated.Value.ToString(), tic.Statuses.Name }); i++; } return(Json(Res)); } else if (data.clu_field == null) { Res = new GenModel(); Res.Status = "K"; Res.data = new List <string[]>(); Res.data.Add(new string[] { "", "", "", "", "", "", "", "", "" }); i = 0; int al = Int32.Parse(data.auc_field); foreach (Tichurim tic in ent.Tichurim.Where(x => (f || x.StatusID == 1) && x.Clusetrs.AuctionID == al && x.DateTimeCreated <to && x.DateTimeCreated> from).OrderBy(x => x.DateTimeCreated)) { Res.data.Add(new string[] { i.ToString(), tic.Units.Name, tic.Clusetrs.Auctions.AuctionNumber, tic.Clusetrs.Auctions.Name, tic.TichurNumber, tic.Clusetrs.DisplayNumber.Value.ToString(), tic.Clusetrs.Name, tic.DateTimeCreated.Value.ToString(), tic.Statuses.Name }); i++; } return(Json(Res)); } else if (data.auc_field == null) { Res = new GenModel(); Res.Status = "K"; Res.data = new List <string[]>(); Res.data.Add(new string[] { "", "", "", "", "", "", "", "", "" }); i = 0; int cl = Int32.Parse(data.clu_field); foreach (Tichurim tic in ent.Tichurim.Where(x => (f || x.StatusID == 1) && x.ClusterID == cl && x.DateTimeCreated <to && x.DateTimeCreated> from).OrderBy(x => x.DateTimeCreated)) { Res.data.Add(new string[] { i.ToString(), tic.Units.Name, tic.Clusetrs.Auctions.AuctionNumber, tic.Clusetrs.Auctions.Name, tic.TichurNumber, tic.Clusetrs.DisplayNumber.Value.ToString(), tic.Clusetrs.Name, tic.DateTimeCreated.Value.ToString(), tic.Statuses.Name }); i++; } return(Json(Res)); } else { Res = new GenModel(); Res.Status = "K"; Res.data = new List <string[]>(); Res.data.Add(new string[] { "", "", "", "", "", "", "", "", "" }); i = 0; int al = Int32.Parse(data.auc_field); int cl = Int32.Parse(data.clu_field); foreach (Tichurim tic in ent.Tichurim.Where(x => (f || x.StatusID == 1) && x.Clusetrs.AuctionID == al && x.ClusterID == cl && x.DateTimeCreated <to && x.DateTimeCreated> from).OrderBy(x => x.DateTimeCreated)) { Res.data.Add(new string[] { i.ToString(), tic.Units.Name, tic.Clusetrs.Auctions.AuctionNumber, tic.Clusetrs.Auctions.Name, tic.TichurNumber, tic.Clusetrs.DisplayNumber.Value.ToString(), tic.Clusetrs.Name, tic.DateTimeCreated.Value.ToString(), tic.Statuses.Name }); i++; } return(Json(Res)); } } else { if (data.clu_field == null && data.auc_field == null) { Res = new GenModel(); Res.Status = "K"; Res.data = new List <string[]>(); Res.data.Add(new string[] { "", "", "", "", "", "", "", "", "" }); i = 0; foreach (Tichurim tic in ent.Tichurim.Where(x => (f || x.StatusID == 1) && x.UnitID == tem && x.DateTimeCreated <to && x.DateTimeCreated> from).OrderBy(x => x.DateTimeCreated)) { Res.data.Add(new string[] { i.ToString(), tic.Units.Name, tic.Clusetrs.Auctions.AuctionNumber, tic.Clusetrs.Auctions.Name, tic.TichurNumber, tic.Clusetrs.DisplayNumber.Value.ToString(), tic.Clusetrs.Name, tic.DateTimeCreated.Value.ToString(), tic.Statuses.Name }); i++; } return(Json(Res)); } else if (data.clu_field == null) { Res = new GenModel(); Res.Status = "K"; Res.data = new List <string[]>(); Res.data.Add(new string[] { "", "", "", "", "", "", "", "", "" }); i = 0; int al = Int32.Parse(data.auc_field); foreach (Tichurim tic in ent.Tichurim.Where(x => (f || x.StatusID == 1) && x.Clusetrs.AuctionID == al && x.UnitID == tem && x.DateTimeCreated <to && x.DateTimeCreated> from).OrderBy(x => x.DateTimeCreated)) { Res.data.Add(new string[] { i.ToString(), tic.Units.Name, tic.Clusetrs.Auctions.AuctionNumber, tic.Clusetrs.Auctions.Name, tic.TichurNumber, tic.Clusetrs.DisplayNumber.Value.ToString(), tic.Clusetrs.Name, tic.DateTimeCreated.Value.ToString(), tic.Statuses.Name }); i++; } return(Json(Res)); } else if (data.auc_field == null) { Res = new GenModel(); Res.Status = "K"; Res.data = new List <string[]>(); Res.data.Add(new string[] { "", "", "", "", "", "", "", "", "" }); i = 0; int cl = Int32.Parse(data.clu_field); foreach (Tichurim tic in ent.Tichurim.Where(x => (f || x.StatusID == 1) && x.ClusterID == cl && x.UnitID == tem && x.DateTimeCreated <to && x.DateTimeCreated> from).OrderBy(x => x.DateTimeCreated)) { Res.data.Add(new string[] { i.ToString(), tic.Units.Name, tic.Clusetrs.Auctions.AuctionNumber, tic.Clusetrs.Auctions.Name, tic.TichurNumber, tic.Clusetrs.DisplayNumber.Value.ToString(), tic.Clusetrs.Name, tic.DateTimeCreated.Value.ToString(), tic.Statuses.Name }); i++; } return(Json(Res)); } else { Res = new GenModel(); Res.Status = "K"; Res.data = new List <string[]>(); Res.data.Add(new string[] { "", "", "", "", "", "", "", "", "" }); i = 0; int al = Int32.Parse(data.auc_field); int cl = Int32.Parse(data.clu_field); foreach (Tichurim tic in ent.Tichurim.Where(x => (f || x.StatusID == 1) && x.Clusetrs.AuctionID == al && x.ClusterID == cl && x.UnitID == tem && x.DateTimeCreated <to && x.DateTimeCreated> from).OrderBy(x => x.DateTimeCreated)) { Res.data.Add(new string[] { i.ToString(), tic.Units.Name, tic.Clusetrs.Auctions.AuctionNumber, tic.Clusetrs.Auctions.Name, tic.TichurNumber, tic.Clusetrs.DisplayNumber.Value.ToString(), tic.Clusetrs.Name, tic.DateTimeCreated.Value.ToString(), tic.Statuses.Name }); i++; } return(Json(Res)); } } } return(Json("")); }
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 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()); }
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()); }