public static string RIDE_REQ_UPDATE(RideRequest riderequest_)
{
return string.Format("UPDATE rh_riderequests t SET t.`accepted` = {0}, t.`seenbyhost` = {1}, t.`seenbyrequestor` = {2} WHERE t.`requestid` = {3}",
Utilities.ConvertToSQLBoolean(riderequest_.Accepted),
Utilities.ConvertToSQLBoolean(riderequest_.SeenByHost),
Utilities.ConvertToSQLBoolean(riderequest_.SeenByRequester),
riderequest_.RequestID);
}
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 StoreRideRequest(RideRequest inRideRequest_)
{
return _rideManager.StoreRideRequest(inRideRequest_);
}
public Boolean HandleRequest(RideRequest inRideRequest_)
{
return _rideManager.UpdateRideRequest(inRideRequest_);
}
//RIDE REQUESTS
public static string STORE_RIDE_REQ(RideRequest riderequest_)
{
return string.Format("INSERT INTO rh_riderequests VALUES (NULL, {0}, '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')",
riderequest_.RequestedById,
riderequest_.RequestedToId,
riderequest_.SessionId,
riderequest_.AdditionalMessage,
Utilities.ConvertToSQLBoolean(riderequest_.Accepted),
Utilities.ConvertToSQLBoolean(riderequest_.SeenByHost),
Utilities.ConvertToSQLBoolean(riderequest_.SeenByRequester)
);
}
public Boolean UpdateRideRequest(RideRequest inRideRequest_)
{
return _sqlData.ExecuteNonQuery(Queries.RIDE_REQ_UPDATE(inRideRequest_));
}
//RIDE REQUESTS
public Boolean StoreRideRequest(RideRequest inRideRequest_)
{
return _sqlData.ExecuteNonQuery(Queries.STORE_RIDE_REQ(inRideRequest_));
}
private List<RideRequest> ParseRideRequestByQuery(string inQuery_)
{
if (_sqlData.OpenConnection() == true)
{
MySqlCommand tmpCmd = new MySqlCommand(inQuery_, this._sqlData.SQLConnection);
List<RideRequest> retRideRequests = new List<RideRequest>();
using (MySqlDataReader dataReader = tmpCmd.ExecuteReader())
{
while (dataReader.Read())
{
RideRequest tmp = new RideRequest()
{
SessionId = dataReader.GetInt64(MySQLConfig.TableConstants.RideRequest.COL_SESSION_ID),
RequestID = dataReader.GetInt64(MySQLConfig.TableConstants.RideRequest.COL_REQ_ID),
AdditionalMessage = dataReader.GetString(MySQLConfig.TableConstants.RideRequest.COL_ADDITIONAL_MSG),
Accepted = (dataReader.GetInt16(MySQLConfig.TableConstants.RideRequest.COL_ACCEPTED) == 1),
RequestedById = dataReader.GetInt64(MySQLConfig.TableConstants.RideRequest.COL_REQ_BY_ID),
RequestedToId = dataReader.GetInt64(MySQLConfig.TableConstants.RideRequest.COL_REQ_TO_ID)
};
retRideRequests.Add(tmp);
}
}
return retRideRequests;
}
else
{
throw new Exception("SQL Connection error");
}
}