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 Department FindDepartmentByName(String departmentName)
{
Department department;
department = ConnectionController.GetInstance().Departments.Where(x => x.DepartmentName.Equals(departmentName)).FirstOrDefault();
return(department);
}
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 DoSearchRideId(String rideName)
{
Ride ride;
ride = ConnectionController.GetInstance().Rides.Where(x => x.RideName.Equals(rideName)).FirstOrDefault();
return(ride.Id);
}
public static void DoInsertRide()
{
RideType rideType = RideTypeController.FindRideTypeByName(rideData[2]);
RideSafety rideSafety = RideSafetyController.FindRideSafetyByName(rideData[4]);
int rideDurability, rideForce;
Int32.TryParse(rideData[1], out rideDurability);
Int32.TryParse(rideData[3], out rideForce);
Ride ride = new Ride();
ride.RideName = rideData[0];
ride.RideDurabilityCheckPerWeek = rideDurability;
ride.RideTypeId = rideType.Id;
ride.RideSafetyId = rideSafety.Id;
ride.RideStatus = rideData[5];
ride.RideMaintainStatus = rideData[6];
ride.RideForce = rideForce;
ConnectionController.GetInstance().Rides.Add(ride);
ConnectionController.GetInstance().SaveChanges();
DoInsertHeader();
DoInsertDetail();
}
public static RideType FindRideTypeByName(String rideTypeName)
{
RideType rideType;
rideType = ConnectionController.GetInstance().RideTypes.Where(x => x.RideTypeName.Equals(rideTypeName)).FirstOrDefault();
return(rideType);
}
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 void DoDeleteRide(int id)
{
Ride ride = DoSearchRide(id);
ConnectionController.GetInstance().Rides.Remove(ride);
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 DoChangePermissionStatus(int id, String response)
{
LeavingPermission leavingPermission = ConnectionController.GetInstance().LeavingPermissions.Where(x => x.Id.Equals(id)).FirstOrDefault();
leavingPermission.ResponseStatus = response;
ConnectionController.GetInstance().SaveChanges();
}
public static Ride DoSearchRide(int id)
{
Ride ride;
ride = ConnectionController.GetInstance().Rides.Where(x => x.Id.Equals(id)).FirstOrDefault();
return(ride);
}
public static void DoChangeToCooked(int id)
{
OrderRequest orderReq = ConnectionController.GetInstance().OrderRequests.Where(x => x.Id.Equals(id)).FirstOrDefault();
orderReq.OrderStatus = "Cooked";
ConnectionController.GetInstance().SaveChanges();
}
public static void DoBuyMaterial(int id)
{
ConnectionController.GetInstance().SaveChanges();
HeaderFundRequest headerFundRequest = ConnectionController.GetInstance().HeaderFundRequests.Where(x => x.Id.Equals(id)).FirstOrDefault();
headerFundRequest.ResponseStatus = "Done";
ConnectionController.GetInstance().SaveChanges();
}
public static void DoResponse(int id, String status)
{
HeaderFundRequest headerFundRequest;
headerFundRequest = ConnectionController.GetInstance().HeaderFundRequests.Where(x => x.Id.Equals(id)).FirstOrDefault();
headerFundRequest.ResponseStatus = status;
ConnectionController.GetInstance().SaveChanges();
}
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();
}
private static int DoSearchMaxHeaderId()
{
int i = 0;
if (ConnectionController.GetInstance().HeaderCreations.ToList().Count() > 0)
{
i = ConnectionController.GetInstance().HeaderCreations.Max(x => x.Id);
}
return(i);
}
public static void DoAddFiringReason(String reason)
{
Firing firing = new Firing();
firing.employeeId = ActiveUserController.GetActiveEmployee().Id;
firing.fireDescription = reason;
ConnectionController.GetInstance().Firings.Add(firing);
ConnectionController.GetInstance().SaveChanges();
}
public static void DoChangeStatus(int id)
{
HeaderConstruction headerConstruction;
headerConstruction = ConnectionController.GetInstance().HeaderConstructions.Where(x => x.Id.Equals(id)).FirstOrDefault();
Ride ride;
ride = RideCreationController.DoSearchRide(headerConstruction.RideId);
ride.RideStatus = "Available";
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 DoChangeToDone(int id)
{
OrderRequest orderReq = ConnectionController.GetInstance().OrderRequests.Where(x => x.Id.Equals(id)).FirstOrDefault();
orderReq.OrderStatus = "Done";
ConnectionController.GetInstance().SaveChanges();
Table table = ConnectionController.GetInstance().Tables.Where(x => x.Id.Equals(orderReq.TableNumber)).FirstOrDefault();
table.TableStatus = "Available";
ConnectionController.GetInstance().SaveChanges();
}
public static void DoScheduleMaintainTime(String startTime, String endTime, int id)
{
HeaderMaintenance headerMaintenance = new HeaderMaintenance();
headerMaintenance.EmployeeId = ActiveUserController.GetActiveEmployee().Id;
headerMaintenance.RideId = id;
headerMaintenance.StartTime = Convert.ToDateTime(startTime);
headerMaintenance.EndTime = Convert.ToDateTime(endTime);
ConnectionController.GetInstance().HeaderMaintenances.Add(headerMaintenance);
ConnectionController.GetInstance().SaveChanges();
}
public static void DoRequestRaiseSalary(int targetId, int price)
{
RequestRaiseSalary raiseRequest = new RequestRaiseSalary();
raiseRequest.EmployeeId = ActiveUserController.GetActiveEmployee().Id;
raiseRequest.EmployeeRaisePrice = price;
raiseRequest.EmployeeTargetId = targetId;
raiseRequest.ResponseStatus = "Waiting";
ConnectionController.GetInstance().RequestRaiseSalaries.Add(raiseRequest);
ConnectionController.GetInstance().SaveChanges();
}
public static void DoRequestResign(String startTime, String reason)
{
ResignRequest resignPermission = new ResignRequest();
resignPermission.EmployeeId = ActiveUserController.GetActiveEmployee().Id;
resignPermission.ResignLetter = reason;
resignPermission.ResignDate = Convert.ToDateTime(startTime);
resignPermission.ResignResponse = "Waiting";
ConnectionController.GetInstance().ResignRequests.Add(resignPermission);
ConnectionController.GetInstance().SaveChanges();
}
public static void DoRequestLeaving(String startTime, String endTime, String reason)
{
LeavingPermission leavingPermission = new LeavingPermission();
leavingPermission.EmployeeId = ActiveUserController.GetActiveEmployee().Id;
leavingPermission.Reason = reason;
leavingPermission.StartDate = Convert.ToDateTime(startTime);
leavingPermission.EndDate = Convert.ToDateTime(endTime);
leavingPermission.ResponseStatus = "Waiting";
ConnectionController.GetInstance().LeavingPermissions.Add(leavingPermission);
ConnectionController.GetInstance().SaveChanges();
}
private static void DoInsertDetail()
{
DetailCreation detailCreation = new DetailCreation();
int quantity;
Int32.TryParse(headerDetailData[0], out quantity);
detailCreation.Quantity = quantity;
detailCreation.HeaderId = DoSearchMaxHeaderId();
detailCreation.RideId = DoSearchRideId(rideData[0]);
ConnectionController.GetInstance().DetailCreations.Add(detailCreation);
ConnectionController.GetInstance().SaveChanges();
}
public static void DoFeedItemMoney(int id, int money)
{
HeaderPurchaseRequest headerPurchaseReq;
headerPurchaseReq = ConnectionController.GetInstance().HeaderPurchaseRequests.Where(x => x.Id.Equals(id)).FirstOrDefault();
ItemPiece itemPiece;
itemPiece = ConnectionController.GetInstance().ItemPieces.Where(x => x.Id.Equals(headerPurchaseReq.ItemPieceId)).FirstOrDefault();
headerPurchaseReq.ResponseStatus = "Pending";
itemPiece.ItemPrice = money;
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 DoCreateOrder(int id)
{
OrderRequest orderReq = ConnectionController.GetInstance().OrderRequests.Where(x => x.Id.Equals(id)).FirstOrDefault();
orderReq.EmployeeId = ActiveUserController.GetActiveEmployee().Id;
orderReq.OrderStatus = "Pending";
ConnectionController.GetInstance().SaveChanges();
Table table = ConnectionController.GetInstance().Tables.Where(x => x.Id.Equals(orderReq.TableNumber)).FirstOrDefault();
table.TableStatus = "Unavailable";
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();
}
public static void DoChangeEmployeeStatus(int id)
{
Employee employee = DoSearchEmployee(id);
if (employee.EmployeeBannedStatus.Equals("No"))
{
employee.EmployeeBannedStatus = "Yes";
}
else
{
employee.EmployeeBannedStatus = "No";
}
ConnectionController.GetInstance().SaveChanges();
}
