public static void DoDeleteRide(int id) { Ride ride = DoSearchRide(id); ConnectionController.GetInstance().Rides.Remove(ride); ConnectionController.GetInstance().SaveChanges(); }
public static void DoOrderFood(String id, String quantity) { int foodId, quantityId, tableNumberId; Int32.TryParse(id, out foodId); Int32.TryParse(quantity, out quantityId); Int32.TryParse(tableNumber, out tableNumberId); OrderRequest orderReq = new OrderRequest(); orderReq.CustomerId = ActiveUserController.GetActiveCustomer().Id; orderReq.OrderDate = DateTime.Now; orderReq.EmployeeId = 1; orderReq.TableNumber = tableNumberId; orderReq.OrderStatus = "Waiting"; orderReq.FeedBackCustomer = "None"; ConnectionController.GetInstance().OrderRequests.Add(orderReq); ConnectionController.GetInstance().SaveChanges(); OrderDetail orderDetail = new OrderDetail(); orderDetail.FoodId = foodId; orderDetail.Quantity = quantityId; orderDetail.OrderId = orderReq.Id; ConnectionController.GetInstance().OrderDetails.Add(orderDetail); ConnectionController.GetInstance().SaveChanges(); }
public static RideSafety FindRideSafetyByName(String rideSafetyName) { RideSafety rideSafety; rideSafety = ConnectionController.GetInstance().RideSafeties.Where(x => x.RideSafetyName.Equals(rideSafetyName)).FirstOrDefault(); return(rideSafety); }
public static void DoChangeResignStatus(int id, string status) { ResignRequest resignReq = ConnectionController.GetInstance().ResignRequests.Where(x => x.Id.Equals(id)).FirstOrDefault(); resignReq.ResignResponse = status; ConnectionController.GetInstance().SaveChanges(); }
public static void DoChangeStatus(int id, string status) { HeaderResponse headerResponse = ConnectionController.GetInstance().HeaderResponses.Where(x => x.Id.Equals(id)).FirstOrDefault(); headerResponse.ResponseStatus = status; ConnectionController.GetInstance().SaveChanges(); }
private static int DoSearchMaxHeaderId() { int i = 0; if (ConnectionController.GetInstance().HeaderCreations.ToList().Count() > 0) { i = ConnectionController.GetInstance().HeaderCreations.Max(x => x.Id); } return(i); }
private static void DoInsertHeader() { HeaderCreation headerCreation = new HeaderCreation(); headerCreation.EmployeeId = ActiveUserController.GetActiveEmployee().Id; headerCreation.CreatedDate = DateTime.Now; ConnectionController.GetInstance().HeaderCreations.Add(headerCreation); ConnectionController.GetInstance().SaveChanges(); }
public static void DoGiveFeedback(String id, String feedback) { int orderId; Int32.TryParse(id, out orderId); OrderRequest orderReq = ConnectionController.GetInstance().OrderRequests.Where(x => x.Id.Equals(orderId)).FirstOrDefault(); orderReq.FeedBackCustomer = feedback; ConnectionController.GetInstance().SaveChanges(); }
public static void DoChangeSalary(int id, string status) { RequestRaiseSalary reqSalary = ConnectionController.GetInstance().RequestRaiseSalaries.Where(x => x.Id.Equals(id)).FirstOrDefault();; reqSalary.ResponseStatus = status; ConnectionController.GetInstance().SaveChanges(); if (status.Equals("Approved")) { Employee employee = ConnectionController.GetInstance().Employees.Where(x => x.Id.Equals(reqSalary.EmployeeTargetId)).FirstOrDefault(); employee.EmployeeSalary += reqSalary.EmployeeRaisePrice; ConnectionController.GetInstance().SaveChanges(); } }
public static void InsertCustomer(String[] customerData) { Customer customer = new Customer(); customer.CustomerFullname = customerData[0]; customer.CustomerEmail = customerData[1]; customer.CustomerPhoneNumber = customerData[2]; customer.CustomerAddress = customerData[3]; customer.CustomerGender = customerData[4]; customer.CustomerUsername = customerData[5]; customer.CustomerPassword = customerData[6]; ConnectionController.GetInstance().Customers.Add(customer); ConnectionController.GetInstance().SaveChanges(); }