public List<RideRequest> GetRideRequestByHostSessionID(RideHostSession inHost_, int inAmt_)
{
if (this._sqlData.OpenConnection() == true)
return ParseRideRequestByQuery(Queries.RIDE_REQ_LOOKUP_BY_SESSION(inHost_));
else
throw new Exception("Can't connect to MySQL server");
}
public List<Review> GetReviewsByRideSession(RideHostSession inRideHostSession_)
{
if (this._sqlData.OpenConnection() == true)
{
return ParseReviewsByQuery(Queries.REVIEWS_LOOKUP_BY_HOST_SESSION(inRideHostSession_));
}
else
{
throw new Exception("Can't connect to MySQL server");
}
}
static void Runn(string[] args)
{
DataService ds = new DataService();
FacebookUser fb = new FacebookUser() { FbId = 666, AboutMe = "werwer", Email = "*****@*****.**", Name = "AHILAN", Phone = "911", PictureUrl = "YYYY" };
FacebookUser fb2 = new FacebookUser() { FbId = 667, AboutMe = "werwer", Email = "*****@*****.**", Name = "AHILAN2", Phone = "911", PictureUrl = "YYYY" };
FacebookUser fb3 = new FacebookUser() { FbId = 668, AboutMe = "werwer", Email = "*****@*****.**", Name = "AHILAN3", Phone = "911", PictureUrl = "YYYY" };
ds.AuthenticateUser(fb);
ds.AuthenticateUser(fb2);
ds.AuthenticateUser(fb3);
List<long> hi = new List<long> { 12, 12, 12, 12 };
RideHostSession s1 = new RideHostSession() { RideHostID = 666, PostedTime = DateTime.Now, DepartTime = DateTime.Now, EstimatedArrivalTime = DateTime.Now, LocationTo = "Toronto", LocationFrom = "Waterloo", Riders = new long[] { 1, 1, 1 }, RideRequests = hi, Price = 12, AdditionalMessage = "no" };
RideHostSession s2 = new RideHostSession() { RideHostID = 699, PostedTime = DateTime.Now, DepartTime = DateTime.Now, EstimatedArrivalTime = DateTime.Now, LocationTo = "Markham", LocationFrom = "Waterloo", Riders = new long[] { 1, 1, 1 }, RideRequests = hi, Price = 12, AdditionalMessage = "no" };
RideHostSession s3 = new RideHostSession() { RideHostID = 698, PostedTime = DateTime.Now, DepartTime = DateTime.Now, EstimatedArrivalTime = DateTime.Now, LocationTo = "Ajax", LocationFrom = "Waterloo", Riders = new long[] { 1, 1, 1 }, RideRequests = hi, Price = 12, AdditionalMessage = "no" };
RideHostSession s4 = new RideHostSession() { RideHostID = 697, PostedTime = DateTime.Now, DepartTime = DateTime.Now, EstimatedArrivalTime = DateTime.Now, LocationTo = "Weber", LocationFrom = "Waterloo", Riders = new long[] { 1, 1, 1 }, RideRequests = hi, Price = 12, AdditionalMessage = "no" };
ds.StoreRideSession(s1);
RideRequest r1 = new RideRequest() {RequestedById = 667, RequestedToId = 666, SessionId = s1.SessionID, AdditionalMessage = "hey", Accepted = false, SeenByHost = false, SeenByRequester = false };
RideRequest r2 = new RideRequest() { RequestedById = 668, RequestedToId = 666, SessionId = s1.SessionID, AdditionalMessage = "heyyo", Accepted = false, SeenByHost = false, SeenByRequester = false };
ds.StoreRideRequest(r1);
ds.StoreRideRequest(r2);
List<RideRequest> hi2 = ds.GetRequests(fb2, true, 10);
ds.GetPostedRides(10, Lib.Enums.SortRideBy.Hot, fb);
}
public Boolean StoreRideSession(RideHostSession inHost_)
{
return _rideManager.StoreRideSession(inHost_);
}
public Boolean UpdateRideSession(RideHostSession inHost_)
{
return _rideManager.UpdateRideSession(inHost_);
}
public static string RIDE_REQ_LOOKUP_BY_SESSION(RideHostSession inHost_)
{
return string.Format("SELECT * FROM rh_riderequests WHERE sessionid = {0}", inHost_.SessionID);
}
public static string REVIEWS_LOOKUP_BY_HOST_SESSION(RideHostSession inHost_)
{
return string.Format("SELECT * FROM rh_reviews WHERE hostsessionreviewid = {0}", inHost_.SessionID);
}
public static string UPDATE_RIDE_SESSION(RideHostSession ridehostsession_)
{
return string.Format("UPDATE rh_ridehostsessions t SET t.`postedtime` = {0}, t.`departtime` = {1}, t.`estimatedarrivaltime` = {2}, t.`locationfrom` = {3}, t.`locationto` = {4}, t.`riders` = {5}, t.`riderequests` = {6}, t.`price` = {7}, t.`additionalmessage` = {8} WHERE sessionid = {9} AND ridehostid = {10}",
Utilities.ConvertToMySQLDate(ridehostsession_.PostedTime),
Utilities.ConvertToMySQLDate(ridehostsession_.DepartTime),
Utilities.ConvertToMySQLDate(ridehostsession_.EstimatedArrivalTime),
ridehostsession_.LocationFrom,
ridehostsession_.LocationTo,
Utilities.JoinUserArrayByID(ridehostsession_.Riders),
Utilities.JoinUserArrayByID(ridehostsession_.RideRequests.ToArray()),
ridehostsession_.Price,
ridehostsession_.AdditionalMessage,
ridehostsession_.SessionID,
ridehostsession_.RideHostID);
}
//RIDE HOST SESSION
public static string STORE_RIDE_SESSION(RideHostSession ridehostsession_)
{
return string.Format("INSERT INTO rh_ridehostsessions VALUES (NULL, {0}, '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}')",
ridehostsession_.RideHostID,
Utilities.ConvertToMySQLDate(ridehostsession_.PostedTime),
Utilities.ConvertToMySQLDate(ridehostsession_.DepartTime),
Utilities.ConvertToMySQLDate(ridehostsession_.EstimatedArrivalTime),
ridehostsession_.LocationFrom,
ridehostsession_.LocationTo,
Utilities.JoinUserArrayByID(ridehostsession_.Riders),
Utilities.JoinUserArrayByID(ridehostsession_.RideRequests.ToArray()),
ridehostsession_.Price,
ridehostsession_.AdditionalMessage
);
}
//HOST SESSIONS
public Boolean StoreRideSession(RideHostSession inRideSession_)
{
return _sqlData.ExecuteNonQuery(Queries.STORE_RIDE_SESSION(inRideSession_));
}
private List<RideHostSession> ParseRideSessionByQuery(string inQuery_)
{
if (_sqlData.OpenConnection() == true)
{
MySqlCommand tmpCmd = new MySqlCommand(inQuery_, this._sqlData.SQLConnection);
List<RideHostSession> retRideRequests = new List<RideHostSession>();
using (MySqlDataReader dataReader = tmpCmd.ExecuteReader())
{
while (dataReader.Read())
{
string tm2p = dataReader.GetString(MySQLConfig.TableConstants.RideHostSession.COL_DEP_TIME);
RideHostSession tmp = new RideHostSession()
{
SessionID = dataReader.GetInt64(MySQLConfig.TableConstants.RideHostSession.COL_SESSION_ID),
RideHostID = dataReader.GetInt64(MySQLConfig.TableConstants.RideHostSession.COL_RIDE_HOST_ID),
DepartTime = Utilities.ConvertFromMySQLDate(dataReader.GetString(MySQLConfig.TableConstants.RideHostSession.COL_DEP_TIME)),
EstimatedArrivalTime = Utilities.ConvertFromMySQLDate(dataReader.GetString(MySQLConfig.TableConstants.RideHostSession.COL_ARRIVAL_TIME)),
Price = dataReader.GetDouble(MySQLConfig.TableConstants.RideHostSession.COL_PRICE),
LocationFrom = dataReader.GetString(MySQLConfig.TableConstants.RideHostSession.COL_DEP_LOCATION),
LocationTo = dataReader.GetString(MySQLConfig.TableConstants.RideHostSession.COL_DESTINATION),
AdditionalMessage = dataReader.GetString(MySQLConfig.TableConstants.RideHostSession.COL_ADDITIONAL_MESSAGE),
PostedTime = Utilities.ConvertFromMySQLDate(dataReader.GetString(MySQLConfig.TableConstants.RideHostSession.COL_USER_POST_TIME)),
RideRequests = Utilities.ParseUserIDArrayString(dataReader.GetString(MySQLConfig.TableConstants.RideHostSession.COL_RIDE_REQ)).ToList(),
Riders = Utilities.ParseUserIDArrayString(dataReader.GetString(MySQLConfig.TableConstants.RideHostSession.COL_RIDERS))
};
retRideRequests.Add(tmp);
}
}
return retRideRequests;
}
else
{
throw new Exception("Unable to connect to SQL database");
}
}
public Boolean UpdateRideSession(RideHostSession inRideSession_)
{
return _sqlData.ExecuteNonQuery(Queries.UPDATE_RIDE_SESSION(inRideSession_));
}
