public static void UpdateList(IEnumerable <PNCSpecialDB> ListToUpdate, int OriginalID, int NewID) { while (true) { try { var context = new DataBaseConnectionContext(); IEnumerable <PNCSpecialDB> CurrentList = context.PNCSpecial.Where(u => u.ActionID == OriginalID && u.Active == true).ToList(); int Revision = 0; foreach (PNCSpecialDB PNC in CurrentList) { PNC.Active = false; Revision = PNC.Rev; context.PNCSpecial.Update(PNC); } foreach (PNCSpecialDB PNC in ListToUpdate) { PNC.ActionID = NewID; PNC.Rev = Revision + 1; PNC.ActionIDOriginal = OriginalID; context.PNCSpecial.Add(PNC); } context.SaveChanges(); return; } catch { NoConnection.Info(); } } }
public static void Update(IEnumerable <PNCListDB> ListToUpdate) { while (true) { try { var context = new DataBaseConnectionContext(); foreach (var Row in ListToUpdate) { if (Row.ID != 0) { context.PNCList.Update(Row); } else { context.PNCList.Add(Row); } } context.SaveChanges(); return; } catch { NoConnection.Info(); } } }
public static void Deactivation(int ID) { while (true) { try { var context = new DataBaseConnectionContext(); IEnumerable <PNCListDB> PNCList = context.PNCList.Where(u => u.ActionID == ID && u.Active == true).ToList(); foreach (PNCListDB PNC in PNCList) { PNC.Active = false; PNC.ChangeTime = DateTime.UtcNow; PNC.ChangeBy = Environment.UserName.ToLower(); context.PNCList.Update(PNC); } context.SaveChanges(); return; } catch { NoConnection.Info(); } } }
public static void UpdateID(int Previous, int Successor) { while (true) { try { var context = new DataBaseConnectionContext(); IEnumerable <PNCListDB> PNCTable = context.PNCList.Where(u => u.ActionID == Previous && u.Active == true).ToList(); foreach (PNCListDB PNC in PNCTable) { PNC.ActionID = Successor; context.PNCList.Update(PNC); } context.SaveChanges(); return; } catch { NoConnection.Info(); } } }
public DbConn(string connStr , IResultsCache aResultsCache , bool commitAtFinalizing , bool debugPrint , ILogger logger) { _connStr = connStr; _aResultsCache = aResultsCache; _commitAtFinalizing = commitAtFinalizing; _debugPrint = debugPrint; _logger = logger; //次状態への遷移 this.GoToNextState(NoConnection.GetInstance()); }
public static IEnumerable <PNCSpecialDB> Load(int ActionID) { while (true) { try { var context = new DataBaseConnectionContext(); var List = context.PNCSpecial.Where(u => u.ActionID == ActionID && u.Active == true).ToList(); return(List); } catch { NoConnection.Info(); } } }
public static void UpdatePerson(UserDB UpdateUsers) { while (true) { try { var context = new DataBaseConnectionContext(); context.Users.Update(UpdateUsers); context.SaveChanges(); return; } catch { NoConnection.Info(); } } }
private IEnumerator LoadObject() { using (var webRequest = UnityWebRequest.Get(webURL)) { yield return(webRequest.SendWebRequest()); var json = webRequest.downloadHandler.text; if (!string.IsNullOrEmpty(webRequest.error)) { Debug.LogError(webRequest.error); NoConnection?.Invoke(); yield break; } var response = JsonConvert.DeserializeObject <List <RootObject> >(json); OnRootObject?.Invoke(response); } }
public static void PersonLoad(string SelectedLogin) { while (true) { try { var context = new DataBaseConnectionContext(); UserDB user = context.Users.Where(u => u.Login == SelectedLogin).FirstOrDefault(); _ = new LoadPerson(user); return; } catch { NoConnection.Info(); } } }
public static IEnumerable <UserDB> GetUsers() { while (true) { try { var _context = new DataBaseConnectionContext(); List <UserDB> users = new List <UserDB>(); foreach (UserDB user in _context.Users) { users.Add(user); } return(users); } catch { NoConnection.Info(); } } }
public static bool AddUser() { while (true) { try { var context = new DataBaseConnectionContext(); var user = new UserDB { Login = MainProgram.Self.addPersonView.GetUserName(), }; context.Add(user); context.SaveChanges(); return(true); } catch { NoConnection.Info(); } } }
public static void Remove(IEnumerable <PNCSpecialDB> ListToRemove) { while (true) { try { var context = new DataBaseConnectionContext(); foreach (var Row in ListToRemove) { context.PNCSpecial.Remove(Row); } context.SaveChanges(); return; } catch { NoConnection.Info(); } } }
public static void UpatePNCList(int Previous, int Successor, IEnumerable <PNCListDB> NewPNCList) { while (true) { try { var context = new DataBaseConnectionContext(); IEnumerable <PNCListDB> CurrentPNCList = context.PNCList.Where(u => u.ActionID == Previous && u.Active == true).ToList(); foreach (PNCListDB CurrentPNC in CurrentPNCList) { CurrentPNC.ActionID = Successor; if (!NewPNCList.Any(u => u.List == CurrentPNC.List)) { CurrentPNC.Active = false; CurrentPNC.ChangeTime = DateTime.UtcNow; CurrentPNC.ChangeBy = Environment.UserName.ToLower(); } context.PNCList.Update(CurrentPNC); } foreach (PNCListDB NewPNC in NewPNCList) { if (!CurrentPNCList.Any(u => u.List == NewPNC.List)) { NewPNC.ActionID = Successor; NewPNC.Active = true; context.PNCList.Add(NewPNC); } } context.SaveChanges(); return; } catch { NoConnection.Info(); } } }
public static void Refresh() { while (true) { try { var users = GetUsers(); MainProgram.Self.addPersonView.ClearAllLogin(); foreach (var user in users) { MainProgram.Self.addPersonView.SetAllLogin(user.Login); } return; } catch { NoConnection.Info(); } } }
private void HideNoConnectionWindow() { if (Globals.AppVars.NoConnectionWindow == null) { return; } NoConnection WindowToClose = Globals.AppVars.NoConnectionWindow; Globals.AppVars.NoConnectionWindow = null; if (App.Current == null) { return; } App.Current.Dispatcher.Invoke(System.Windows.Threading.DispatcherPriority.Normal, (Action)(() => { try { WindowToClose.Close(); } catch { }; })); }
public static UserDB ReturnUser(string UserLogin) { while (true) { try { var context = new DataBaseConnectionContext(); UserDB user = context.Users.Where(u => u.Login == UserLogin).FirstOrDefault(); if (user != null) { return(user); } return(null); } catch { NoConnection.Info(); } } }
public static bool DeleteUser(string UserLogin) { while (true) { try { var context = new DataBaseConnectionContext(); UserDB user = context.Users.Where(u => u.Login == UserLogin).FirstOrDefault(); if (user != null) { context.Users.Remove(user); context.SaveChanges(); return(true); } return(false); } catch { NoConnection.Info(); } } }
public static void Deactivation(int ActionID) { while (true) { try { var context = new DataBaseConnectionContext(); var List = context.PNCSpecial.Where(u => u.ActionID == ActionID).ToList(); foreach (PNCSpecialDB PNC in List) { PNC.Active = false; context.PNCSpecial.Update(PNC); } context.SaveChanges(); return; } catch { NoConnection.Info(); } } }
public ApiResult(NoConnection thirdValue) : base(thirdValue) { }