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 }); } }