public User GetByUsername(string username) { using (var db = new DomoFinoContext()) { try { var user = db.User.Where(x => x.Username == username).Include(g => g.UserGroup).SingleOrDefault(); // (from p in db.Paragon // join c in db.Category on p.CategoryId equals c.Id // join user in db.User on p.AddedById equals user.Id // join userGroup in db.UserGroup on user.UserGroupId equals userGroup.Id // where userGroup.Name == userGroupName // select p).ToList(); return user; } catch (NullReferenceException e) { Console.WriteLine(e); throw; } catch (Exception e) { Console.WriteLine(e); throw; } } }
public Paragon Update(Paragon paragon) { using (var db = new DomoFinoContext()) { try { db.Paragon.AddOrUpdate(paragon); //requires using System.Data.Entity.Migrations; db.SaveChanges(); return(db.Paragon.Include(p => p.Category).SingleOrDefault(x => x.Id == paragon.Id)); // var entity = db.Paragon.Find(paragon); // if (entity == null) // { // return; // } // // db.Entry(entity).CurrentValues.SetValues(paragon); // db.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); throw; } } }
public Category GetCategoryById(int id) { using (var db = new DomoFinoContext()) { return(db.Category.SingleOrDefault(x => x.Id == id)); } }
public IList <Category> GetAllCategoriesForGroup(int groupId) { using (var db = new DomoFinoContext()) { var lst = db.Category.Where(x => x.UserGroupId == groupId).ToList(); lst.ForEach(x => x.BackgroundColor = x.BackgroundColor ?? "#ffffff"); return(lst); } }
public IList <Category> GetAllCategories() { using (var db = new DomoFinoContext()) { var lst = db.Category.ToList(); lst.ForEach(x => x.BackgroundColor = x.BackgroundColor ?? "#ffffff"); return(lst); } }
public Paragon AddNew(Paragon paragon) { using (var db = new DomoFinoContext()) { try { db.Paragon.Add(paragon); db.Category.Attach(paragon.Category); db.SaveChanges(); return(paragon); } catch (Exception e) { Console.WriteLine(e); throw; } } }
public User LoginUser(string username, string password) { using (var db = new DomoFinoContext()) { try { var user = db.User.Where(x => x.Username == username).Include(g => g.UserGroup).SingleOrDefault(); return user; } catch (NullReferenceException e) { Console.WriteLine(e); throw; } catch (Exception e) { Console.WriteLine(e); throw; } } }
//newest public IList <Paragon> GetByUserForGroup(int groupId) { using (var db = new DomoFinoContext()) { try { var userList = db.User.Where(u => u.UserGroupId == groupId).ToList(); var paragonList = new List <Paragon>(); foreach (var user in userList) { var lst = db.Paragon.Where(p => p.AddedById == user.Id).Include(p => p.Category).ToList(); paragonList.AddRange(lst); } return(paragonList); } catch (Exception e) { Console.WriteLine(e); throw; } } }
public void DeleteFromBin(List <int> idList) { using (var db = new DomoFinoContext()) { try { idList.ForEach(id => { Paragon paragon = new Paragon() { Id = id }; db.Paragon.Attach(paragon); db.Paragon.Remove(paragon); }); db.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); throw; } } }