Exemplo n.º 1
0
        public List <Reservation> GetReservations(string customerRef)
        {
            List <Reservation> reservations = new List <Reservation>();

            using (var context = new MobileServiceContext())
            {
                try
                {
                    // TODO - Logic for Timezone issues needs to be checked
                    DateTimeOffset today = DateTimeOffset.UtcNow;

                    reservations = context.Reservations
                                   .Include(rr => rr.ParkingLot)
                                   .Where(rr => rr.CustomerRef == customerRef &&
                                          ((rr.Type == ReservationType.ST.Code && rr.EndDate >= today && rr.ActualCheckout == null) ||
                                           (rr.Type != ReservationType.ST.Code && rr.EndDate >= today)))
                                   .ToList();
                }
                catch (Exception ex)
                {
                    throw ServerUtils.BuildException(ex);
                }
            }

            return(reservations);
        }
Exemplo n.º 2
0
        public string PayBalance(string resCode, string confNum, string checkout)
        {
            using (var context = new MobileServiceContext())
            {
                try
                {
                    Reservation rItem = context.Reservations
                                        .Include(rr => rr.ParkingLot)
                                        .Include(rr => rr.PriceModel)
                                        .Where(rr => rr.Id == resCode)
                                        .FirstOrDefault();

                    // Convert serialized string received from Client into checkout time
                    // The string is serialized in Checkout() method above and sent to the Client
                    // The serialized string is delimited by "<" and ">" at the beginning and end
                    DateTimeOffset checkoutTime = DateTimeOffset.Parse(checkout.Substring(1, checkout.Length - 2),
                                                                       null, DateTimeStyles.RoundtripKind);

                    decimal balance = rItem.PriceModel.GetTotalCharge(rItem, checkoutTime) - rItem.AdvancePaid.Value;

                    Utils.CreateStripeCharge(balance, rItem.ParkingLot.Name, confNum);

                    rItem.BalancePaid    = balance;
                    rItem.ConfNumBalance = confNum;

                    FinalizeCheckout(context, rItem, checkoutTime);
                }
                catch (Exception ex)
                {
                    throw ServerUtils.BuildException(ex);
                }
            }

            return(null);
        }
Exemplo n.º 3
0
        public string MakeReservation(Reservation resItem)
        {
            ReservationType rtype = ReservationType.GetType(resItem.Type);

            if (rtype == ReservationType.LTWeekly || rtype == ReservationType.LTWeeklyWorkHrs)
            {
                resItem.EndDate = resItem.StartDate.AddDays(7);
            }
            else if (rtype == ReservationType.LTMonthly || rtype == ReservationType.LTMonthlyWorkHrs)
            {
                resItem.EndDate = resItem.StartDate.AddDays(30);
            }
            else
            {
                resItem.EndDate = resItem.StartDate.AddDays(1);
            }

            resItem.EndDate = resItem.EndDate.AddSeconds(-1); // 12.59.59 PM Local time on the last day of reservation

            using (var context = new MobileServiceContext())
            {
                try
                {
                    ParkingLot parkingLot = context.ParkingLots.Find(resItem.LotId);

                    string sql = "SELECT COUNT(*) FROM Reservation rr WHERE rr.LotId = @lotid and @startDt <= rr.EndDate and @endDt >= rr.StartDate";

                    SqlParameter[] parms = new SqlParameter[]
                    {
                        new SqlParameter("@lotid", resItem.LotId),
                        new SqlParameter("@startDt", resItem.StartDate),
                        new SqlParameter("@endDt", resItem.EndDate),
                    };

                    int reserved = context.Database.SqlQuery <int>(sql, parms).FirstOrDefault();

                    if (reserved >= parkingLot.Capacity)
                    {
                        return("Parking not available for the selected date(s)");
                    }

                    PriceModel priceModel = context.PriceModels.Find(resItem.PriceModelId);
                    resItem.AdvancePaid = priceModel.GetAdvanceCharge(resItem.Type);

                    Utils.CreateStripeCharge(resItem.AdvancePaid.Value, parkingLot.Name, resItem.ConfNumAdvance);

                    parkingLot.Reserved++;
                    context.Reservations.Add(resItem);
                    context.SaveChanges();
                }
                catch (Exception ex)
                {
                    throw ServerUtils.BuildException(ex);
                }
            }

            return(null);
        }
Exemplo n.º 4
0
        public List <ParkingLot> GetParkingList(double lat, double lng)
        {
            List <ParkingLot> parkingList = new List <ParkingLot>();

            string sql = $"SELECT p.*, dbo.fx_CalcDist(@lat, @lng, p.Latitude, p.Longitude) AS Distance FROM dbo.parkinglot p ORDER BY Distance";

            using (var context = new MobileServiceContext())
            {
                try
                {
                    // Get list of Parking Lots oredered by distance from the given position
                    // CollectionFromSql() is a custom Extension method of DbContext defined in Extensions.cs
                    // fx_CalcDist is a custom user defined database function to calculate distance
                    var mlist = context.CollectionFromSql(sql,
                                                          new Dictionary <string, object> {
                        { "@lat", lat },
                        { "@lng", lng },
                    });

                    foreach (IDictionary <string, Object> dict in mlist)
                    {
                        parkingList.Add(new ParkingLot
                        {
                            Id         = (string)dict["Id"],
                            UpdatedAt  = (DateTimeOffset)dict["UpdatedAt"],
                            CreatedAt  = (DateTimeOffset)dict["CreatedAt"],
                            Name       = (string)dict["Name"],
                            Street     = (string)dict["Street"],
                            City       = (string)dict["City"],
                            State      = (string)dict["State"],
                            Zipcode    = (string)dict["Zipcode"],
                            Telephone  = (string)dict["Telephone"],
                            Timezone   = (string)dict["Timezone"],
                            Latitude   = (decimal)dict["Latitude"],
                            Longitude  = (decimal)dict["Longitude"],
                            WorkHrsEnd = (int)dict["WorkHrsEnd"],
                            Capacity   = (int)dict["Capacity"],
                            Reserved   = (int)dict["Reserved"],
                            Distance   = (double)dict["Distance"],
                        });
                    }
                }
                catch (Exception ex)
                {
                    throw ServerUtils.BuildException(ex);
                }
            }

            return(parkingList);
        }
Exemplo n.º 5
0
        public APIResponse Checkout(string resCode)
        {
            APIResponse resp = new APIResponse {
                Code = Constants.PROCESS_SUCCESS, Message = null, Result = null
            };

            using (var context = new MobileServiceContext())
            {
                try
                {
                    Reservation rItem = context.Reservations
                                        .Include(rr => rr.ParkingLot)
                                        .Include(rr => rr.PriceModel)
                                        .Where(rr => rr.Id == resCode)
                                        .FirstOrDefault();

                    string msg = VerifyCheckout(context, rItem);

                    if (msg != null)
                    {
                        resp.Code    = Constants.PROCESS_ERROR;
                        resp.Message = msg;
                        return(resp);
                    }

                    DateTimeOffset checkoutTime = DateTimeOffset.UtcNow;

                    decimal totalCharge = rItem.PriceModel.GetTotalCharge(rItem, checkoutTime);

                    if (totalCharge > rItem.AdvancePaid && rItem.BalancePaid == null)
                    {
                        decimal balance = totalCharge - rItem.AdvancePaid.Value;
                        resp.Code    = Constants.BALANCE_DUE;
                        resp.Message = $"Your balance is: {balance:C2}";
                        resp.Result  = "<" + checkoutTime.ToString("O") + ">";

                        return(resp);
                    }

                    FinalizeCheckout(context, rItem, checkoutTime);
                }
                catch (Exception ex)
                {
                    throw ServerUtils.BuildException(ex);
                }
            }

            return(resp);
        }