protected void DeleteRideOffer(int rideId)
{
RideOffer rideOffer = new RideOffer();
try
{
rideOffer.DeleteRideOffer(Convert.ToInt32(rideId));
}
catch (Exception ex)
{
throw ex;
}
DataTable dt = new DataTable();
try
{
dt = GetAllRideOffers().Tables[0];
}
catch (Exception ex)
{
throw ex;
}
TrempsRepeater.DataSource = dt;
TrempsRepeater.DataBind();
}
public UserRideOffer(User user, RideOffer rideOffer)
: base(user)
{
RideOffer = rideOffer;
PostStatus(null).FireAndForgetAsync(Program.ErrorHandler);
}
protected DataSet GetAllRideOffers()
{
RideOffer rideOffer = new RideOffer();
DataSet ds = new DataSet();
try
{
ds = rideOffer.GetUserRideOffers((int)Session["userId"]);
}
catch (Exception ex)
{
throw ex;
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (Convert.ToInt32(ds.Tables[0].Rows[i]["price"]) == -1)
{
ds.Tables[0].Rows[i]["price"] = 0;
}
string date = ds.Tables[0].Rows[i]["rideDate"].ToString();
string[] arr = date.Split('-');
ds.Tables[0].Rows[i]["rideDate"] = arr[2] + "/" + arr[1] + "/" + arr[0];
}
return(ds);
}
protected void Page_Load(object sender, EventArgs e)
{
rideOfferId = Convert.ToInt32(Request.QueryString["rideId"]);
RideOffer rideOffer = new RideOffer();
DataTable requestsTable = new DataTable();
try
{
requestsTable = rideOffer.getMatchforRideOffer(rideOfferId);
}
catch (Exception ex)
{
throw ex;
}
for (int i = 0; i < requestsTable.Rows.Count; i++)
{
if (Convert.ToInt32(requestsTable.Rows[i]["price"]) == -1)
{
requestsTable.Rows[i]["price"] = 0;
}
string date = requestsTable.Rows[i]["rideDate"].ToString();
string[] arr = date.Split(' ');
requestsTable.Rows[i]["rideDate"] = arr[0];
}
matchUsersRepeater.DataSource = requestsTable;
matchUsersRepeater.DataBind();
}
public void GetAllRidesOffered_ShouldWork()
{
RideOffer SampleRideOffer = RideOfferTestingData.GetSampleRideOfferDetails();
User SampleUser = UserTestingData.GetSampleUser();
List <OfferRide> SampleRides = RideOfferTestingData.GetSampleRideOffersList();
Booking SampleBooking = BookingTestingData.GetSampleBooking();
RideDetails SampleRideDetails = BookingTestingData.GetSampleRideDetails();
List <Booking> SampleBookings = BookingTestingData.GetSampleBookings();
using (var mock = AutoMock.GetStrict())
{
var TestService = mock.Create <OfferRideService>();
mock.Mock <IMapper>().Setup(x => x.Map <Booking, RideDetails>(SampleBookings[0])).Returns(SampleRideDetails).Verifiable();
mock.Mock <IRepositoryManager <User> >().Setup(x => x.Get(19)).Returns(SampleUser).Verifiable();
mock.Mock <IRepositoryManager <OfferRide> >().Setup(x => x.GetAll()).Returns(SampleRides).Verifiable();
mock.Mock <IRepositoryManager <Booking> >().Setup(x => x.GetAll()).Returns(SampleBookings).Verifiable();
TestService.GetAllRidesOffered(22);
mock.Mock <IRepositoryManager <OfferRide> >().Verify(x => x.GetAll(), Times.Exactly(1));
}
}
public void CreateRideOffer_ShouldWork()
{
RideOffer SampleRideOffer = RideOfferTestingData.GetSampleRideOfferDetails();
User SampleUser = UserTestingData.GetSampleUser();
OfferRide SampleRide = RideOfferTestingData.GetSampleRideOffer();
using (var mock = AutoMock.GetStrict())
{
var TestService = mock.Create <OfferRideService>();
mock.Mock <IRepositoryManager <Place> >().Setup(x => x.AddRange(SampleRide.Route));
mock.Mock <IMapper>().Setup(x => x.Map <RideOffer, OfferRide>(SampleRideOffer)).Returns(SampleRide).Verifiable();
mock.Mock <IRepositoryManager <User> >().Setup(x => x.Get(19)).Returns(SampleUser).Verifiable();
mock.Mock <IRepositoryManager <User> >().Setup(x => x.Put(SampleUser)).Verifiable();
mock.Mock <IRepositoryManager <OfferRide> >().Setup(x => x.Post(SampleRide)).Verifiable();
TestService.CreateRideOffer(19, SampleRideOffer);
mock.Mock <IRepositoryManager <OfferRide> >().Verify(x => x.Post(SampleRide), Times.Exactly(1));
}
}
public async Task <string> PostRideOfferAsync(string userId, RideOffer rideOffer)
{
var uri = new Uri(App.Current.ServerAddress, "api/rides/ride-offer")
.AddParameter("userId", userId);
var content = new StringContent(JsonConvert.SerializeObject(rideOffer), System.Text.Encoding.UTF8, "application/json");
try
{
var response = await App.Current.HttpClient.PostAsync(uri, content);
Console.WriteLine($"Response code: {response.StatusCode}");
if (response.IsSuccessStatusCode)
{
Console.WriteLine($"Response body: {await response.Content.ReadAsStringAsync()}");
return(response.Headers.Location.OriginalString);
}
else
{
Console.WriteLine($"Reason phrases: {response.ReasonPhrase}");
return(null);
}
}
catch (HttpRequestException e)
{
Console.WriteLine($"Got exception: {e}");
return(null);
}
}
public async Task <IPendingRideRelatedRequest> SubmitRideOffer(RideOffer rideOffer)
{
string userId = App.Current.UserInfo.UserId;
string requestId = await RideService.Instance.PostRideOfferAsync(userId, rideOffer);
if (string.IsNullOrEmpty(requestId))
{
return(null);
}
return(new PollNotifications.PendingRideRelatedRequest(userId, requestId));
}
public int SaveRideOffer(RideOffer rideOffer)
{
var conn = MyAdoHelper.ConnectToDb("Database.mdf");
try
{
var param = new System.Data.SqlClient.SqlParameter[11];
param[0] = new System.Data.SqlClient.SqlParameter("userId", SqlDbType.Int);
param[0].Value = rideOffer.GetUserId();
param[1] = new System.Data.SqlClient.SqlParameter("rideDate", SqlDbType.DateTime);
param[1].Value = rideOffer.GetRideDate();
param[2] = new System.Data.SqlClient.SqlParameter("minute", SqlDbType.Int);
param[2].Value = rideOffer.GetMinute();
param[3] = new System.Data.SqlClient.SqlParameter("hour", SqlDbType.Int);
param[3].Value = rideOffer.GetHour();
param[4] = new System.Data.SqlClient.SqlParameter("email", SqlDbType.NVarChar);
param[4].Value = rideOffer.GetEmail();
param[5] = new System.Data.SqlClient.SqlParameter("phone", SqlDbType.NVarChar);
param[5].Value = rideOffer.GetPhone();
param[6] = new System.Data.SqlClient.SqlParameter("notes", SqlDbType.NVarChar);
param[6].Value = rideOffer.GetNotes();
param[7] = new System.Data.SqlClient.SqlParameter("price", SqlDbType.Int);
param[7].Value = rideOffer.GetPrice();
param[8] = new System.Data.SqlClient.SqlParameter("genderPref", SqlDbType.Int);
param[8].Value = rideOffer.GetgenderPref();
param[9] = new System.Data.SqlClient.SqlParameter("originName", SqlDbType.NVarChar);
param[9].Value = rideOffer.GetOriginName();
param[10] = new System.Data.SqlClient.SqlParameter("destinationName", SqlDbType.NVarChar);
param[10].Value = rideOffer.GetDestinationName();
return(Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.StoredProcedure, "SaveRideOffer", param).ToString()));
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
public RideOffer GetSampleRideOfferDetails()
{
RideOffer ride = new RideOffer()
{
AvailableSeats = 2,
CarId = 2,
RideOfferedDate = DateTime.Now.Date,
Route = new List <string>()
{
"Ashoknagar", "Sircilla", "Venkampet"
},
Time = "3am-6am",
};
return(ride);
}
/// <summary>
/// Posts the offer.
/// </summary>
/// <returns>True if posting succeeded, false otherwise.</returns>
/// <param name="offer">Offer to post.</param>
public async Task <bool> PostOffer(RideOffer offer)
{
if (IsStale)
{
return(false);
}
IPendingRideRelatedRequest response = await RideOfferer.SubmitRideOffer(offer);
if (response != null)
{
TransitionTo(new OfferPendingState(this, response, offer));
return(true);
}
return(false);
}
public async Task <ActionResult <string> > PostRideOffer([FromBody] RideOffer offer, [FromQuery] string userId)
{
User user = await Users.GetUser(userId);
if (user == null)
{
return(NotFound());
}
string requestId = user.AddRideOffer(offer);
//TODO is this the correct response code?
if (string.IsNullOrEmpty(requestId))
{
return(BadRequest());
}
return(Created(requestId, null));
}
protected void RideOfferPathBtn_Click(object sender, EventArgs e)
{
RideOfferCoordinates rideOfferCoordinates = new RideOfferCoordinates();
string[] coordinateX;
string[] coordinateY;
string xmlStr = "";
coordinateX = coordinateXArray.Text.Split(','); //from js
coordinateY = coordinateYArray.Text.Split(',');
int coordinateXLength = coordinateX.Length;
xmlStr += "<Coordinates>";
for (int i = 0; i < coordinateXLength; i++)
{
xmlStr += "<row";
xmlStr += " X=\"" + coordinateX[i] + "\"";
xmlStr += " Y=\"" + coordinateY[i] + "\"";
xmlStr += " ordinal=\"" + i + "\"";
xmlStr += "/>";
}
xmlStr += "</Coordinates>";
RideOffer rideOffer = new RideOffer(Convert.ToInt32(Request.QueryString["userId"]), (Convert.ToDateTime(Request.QueryString["rideDate"])), Convert.ToInt32(Request.QueryString["minute"]), Convert.ToInt32(Request.QueryString["hour"]), Request.QueryString["email"], Request.QueryString["phone"], Request.QueryString["notes"], Convert.ToInt32(Request.QueryString["price"]), Convert.ToInt32(Request.QueryString["gender"]), Request.QueryString["origin"], Request.QueryString["destination"]);
int rideOfferId;
try
{
rideOfferId = rideOffer.SaveRideOffer();
rideOfferCoordinates.SaveRideOfferCoordinate(rideOfferId, xmlStr);
}
catch (Exception ex)
{
throw ex;
}
Response.Redirect("MatchUsersForOffer.aspx?rideOfferId=" + rideOfferId);
//Response.Redirect("~/MatchUsersForOffer.aspx?rideOfferId=" + Request.QueryString["rideOfferId"] + "&originPoint=" + Request.QueryString["OriginPoint"] + "&destinationPoint=" + Request.QueryString["DestinationPoint"]);
}
public void CreateRideOffer(long userId, RideOffer rideOffer)
{
OfferRide NewRideOffer = _mapper.Map <RideOffer, OfferRide>(rideOffer);
NewRideOffer.RideOfferId = GenerateId();
NewRideOffer.HostId = userId;
_repository.Post(NewRideOffer);
foreach (string area in rideOffer.Route)
{
Place NewPlace = new Place
{
AreaName = area,
RideOfferId = NewRideOffer.RideOfferId
};
NewRideOffer.Route.Add(NewPlace);
}
_routeRepository.AddRange(NewRideOffer.Route);
User user = _userRepository.Get(userId);
user.LastOfferRideId = NewRideOffer.RideOfferId;
_userRepository.Put(user);
}
public OfferPendingState(Ridesharing.StateBase previous, IPendingRideRelatedRequest response, RideOffer offer)
: base(previous, response)
{
Offer = offer;
}
public void CreateRide([FromRoute] long userId, [FromBody] RideOffer rideOffer)
{
_service.CreateRideOffer(userId, rideOffer);
}
