public void AddOrder(DTO.OrderDto currentOrder, DTO.CustomerDto currentCustomer) { var db = new PapaBobEntities(); var dbOrders = db.Orders; var dbCustomers = db.Customers; var newOrder = new Persistence.Order(); CreateNewOrder(currentOrder, out newOrder); var dbCustomersList = db.Customers.ToList(); var check_if_customer_exits = CustomerRepository.CustomerExists(dbCustomersList, currentCustomer); if (!check_if_customer_exits) { var newCustomer = new Customer(); newCustomer = CustomerRepository.CreateNewCustomer(currentCustomer); newOrder.customer_id = newCustomer.customer_id; var tempAmountOwing = currentOrder.payment_type != DTO.Enums.PaymentType.Cash ? currentOrder.cost : 0; newCustomer.amount_owing = double.Parse(tempAmountOwing.ToString()); newOrder.Customer = newCustomer; dbCustomers.Add(newCustomer); } else { var existingCustomer = dbCustomersList?.Find(p => p.phone_number == currentCustomer.phone_number); newOrder.customer_id = existingCustomer.customer_id; var tempAmountOwing = currentOrder.payment_type != DTO.Enums.PaymentType.Cash ? currentOrder.cost : 0; existingCustomer.amount_owing += double.Parse(tempAmountOwing.ToString()); } dbOrders.Add(newOrder); db.SaveChanges(); }
public double CustomerBalanceOwing(string phoneNumber) { var db = new PapaBobEntities(); var dbCustomersList = db.Customers.ToList(); var customerInQuestion = dbCustomersList?.Find(p => p.phone_number == phoneNumber); return(customerInQuestion.amount_owing); }
public void UpdateOrder(string currentOrderId) { var db = new PapaBobEntities(); var dbOrders = db.Orders.ToList(); var existingOrder = dbOrders?.Find(p => p.order_id == new Guid(currentOrderId)); existingOrder.completed = true; db.SaveChanges(); }
public DTO.PizzaPriceTableDto GetPizzaPrices() { var db = new PapaBobEntities(); var dbPrices = db.PizzaPriceTables.ToList(); dbPrices = dbPrices.OrderBy(p => p.Date).ToList(); var latestPrice = dbPrices[dbPrices.Count - 1]; return(PriceMapper(latestPrice)); }
public List <DTO.CustomerDto> GetCustomerList() { var db = new PapaBobEntities(); var dbCustomers = db.Customers.ToList(); var dto_customers_list = new List <DTO.CustomerDto>(); foreach (var customer in dbCustomers) { var new_customer = new DTO.CustomerDto(); CustomerMapper(customer, out new_customer); dto_customers_list.Add(new_customer); } return(dto_customers_list); }
public List <DTO.OrderDto> GetOrdersList() { var db = new PapaBobEntities(); var dbOrders = db.Orders.ToList(); var dto_orders_list = new List <DTO.OrderDto>(); foreach (var order in dbOrders) { if (!order.completed) { var newOrder = new DTO.OrderDto(); OrderMapper(order, out newOrder); dto_orders_list.Add(newOrder); } } return(dto_orders_list); }