public List <SkillName> GetSkillNameByUserId(Guid id)
{
using (var ctx = new PlatineContext())
{
return(ctx.SkillNames.Where(s => s.UserId.Equals(id)).ToList());
}
}
public User GetUserById(Guid id)
{
using (var ctx = new PlatineContext())
{
return(ctx.Users.SingleOrDefault(e => e.Id.Equals(id)));
}
}
public List <User> GetAllUsers()
{
using (var ctx = new PlatineContext())
{
return(ctx.Users.ToList());
}
}
public void AddSkill(Skill skill)
{
using (var ctx = new PlatineContext())
{
ctx.Skills.Add(skill);
ctx.SaveChanges();
}
}
public void UpdateEducation(Education education)
{
using (var ctx = new PlatineContext())
{
ctx.Entry(education).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
}
}
public void AddSkillName(SkillName skillName)
{
using (var ctx = new PlatineContext())
{
ctx.SkillNames.Add(skillName);
ctx.SaveChanges();
}
}
public void AddEducation(Education education)
{
using (var ctx = new PlatineContext())
{
ctx.Educations.Add(education);
ctx.SaveChanges();
}
}
public void AddExperience(Experience experience)
{
using (var ctx = new PlatineContext())
{
ctx.Experiences.Add(experience);
ctx.SaveChanges();
}
}
public List <Experience> GetExperienceByUserId(Guid id)
{
using (var ctx = new PlatineContext())
{
var query = ctx.Experiences.Where(e => e.UserId.Equals(id)).ToList();
return(query);
}
}
public void UpdateUser(User user)
{
using (var ctx = new PlatineContext())
{
ctx.Entry(user).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
}
}
public User GetUserByLogin(string login)
{
using (var ctx = new PlatineContext())
{
var query = ctx.Users.SingleOrDefault(u => u.Login.Equals(login));
return(query);
};
}
public void DeleteEducation(Guid id)
{
using (var ctx = new PlatineContext())
{
var query = ctx.Educations.SingleOrDefault(e => e.Id.Equals(id));
ctx.Educations.Remove(query);
ctx.SaveChanges();
}
}
public List <Education> GetEducationsByUserId(Guid id)
{
using (var ctx = new PlatineContext())
{
//List<Education> l = new List<Education>();
var query = ctx.Educations.Where(e => e.UserId.Equals(id)).ToList();
return(query);
}
}
public User GetUserByMail(string Mail)
{
using (var ctx = new PlatineContext())
{
var query = ctx.Users.SingleOrDefault(e => e.Mail.Equals(Mail));
if (query == null)
{
throw new MissingException("Mail " + Mail);
}
return(query);
}
}
public Education GetEducationById(Guid id)
{
using (var ctx = new PlatineContext())
{
var query = ctx.Educations.SingleOrDefault(e => e.Id.Equals(id));
if (query == null)
{
throw new MissingException("Education");
}
return(query);
}
}
public void UpdateExperience(Experience experience, Guid userId)
{
using (var ctx = new PlatineContext())
{
if (!experience.UserId.Equals(userId))
{
throw new NotAllowedException();
}
ctx.Entry(experience).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
}
}
public void Register(User user)
{
using (var ctx = new PlatineContext())
{
var query = ctx.Users.SingleOrDefault(u => u.Login.Equals(user.Login));
if (query != null)
{
throw new AlreadyExistException();
}
ctx.Users.Add(user);
ctx.SaveChanges();
};
}
public void DeleteUserById(Guid id)
{
using (var ctx = new PlatineContext())
{
User u = ctx.Users.SingleOrDefault(e => e.Id.Equals(id));
if (u == null)
{
throw new MissingException("User " + id);
}
ctx.Users.Remove(u);
ctx.SaveChanges();
}
}
public Experience GetExperienceById(Guid id, Guid userId)
{
using (var ctx = new PlatineContext())
{
var query = ctx.Experiences.SingleOrDefault(e => e.Id.Equals(id));
if (query == null)
{
throw new MissingException("experience");
}
if (!query.UserId.Equals(userId))
{
throw new NotAllowedException();
}
return(query);
}
}
public void DeleteExperience(Guid id, Guid userId)
{
using (var ctx = new PlatineContext())
{
var query = ctx.Experiences.SingleOrDefault(e => e.Id.Equals(id));
if (query == null)
{
throw new MissingException("Experience");
}
if (!query.UserId.Equals(userId))
{
throw new NotAllowedException();
}
ctx.Experiences.Remove(query);
ctx.SaveChanges();
}
}
public Tuple <Guid, string> Login(string login, string password)
{
//return new Tuple<Guid, string>(new Guid(), "momo");
using (var ctx = new PlatineContext())
{
var query = ctx.Users.SingleOrDefault(u => u.Login.Equals(login));
if (query == null)
{
throw new LoginIncorrect();
}
if (!query.Password.Equals(password))
{
throw new PasswordIncorrect();
}
return(new Tuple <Guid, string>(query.Id, query.Login));
};
}
