public string getOneMyEvent(string eventNum, string UserEmail)
{
List<EventOnAir> eventsList = new List<EventOnAir>();
DBservices dbs = new DBservices();
User U = new User();
U.Email = UserEmail;
DataTable dtUserEvents = dbs.ReadMyEvent(U);
for (int i = 0; i < dtUserEvents.Rows.Count; i++)
{
if (dtUserEvents.Rows[i]["EventNumber"].ToString() == eventNum)
{
EventOnAir evTemp = new EventOnAir();
evTemp.Point = new Point(double.Parse(dtUserEvents.Rows[i]["Lat"].ToString()), double.Parse(dtUserEvents.Rows[i]["Lng"].ToString()));
evTemp.Address = dtUserEvents.Rows[i]["Address"].ToString();
evTemp.MaxAge = int.Parse(dtUserEvents.Rows[i]["MaxAge"].ToString());
evTemp.MinAge = int.Parse(dtUserEvents.Rows[i]["MinAge"].ToString());
evTemp.NumOfParti = int.Parse(dtUserEvents.Rows[i]["NumOfParticipants"].ToString());
evTemp.ImageUrl = dtUserEvents.Rows[i]["ImageUrl"].ToString();
evTemp.AdminID = int.Parse(dtUserEvents.Rows[i]["AdminId"].ToString());
evTemp.IsPrivate1 = bool.Parse(dtUserEvents.Rows[i]["Private"].ToString());
evTemp.DateTime = DateTime.Parse(dtUserEvents.Rows[i]["Time"].ToString());
evTemp.DateTimeStr = (dtUserEvents.Rows[i]["Time"].ToString());
evTemp.Description = dtUserEvents.Rows[i]["Description"].ToString();
evTemp.FrequencyStr = dtUserEvents.Rows[i]["Frequency"].ToString();
evTemp.Comments = dtUserEvents.Rows[i]["Comments"].ToString();
evTemp.EventNum = dtUserEvents.Rows[i]["EventNumber"].ToString();
evTemp.NumOfRegis = dtUserEvents.Rows[i]["NumOfRegister"].ToString();
User u = new User();
u.UserId = int.Parse(dtUserEvents.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;
}
public string ReadMyEvent(string UserEmail)
{
List<EventOnAir> MyeventsList = new List<EventOnAir>();
DBservices dbs = new DBservices();
User U = new User();
U.Email = UserEmail;
DataTable dtUserEvents = dbs.ReadMyEvent(U);
for (int i = 0; i < dtUserEvents.Rows.Count; i++)
{
EventOnAir evTemp = new EventOnAir();
evTemp.Point = new Point(double.Parse(dtUserEvents.Rows[i]["Lat"].ToString()), double.Parse(dtUserEvents.Rows[i]["Lng"].ToString()));
evTemp.Address = dtUserEvents.Rows[i]["Address"].ToString();
evTemp.MaxAge = int.Parse(dtUserEvents.Rows[i]["MaxAge"].ToString());
evTemp.MinAge = int.Parse(dtUserEvents.Rows[i]["MinAge"].ToString());
evTemp.NumOfParti = int.Parse(dtUserEvents.Rows[i]["NumOfParticipants"].ToString());
evTemp.ImageUrl = dtUserEvents.Rows[i]["ImageUrl"].ToString();
evTemp.AdminID = int.Parse(dtUserEvents.Rows[0]["AdminId"].ToString());
evTemp.IsPrivate1 = bool.Parse(dtUserEvents.Rows[0]["Private"].ToString());
evTemp.DateTime = DateTime.Parse(dtUserEvents.Rows[i]["Time"].ToString());
evTemp.DateTimeStr = (dtUserEvents.Rows[i]["Time"].ToString());
evTemp.Description = dtUserEvents.Rows[i]["Description"].ToString();
evTemp.Comments = dtUserEvents.Rows[i]["Comments"].ToString();
evTemp.EventNum = dtUserEvents.Rows[i]["EventNumber"].ToString();
//add the event to the list
MyeventsList.Add(evTemp);
}
JavaScriptSerializer js = new JavaScriptSerializer();
string jsonString = js.Serialize(MyeventsList);
return jsonString;
}
//read the Myevent table
public DataTable ReadMyEvent()
{
DBservices dbs = new DBservices();
return dbs.ReadMyEvent(this);
}
