public ParkingOperator GetOperatorInfo(int operatorId)
{
using (var context = new ValetDBEntities())
{
var result = context.sp_GetOperatorById(operatorId).FirstOrDefault();
return((result == null) ? new ParkingOperator() :
new ParkingOperator
{
OperatorName = result.OperatorName,
Latitude = result.Latitude,
Longitude = result.Longitude,
Address1 = result.Address1,
City = result.City,
State = result.StateID,
Zip = result.Zip,
Phone = result.Phone,
WebsiteUrl = result.WebsiteUrl,
NumberOfSpaces = (int)result.NumberOfSpaces,
InitialFee = result.InitialFee,
InitialHours = result.InitialHours,
SubsequentHourlyFee = result.HourlyFee,
AcceptsCash = result.AcceptsCash,
AcceptsCredit = result.AcceptsCredit,
CoveredParking = result.CoveredParking,
Open24Hours = result.Open24Hours,
HourOpen = result.HourOpen,
HourClosed = result.HourClosed,
EventParking = result.EventParking,
ParkingGarage = result.ParkingGarage,
});
}
}
public List <ParkingOperator> GetParkingInRadius(double myLat, double myLong, double radius)
{
using (var context = new ValetDBEntities())
{
var result = context.sp_GetParkingInRadius(myLat, myLong, radius);
return((result == null) ? new List <ParkingOperator>() :
result.Select(d =>
new ParkingOperator
{
OperatorName = d.OperatorName,
Latitude = d.Latitude,
Longitude = d.Longitude,
Address1 = d.Address1,
City = d.City,
State = d.StateID,
Zip = d.Zip.Trim(),
Phone = d.Phone,
WebsiteUrl = d.WebsiteUrl,
NumberOfSpaces = (int)d.NumberOfSpaces,
InitialFee = d.InitialFee,
InitialHours = d.InitialHours,
SubsequentHourlyFee = d.HourlyFee,
AcceptsCash = d.AcceptsCash,
AcceptsCredit = d.AcceptsCredit,
CoveredParking = d.CoveredParking,
Open24Hours = d.Open24Hours,
HourOpen = d.HourOpen,
HourClosed = d.HourClosed,
EventParking = d.EventParking,
ParkingGarage = d.ParkingGarage,
Distance = Convert.ToDouble(d.Distance),
}).ToList());
}
}
public void UpdateExpires(string deviceId, DateTime expires)
{
using (var context = new ValetDBEntities())
{
context.sp_UpdateExpires(deviceId, expires);
}
}
public void NotifyDriver(int driverId)
{
using (var context = new ValetDBEntities())
{
context.sp_DriverNotified(driverId);
}
}
public void InsertDriver(string driverName, double?latitude, double?longitude, string deviceId, DateTime?expires)
{
using (var context = new ValetDBEntities())
{
context.sp_Driver_Insert(driverName, latitude, longitude, deviceId, expires);
}
}
public void InsertParking(string operatorName, double?latitude, double?longitude, string addr1, string city,
string state,
string zip, string phone, string website, int?numberOfSpaces, decimal?initFee, int?initHours,
decimal?hourlyFee,
bool?acceptCash, bool?acceptCredit, bool?coveredParking, bool?open24, int?hourOpen, int?hourClosed,
bool?eventParking, bool?parkingGarage)
{
using (var context = new ValetDBEntities())
{
context.sp_Operator_Insert(operatorName, latitude, longitude, addr1, city, state, zip, phone, website,
numberOfSpaces, initFee, initHours, hourlyFee, acceptCash, acceptCredit, coveredParking, open24,
hourOpen, hourClosed, eventParking, parkingGarage);
}
}
public Driver GetDriverInfo(int driverId)
{
using (var context = new ValetDBEntities())
{
var result = context.sp_DriverById(driverId).FirstOrDefault();
return((result == null) ? new Driver() :
new Driver
{
DriverName = result.DriverName,
Latitude = result.Latitude,
Longitude = result.Longitude,
DeviceId = result.DeviceID,
Expires = result.Expires,
Notified = result.Notified
});
}
}
public List <Driver> GetAllDrivers()
{
using (var context = new ValetDBEntities())
{
var result = context.sp_GetAllDrivers();
return((result == null) ? new List <Driver>() :
result.Select(d =>
new Driver
{
DriverName = d.DriverName,
Latitude = d.Latitude,
Longitude = d.Longitude,
DeviceId = d.DeviceID,
Expires = d.Expires,
Notified = d.Notified
}).ToList());
}
}