public IHttpActionResult CancelRide(int rid)
{
Ride r = new Ride();
r.Id = rid;
r.RideStatusId = 4;
new RideDAC().RideStatusUpdate(r);
Ride ride = new RideDAC().SelectById(rid);
Users driver = new UsersDAC().SelectById(ride.UserId);
RideRequest rr = new RideRequest();
rr.RideId = rid;
rr.RequestStatus = "2";
List <RideRequest> rrlist = new RideRequestDAC().SelectALLAcceptedRequestByRideId(rr);
if (rrlist != null)
{
foreach (RideRequest i in rrlist)
{
Users u = new UsersDAC().SelectById(i.PassengerId);
String message = driver.UserName + " Cancelled the ride from " + ride.Source + " to " + ride.Destination + " which you joined! ";
NotifyCancelledRideStatus(u.Token, message, "JoinedPassengers");
}
}
new RideRequestDAC().DeleteAllRideRequestsByRideId(rid);
return(Ok());
}
public IHttpActionResult JoinedRiders(int rid)
{
RideRequest rr = new RideRequest();
rr.RideId = rid;
rr.RequestStatus = "2";
List <RideRequest> rrlist = new RideRequestDAC().SelectALLAcceptedRequestByRideId(rr);
List <JoinedRidersModel> jrlist = new List <JoinedRidersModel>();
if (rrlist != null)
{
foreach (RideRequest m in rrlist)
{
JoinedRidersModel jrmodel = new JoinedRidersModel();
Users utemp = new UsersDAC().SelectById(m.PassengerId);
jrmodel.Id = m.Id;
jrmodel.PassengerId = m.PassengerId;
jrmodel.PickupLocation = m.PickupLocation;
jrmodel.Destination = m.Destination;
jrmodel.RideId = m.RideId;
jrmodel.RequestStatus = m.RequestStatus;
jrmodel.TotalAmount = m.TotalAmount;
jrmodel.UserName = utemp.UserName;
jrlist.Add(jrmodel);
}
jrlist.TrimExcess();
return(Ok(jrlist));
}
else
{
return(NotFound());
}
}
public IHttpActionResult RideEnded(int rid)
{
Ride r = new Ride();
r.Id = rid;
r.RideStatusId = 3;
new RideDAC().RideStatusUpdate(r);
Ride rtemp = new RideDAC().SelectById(rid);
Users driver = new UsersDAC().SelectById(rtemp.UserId);
RideRequest rr = new RideRequest();
rr.RideId = rid;
rr.RequestStatus = "2";
List <RideRequest> rrlist = new RideRequestDAC().SelectALLAcceptedRequestByRideId(rr);
if (rrlist != null)
{
foreach (RideRequest i in rrlist)
{
Users passenger = new UsersDAC().SelectById(i.PassengerId);
string message = "Rate your ride with " + driver.UserName + " from " + rtemp.Source + " to " + rtemp.Destination + ".";
NotifyRateDriverToJoinedPassengers(passenger.Token, driver, rtemp, message, "RateDriver");
}
}
return(Ok());
}
public Users Get(int id)
{
var userDac = new UsersDAC();
var result = userDac.SelectById(id);
return(result);
}
public IHttpActionResult UserProfileRating(int uid)
{
Users u = new UsersDAC().SelectById(uid);
Rating r = new RatingDAC().SelectByUserId(uid);
if (u != null)
{
UserProfileRatingModel uprm = new UserProfileRatingModel();
uprm.Id = u.Id;
uprm.Student_EmployeeId = u.Student_EmployeeId;
uprm.UserName = u.UserName;
uprm.Phone = u.Phone;
uprm.PhoneStatus = u.PhoneStatus;
if (r != null)
{
uprm.OneStar = r.OneStar;
uprm.TwoStar = r.TwoStar;
uprm.ThreeStar = r.ThreeStar;
uprm.FourStar = r.FourStar;
uprm.FiveStar = r.FiveStar;
}
else
{
uprm.OneStar = null;
uprm.TwoStar = null;
uprm.ThreeStar = null;
uprm.FourStar = null;
uprm.FiveStar = null;
}
return(Ok(uprm));
}
return(NotFound());
}
public List <Users> List()
{
List <Users> result = default(List <Users>);
var userDac = new UsersDAC();
result = userDac.Select();
return(result);
}
public Users Create(Users artist)
{
Users result = default(Users);
var userDac = new UsersDAC();
result = userDac.Create(artist);
return(result);
}
public IHttpActionResult SelectAll()
{
List <Users> ulist = new List <Users>();
ulist = new UsersDAC().SelectAllUsers();
return(Ok(ulist));
}
public IHttpActionResult SendTextMessageToPassenger(int pid, int rid, string message)
{
Ride rtemp = new RideDAC().SelectById(rid);
Users driver = new UsersDAC().SelectById(rtemp.UserId);
Users passenger = new UsersDAC().SelectById(pid);
NotifyTextMessageToPassenger(passenger.Token, driver.UserName, message, "TextMessageToPassenger");
return(Ok());
}
public User GetUserById(int userID)
{
User user = null;
UsersDAC usersData = new UsersDAC();
user = usersData.SelectUser(userID);
return(user);
}
// GET api/values
public IEnumerable <Users> Get()
{
//return new string[] { "value1", "value2" };
List <Users> ulist = new List <Users>();
ulist = new UsersDAC().SelectAllUsers();
return(ulist);
}
public IHttpActionResult StdEmpId(string id)
{
Users u = new UsersDAC().SelectByStdEmpId(id);
if (u == null)
{
return(NotFound());
}
return(Ok(u));
}
public User CreateUser(User user)
{
User newUser = null;
UsersDAC usersData = new UsersDAC();
newUser = usersData.Create(user);
return(newUser);
}
public IEnumerable <User> GetUsers()
{
IEnumerable <User> resultsList = null;
UsersDAC usersData = new UsersDAC();
resultsList = usersData.Select();
return(resultsList);
}
public IHttpActionResult SendNotification(string phone)
{
Users u = new UsersDAC().SelectByPhone(phone);
if (u == null)
{
return(NotFound());
}
SendNotificationFromFirebaseCloud(u.Token);
return(Ok());
}
public IHttpActionResult Login(string id, string pass, string token)
{
Users u = new UsersDAC().SelectByStdEmpIdAndPassword(id, pass);
if (u == null)
{
return(NotFound());
}
u.Token = token;
new UsersDAC().UserUpdate(u);
return(Ok(u));
}
//private static readonly ILog log = LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
/// <summary>
/// Método ejecutado justo antes de la ejecución de la acción
/// </summary>
/// <param name="filterContext"></param>
public override void OnActionExecuted(ActionExecutedContext filterContext)
{
UserData wUserData = null;
//[ModelBinder(typeof(UserDataModelBinder<UserData>))]
if (filterContext.RequestContext.HttpContext.Request.IsAuthenticated)
{
var cookie = filterContext
.RequestContext
.HttpContext
.Request
.Cookies[FormsAuthentication.FormsCookieName];
if (null == cookie)
{
// throw new Exception("No inicio session correctemnete");
filterContext.Result = new RedirectToRouteResult(
new RouteValueDictionary {
{ "controller", "Home" }, { "action", "LogIn" }
});
}
var decrypted = FormsAuthentication.Decrypt(cookie.Value);
if (!string.IsNullOrEmpty(decrypted.UserData))
{
wUserData = JsonConvert.DeserializeObject <UserData>(decrypted.UserData);
}
//TODO: Se podria armar un patron de nombre de recla con ControllerName+ActionNAme
// String regla = filterContext.Controller.
if (!String.IsNullOrEmpty(OuthRuleName))
{
UsersDAC.Authenticate(wUserData, OuthRuleName);
}
}
else
{
filterContext.Result = new RedirectToRouteResult(
new RouteValueDictionary {
{ "controller", "Home" }, { "action", "LogIn" }
});
}
base.OnActionExecuted(filterContext);
// Almacenamos el nombre del método
//log.Debug(System.Reflection.MethodBase.GetCurrentMethod().ToString());
}
public IHttpActionResult UserInsert([FromBody] Users users)
{
Users u = new Users();
u.Student_EmployeeId = users.Student_EmployeeId;
u.UserName = users.UserName;
u.Phone = users.Phone;
u.PhoneStatus = users.PhoneStatus;
u.Password = users.Password;
u.Token = users.Token;
new UsersDAC().UserUpdate(u);
Users urt = new UsersDAC().SelectByStdEmpId(users.Student_EmployeeId);
return(Ok(urt));
}
public IHttpActionResult RideRequestNotify(RideRequest rr)
{
RideRequest rrquest = new RideRequest();
rrquest.PassengerId = rr.PassengerId;
rrquest.RideId = rr.RideId;
rrquest.PickupLocation = rr.PickupLocation;
rrquest.Destination = rr.Destination;
rrquest.TotalAmount = rr.TotalAmount;
rrquest.RequestStatus = "1";
new RideRequestDAC().Insert(rrquest);
Ride r = new RideDAC().SelectById(rr.RideId);
Users u = new UsersDAC().SelectById(r.UserId);
Users passenger = new UsersDAC().SelectById(rr.PassengerId);
string message = "" + passenger.UserName + " requested to join your ride.";
String res = SendNotificationFromFirebaseCloud(u.Token, passenger, rrquest, r, message, "Driver");
return(Ok());
}
public IHttpActionResult LeaveRide(int uid, int rid)
{
RideRequest rr = new RideRequest();
rr.PassengerId = uid;
rr.RideId = rid;
rr.RequestStatus = "2";
new RideRequestDAC().DeleteRideRequest(rr);
Ride rtemp = new RideDAC().SelectById(rid);
rtemp.AvailableSeats += 1;
new RideDAC().RideUpdate(rtemp);
Users driver = new UsersDAC().SelectById(rtemp.UserId);
Users passenger = new UsersDAC().SelectById(uid);
String message = passenger.UserName + " left your ride from " + rtemp.Source + " to " + rtemp.Destination + " which you posted earlier! ";
NotifyDriverPassengerLeftStatus(driver.Token, message, "PassengerLeft");
return(Ok());
}
public IHttpActionResult KickoutPassenger(int rid, int uid)
{
RideRequest rr = new RideRequest();
rr.PassengerId = uid;
rr.RideId = rid;
rr.RequestStatus = "2";
new RideRequestDAC().DeleteRideRequest(rr);
Ride rtemp = new RideDAC().SelectById(rid);
rtemp.AvailableSeats += 1;
new RideDAC().RideUpdate(rtemp);
Users driver = new UsersDAC().SelectById(rtemp.UserId);
Users passenger = new UsersDAC().SelectById(uid);
string message = driver.UserName + " removed you from ride " + rtemp.Source + " to " + rtemp.Destination + ".";
NotifyPassengerRideKickoutStatus(passenger.Token, message, "DriverRemovedPassenger");
return(Ok());
}
public IHttpActionResult AcceptRejectRideRequestNotify(int uid, int rid, string action)
{
if (action == "AcceptRequest")
{
RideRequest rRequest = new RideRequest();
rRequest.PassengerId = uid;
rRequest.RideId = rid;
rRequest.RequestStatus = "2";
new RideRequestDAC().RideRequestStatusUpdate(rRequest);
Ride rtemp = new RideDAC().SelectById(rid);
rtemp.AvailableSeats -= 1;
new RideDAC().RideUpdate(rtemp);
//new RideDAC().RideStatusUpdate(rtemp);
Ride r = new RideDAC().SelectById(rid);
Users u = new UsersDAC().SelectById(r.UserId);
Users passenger = new UsersDAC().SelectById(uid);
string message = "" + u.UserName + " accepted your ride joining request.";
RideRequest rr = new RideRequest();
String res = SendNotificationFromFirebaseCloud(passenger.Token, u, rr, r, message, "PassengerAccepted");
return(Ok());
}
else if (action == "RejectRequest")
{
RideRequest rRequest = new RideRequest();
rRequest.PassengerId = uid;
rRequest.RideId = rid;
rRequest.RequestStatus = "3";
new RideRequestDAC().RideRequestStatusUpdate(rRequest);
Ride r = new RideDAC().SelectById(rid);
Users u = new UsersDAC().SelectById(r.UserId);
Users passenger = new UsersDAC().SelectById(uid);
string message = "" + u.UserName + " rejected your ride joining request.";
RideRequest rr = new RideRequest();
String res = SendNotificationFromFirebaseCloud(passenger.Token, u, rr, r, message, "PassengerRejected");
return(Ok());
}
return(null);
}
public IHttpActionResult SelectRideRequests(int uid)
{
Ride r = new Ride();
r.RideStatusId = 1;
r.UserId = uid;
List <Ride> rides = new RideDAC().SelectAllRidesByUserId(r);
List <RideRequest> rtemplist = new List <RideRequest>();
List <JoinedRidersModel> jrlist = new List <JoinedRidersModel>();
if (rides != null)
{
foreach (Ride ride in rides)
{
rtemplist = new RideRequestDAC().SelectAllPendingRideRequestByRideId(ride.Id);
if (rtemplist != null)
{
foreach (RideRequest m in rtemplist)
{
JoinedRidersModel jrmodel = new JoinedRidersModel();
Users utemp = new UsersDAC().SelectById(m.PassengerId);
jrmodel.Id = m.Id;
jrmodel.PassengerId = m.PassengerId;
jrmodel.PickupLocation = m.PickupLocation;
jrmodel.Destination = m.Destination;
jrmodel.RideId = m.RideId;
jrmodel.RequestStatus = m.RequestStatus;
jrmodel.TotalAmount = m.TotalAmount;
jrmodel.UserName = utemp.UserName;
jrlist.Add(jrmodel);
}
rtemplist.Clear();
}
}
jrlist.TrimExcess();
return(Ok(jrlist));
}
return(NotFound());
}
public ActionResult LogIn(LogOnModel model, string returnUrl)
{
try
{
if (ModelState.IsValid)
{
// Some code to validate and check authentication
if (!UsersDAC.ValidateUser(model.UserName, model.Password))
{
throw new Exception("Incorrect username or password");
}
UserData account = UsersDAC.Get(model.UserName);
HttpResponseBaseExtensions.SetAuthCookie <UserData>(Response, account.Id.ToString(), model.RememberMe, account);
//Response.SetAuthCookie(account.Id.ToString(), model.RememberMe, account);
if (Url.IsLocalUrl(returnUrl))
{
return(Redirect(returnUrl));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
}
catch (Exception ex)
{
throw ex;
}
model.Password = "";
return(View(model));
}
public void DeleteUser(int Id)
{
UsersDAC usersData = new UsersDAC();
usersData.Delete(Id);
}
public Users Login(Users users)
{
var userDac = new UsersDAC();
return(userDac.Login(users.NombreUsuario, users.Contraseña));
}
public void Remove(int id)
{
var userDac = new UsersDAC();
userDac.DeleteById(id);
}
public void Update(Users artist)
{
var userDac = new UsersDAC();
userDac.UpdateById(artist);
}
