public bool isCodeMatching(string code)
{
Matches matchCode = new Matches();
string cd = matchCode.getPvtMatchCode(match_id);
if (cd == code)
{
return(true);
}
return(false);
}
public string sendMatchInvite(string receiveid, string senderid, string mid)
{
//[invite_id] [invite_resever] [invite_sender] [invite_read] [invite_match]
Matches match = new Matches();
string code = match.getPvtMatchCode(mid);
string queryString = "USE ssm_mvc_demo1 INSERT INTO invites (invite_resever, invite_sender, invite_read, invite_match, invite_code)" +
" VALUES (@resever, @sender, @read, @match, @code)";
string status = "";
using (SqlConnection connection = new SqlConnection(cs))
{
SqlCommand command = new SqlCommand(queryString, connection);
try
{
command.Connection.Open();
command.Parameters.AddWithValue("@resever", receiveid);
command.Parameters.AddWithValue("@sender", senderid);
command.Parameters.AddWithValue("@read", 0);
command.Parameters.AddWithValue("@match", mid);
command.Parameters.AddWithValue("@code", code);
if (command.ExecuteNonQuery() > 0)
{
status = "good";
}
}
catch (SqlException ex)
{
for (int i = 0; i < ex.Errors.Count; i++)
{
errorMessages.Append("Index #" + i + "\n" +
"Message: " + ex.Errors[i].Message + "\n" +
"LineNumber: " + ex.Errors[i].LineNumber + "\n" +
"Source: " + ex.Errors[i].Source + "\n" +
"Procedure: " + ex.Errors[i].Procedure + "\n");
}
Console.WriteLine(errorMessages.ToString());
status = errorMessages.ToString();
}
finally
{
command.Connection.Close();
}
}
return(status);
}
protected void GoPrivate_Click(object sender, EventArgs e)
{
Matches match = new Matches();
string code = match.getPvtMatchCode(match_id);
if (match.toggleMatchType(match_id, "Private"))
{
Response.Redirect("~/MatchRoom.aspx?match_id=" + match_id + "&type=Private" + "&code=" + code);
}
else
{
Response.Redirect("~/Default.aspx");
}
}
public void createMatch_Click(object sender, EventArgs e)
{
Matches match = new Matches();
bool isCreated = match.createMatch(matchName.Text, matchType.Text, selectedId.Value, matchDate.Text, matchTime.Text, Session["userid"].ToString());
if (isCreated)
{
if (match.type == "Private")
{
Response.Redirect("~/MatchRoom.aspx?match_id=" + match.id + "&type=" + match.type + "&code=" + match.getPvtMatchCode(match.id));
}
if (match.type == "Public")
{
Response.Redirect("~/MatchRoom.aspx?match_id=" + match.id + "&type=" + match.type);
}
Response.Redirect("~/MatchRoom.aspx?match_id=" + match.id + "&type=" + "WRONG");
}
// should be relocated to my matches page
}
protected void Page_Load(object sender, EventArgs e)
{
userid = Request.QueryString["userid"].ToString();
Users user = new Users();
List <string[]> requested = user.getRequestedList(userid, 0);
if (requested != null)
{
for (int i = 0; i < requested.Count(); i++)
{
string reqid = requested[i][0];
string username = requested[i][1];
string friendReqBlock = "<div runat='server' style='font-size: 12.5px;' class='py-1 my-1'>Friend request</div> " +
"<div class='row notif-row my-2'> " +
"<div runat='server'>" + username + "#" + reqid + "</div> " +
"<div id='" + reqid + "' class='btn btn-sm btn-info p-1 m-1' onclick='accepted(this); return true;'>Accept</div> " +
"<div id='" + reqid + "' class='btn btn-sm btn-warning p-1 m-1' onclick='decline(this); return true;'>Decline</div> " +
"</div>";
notif.InnerHtml += friendReqBlock;
}
}
//MATCH INVITES
List <string[]> invited = user.getMatchInvites(userid);
//test.InnerText = invited[0][0];
if (invited != null)
{
for (int i = 0; i < invited.Count(); i++)
{
string matchid = invited[i][0];
string senderid = invited[i][1];
string read = invited[i][2];
Matches match = new Matches();
string code = match.getPvtMatchCode(matchid);
string[] matchinfo = match.getMatchInfo(matchid);
string type = matchinfo[2];
// == MATCHINFO ARRAY: ==
//0 = NAME //1 = DATE
//2 = TYPE //3 = FIELD
Users user1 = new Users();
string username1 = user.getUsername(senderid);
string friendReqBlock = "<div runat='server' style='font-size: 12.5px;' class='py-1 my-1'>Match invite ⚽</div> " +
"<div class='row notif-row my-2'> " +
"<div runat='server'>" + username1 + "#" + senderid + "</div> " +
"<div id='" + matchid + "' class='p-1 m-1'>Match invite</div> " +
"<div id='" + matchid + "#" + code + "@" + type + "' class='btn btn-sm btn-success p-1 m-1' onclick='Goto(this); return true;'>View</div> " +
"</div>";
notif.InnerHtml += friendReqBlock;
}
}
if (invited == null && requested == null)
{
notif.InnerHtml = "<h6 id='notifEmpty' class='notif-Empty' runat='server'>No notifications. </h6>";
}
}