public void AddScore(Score score)
{
Database db = DatabaseFactory.CreateDatabase("cnGrammit");
score.ID = Convert.ToInt32(db.ExecuteScalar("dbo.usp_Z_Score_addScore", new Guid(score.UserId), this.ID, score.RatingRaw, score.Text, score.IsPro));
List<Score> list = (score.IsPro) ? this.Pros : this.Cons;
//remove placeholder
if (list.Count == 1 && list[0].RatingRaw == 0)
list.RemoveAt(0);
list.Add(score);
}
private string AddScore(string username, string userPass, string gameName, string gamePass, int points)
{
User user = users.FirstOrDefault(u => u.Username == username && u.Password == userPass);
Game game = games.FirstOrDefault(g => g.GameName == gameName && g.GamePassword == gamePass);
if (user != null)
{
if (game != null)
{
var score = new Score()
{
User = user,
Game = game,
Points = points
};
this.scores.Add(score);
return "Score added";
}
return "Cannot add score";
}
return "Cannot add score";
}
protected void grdPro_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
//e.Row.Cells[0].CssClass = "score";
//e.Row.Cells[1].CssClass = "score";
//if (sender == this.grdPro)
// e.Row.Cells[1].Text = board.ProTotal.ToString();
//else
// e.Row.Cells[1].Text = board.ProTotal.ToString();
//e.Row.Cells.RemoveAt(1);
}
else if (e.Row.RowType == DataControlRowType.DataRow)
{
int scoreIdx = (sender == grdPro) ? 1 : 2;
int textIdx = (sender == grdPro) ? 2 : 1;
//activates the #board td.score class
e.Row.Cells[scoreIdx].CssClass = "sc";
Score score = e.Row.DataItem as Score;
bool alreadyVoted = (user == null) ? false : score.AlreadyVoted(user.ProviderUserKey.ToString());
HtmlGenericControl btnUp = e.Row.Cells[textIdx].FindControl("btnUp") as HtmlGenericControl;
HtmlGenericControl btnDown = e.Row.Cells[textIdx].FindControl("btnDown") as HtmlGenericControl;
HtmlGenericControl btnCom = e.Row.Cells[textIdx].FindControl("btnCom") as HtmlGenericControl;
//enable the delete button
if (score.Votes != null && score.Votes.Count == 0)
{
user = (user == null) ? Membership.GetUser() : user;
if (user != null && score.UserId == user.ProviderUserKey.ToString())
{
LinkButton deleteBtn = e.Row.Cells[textIdx].FindControl("btnDel") as LinkButton;
deleteBtn.CommandArgument = score.ID.ToString();
deleteBtn.EnableViewState = true;
deleteBtn.Visible = true;
deleteBtn.Text = "delete";
deleteBtn.CssClass = "del";
}
}
string voteFunction = (user == null) ? "$find('mpbSignup').show();" :
(score.RatingRaw == 0) ? "$find('mpeScore').show();" : ("showCom(event," + score.ID.ToString() + ", {0}, this);");
if (alreadyVoted)
{
//format whether comments can be added
btnUp.Attributes.Add("class", "up-ya");
btnDown.Attributes.Add("class", "down-ya");
}
else
{
btnUp.Attributes.Add("onclick", string.Format(voteFunction, "1"));
btnDown.Attributes.Add("onclick", string.Format(voteFunction, "-1"));
}
btnCom.Attributes.Add("onclick", string.Format(voteFunction, "0"));
//Panel comments = e.Row.Cells[0].FindControl("comments") as Panel;
//for (int i = 0; i < score.Votes.Count; i++)
//{
// Vote vote = score.Votes[i];
// HtmlGenericControl comment = new HtmlGenericControl("div");
// comment.Attributes.Add("class", "comment");
// if (vote.Comment == string.Empty)
// if (vote.Weight > 0)
// vote.Comment = "vote +1";
// else if (vote.Weight < 0)
// vote.Comment = "vote -1";
// comment.InnerText = vote.Comment;
// comments.Controls.Add(comment);
//}
}
}
public static ScoreBored Load(string boredName)
{
ScoreBored frankenstein = null;
Database db = DatabaseFactory.CreateDatabase("cnGrammit");
//remove the "_" chars first
using (IDataReader rdr = db.ExecuteReader("[usp_Z_Score_getBoard]", boredName))
{
if (rdr.Read())
{
frankenstein = new ScoreBored()
{
ID = Convert.ToInt32(rdr["ID"]),
UserId = rdr["UserID"].ToString(),
UserName = rdr["UserName"].ToString(),
ConName = rdr["CON_NAME"].ToString(),
Cons = new List<Score>(),
Created = DateTime.Parse(rdr["DT_CREATED"].ToString()),
Description = rdr["DESCRIPTION"].ToString(),
Name = rdr["NAME"].ToString(),
ProName = rdr["PRO_NAME"].ToString(),
Pros = new List<Score>(),
Phrases = new Dictionary<short, string>(),
PhraseIs = Convert.ToBoolean(rdr["IS_PHRASE"])
};
}
else
{
return null;
}
if (rdr.NextResult())
{
while (rdr.Read()){
Score score = new Score(){
Created = DateTime.Parse(rdr["DT_CREATED"].ToString()),
RatingRaw = Convert.ToInt32(rdr["SCORE"]),
Text = rdr["WORDS"].ToString(),
UserId = rdr["UserID"].ToString(),
ID = Convert.ToInt32(rdr["ID"]),
Votes = new List<Vote>(Convert.ToInt32(rdr["VOTES"])),
IsPro = Convert.ToBoolean(rdr["IS_PRO"])
};
if (score.IsPro)
{
frankenstein.Pros.Add(score);
}
else
frankenstein.Cons.Add(score);
}
}
if (rdr.NextResult())
{
while (rdr.Read())
{
frankenstein.Phrases.Add(Convert.ToInt16(rdr["MARGIN"]), rdr["PHRASE"].ToString());
}
}
if (rdr.NextResult())
{
while (rdr.Read())
{
Score parentScore = frankenstein.FindScore(Convert.ToBoolean(rdr["IS_PRO"]), Convert.ToInt32(rdr["SCORE_ID"]));
Vote vote = new Vote()
{
ID = Convert.ToInt32(rdr["ID"]),
Comment = rdr["COMMENT"].ToString(),
UserId = rdr["UserId"].ToString(),
UserName = rdr["UserName"].ToString(),
Weight = Convert.ToInt16(rdr["WEIGHT"]),
Dt = Convert.ToDateTime(rdr["DT_CREATED"]),
Parent = parentScore
};
parentScore.Votes.Add(vote);
}
}
}
if (frankenstein.Pros.Count == 0)
{
frankenstein.Pros.Add(
new Score()
{
ID = 0,
RatingRaw = 0,
Text="Vote to add points"
});
}
if (frankenstein.Cons.Count == 0)
{
frankenstein.Cons.Add(
new Score()
{
ID = 0,
RatingRaw = 0,
Text = "Vote to add points"
});
}
return frankenstein;
}
protected void btnVote_Click(object sender, EventArgs e)
{
if (User.Identity.IsAuthenticated)
{
LoadBored();
Score rating = new Score()
{
Created = DateTime.UtcNow,
RatingRaw = int.Parse(Rating1.CurrentRating.ToString()),
Text = txtEntry.Text,
UserId = Membership.GetUser().ProviderUserKey.ToString(),
Votes = new List<Vote>(1),
IsPro = (sender == btnPro)
};
_board.AddScore(rating);
BindAll();
txtEntry.Text = string.Empty;
upScore.Update();
upBoards.Update();
upComs.Update();
}
else
{
MPESignup.Show();
Rating1.CurrentRating = 1;
}
}
