public UserModel Add(string id, string profileImageUrl, string screenName, string token, string OAuthToken)
{
var newUser = null as UserModel;
var dbContext = new MeleeMeEntities();
using (dbContext)
{
var mUser = dbContext.m_User.FirstOrDefault(mu => mu.TwitterUserId == id);
if (mUser != null)
{
var um = new UserModel
{
TwitterUserId = id,
UserId = mUser.UserId,
ImageUrl = profileImageUrl,
AccessToken = mUser.m_Credentials.Select(at => at.AccessToken).ToString(),
Stats = MeleeRepository.GetMeleeStats(id, UserType.Challenger),
Connections = new ConnectionRepository().Get(mUser.UserId)
};
mUser.ProfileImageUrl = profileImageUrl;
mUser.ScreenName = screenName;
dbContext.SaveChanges();
return(um);
}
var u = new m_User
{
TwitterUserId = id,
ProfileImageUrl = profileImageUrl,
ScreenName = screenName
};
dbContext.m_User.Add(u);
AddUserCredentials(dbContext, u, token);
AddConnection(dbContext, u, token, OAuthToken);
newUser = new UserModel
{
TwitterUserId = id,
ImageUrl = profileImageUrl,
ScreenName = screenName,
AccessToken = token,
UserId = u.UserId,
Stats = new MeleeStatisticsModel()
};
dbContext.SaveChanges();
newUser.Connections = new ConnectionRepository().Get(u.UserId);
}
return(newUser);
}
public bool Delete(int userId, int id)
{
var dbContext = new MeleeMeEntities();
using (dbContext)
{
var userConn =
(from uc in dbContext.m_UserConnections
where uc.UserId == userId && uc.ConnectionId == id
select uc).FirstOrDefault();
dbContext.m_UserConnections.Remove(userConn);
dbContext.SaveChanges();
}
return(true);
}
public void Add(string currentUser, string opponent, string winner, string loser)
{
var dbContext = new MeleeMeEntities();
using (dbContext)
{
var m = new m_Melee
{
challenger = currentUser,
opponent = opponent,
timestamp = DateTime.Now
};
dbContext.m_Melee.Add(m);
AddMeleeStatistics(dbContext, m, winner, loser);
dbContext.SaveChanges();
}
}
public ConnectionModel Add(int userId, string connectionName, string accessToken, string refreshToken)
{
var dbContext = new MeleeMeEntities();
using (dbContext)
{
try
{
var conn = (from cx in dbContext.m_Connections
where cx.ConnectionName == connectionName
select cx).FirstOrDefault();
var c = new m_UserConnections()
{
UserId = userId,
ConnectionId = conn.ConnectionId,
AccessToken = accessToken,
RefreshToken = refreshToken
};
var cm = new ConnectionModel
{
ConnectionName = connectionName,
ConnectionId = conn.ConnectionId,
AccessToken = accessToken,
RefreshToken = refreshToken,
ConnectionProvider = LoadConnectionProvider(connectionName + "Connection")
};
dbContext.m_UserConnections.Add(c);
dbContext.SaveChanges();
return(cm);
}
catch (Exception ex)
{
var msg = ex.ToString();
}
}
return(null);
}