public static void Add(IEnumerable <PNCListDB> ListToAdd)
{
while (true)
{
try
{
var context = new DataBaseConnectionContext();
foreach (var Row in ListToAdd)
{
context.PNCList.Add(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 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 void UpdateANC(int OldID, int NewID, IEnumerable <ANCChangeDB> NewList)
{
var context = new DataBaseConnectionContext();
var OldList = context.ANCChange.Where(u => u.ActionID == OldID && u.Active == true).ToList();
int Revision = 0;
foreach (var Old in OldList)
{
Old.Active = false;
Revision = Old.Rev;
context.ANCChange.Update(Old);
}
foreach (var New in NewList)
{
New.ActionID = NewID;
New.Rev = Revision + 1;
New.ChangeBy = Environment.UserName.ToLower();
New.ChangeTime = DateTime.UtcNow;
context.ANCChange.Add(New);
}
context.SaveChanges();
}
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();
}
}
}
