public string getEvents()
{
EventOnAir ev = new EventOnAir();
List<EventOnAir> eventsList = new List<EventOnAir>();
DataTable dt = ev.readTable();
for (int i = 0; i < dt.Rows.Count; i++)
{
EventOnAir evTemp = new EventOnAir();
evTemp.Point = new Point(double.Parse(dt.Rows[i]["Lat"].ToString()), double.Parse(dt.Rows[i]["Lng"].ToString()));
evTemp.Address = dt.Rows[i]["Address"].ToString();
evTemp.MaxAge = int.Parse(dt.Rows[i]["MaxAge"].ToString());
evTemp.MinAge = int.Parse(dt.Rows[i]["MinAge"].ToString());
evTemp.NumOfParti = int.Parse(dt.Rows[i]["NumOfParticipants"].ToString());
evTemp.ImageUrl= dt.Rows[i]["ImageUrl"].ToString();
evTemp.AdminID = int.Parse(dt.Rows[0]["AdminId"].ToString());
evTemp.IsPrivate1 = bool.Parse(dt.Rows[0]["Private"].ToString());
evTemp.DateTime = DateTime.Parse(dt.Rows[i]["Time"].ToString());
evTemp.DateTimeStr = (dt.Rows[i]["Time"].ToString());
evTemp.Description = dt.Rows[i]["Description"].ToString();
evTemp.Comments = dt.Rows[i]["Comments"].ToString();
evTemp.EventNum = dt.Rows[i]["EventNumber"].ToString();
//add the event to the list
eventsList.Add(evTemp);
}
JavaScriptSerializer js = new JavaScriptSerializer();
string jsonString = js.Serialize(eventsList);
return jsonString;
}
public string getEvents()
{
EventOnAir ev = new EventOnAir();
List <EventOnAir> eventsList = new List <EventOnAir>();
DataTable dt = ev.readTable();
for (int i = 0; i < dt.Rows.Count; i++)
{
EventOnAir evTemp = new EventOnAir();
evTemp.Point = new Point(double.Parse(dt.Rows[i]["Lat"].ToString()), double.Parse(dt.Rows[i]["Lng"].ToString()));
evTemp.Address = dt.Rows[i]["Address"].ToString();
evTemp.MaxAge = int.Parse(dt.Rows[i]["MaxAge"].ToString());
evTemp.MinAge = int.Parse(dt.Rows[i]["MinAge"].ToString());
evTemp.NumOfParti = int.Parse(dt.Rows[i]["NumOfParticipants"].ToString());
evTemp.ImageUrl = dt.Rows[i]["ImageUrl"].ToString();
evTemp.AdminID = int.Parse(dt.Rows[0]["AdminId"].ToString());
evTemp.IsPrivate1 = bool.Parse(dt.Rows[0]["Private"].ToString());
evTemp.DateTime = DateTime.Parse(dt.Rows[i]["Time"].ToString());
evTemp.DateTimeStr = (dt.Rows[i]["Time"].ToString());
evTemp.Description = dt.Rows[i]["Description"].ToString();
evTemp.Comments = dt.Rows[i]["Comments"].ToString();
evTemp.EventNum = dt.Rows[i]["EventNumber"].ToString();
//add the event to the list
eventsList.Add(evTemp);
}
JavaScriptSerializer js = new JavaScriptSerializer();
string jsonString = js.Serialize(eventsList);
return(jsonString);
}
protected void Page_Load(object sender, EventArgs e)
{
string ageRange;
EventOnAir Ev = new EventOnAir();
MapPlaceHolder.Visible = false;
dt = Ev.readTable();
GridView1.DataSource = dt;
GridView1.DataBind();
//load the user age
if (Session["UserDeatail"] != null)
{
DataTable dtUser = (DataTable)HttpContext.Current.Session["UserDeatail"];
ageTXT.Text = dtUser.Rows[0]["Age"].ToString();
}
for (int i = 0; i < dt.Rows.Count; i++)
{ //edit the age range
ageRange = dt.Rows[i]["MinAge"].ToString();
ageRange += "-" + dt.Rows[i]["MaxAge"].ToString();
GridView1.Rows[i].Cells[6].Text = ageRange;
// adding the join btn
Button JoinBtn = new Button();
JoinBtn.Text = " Join Now";
JoinBtn.CssClass = "myButton";
JoinBtn.Click += new EventHandler(JoinBtn_Click);
JoinBtn.ID = dt.Rows[i]["EventNumber"].ToString();
GridView1.Rows[i].Cells[7].Controls.Add(JoinBtn);
//hide if private
CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[10].Controls[0];
if (cb.Checked)
{ GridView1.Rows[i].Visible = false; }
//hide EventNumber & Comments & private& lat lng
for (int r = 8; r < 14; r++)
{
GridView1.Rows[i].Cells[r].Visible = false;
GridView1.HeaderRow.Cells[r].Visible = false;
}
}
GridView1.HeaderRow.Cells[0].Text = "";
GridView1.HeaderRow.Cells[2].Text = "Max Partic.";
GridView1.HeaderRow.Cells[6].Text = "Age Range";
GridView1.HeaderRow.Cells[7].Text = "";
//adding the image
for (int i = 0; i < dt.Rows.Count; i++)
{
Image imsel = new Image();
imsel.ImageUrl = dt.Rows[i]["imageUrl"].ToString();
GridView1.Rows[i].Cells[0].Controls.Add(imsel);
}
}
protected void Page_Load(object sender, EventArgs e)
{
MapPlaceHolder.Visible = false;
string ageRange;
EventOnAir Ev = new EventOnAir();
dt = Ev.readTable();
GridView1.DataSource = dt;
//GridView1 desing
GridView1.AllowPaging = true;
dt.Columns[6].ColumnName = "Age Range";
GridView1.DataBind();
for (int i = 0; i < dt.Rows.Count; i++)
{ //edit the age range
ageRange = dt.Rows[i]["Age Range"].ToString();
ageRange += "-" + dt.Rows[i]["MaxAge"].ToString();
GridView1.Rows[i].Cells[6].Text = ageRange;
// adding the join btn
Button JoinBtn = new Button();
JoinBtn.Text = " Join Now";
JoinBtn.Click += new EventHandler(JoinBtn_Click);
JoinBtn.ID = dt.Rows[i]["EventNumber"].ToString();
GridView1.Rows[i].Cells[7].Controls.Add(JoinBtn);
//hide if private
CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[10].Controls[0];
if (cb.Checked)
{
GridView1.Rows[i].Visible = false;
}
//hide EventNumber & Comments & private
GridView1.Rows[i].Cells[8].Visible = false;
GridView1.Rows[i].Cells[9].Visible = false;
GridView1.Rows[i].Cells[10].Visible = false;
}
GridView1.HeaderRow.Cells[7].Text = "";
GridView1.HeaderRow.Cells[8].Visible = false;
GridView1.HeaderRow.Cells[9].Visible = false;
GridView1.HeaderRow.Cells[10].Visible = false;
//adding the image
for (int i = 0; i < dt.Rows.Count; i++)
{
Image imsel = new Image();
imsel.ImageUrl = dt.Rows[i]["imageUrl"].ToString();
GridView1.Rows[i].Cells[1].Controls.Add(imsel);
}
}
public void LoadUserTable()
{
DBservices db = new DBservices();
usetT = db.GetAllUsers();
userGride.DataSource = usetT;
userGride.DataBind();
AddImage();
AddCheckBox();
//load events
EventOnAir ev = new EventOnAir();
dt = ev.readTable();
}
protected void Page_Load(object sender, EventArgs e)
{
MapPlaceHolder.Visible = false;
string ageRange;
EventOnAir Ev = new EventOnAir();
dt = Ev.readTable();
GridView1.DataSource = dt;
//GridView1 desing
GridView1.AllowPaging = true;
dt.Columns[6].ColumnName = "Age Range";
GridView1.DataBind();
for (int i = 0; i < dt.Rows.Count; i++)
{ //edit the age range
ageRange = dt.Rows[i]["Age Range"].ToString();
ageRange += "-" + dt.Rows[i]["MaxAge"].ToString();
GridView1.Rows[i].Cells[6].Text = ageRange;
// adding the join btn
Button JoinBtn = new Button();
JoinBtn.Text = " Join Now";
JoinBtn.Click += new EventHandler(JoinBtn_Click);
JoinBtn.ID = dt.Rows[i]["EventNumber"].ToString();
GridView1.Rows[i].Cells[7].Controls.Add(JoinBtn);
//hide if private
CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[10].Controls[0];
if (cb.Checked)
{ GridView1.Rows[i].Visible = false; }
//hide EventNumber & Comments & private
GridView1.Rows[i].Cells[8].Visible = false;
GridView1.Rows[i].Cells[9].Visible = false;
GridView1.Rows[i].Cells[10].Visible = false;
}
GridView1.HeaderRow.Cells[7].Text = "";
GridView1.HeaderRow.Cells[8].Visible = false;
GridView1.HeaderRow.Cells[9].Visible = false;
GridView1.HeaderRow.Cells[10].Visible = false;
//adding the image
for (int i = 0; i < dt.Rows.Count; i++)
{
Image imsel = new Image();
imsel.ImageUrl = dt.Rows[i]["imageUrl"].ToString();
GridView1.Rows[i].Cells[1].Controls.Add(imsel);
}
}
public string getOneEvent(string eventNum)
{
EventOnAir ev = new EventOnAir();
List<EventOnAir> eventsList = new List<EventOnAir>();
DataTable dt = ev.readTable();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["EventNumber"].ToString() == eventNum)
{
EventOnAir evTemp = new EventOnAir();
evTemp.Point = new Point(double.Parse(dt.Rows[i]["Lat"].ToString()), double.Parse(dt.Rows[i]["Lng"].ToString()));
evTemp.Address = dt.Rows[i]["Address"].ToString();
evTemp.MaxAge = int.Parse(dt.Rows[i]["MaxAge"].ToString());
evTemp.MinAge = int.Parse(dt.Rows[i]["MinAge"].ToString());
evTemp.NumOfParti = int.Parse(dt.Rows[i]["NumOfParticipants"].ToString());
evTemp.ImageUrl = dt.Rows[i]["ImageUrl"].ToString();
evTemp.AdminID = int.Parse(dt.Rows[i]["AdminId"].ToString());
evTemp.IsPrivate1 = bool.Parse(dt.Rows[i]["Private"].ToString());
evTemp.DateTime = DateTime.Parse(dt.Rows[i]["Time"].ToString());
evTemp.DateTimeStr = (dt.Rows[i]["Time"].ToString());
evTemp.FrequencyStr = (dt.Rows[i]["Frequncy"].ToString());
evTemp.Description = dt.Rows[i]["Description"].ToString();
evTemp.Comments = dt.Rows[i]["Comments"].ToString();
evTemp.EventNum = dt.Rows[i]["EventNumber"].ToString();
evTemp.NumOfRegis = dt.Rows[i]["NumOfRegister"].ToString();
User u = new User();
u.UserId = int.Parse(dt.Rows[i]["AdminId"].ToString());
DataTable dtName = u.CheckUserName();
if (dtName.Rows.Count == 1)
{
evTemp.AdminFullName = dtName.Rows[0]["Fname"].ToString() + " " + dtName.Rows[0]["Lname"].ToString();
}
else
{
evTemp.AdminFullName = "";
}
DataTable dtUS = evTemp.ReadUserInEvent(eventNum);
for (int r = 0; r < dtUS.Rows.Count; r++)
{
User utemp = new User();
utemp.UserName = dtUS.Rows[r]["UserName"].ToString();
utemp.UserId = int.Parse(dtUS.Rows[r]["UserId"].ToString());
utemp.Fname = dtUS.Rows[r]["Fname"].ToString();
utemp.Lname = dtUS.Rows[r]["Lname"].ToString();
utemp.Age = int.Parse(dtUS.Rows[r]["Age"].ToString());
utemp.Rating = int.Parse(dtUS.Rows[r]["Rating"].ToString());
utemp.City = dtUS.Rows[r]["City"].ToString();
utemp.ImageUrl = dtUS.Rows[r]["Picture"].ToString();
evTemp.PlayerUserList.Add(utemp);
}
eventsList.Add(evTemp); //add the event to the list
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
string jsonString = js.Serialize(eventsList);
return jsonString;
}
protected void Page_Load(object sender, EventArgs e)
{
string ageRange;
EventOnAir Ev = new EventOnAir();
MapPlaceHolder.Visible = false;
dt = Ev.readTable();
GridView1.DataSource = dt;
GridView1.DataBind();
//load the user age
if (Session["UserDeatail"] != null)
{
DataTable dtUser = (DataTable)HttpContext.Current.Session["UserDeatail"];
ageTXT.Text = dtUser.Rows[0]["Age"].ToString();
}
for (int i = 0; i < dt.Rows.Count; i++)
{ //edit the age range
ageRange = dt.Rows[i]["MinAge"].ToString();
ageRange += "-" + dt.Rows[i]["MaxAge"].ToString();
GridView1.Rows[i].Cells[6].Text = ageRange;
// adding the join btn
Button JoinBtn = new Button();
JoinBtn.Text = " Join Now";
JoinBtn.CssClass = "myButton";
JoinBtn.Click += new EventHandler(JoinBtn_Click);
JoinBtn.ID = dt.Rows[i]["EventNumber"].ToString();
GridView1.Rows[i].Cells[7].Controls.Add(JoinBtn);
//hide if private
CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[10].Controls[0];
if (cb.Checked)
{
GridView1.Rows[i].Visible = false;
}
//hide EventNumber & Comments & private& lat lng
for (int r = 8; r < 14; r++)
{
GridView1.Rows[i].Cells[r].Visible = false;
GridView1.HeaderRow.Cells[r].Visible = false;
}
}
GridView1.HeaderRow.Cells[0].Text = "";
GridView1.HeaderRow.Cells[2].Text = "Max Partic.";
GridView1.HeaderRow.Cells[6].Text = "Age Range";
GridView1.HeaderRow.Cells[7].Text = "";
//adding the image
for (int i = 0; i < dt.Rows.Count; i++)
{
Image imsel = new Image();
imsel.ImageUrl = dt.Rows[i]["imageUrl"].ToString();
GridView1.Rows[i].Cells[0].Controls.Add(imsel);
}
}
