//TODO:
// CHANGE THE IMAGE ARRAY TO IMAGES LIST
public void addCourt_Click(object sender, EventArgs e)
{
int courtId;
string lat = hiddenValue.Value;
string lng = hiddenValue1.Value;
int climit = getSelectedIndex(courtLimit.SelectedIndex);
//string[] images = new string[5];
List <String> images = new List <string>();
string path2 = System.Web.HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority);
string path = Server.MapPath("~/FieldImages/");
Courts court = new Courts(courtName.Text, courtCity.Text, climit, lat, lng);
bool isAdded = court.addField();
courtId = court.id;
if (isAdded)
{
try
{
if (imageUpload.HasFile)
{
int count = 0;
string folder = courtId.ToString();
DirectoryInfo di = Directory.CreateDirectory(path + folder);
foreach (HttpPostedFile file in imageUpload.PostedFiles)
{
if (count > 4)
{
break;
}
string ext = Path.GetExtension(file.FileName).ToLower();
file.SaveAs(di.FullName + @"\" + count + ext);
//images[count] = count + ext;
images.Add(count + ext);
count++;
}
}
else
{
images = null;
}
}
catch
{
}
string err = court.addImages(courtId, images, path2);
Response.Redirect("~/SuccessPage.aspx?courtId=" + courtId);
}
}
public List <Courts> GetCourts()
{
List <Courts> courtsList = new List <Courts>();
string queryString = "USE ssm_mvc_demo1 SELECT * FROM courts";
using (SqlConnection connection = new SqlConnection(cs))
{
SqlCommand command = new SqlCommand(queryString, connection);
try
{
command.Connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Courts court = new Courts();
court.id = (int)reader["court_id"];
court.name = reader["court_name"].ToString();
court.city = reader["court_city"].ToString();
court.limit = (int)reader["court_limit"];
court.lat = reader["court_lat"].ToString();
court.lng = reader["court_lng"].ToString();
courtsList.Add(court);
}
}
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");
}
Courts court = new Courts();
Console.WriteLine(errorMessages.ToString());
court.name = errorMessages.ToString();
courtsList.Add(court);
return(courtsList);
}
finally
{
command.Connection.Close();
}
}
return(courtsList);
}
protected void Page_Load(object sender, EventArgs e)
{
string match_id = Request.QueryString[0];
// === M A T C H ===
Matches match = new Matches();
string[] matchInfo = match.getMatchInfo(match_id);
// == MATCHINFO ARRAY : ==
//0 = NAME //1 = CITY //2 = DATE //3 = TYPE //4 = FIELD
// === /M A T C H
// === C O U R T ===
Courts court = new Courts();
string[] courtInfo = court.getCourtInfo(Int32.Parse(matchInfo[3]));
List <String> courtImgs = court.getCourtImages(Int32.Parse(matchInfo[3]));
string url = "https://www.google.com/maps/embed/v1/place?key=AIzaSyDT-7W1RK56peUVp3CRTKxuQ5pyoifLnH8&q="
+ courtInfo[3] + "," + courtInfo[4] + "&zoom=12";
string iframeUrl = "<iframe width=\"210\" height=\"160\" src=\"" + url
+ "\" frameborder=\"0\" style=\"border: 0\" > </iframe>";
// == COURTINFO ARRAY : ==
//0 = NAME //1 = CITY //2 = LIMIT //3 = LAT //4 = LNG
// === /C O U R T ===
// === FILLING DATA ====
// Match related info
Mname.InnerText = matchInfo[0];
Mcity.InnerText = courtInfo[1];
Mdatetime.InnerText = matchInfo[1];
// Court related info
fillSrc(courtImgs);
Cname.InnerText = courtInfo[0];
Clocation.InnerHtml = iframeUrl;
//viewMatch.Attributes["href"] = System.Web.HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority) + "/" + "MatchRoom?match_id=" + match_id;
}
public bool IsTeamFull(string mid, int team)
{
Matches match = new Matches();
string[] matchInfo = match.getMatchInfo(mid);
List <string> teamList = this.getTeam(mid, team);
Courts court = new Courts();
string[] courtInfo = court.getCourtInfo(Int32.Parse(matchInfo[3]));
string courtLimit = courtInfo[2];
int teamLimit = Int32.Parse(courtInfo[2]) / 2;
if (teamList.Count() == teamLimit)
{// team is full
return(true);
}
return(false);
}
public void checkIfFull()
{
Matches match = new Matches();
string[] matchInfo = match.getMatchInfo(match_id);
Courts court = new Courts();
string[] courtInfo = court.getCourtInfo(Int32.Parse(matchInfo[3]));
string courtLimit = courtInfo[2];
int teamLimit = Int32.Parse(courtInfo[2]) / 2;
// Check if team A is full:
List <string> teamA = match.getTeam(match_id, 1);
if (teamA.Count() == teamLimit) // team A is full
{
if (!teamA.Contains(user_id)) // if not current user:
{
JoinA.Visible = false;
teamAfull.Visible = true;
}
}
// Check if team B is full:
List <string> teamB = match.getTeam(match_id, 2);
if (teamB.Count() == teamLimit) // team B is full
{
if (!teamB.Contains(user_id)) // if not current user:
{
JoinB.Visible = false;
teamBfull.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["courtId"] == null)
{
Response.Redirect("/Default.aspx");
}
int court_id = Int32.Parse(Request.QueryString["courtId"]);
string len = Request.QueryString["length"];
string courtLocationUrl = "https://maps.google.com/?q=";
Courts court = new Courts();
string[] courtInfo = court.getCourtInfo(court_id);
List <String> courtImgs = court.getCourtImages(court_id);
// == COURTINFO ARRAY : ==
//0 = NAME //1 = CITY
//2 = LIMIT //3 = LAT //4 = LNG
string name = courtInfo[0];
string city = courtInfo[1];
string limit = courtInfo[2];
string lat = courtInfo[3];
string lng = courtInfo[4];
courtLocationUrl += lat + "," + lng + "&ll=" + lat + "," + lng + "&z=15";
courtMap.Attributes["href"] = courtLocationUrl;
courtName.InnerText = name;
courtCity.InnerText = "Field city: " + city;
courtLimit.InnerText = "Field limit: " + limit;
int imgsCounter = 0;
if (courtImgs != null)
{
for (int i = 0; i < courtImgs.Count(); i++)
{
string src = courtImgs[i].Replace(@"\", "/");
imgsCounter++;
switch (i)
{
case 0:
img0.Attributes["src"] = src;
break;
case 1:
img1.Attributes["src"] = src;
break;
case 2:
img2.Attributes["src"] = src;
break;
case 3:
img3.Attributes["src"] = src;
break;
case 4:
img4.Attributes["src"] = src;
break;
}
}
if (courtImgs.Count() < 5)
{
for (int i = 4; i >= imgsCounter; i--)
{
switch (i)
{
case 4:
imgblock4.Visible = false;
break;
case 3:
imgblock3.Visible = false;
break;
case 2:
imgblock2.Visible = false;
break;
case 1:
imgblock1.Visible = false;
break;
case 0:
imgblock0.Visible = false;
break;
}
}
}
}
else
{
for (int i = 0; i < 5; i++)
{
switch (i)
{
case 4:
imgblock4.Visible = false;
break;
case 3:
imgblock3.Visible = false;
break;
case 2:
imgblock2.Visible = false;
break;
case 1:
imgblock1.Visible = false;
break;
case 0:
imgblock0.Visible = false;
break;
}
}
}
if (courtImgs == null)
{
notFound.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null || Session["userid"] == null)
{
Response.Redirect("~/Login.aspx");
}
else//Session is available
{
// Get user ID from session, match ID from URL query string
user_id = Session["userid"].ToString();
match_id = Request.QueryString.Get(0);
}
Matches match = new Matches();
string[] MatchInfo = match.getMatchInfo(match_id);
Courts court = new Courts();
string[] courtInfo = court.getCourtInfo(Int32.Parse(MatchInfo[3]));
type = MatchInfo[2];
if (type == "Private" && isCaptain(user_id, match_id))// if private and captain
{
pvt.Visible = true;
}
if (type == "Public" && isCaptain(user_id, match_id))// if private and captain
{
pvt1.Visible = true;
}
if (type == "Public")
{
status.Visible = true;
status.InnerText = "public.";
status.Attributes["class"] = "subtitle-pub";
}
if (type == "Private")
{
status.Visible = true;
status.InnerText = "private.";
status.Attributes["class"] = "subtitle-pvt";
}
List <String> courtImgs = court.getCourtImages(Int32.Parse(MatchInfo[3]));
string courtLocationUrl = "https://maps.google.com/?q=";
string lat = courtInfo[3];
string lng = courtInfo[4];
courtLocationUrl += lat + "," + lng + "&ll=" + lat + "," + lng + "&z=15";
// == Filling data: ==
if (!IsPostBack)
{
checkIfFull();
checkIfJoined(user_id, match_id);
fillDefaultSlots(Int32.Parse(MatchInfo[3]));
fillSlotsTeam1(match_id);
fillSlotsTeam2(match_id);
fillCourtImages(courtImgs);
}
matchName.InnerText = MatchInfo[0];
matchDate.InnerText = MatchInfo[1];
courtName.InnerText = courtInfo[0];
matchCity.InnerText = courtInfo[1];
courtLocation.HRef = courtLocationUrl;
}
public void fillDefaultSlots(int cid)
{
Courts court = new Courts();
string[] courtInfo = court.getCourtInfo(cid);
for (int i = 0; i < Int32.Parse(courtInfo[2]) / 2; i++)
{
switch (i)
{
case 0:
Div0.Visible = true;
break;
case 1:
Div1.Visible = true;
break;
case 2:
Div2.Visible = true;
break;
case 3:
Div3.Visible = true;
break;
case 4:
Div4.Visible = true;
break;
case 5:
Div5.Visible = true;
break;
case 6:
Div6.Visible = true;
break;
case 7:
Div7.Visible = true;
break;
case 8:
Div8.Visible = true;
break;
case 9:
Div9.Visible = true;
break;
case 10:
Div10.Visible = true;
break;
}
}
for (int i = 0; i < Int32.Parse(courtInfo[2]) / 2; i++)
{
switch (i)
{
case 0:
Div11.Visible = true;
break;
case 1:
Div12.Visible = true;
break;
case 2:
Div13.Visible = true;
break;
case 3:
Div14.Visible = true;
break;
case 4:
Div15.Visible = true;
break;
case 5:
Div16.Visible = true;
break;
case 6:
Div17.Visible = true;
break;
case 7:
Div18.Visible = true;
break;
case 8:
Div19.Visible = true;
break;
case 9:
Div20.Visible = true;
break;
case 10:
Div21.Visible = true;
break;
}
}
}
