public static void RemoveAccount(Account acc) { using (var context = new TbsContext()) { context.DbAccount.Remove(FindDbAccount(acc, context)); context.SaveChanges(); } }
public static void SyncAccountsTxt() { using (var context = new TbsContext()) { var accs = IoHelperCore.ReadAccounts(); var dbAccs = new List <DbAccount>(accs.Count); foreach (var acc in accs) { dbAccs.Add(ConvertAcc(acc)); } context.DbAccount.AddRange(dbAccs); context.SaveChanges(); } }
public static List <Account> GetAccounts() { using (var context = new TbsContext()) { try { var accounts = context.DbAccount.AsQueryable().Select(x => x.Deserialize()); //accounts.ForEach(x => ObjectHelper.FixAccObj(x, x)); return(accounts.ToList()); } catch (Exception e) { Console.WriteLine("Exception thrown: " + e.Message); } return(new List <Account>()); } }
public static void SaveAccount(Account acc) { using (var context = new TbsContext()) { var saved = FindDbAccount(acc, context); if (saved == null) { context.DbAccount.Add(ConvertAcc(acc)); } else { saved.JsonData = JsonConvert.SerializeObject(acc); } context.SaveChanges(); } }
private static DbAccount FindDbAccount(Account acc, TbsContext context) => context.DbAccount.FirstOrDefault(x => x.Username == acc.AccInfo.Nickname && x.Server == acc.AccInfo.ServerUrl);