public static void FillTheDatabase() { DatabaseQueryProcessor.CreateNewProduct("Lavazza", 1500, "./img.jpg", "100% Arabica", "Good"); DatabaseQueryProcessor.CreateNewProduct("Vergnano", 2500, "./img.jpg", "100% Robusta", "Strong"); DatabaseQueryProcessor.CreateNewWorker(WorkerRole.a, "*****@*****.**", "240be518fabd2724ddb6f04eeb1da5967448d7e831c08c8fa822809f74c720a9"); DatabaseQueryProcessor.CreateNewWorker(WorkerRole.b, "*****@*****.**", "240be518fabd2724ddb6f04eeb1da5967448d7e831c08c8fa822809f74c720a9"); DatabaseQueryProcessor.CreateNewClient("*****@*****.**", "Jane", "Doe", "240be518fabd2724ddb6f04eeb1da5967448d7e831c08c8fa822809f74c720a9", "*****@*****.**"); DatabaseQueryProcessor.CreateNewAddress(0, "Poland", "Gdynia", "Rzemieslnicza", 30445, 12, "1a"); DatabaseQueryProcessor.CreateNewAddress(0, "Poland", "Warsaw", "Grodzka", 25487, 23, ""); DatabaseQueryProcessor.CreateNewOrder(0, 0, 0, 1, "2018-05-12"); DatabaseQueryProcessor.CreateNewOrderEntry(0, 0, 1); DatabaseQueryProcessor.CreateNewOrderEntry(0, 1, 2); DatabaseQueryProcessor.CreateNewOrder(0, 1, 1, 0, "2018-10-12"); DatabaseQueryProcessor.CreateNewOrderEntry(1, 0, 1); DatabaseQueryProcessor.UpdateOrder(1, 1); DatabaseQueryProcessor.UpdateOrder(1, "2018-10-14"); DatabaseQueryProcessor.CreateNewComplaint(1, 1, "I am dissatisfied", "2018-10-15", true); DatabaseQueryProcessor.CreateNewClient("*****@*****.**", "John", "Doe", "240be518fabd2724ddb6f04eeb1da5967448d7e831c08c8fa822809f74c720a9", "*****@*****.**"); DatabaseQueryProcessor.CreateNewAddress(1, "Poland", "Cracow", "Krakowska", 30000, 1, ""); DatabaseQueryProcessor.CreateNewOrder(1, 0, 2, 0, "2018-06-12"); DatabaseQueryProcessor.CreateNewOrderEntry(2, 1, 1); DatabaseQueryProcessor.CreateNewClient("*****@*****.**", "Anne", "Bottom", "240be518fabd2724ddb6f04eeb1da5967448d7e831c08c8fa822809f74c720a9", "*****@*****.**"); }
public IResult Handle(AddComplaintCommand command) { int clientId = SessionRepository.GetClientIdOfSession(command.sessionToken); if (clientId == -1) { throw new Exception(); } var order = DatabaseQueryProcessor.GetOrder(command.orderId); if (order == null) { throw new Exception(); } if (order.clientId != clientId) { throw new Exception(); } var foundComplaint = DatabaseQueryProcessor.GetComplaint(order.orderId); if (foundComplaint != null) { throw new Exception(); } DatabaseQueryProcessor.CreateNewComplaint( command.orderId, 0, command.description, DateTime.Now.ToString("yyyy-MM-dd"), false ); return(new SuccessInfoDto() { isSuccess = true }); }