public HttpResponseMessage UnsubscribeChannels(string sessionKey)
{
var rep = new DbChannelRepository(db);
int userId = db.Set<User>().Where(u => u.SessionKey == sessionKey).Select(u=>u.UserID).FirstOrDefault();
var result = rep.GetAllUnsubscribeChannels(userId);
List<ChannelModel> all = new List<ChannelModel>();
foreach (var res in result)
{
ChannelModel newChannel = new ChannelModel
{
ChannelName = res.ChannelName,
FirstUserId = res.UserID,
SecondUserId = res.SecondUserID,
FirstUsername = db.Set<User>().Where(u => u.UserID == res.UserID).Select(u => u.Username).FirstOrDefault(),
SecondUsername = db.Set<User>().Where(u => u.UserID == res.SecondUserID).Select(u => u.Username).FirstOrDefault(),
};
all.Add(newChannel);
}
var responseMsg = Request.CreateResponse(HttpStatusCode.OK, all);
return responseMsg;
}
public HttpResponseMessage UnsubscribeChannels(string sessionKey)
{
var rep = new DbChannelRepository(db);
int userId = db.Set <User>().Where(u => u.SessionKey == sessionKey).Select(u => u.UserID).FirstOrDefault();
var result = rep.GetAllUnsubscribeChannels(userId);
List <ChannelModel> all = new List <ChannelModel>();
foreach (var res in result)
{
ChannelModel newChannel = new ChannelModel
{
ChannelName = res.ChannelName,
FirstUserId = res.UserID,
SecondUserId = res.SecondUserID,
FirstUsername = db.Set <User>().Where(u => u.UserID == res.UserID).Select(u => u.Username).FirstOrDefault(),
SecondUsername = db.Set <User>().Where(u => u.UserID == res.SecondUserID).Select(u => u.Username).FirstOrDefault(),
};
all.Add(newChannel);
}
var responseMsg = Request.CreateResponse(HttpStatusCode.OK, all);
return(responseMsg);
}
