public IEnumerable<DiciplineWrapper> GetDiciplinesByUserId(Guid user)
{
DiciplineTableAdapter ta=new DiciplineTableAdapter();
DBDataSet.DiciplineDataTable tbl = ta.GetDataByUserId(user);
return tbl.Select(row => new DiciplineWrapper(){Name = row.Name,DiciplineId = row.DiciplineId});
}
public IEnumerable<DiciplineWrapper> GetDiciplines()
{
DiciplineTableAdapter adapter = new DiciplineTableAdapter();
DBDataSet.DiciplineDataTable tbl = adapter.GetData();
return tbl.Select(d => new DiciplineWrapper(){DiciplineId = d.DiciplineId,Name = d.Name});
}
public void UpdateUser(UserWrapper user)
{
UserTableAdapter adapter=new UserTableAdapter();
adapter.Update(user.UserID, user.FirstName, user.LastName, user.BirthDate, user.Role,
user.UserName, user.Password);
DiciplineTableAdapter da = new DiciplineTableAdapter();
foreach (var diciplineWrapper in user.Dicipline)
{
da.InsertInterest(user.UserID, diciplineWrapper.DiciplineId);
}
SubscriptionTableAdapter sa = new SubscriptionTableAdapter();
foreach (var subWrapper in user.Subscriptions)
{
sa.Insert(subWrapper.UnitCode, subWrapper.UserId);
}
}
public void AddUser(UserWrapper user)
{
UserTableAdapter adapter=new UserTableAdapter();
adapter.Insert(user.FirstName, user.LastName, user.BirthDate, user.Role, user.UserName, user.Password,
user.Salt);
DBDataSet.UserDataTable res = adapter.GetData(user.UserName);
DiciplineTableAdapter da=new DiciplineTableAdapter();
foreach (var diciplineWrapper in user.Dicipline)
{
da.InsertInterest(res.FirstOrDefault().UserID, diciplineWrapper.DiciplineId);
}
SubscriptionTableAdapter sa=new SubscriptionTableAdapter();
foreach (var subWrapper in user.Subscriptions)
{
sa.Insert(subWrapper.UnitCode, subWrapper.UserId);
}
}
public DiciplineWrapper GetDicipline(string unitCode)
{
DiciplineTableAdapter adapter = new DiciplineTableAdapter();
DBDataSet.DiciplineDataTable tbl = adapter.GetDataById(unitCode);
return tbl.Select(d => new DiciplineWrapper() { DiciplineId = d.DiciplineId, Name = d.Name }).FirstOrDefault();
}