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)
{
}
