public int[] takeListInterest(UserInterest usr, int userId)
{
using (var dbContext = new LinqClassesDataContext())
{
int[] list_interest = dbContext.UserInterests
.Where(v => v.userID == userId)
.Select(v => v.interestID).ToArray();
return(list_interest);
}
}
public void LoadInterestId(UserInterest intr, int id)
{
using (var dbContext = new LinqClassesDataContext())
{
var table = from t in dbContext.UserInterests
where t.userID == id
select t;
intr.Id = table.Single().Id;
intr.interestID = table.Single().interestID;
intr.userID = table.Single().userID;
}
}
/* public void AddInterest(User_info info, List<int> interestid)
* {
* UserInterest u = new UserInterest();
*
*
* foreach (int x in interestid)
* {
* using (var dbContext = new LinqClassesDataContext())
* {
*
* u.interestID = x;
* u.userID = info.Id;
*
* dbContext.UserInterests.InsertOnSubmit(u);
* dbContext.SubmitChanges();
* }
* }
*
* }*/
public void AddInterest(User_info info, int interestid)
{
UserInterest u = new UserInterest();
using (var dbContext = new LinqClassesDataContext())
{
u.interestID = interestid;
u.userID = info.Id;
dbContext.UserInterests.InsertOnSubmit(u);
dbContext.SubmitChanges();
}
}
private void detach_UserInterests(UserInterest entity)
{
this.SendPropertyChanging();
entity.Interest = null;
}
private void attach_UserInterests(UserInterest entity)
{
this.SendPropertyChanging();
entity.Interest = this;
}
partial void DeleteUserInterest(UserInterest instance);
partial void UpdateUserInterest(UserInterest instance);
partial void InsertUserInterest(UserInterest instance);
