public static int AddUsrOptions(string user, int week, string gameKey, string gamePick)
{
NFLUsrPicks data = new NFLUsrPicks
{
UserID = user,
Week = week,
GameKey = gameKey,
GamePick = gamePick
};
string sql = @"INSERT INTO dbo.usrPicks (UserID, Week, GameKey, GamePick)
VALUES (@UserID, @Week, @GameKey, @GamePick);";
return(SqlDataAccess.SaveData(sql, data));
}
public static int PopulateUsrPicks(string userID, int week, string gameKey, string gamePick)
{
NFLUsrPicks data = new NFLUsrPicks
{
UserID = userID,
Week = week,
GameKey = gameKey,
GamePick = gamePick
};
string sql = @"IF EXISTS (SELECT * FROM dbo.usrPicks WHERE GameKey = @GameKey AND UserID = @UserID)
BEGIN
UPDATE dbo.usrPicks SET UserID = @UserID, Week = @Week, GameKey = @GameKey, GamePick = @GamePick
WHERE GameKey = @GameKey AND UserID = @UserID;
END
ELSE
BEGIN
INSERT INTO dbo.usrPicks (UserID, Week, GameKey, GamePick)
VALUES(@UserID, @Week, @GameKey, @GamePick);
END";
return(SqlDataAccess.SaveData(sql, data));
}
