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;
}
}
}
