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(); }
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; }