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