public static void UserAgreeToBet(int BetId, int UserIdWhoCreated, int UserIdWhoAccepted, bool IsTeamBet)
{
using (SqlContextDataContext con = new SqlContextDataContext())
{
tblLinkUsersToBet NewBetAcceptor = new tblLinkUsersToBet
{
fkUserWhoCreatedId = UserIdWhoCreated,
fkUserWhoAccepted = UserIdWhoAccepted,
fkBetId = BetId,
datDateTimeAccepted = DateTime.Now,
blnIsTeamBet = IsTeamBet
};
con.tblLinkUsersToBets.InsertOnSubmit(NewBetAcceptor);
con.SubmitChanges();
if (IsTeamBet)
{
tblTeamBet TeamBet = con.tblTeamBets.Single(x => x.pkBetId == BetId);
TeamBet.blnBetIsOpened = false;
con.SubmitChanges();
}
else
{
tblPlayerBet PlayerBet = con.tblPlayerBets.Single(x => x.pkBetId == BetId);
PlayerBet.blnBetIsOpened = false;
con.SubmitChanges();
}
}
}
protected void btnUploadAvatar_Click(object sender, EventArgs e)
{
HttpPostedFile Avatar = filUploadAvatar.PostedFile;
string FileName = Path.GetFileName(filUploadAvatar.PostedFile.FileName);
string FileExtension = Path.GetExtension(FileName);
int FileSize = Avatar.ContentLength;
if (FileExtension == ".jpg" || FileExtension == ".gif" ||
FileExtension == ".png" || FileExtension == ".bmp")
{
Stream s = Avatar.InputStream;
BinaryReader rdr = new BinaryReader(s);
byte[] ImageBytes = rdr.ReadBytes((int)s.Length);
using (SqlContextDataContext con = new SqlContextDataContext())
{
tblUser User = con.tblUsers.Single(x => x.pkUserId == (int)Session["UserId"]);
User.bytUserImage = ImageBytes;
con.SubmitChanges();
}
GetUserAvatar((int)Session["UserId"]);
}
}
public static void InsertDefaultAvatar(int UserId)
{
FileStream fs = new FileStream(System.Web.HttpContext.Current.Server.MapPath("Icons\\default-avatar.jpg"), FileMode.Open);
using (fs)
{
using (BinaryReader binaryReader = new BinaryReader(fs))
{
Byte[] bytes = binaryReader.ReadBytes((int)fs.Length);
try
{
using (SqlContextDataContext con = new SqlContextDataContext())
{
tblUser user = con.tblUsers.First(x => x.pkUserId == UserId);
user.bytUserImage = bytes;
con.SubmitChanges();
}
}
catch (Exception err)
{
throw new ApplicationException(err.Message);
}
}
}
}
public static IEnumerable <object> GetPopularPlayers()
{
SqlContextDataContext con = new SqlContextDataContext();
IEnumerable <object> PopularPlayerBets = from b in con.tblPlayerBets
join
t in con.tblNflPlayers on b.strPlayerName equals t.strPlayerName
group b by new
{
PlayerName = t.strPlayerName,
PlayerImage = t.strPlayerImage,
PlayerTeam = t.fkPlayerTeam
} into eGroup
orderby eGroup.Key.PlayerName.Count() descending
select new
{
PlayerCount = eGroup.Key.PlayerName.Count(),
Player = HttpContext.Current.Server.UrlEncode(eGroup.Key.PlayerName),
PlayerName = eGroup.Key.PlayerName,
PlayerImage = eGroup.Key.PlayerImage,
PlayerTeam = eGroup.Key.PlayerTeam
};
return(PopularPlayerBets.Take(20));
}
protected void btnReply_Click(object sender, EventArgs e)
{
using (SqlContextDataContext con = new SqlContextDataContext())
{
tblChildBulletinBoard Child = new tblChildBulletinBoard()
{
intBoardCreatorUserId = (int)Session["UserId"],
datDateTimeCreated = DateTime.Now,
intNumOfLikes = 0,
intParentBoardId = Convert.ToInt32(Request.QueryString["BulletinId"]),
strBoardMessage = txtReplyBulletin.Text.Trim()
};
con.tblChildBulletinBoards.InsertOnSubmit(Child);
con.SubmitChanges();
}
ViewState["BulletinWasPosted"] = true;
int BetId = Convert.ToInt32(Request.QueryString["BetId"]);
bool IsTeamBet = Request.QueryString["Type"] == null ? true : false;
if (IsTeamBet)
{
Response.Redirect("ViewBet.aspx?BetId=" + BetId.ToString());
}
else
{
Response.Redirect("ViewBet.aspx?Type=PlayerBet&BetId=" + BetId.ToString());
}
}
private void GetRecentlyCreatedBets()
{
using (SqlContextDataContext con = new SqlContextDataContext())
{
IEnumerable <object> Bets = con.tblPlayerBets.Select(x => new
{
Id = x.pkBetId,
Name = x.strPlayerName,
StatArgument = x.fkStatType,
LogicArgument = x.strLogicArgument,
ValueArgument = x.decArgumentValue,
WeekNumber = x.intWeekNumber,
PlayerOrTeamBet = "PlayerBet",
Wager = x.decMoneyWager,
}).Concat(con.tblTeamBets.Select(x => new
{
Id = x.pkBetId,
Name = x.strTeam,
StatArgument = x.fkStatType,
LogicArgument = x.strLogicArgument,
ValueArgument = x.decArgumentValue,
WeekNumber = x.intWeekNumber,
PlayerOrTeamBet = "TeamBet",
Wager = x.decMoneyWager,
})).OrderByDescending(x => x.Id).Take(10);
gvRecentlyCreatedBets.DataSource = Bets;
gvRecentlyCreatedBets.DataBind();
}
}
private bool IsBetOpen(bool IsTeamBet, int BetId)
{
SqlContextDataContext context = new SqlContextDataContext();
bool IsOpen = true;
if (IsTeamBet)
{
var IsTeamBetOpen = context.tblTeamBets.Where(x => x.pkBetId == BetId)
.Select(n => new { n.blnBetIsOpened });
foreach (var r in IsTeamBetOpen)
{
IsOpen = r.blnBetIsOpened;
}
}
else
{
var IsPlayerBetOpen = context.tblPlayerBets.Where(x => x.pkBetId == BetId)
.Select(n => new { n.blnBetIsOpened });
foreach (var r in IsPlayerBetOpen)
{
IsOpen = r.blnBetIsOpened;
}
}
return(IsOpen);
}
private void GetTeamBet(int BetId)
{
using (SqlContextDataContext con = new SqlContextDataContext())
{
var TeamBets = con.tblTeamBets.Join
(con.tblNflTeams, b => b.strTeam, t => t.strTeamName, (bets, teams) => new
{
Bets = bets,
Teams = teams
}).Where(x => x.Bets.pkBetId == BetId);
fvTeamBet.DataSource = TeamBets;
fvTeamBet.DataBind();
foreach (var r in TeamBets)
{
Session["UserIdWhoCreated"] = r.Bets.fkCreatorUserId;
}
if (Session["UserId"] != null)
{
if ((int)Session["UserId"] == (int)Session["UserIdWhoCreated"])
{
btnAcceptToBet.Enabled = false;
btnAcceptToBet.Attributes.CssStyle.Add("opacity", ".5");
btnAcceptToBet.ToolTip = "Bet IWas Made By You";
}
}
}
}
public void LoadTreeView()
{
SqlContextDataContext con = new SqlContextDataContext();
var result = con.tblUserTreeViewItems.
GroupJoin(con.tblUserTreeViewItems, p =>
p.ID, c => c.ParentId, (parent, child) => new
{
Parent = parent,
Child = child
});
foreach (var Parentt in result)
{
TreeNode node = new TreeNode()
{
Text = Parentt.Parent.TreeViewText
};
foreach (var Child in Parentt.Child)
{
node.ChildNodes.Add(new TreeNode()
{
Text = Child.TreeViewText
});
}
}
}
protected void btnCreateTeamBet_Click(object sender, EventArgs e)
{
if (Session["UserId"] != null)
{
if (rdoTypeOfBet.SelectedIndex == 0)
{
this.Page.Validate("TeamBet");
if (this.Page.IsValid)
{
using (SqlContextDataContext con = new SqlContextDataContext())
{
tblTeamBet NewBet = new tblTeamBet
{
fkCreatorUserId = (int)Session["UserId"],
intWeekNumber = ddlWeekNumber.SelectedIndex,
strTeam = ddlTeams.SelectedItem.Text,
fkStatType = ddlTeamArguments.SelectedItem.Text,
strLogicArgument = ddlTeamLogic.SelectedItem.Text,
decArgumentValue = Convert.ToDecimal(txtTeamArgumentValue.Text),
datDateTimeCreated = DateTime.Now,
decMoneyWager = Convert.ToDecimal(txtTeamWagerAmount.Text.Trim()),
blnBetIsOpened = true
};
con.tblTeamBets.InsertOnSubmit(NewBet);
con.SubmitChanges();
}
pnlBetCreationIsSuccessful.Visible = true;
}
}
}
}
public static bool IsBetOpen(int BetId, bool IsTeamBet)
{
bool IsBetOpen = false;
using (SqlContextDataContext con = new SqlContextDataContext())
{
if (IsTeamBet)
{
var IsOpen = con.tblTeamBets.Where(x => x.pkBetId == BetId)
.Select(y => y.blnBetIsOpened);
foreach (var r in IsOpen)
{
IsBetOpen = Convert.ToBoolean(r);
}
}
else
{
var IsOpen = con.tblPlayerBets.Where(x => x.pkBetId == BetId)
.Select(y => y.blnBetIsOpened);
foreach (var r in IsOpen)
{
IsBetOpen = Convert.ToBoolean(r);
}
}
}
return(IsBetOpen);
}
public static bool UserBetApprovals(int BetId, int UserId)
{
bool IsAlreadyApproved = false;
using (SqlContextDataContext con = new SqlContextDataContext())
{
int ApprovalCount = con.tblBetApprovals.Where(x => x.fkUserIdWhoApproved == UserId).Count();
if (ApprovalCount == 0)
{
tblBetApproval NewBetApproval = new tblBetApproval()
{
fkBetId = BetId,
fkUserIdWhoApproved = UserId
};
con.tblBetApprovals.InsertOnSubmit(NewBetApproval);
con.SubmitChanges();
}
else
{
IsAlreadyApproved = true;
}
}
return(IsAlreadyApproved);
}
public int PageViews(string RawUrl)
{
SqlContextDataContext con = new SqlContextDataContext();
int count = con.tblStatsPageVisits.Where(w => w.strBaseUrlVisited == RawUrl).Count();
return(count);
}
protected void btnLogin_Click(object sender, EventArgs e)
{
this.Page.Validate();
if (this.Page.IsValid)
{
string UserName = txtUserName.Text.Trim();
string PassWord = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassWord.Text.Trim(), "SHA1");
using (SqlContextDataContext context = new SqlContextDataContext())
{
int UserId = context.tblUsers.Where(x => x.strUserName == UserName && x.strPassword == PassWord).Select(x => x.pkUserId).SingleOrDefault();
bool IsAuthenticated = UserId != 0 ? true : false;
if (IsAuthenticated)
{
Session["UserId"] = UserId;
pnlLoginIsSuccessful.Visible = true;
pnlLoginIsNotSuccessful.Visible = false;
if (chkRememberMe.Checked)
{
HttpCookie cookie = new HttpCookie("LogInCookie");
cookie["UserName"] = txtUserName.Text;
cookie["PassWord"] = txtPassWord.Text;
cookie.Expires = DateTime.Now.AddDays(30);
HttpContext.Current.Response.SetCookie(cookie);
}
else
{
if (HttpContext.Current.Request.Cookies["LogInCookie"] != null)
{
HttpCookie currentUserCookie = HttpContext.Current.Request.Cookies["LogInCookie"];
HttpContext.Current.Response.Cookies.Remove("LogInCookie");
currentUserCookie.Expires = DateTime.Now.AddDays(-10);
HttpContext.Current.Response.SetCookie(currentUserCookie);
}
}
Response.Redirect("MyProfile.aspx", true);
}
else
{
pnlLoginIsNotSuccessful.Visible = true;
lblStatus.Text = "Invalid UserName/PassWord";
lblStatus.ForeColor = System.Drawing.Color.Red;
pnlLoginIsSuccessful.Visible = false;
pnlLoginIsNotSuccessful.Visible = true;
}
}
}
}
protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
SelectedDatesCollection DateTimes = Calendar1.SelectedDates;
using (SqlContextDataContext context = new SqlContextDataContext())
{
if (DateTimes.Count > 1)
{
var schedule = from x in context.tblNflSchedules
join tt in context.tblNflTeams on x.fkHomeTeam equals tt.strTeamName
join t in context.tblNflTeams on x.fkVisitorTeam equals t.strTeamName
where x.datDateOfGame >= DateTimes[0] && x.datDateOfGame <= DateTimes[6]
select new
{
GameId = x.NflGameId,
HomeTeam = x.fkHomeTeam,
VisitorTeam = x.fkVisitorTeam,
DateOfGame = x.datDateOfGame,
WeekNumber = x.intWeekNumber,
IsBuy = x.blnIsBuy,
HomeImage = tt.strTeamImage,
VisitorImage = t.strTeamImage,
Date = x.datDateOfGame
};
gvNflSchedule.DataSource = schedule;
gvNflSchedule.DataBind();
}
else
{
var Schedule = from x in context.tblNflSchedules
join tt in context.tblNflTeams on x.fkHomeTeam equals tt.strTeamName
join t in context.tblNflTeams on x.fkVisitorTeam equals t.strTeamName
where x.datDateOfGame == DateTimes[0]
select new
{
GameId = x.NflGameId,
HomeTeam = x.fkHomeTeam,
VisitorTeam = x.fkVisitorTeam,
DateOfGame = x.datDateOfGame,
WeekNumber = x.intWeekNumber,
IsBuy = x.blnIsBuy,
HomeImage = tt.strTeamImage,
VisitorImage = t.strTeamImage,
Date = x.datDateOfGame
};
gvNflSchedule.DataSource = Schedule;
gvNflSchedule.DataBind();
}
}
}
public static IEnumerable <tblTeamBet> GetTeamBetForWinOrLost(int BetId)
{
SqlContextDataContext con = new SqlContextDataContext();
IEnumerable <tblTeamBet> TeamBet = con.tblTeamBets.AsEnumerable().Where(b => b.pkBetId == BetId);
con.Dispose();
return(TeamBet);
}
private void GetMyStats(int UserId)
{
using (SqlContextDataContext context = new SqlContextDataContext())
{
IEnumerable <tblUsersBettingStatistic> stats = from u in context.tblUsersBettingStatistics where u.fkUserId == UserId
select u;
fvMyStats.DataSource = stats;
fvMyStats.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserId"] != null)
{
if (Request.UrlReferrer.ToString() == "http://localhost:32550/Login.aspx")
{
pnlUserLoggedIn.Visible = true;
}
else
{
pnlUserLoggedIn.Visible = false;
}
int UserId = Convert.ToInt32(Session["UserId"]);
if (!this.Page.IsPostBack)
{
// UsersBets.GetBetWinPercentages(UserId, gvMyBetHistory);
LoadTreeView();
foreach (Panel pnl in PagePanels)
{
if (pnl.ID != "pnlMyBets")
{
pnl.Visible = false;
}
}
UserInfo ui = new UserInfo();
// Control[] arrControl = { gvMyCreatedBets, gvMyAcceptedBets };
GetMyCreatedBets(UserId, 1);
ui.UserId = UserId;
// ui.PopulateControlWithUserTeamBets(arrControl);
GetBetPredictions();
GetUserBetHistory(UserId);
GetMyAcceptedBets(UserId);
GetBetHistory(UserId);
GetUserAvatar((int)Session["UserId"]);
GetMyStats((int)Session["UserId"]);
}
else
{
}
SqlContextDataContext db = new SqlContextDataContext();
fvPaymentInformation.DataSource = from t in db.tblUsersPaymentInformations
where t.fkUserId == UserId
select t;
fvPaymentInformation.DataBind();
}
}
private void GetBetPredictions()
{
using (SqlContextDataContext con = new SqlContextDataContext())
{
gvMyPredictions.DataSource = from t in con.tblTeamBets
where
t.fkCreatorUserId == (int)Session["UserId"] && t.decMoneyWager == null
select t;
gvMyPredictions.DataBind();
}
}
protected void btnRegister_Click(object sender, EventArgs e)
{
Page.Validate();
if (this.Page.IsValid)
{
using (SqlContextDataContext context = new SqlContextDataContext())
{
string UserName = txtUserName.Text.Trim();
string UserEmail = txtUserEmail.Text.Trim();
int UserNameCount = context.tblUsers.Where(x => x.strUserName == UserName).Count();
int UserEmailCount = context.tblUsers.Where(x => x.strEmail == UserEmail).Count();
if (UserNameCount == 0 && UserEmailCount == 0)
{
int UserId = 0;
tblUser NewUser = new tblUser
{
datDateRegistered = DateTime.Now,
strEmail = txtUserEmail.Text.Trim(),
strPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassWord.Text.Trim(), "SHA1"),
strUserName = txtUserName.Text.Trim(),
};
context.tblUsers.InsertOnSubmit(NewUser);
context.SubmitChanges();
UserId += NewUser.pkUserId;
lblRegisterSuccessful.Text = "Registered Successfully!";
lblRegisterSuccessful.ForeColor = System.Drawing.Color.Green;
pnlRegisterIsSuccessful.Visible = true;
pnlRegisterIsNotSuccessful.Visible = false;
UserInfo.InsertDefaultAvatar(UserId);
}
else if (UserNameCount == 1)
{
lblStatus.Text = "User Name Already In User";
lblStatus.ForeColor = System.Drawing.Color.Red;
pnlRegisterIsNotSuccessful.Visible = true;
}
else
{
lblStatus.Text = "User Email Already In User";
lblStatus.ForeColor = System.Drawing.Color.Red;
pnlRegisterIsNotSuccessful.Visible = true;
}
}
}
}
protected void fvPaymentInformation_ModeChanging(object sender, FormViewModeEventArgs e)
{
(sender as FormView).ChangeMode(e.NewMode);
SqlContextDataContext db = new SqlContextDataContext();
fvPaymentInformation.DataSource = from t in db.tblUsersPaymentInformations
where t.fkUserId == (int)Session["UserId"]
select t;
fvPaymentInformation.DataBind();
}
private bool IsAgreed(int UserId, int BetId, bool IsTeamBet)
{
using (SqlContextDataContext con = new SqlContextDataContext())
{
int r = con.tblBetApprovals.Where(
x => x.blnIsTeamBet == IsTeamBet &&
x.fkBetId == BetId &&
x.fkUserIdWhoApproved == UserId).Count();
return(Convert.ToBoolean(r));
}
}
private void InsertUserFavoriteNflTeam(int UserId, int FavoriteTeamId)
{
using (SqlContextDataContext context = new SqlContextDataContext())
{
tblUsersFavoriteNflTeam NewUsersFavoriteTeam = new tblUsersFavoriteNflTeam
{
fkSportsTeam = FavoriteTeamId,
fkUserId = UserId
};
context.tblUsersFavoriteNflTeams.InsertOnSubmit(NewUsersFavoriteTeam);
context.SubmitChanges();
}
}
protected void gvMyCreatedBets_RowCommand(object sender, GridViewCommandEventArgs e)
{
int RowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
string TeamOrPlayer = e.CommandArgument.ToString();
GridView gv = (GridView)sender;
int BetId = Convert.ToInt32(((Label)gv.Rows[RowIndex].FindControl("lblBetId")).Text);
if (e.CommandName == "CancelBet")
{
using (SqlContextDataContext context = new SqlContextDataContext())
{
if (TeamOrPlayer == "TeamBet")
{
tblTeamBet TeamBet = context.tblTeamBets.SingleOrDefault(x => x.pkBetId == BetId);
context.tblTeamBets.DeleteOnSubmit(TeamBet);
context.SubmitChanges();
int TeamLinkCount = context.tblLinkUsersToBets.Count(x => x.fkBetId == BetId && x.blnIsTeamBet == true);
if (TeamLinkCount != 0)
{
tblLinkUsersToBet DeleteBet = context.tblLinkUsersToBets.SingleOrDefault(x => x.fkBetId == BetId && x.blnIsTeamBet == true);
context.tblLinkUsersToBets.DeleteOnSubmit(DeleteBet);
context.SubmitChanges();
}
}
else
{
tblPlayerBet PlayerBet = context.tblPlayerBets.SingleOrDefault(x => x.pkBetId == BetId);
context.tblPlayerBets.DeleteOnSubmit(PlayerBet);
context.SubmitChanges();
int PlayerLinkCount = context.tblLinkUsersToBets.Count(x => x.fkBetId == BetId && x.blnIsTeamBet == false);
if (PlayerLinkCount != 0)
{
tblLinkUsersToBet DeleteBet = context.tblLinkUsersToBets.SingleOrDefault(x => x.fkBetId == BetId && x.blnIsTeamBet == false);
context.tblLinkUsersToBets.DeleteOnSubmit(DeleteBet);
context.SubmitChanges();
}
}
}
GetMyCreatedBets((int)Session["UserId"], 1);
}
else if (e.CommandName == "SendBetEmail")
{
}
}
protected void btnSendBetEmail_Click(object sender, EventArgs e)
{
int BetId = Convert.ToInt32(Request.QueryString["BetId"]);
if (Request.QueryString["BetId"] != null)
{
if (Session["UserId"] != null)
{
GetModal("ModalSendBetEmail");
if (Request.QueryString["Type"] != null && Request.QueryString["Type"] == "PlayerBet")
{
using (SqlContextDataContext con = new SqlContextDataContext())
{
var PlayerBets = con.tblPlayerBets.Join
(con.tblNflPlayers, p => p.strPlayerName, t => t.strPlayerName, (bets, players) => new
{
Bets = bets,
Players = players
}).Where(x => x.Bets.pkBetId == BetId);
fvPlayerBetEmail.DataSource = PlayerBets;
fvPlayerBetEmail.DataBind();
}
}
else
{
SqlContextDataContext con = new SqlContextDataContext();
var TeamBets = con.tblTeamBets.Join
(con.tblNflTeams, b => b.strTeam, t => t.strTeamName, (bets, teams) => new
{
Bets = bets,
Teams = teams
});
fvBetEmail.DataSource = TeamBets;
fvBetEmail.DataBind();
}
}
else
{
pnlMustBeLoggedId.Visible = true;
ViewState["MustBeLoggedIn"] = true;
}
}
}
private void GetReplyData()
{
int BoardId;
if (int.TryParse(Request.QueryString["BulletinId"], out BoardId))
{
SqlContextDataContext con = new SqlContextDataContext();
StringBuilder s = new StringBuilder();
foreach (tblParentBulletinBoard pb in con.tblParentBulletinBoards.Where(x => x.intParentBoardId == BoardId))
{
var UserNameAndImage = from t in con.tblUsers
join u in con.tblUsersBettingStatistics on t.pkUserId equals u.fkUserId
where t.pkUserId == pb.intUserIdWhoPostedBoard
select new
{
UserName = t.strUserName,
UserImage = t.bytUserImage,
WinPerc = u.fltOverallWinningPercentage,
};
foreach (var v in UserNameAndImage)
{
s.Append("Posted By" + v.UserName);
s.Append("<br />");
s.Append("<img src=\"data:Image/png;base64," + Convert.ToBase64String((byte[])v.UserImage.ToArray()) + "\" class=\"img-circle\" width=\"50\" height=\"50\" />");
if (v.WinPerc > .75)
{
s.Append("Win Perc=<span style=\"color:green;\">" + v.WinPerc.ToString() + "</span>");
}
else if (v.WinPerc < .25)
{
s.Append("Win Perc=<span style=\"color:green;\">" + v.WinPerc.ToString() + "</span>");
}
}
s.Append("@ " + pb.datDateTimeCreated.Value.ToShortDateString());
s.Append("<br />");
s.Append(pb.strBoardMessage);
litReply.Text = s.ToString();
}
}
}
private void GetUserAvatar(int UserId)
{
SqlContextDataContext con = new SqlContextDataContext();
var Image = from user in con.tblUsers
where user.pkUserId == UserId
select new
{
UserImage = user.bytUserImage
};
foreach (var img in Image)
{
imgAvatar.ImageUrl = "data:Image/png;base64," + Convert.ToBase64String((byte[])img.UserImage.ToArray());
}
}
private void GetBetHistory(int UserId)
{
using (SqlContextDataContext context = new SqlContextDataContext())
{
IEnumerable <int> BetIdsIsTeam = from t in context.tblBetHistories
where (t.fkUserIdLoser == UserId ||
t.fkUserIdWinner == UserId) && t.IsTeamBet == true
select t.fkBetId;
IEnumerable <int> BetIdsForPlayerBets = from t in context.tblBetHistories
where (t.fkUserIdLoser == UserId ||
t.fkUserIdWinner == UserId) && t.IsTeamBet == false
select t.fkBetId;
IEnumerable <object> MyBetHistory = context.tblTeamBets.Select(x =>
new
{
BetId = x.pkBetId,
Name = x.strTeam,
StatArgument = x.fkStatType,
LogicArgument = x.strLogicArgument,
ValueArgument = x.decArgumentValue,
WeekNumber = x.intWeekNumber,
PlayerOrTeamBet = "TeamBet",
UserId = x.fkCreatorUserId,
Wager = x.decMoneyWager
}).Where(x => BetIdsIsTeam.Contains(x.BetId))
.Union(context.tblPlayerBets.Select(x => new
{
BetId = x.pkBetId,
Name = x.strPlayerName,
StatArgument = x.fkStatType,
LogicArgument = x.strLogicArgument,
ValueArgument = x.decArgumentValue,
WeekNumber = x.intWeekNumber,
PlayerOrTeamBet = "PlayerBet",
UserId = x.fkCreatorUserId,
Wager = x.decMoneyWager
}).Where(x => BetIdsForPlayerBets.Contains(x.BetId)));
gvMyBetHistory.DataSource = MyBetHistory;
gvMyBetHistory.DataBind();
}
}
private void SelectMostViewedBets()
{
SqlContextDataContext con = new SqlContextDataContext();
using (con)
{
var r = con.tblTeamBets.GroupJoin(con.tblStatsPageVisits,
b => b.pkBetId, v => v.strQueryStringValue, (bets, visits) => new
{
Bets = bets,
Count = visits.Count()
}).OrderByDescending(y => y.Count).Take(10);
// lvMostViewedTeamBets.DataSource = r;
// lvMostViewedTeamBets.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (SqlContextDataContext con = new SqlContextDataContext())
{
var r = from t in con.tblBetHistories
group t by
new
{
t.fkUserIdWinner
} into eGroup
select eGroup.Key;
lvWeeklyWinners.DataSource = r;
this.Page.DataBind();
}
}
