public async Task <APIResult <bool> > Canceled(string ids) { int[] book_ids = ids.Split(',').Select(a => int.Parse(a)).ToArray(); if (book_ids.Count() == 0) { return(APIResult <bool> .Error(ResponseCode.UserValidationField, "ids is required !")); } var u = APIRequest.User(HttpContext.Current.Request); using (var ctx = new DAL.MainEntities()) { var lst = ctx.trip_book.Include("trip_share_details").Include("trip_request_details").Where(a => book_ids.Contains(a.id)); foreach (var item in lst) { item.canceled_at = DateTime.Now; item.canceled_by = u.Entity.id; item.trip_share_details.booked_seats++; ctx.Entry(item).State = System.Data.Entity.EntityState.Modified; } bool r = ctx.SaveChanges() > 0; var tripid = lst.FirstOrDefault().trip_share_details.id; var riderIDs = ctx.trip_request.Where(a => lst.Select(s => s.trip_request_details.trip_request_id).Contains(a.id)).Select(a => a.rider_id).ToList(); var driverDeviceID = ctx.sec_sessions.Where(a => riderIDs.Contains(a.user_id)).Select(a => a.device_id).Distinct().ToArray(); await FirebaseNotifications.Send(driverDeviceID, "Seats Canceled", "The driver just canceled your request seats.", new { type = 3, screen = "trip", id = tripid, sender = ctx.vwProfile.FirstOrDefault(a => a.id == u.Entity.id).firebase_uid }); return(APIResult <bool> .Success(r)); } }
public async Task <APIResult <List <DAL.trip_book> > > Booking(int trip_id, int?seat = 1, bool?all_shoots = true) { var u = Requests.APIRequest.User(HttpContext.Current.Request); if (trip_id == 0) { return(APIResult <List <DAL.trip_book> > .Error(ResponseCode.UserValidationField, "'trip_id' is required!")); } List <DAL.trip_book> lst = new List <DAL.trip_book>(); using (var ctx = new DAL.MainEntities()) { var selectedTrip = ctx.trip_share_details.Include("trip_share").FirstOrDefault(a => a.id == trip_id); if (selectedTrip.trip_share.driver_id == u.Entity.id) { return(APIResult <List <DAL.trip_book> > .Error(ResponseCode.UserValidationField, "You cannot booking your shared trip!")); } //var cTime = DateTime.Now.AddMinutes(-30) ; //&& a.start_at_date >= cTime var triplist = ctx.trip_share_details.Include("trip_share").Where(a => a.trip_share_id == selectedTrip.trip_share_id).ToList(); if (triplist.Count == 0) { return(APIResult <List <DAL.trip_book> > .Error(ResponseCode.UserValidationField, "This trip not available for booking now!")); } foreach (var trip in triplist) { //var trip=ctx.trip_share_details.Include("trip_share").Where(a=>a.id==trip_id).FirstOrDefault(); if (trip == null) { return(APIResult <List <DAL.trip_book> > .Error(ResponseCode.UserNotFound, "This trip not found!")); } if (trip.booked_seats == null) { trip.booked_seats = 0; } if (trip.seats == trip.booked_seats) { return(APIResult <List <DAL.trip_book> > .Error(ResponseCode.UserNotAcceptable, "There are no available seat in this trip!")); } if (trip.seats - trip.booked_seats < seat) { return(APIResult <List <DAL.trip_book> > .Error(ResponseCode.UserNotAcceptable, "There are only " + (trip.seats - trip.booked_seats) + " available seat/s in this trip")); } //var requests=ctx.trip_request_details.Include("trip_request").Where(a=>) var req = new DAL.trip_request() { created_at = DateTime.Now, created_by = u.Entity.id, end_at_date = null, rider_id = u.Entity.id, seats = seat, start_at_date = trip.start_at_date, trip_type_id = trip.trip_share.trip_type_id, }; var req_details = new DAL.trip_request_details() { from_lat = trip.from_lat, from_lng = trip.from_lng, from_plc = trip.from_plc, gender_id = trip.gender_id, is_active = true, seats = seat, seat_cost_from = trip.seat_cost, seat_cost_to = trip.seat_cost, start_at_date = trip.start_at_date, start_at_time = trip.start_at_time, to_lat = trip.to_lat, to_lng = trip.to_lng, to_plc = trip.to_plc, booked = true }; req.trip_request_details.Add(req_details); ctx.trip_request.Add(req); if (ctx.SaveChanges() > 0) { for (int i = 0; i < seat; i++) { var itm = new DAL.trip_book() { trip_request_details_id = req_details.id, booked_at = DateTime.Now, seats = 1, trip_share_details_id = trip_id, trip_token = Guid.NewGuid(), }; trip.booked_seats++; ctx.Entry(trip).State = System.Data.Entity.EntityState.Modified; ctx.trip_book.Add(itm); lst.Add(itm); } ctx.SaveChanges(); } else { return(APIResult <List <DAL.trip_book> > .Error(ResponseCode.BackendDatabase, "Error while save trip_request")); } if (all_shoots != true) { return(APIResult <List <DAL.trip_book> > .Success(lst)); } } var driverDeviceID = ctx.sec_sessions.Where(a => a.user_id == selectedTrip.trip_share.driver_id && a.device_id != null).Select(a => a.device_id).Distinct().ToArray(); //var ddd = ctx.sec_sessions.Where(a => a.user_id == selectedTrip.trip_share.driver_id).ToArray(); // Logger.log(JsonConvert.SerializeObject( ddd)); await FirebaseNotifications.Send(driverDeviceID, "Seats Booking", "Someone has booked your shared seats.", new { type = 1, screen = "trip_share", id = selectedTrip.id, sender = ctx.vwProfile.FirstOrDefault(a => a.id == u.Entity.id).firebase_uid }); //FirebaseNotifications.Send(new string[] { "rP2tRzF3uKNfYrZu9YypmohBKJX2" }, "Seats Booking", "Someone has booked your shared seats.", new { type = 1, screen = "trip_share", id = 2272, sender = "PF3nbGndlZV99YyPI1J4NOs6XVE2" }); return(APIResult <List <DAL.trip_book> > .Success(lst)); } }