public static IntegerReturnValue UpdateReservation(ReservationModel nv)
{
try
{
using (var db = new QCallerEntities())
{
var result = db.UpdateReservation(nv.ReservationId, nv.ReservationTime, nv.GuestCount,
nv.Status.ToString("g"));
return(new IntegerReturnValue()
{
Description = "Successfully Updated Reservation",
Result = result
});
}
}
catch (Exception e)
{
return(new IntegerReturnValue()
{
Description = $"Failed to Update Reservation: {e.Message}",
Result = -1
});
}
}
public static IntegerReturnValue InsertRestaurant(RestaurantModel nv)
{
try
{
using (var db = new QCallerEntities())
{
var result = db.SaveRestaurant(nv.Name, nv.Address, nv.City, nv.State, nv.ZipCode, nv.PhoneNumber,
nv.EmailAddress, null).FirstOrDefault();
if (result != null)
{
return(new IntegerReturnValue()
{
Description = "Successfully Created Reservation",
Result = result.Value
});
}
throw new Exception("Failed to Create Restaurant");
}
}
catch (Exception e)
{
return(new IntegerReturnValue()
{
Description = e.Message,
Result = -1
});
}
}
public static IntegerReturnValue UpdateRestaurant(RestaurantModel nv)
{
try
{
using (var db = new QCallerEntities())
{
var result = db.UpdateRestaurant(nv.RestaurantId, nv.Name, nv.Address, nv.City, nv.State,
nv.ZipCode,
nv.PhoneNumber,
nv.EmailAddress);
return(new IntegerReturnValue()
{
Description = "Successfully Updated Restaurant",
Result = result
});
}
}
catch (Exception e)
{
return(new IntegerReturnValue()
{
Description = $"Failed to Update Restaurant: {e.Message}",
Result = -1
});
}
}
public static IntegerReturnValue UpdateCustomer(CustomerModel nv)
{
try
{
using (var db = new QCallerEntities())
{
var result = db.UpdateCustomer(nv.CustomerId, nv.FirstName, nv.LastName, nv.PhoneNumber,
nv.EmailAddress);
return(new IntegerReturnValue()
{
Description = "Successfully Updated Reservation",
Result = result
});
}
}
catch (Exception e)
{
return(new IntegerReturnValue()
{
Description = $"Failed to Update Reservation: {e.Message}",
Result = -1
});
}
}
/// <summary>
/// Gets a restaurants information using the RestaurantID.
/// FORMAT: /api/restaurant/{id}
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string Get(int id)
{
try
{
using (var db = new QCallerEntities())
{
var r = (from a in db.DBRestaurants
where a.RestaurantId == id
select a).FirstOrDefault();
if (r == null)
{
throw new Exception("Restaurant Does Not Exist");
}
var result = new RestaurantModel()
{
Address = r.Address,
City = r.City,
EmailAddress = r.EmailAddress,
LogoId = 0,
Name = r.Name,
PhoneNumber = r.PhoneNumber,
RestaurantId = r.RestaurantId,
State = r.State,
ZipCode = r.ZipCode
};
if (r.LogoID.HasValue)
{
result.LogoId = r.LogoID.Value;
}
return(result.ToJsonString());
}
}
catch (Exception)
{
return(new RestaurantModel()
{
Address = "Failed",
City = "Failed",
EmailAddress = "Failed",
LogoId = -1,
Name = "Failed",
PhoneNumber = "Failed",
RestaurantId = -1,
State = "Failed",
ZipCode = "Failed"
}.ToJsonString());
}
}
public static IntegerReturnValue InsertReservation(ReservationModel nv)
{
try
{
using (var db = new QCallerEntities())
{
nv.ReservationTime = DateTime.Now + TimeSpan.FromHours(1);
var result = db.SaveReservation(nv.RestaurantId, nv.CustomerId, nv.ReservationTime, nv.GuestCount, ReservationStatus.Waiting.ToString("g")).FirstOrDefault();
if (result != null)
{
return(new IntegerReturnValue()
{
Description = $"Successfully Created Reservation Time: {nv.ReservationTime:yyyy-MM-dd HH:mm:ss}",
Result = result.Value
});
}
//GET /api/reservation/
public string Get()
{
using (var db = new QCallerEntities())
{
var restaurants = from a in db.DBRestaurants
select a;
var customer = (from b in db.DBCustomers
select b).FirstOrDefault();
return(new ReservationModel()
{
CustomerId = customer.CustomerId,
GuestCount = 0,
ReservationId = 0,
ReservationTime = DateTime.Now,
RestaurantId = restaurants.First().RestaurantId,
Status = ReservationStatus.Waiting
}.ToJsonString());
}
}
//GET api/reservation/id
/// <summary>
/// Gets Reservation From Reservation ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string Get(int id)
{
try
{
using (var db = new QCallerEntities())
{
var rc = (from a in db.DBReservations
where a.ReservationID == id
select a).FirstOrDefault();
if (rc == null)
{
throw new Exception("Failed");
}
return(new ReservationModel()
{
CustomerId = rc.CustomerID,
ReservationId = rc.ReservationID,
RestaurantId = rc.RestaurantID,
ReservationTime = rc.Time,
GuestCount = rc.GuestCount,
Status = GetReservationStatus.GetStatus(rc.Status)
}.ToJsonString());
}
}
catch (Exception)
{
return(new ReservationModel()
{
CustomerId = -1,
ReservationId = -1,
RestaurantId = -1,
ReservationTime = DateTime.Now,
GuestCount = -1,
Status = ReservationStatus.Unknown
}.ToJsonString());
}
}
//GET api/reservation/id
/// <summary>
/// Gets Reservation From Reservation ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string Get(int id)
{
try
{
using (var db = new QCallerEntities())
{
var customer = (from a in db.DBCustomers
where a.CustomerId == id
select a).FirstOrDefault();
if (customer == null)
{
throw new Exception("DB Customer is Null");
}
return(new CustomerModel()
{
CustomerId = customer.CustomerId,
EmailAddress = customer.EmailAddress,
FirstName = customer.FirstName,
LastName = customer.LastName,
PhoneNumber = customer.PhoneNumber
}.ToJsonString());
}
}
catch (Exception e)
{
return(new CustomerModel()
{
CustomerId = -1,
EmailAddress = e.Message,
FirstName = "Failed",
LastName = "Failed",
PhoneNumber = "Failed"
}.ToJsonString());
}
}
public static IntegerReturnValue DeleteCustomer(int customerId)
{
try
{
using (var db = new QCallerEntities())
{
var result = db.DeleteCustomer(customerId);
return(new IntegerReturnValue()
{
Description = "Successfully Deleted Customer",
Result = result
});
}
}
catch (Exception e)
{
return(new IntegerReturnValue()
{
Description = $"Failed to Delete Customer: {e.Message}",
Result = -1
});
}
}
