public int AddHobbytoUser(Hobby hobby, User user)
{
var sorgu = _db.Users.Where(x => x.ID == user.ID).FirstOrDefault();
User_Hobby uh = new User_Hobby();
uh.HobbyID = _db.Hobbies.Where(x => x.HobbyName == hobby.HobbyName).Select(x => x.ID).FirstOrDefault();
uh.UserID = user.ID;
uh.IsDelete = false;
_db.Entry(uh).State = System.Data.Entity.EntityState.Added;
_db.SaveChanges();
var sorguUpperID = (from h in _db.Hobbies
where h.HobbyName == hobby.HobbyName
select h.UpperID).FirstOrDefault();
if (sorguUpperID != null)
{
User_Hobby uh2 = new User_Hobby();
uh2.HobbyID = _db.Hobbies.Where(x => x.ID == sorguUpperID).Select(x => x.ID).FirstOrDefault();
uh2.UserID = user.ID;
uh2.IsDelete = false;
_db.Entry(uh2).State = System.Data.Entity.EntityState.Added;
}
return(_db.SaveChanges());
}
public int AddMainHobbytoUser(Hobby hobby, User user)
{
var sorgu = _db.Users.Where(x => x.ID == user.ID).FirstOrDefault();
User_Hobby uh = new User_Hobby();
uh.HobbyID = _db.Hobbies.Where(x => x.HobbyName == hobby.HobbyName).Select(x => x.ID).FirstOrDefault();
uh.UserID = user.ID;
uh.IsDelete = false;
_db.Entry(uh).State = System.Data.Entity.EntityState.Added;
return(_db.SaveChanges());
}
