public Order GetOrderById(int orderId) { Order order = new Order(); using (sql36Entities entities = new sql36Entities()) { order = entities.Orders.Where(o => o.Id == orderId).Take(1).FirstOrDefault(); } return(order); }
public Customer GetCustomerById(int customerId) { Customer customer = new Customer(); using (sql36Entities entities = new sql36Entities()) { customer = entities.Customers.Where(c => c.Id == customerId).Take(1).FirstOrDefault(); } return(customer); }
public List <Order> GetAllOrders() { List <Order> orders = new List <Order>(); using (sql36Entities entities = new sql36Entities()) { orders = entities.Orders.ToList(); } return(orders); }
public List <Order> GetAllOrdersByCustomerId(int customerId) { List <Order> orders = new List <Order>(); using (sql36Entities entities = new sql36Entities()) { orders = entities.Orders.Where(o => o.Customer_Id == customerId).ToList(); } return(orders); }
public List <Customer> GetAllCustomers() { List <Customer> customers = new List <Customer>(); using (sql36Entities entities = new sql36Entities()) { customers = entities.Customers.ToList(); } return(customers); }
public bool RemoveCustomer(int customerId) { if (customerId > 0) { using (sql36Entities entities = new sql36Entities()) { entities.Customers.Remove(entities.Customers.Where(c => c.Id == customerId).Take(1).FirstOrDefault()); entities.SaveChanges(); return(true); } } return(false); }
public bool AddCustomer(Customer customer) { if (customer != null) { using (sql36Entities entities = new sql36Entities()) { entities.Customers.Add(customer); entities.SaveChanges(); return(true); } } return(false); }
public bool AddOrder(Order order) { if (order != null) { using (sql36Entities entities = new sql36Entities()) { entities.Orders.Add(order); entities.SaveChanges(); return(true); } } return(false); }
public bool RemoveOrder(int orderId) { using (sql36Entities entities = new sql36Entities()) { if (entities.Orders.Where(o => o.Id == orderId).FirstOrDefault() != null) { entities.Orders.Remove(entities.Orders.Where(o => o.Id == orderId).Take(1).FirstOrDefault()); entities.SaveChanges(); Console.WriteLine("removed successfully!"); return(true); } Console.WriteLine("no order with this id was found!"); return(false); } }
public bool UpdateCustomer(int customerId, Customer customer) { if (customerId > 0 && customer != null) { using (sql36Entities entities = new sql36Entities()) { var selectedCustomer = entities.Customers.Where(c => c.Id == customerId).Take(1).FirstOrDefault(); selectedCustomer.Id = customer.Id; selectedCustomer.Name = customer.Name; selectedCustomer.Country = customer.Country; selectedCustomer.Age = customer.Age; entities.SaveChanges(); return(true); } } return(false); }
public List <OrderCustomer> GetAllOrderCustomer() { List <OrderCustomer> orderCustomer = new List <OrderCustomer>(); using (sql36Entities entities = new sql36Entities()) { orderCustomer = entities.Orders.Join(entities.Customers, o => o.Customer_Id, c => c.Id, (o, c) => new OrderCustomer { Id = o.Id, Price = o.Price, Date = o.Date, CustomerId = o.Customer_Id, CustomerName = c.Name }).ToList(); } return(orderCustomer); }
public bool UpdateOrder(int orderId, Order order) { using (sql36Entities entities = new sql36Entities()) { if (entities.Orders.Where(o => o.Id == orderId).FirstOrDefault() != null && order != null) { var selectedOrder = entities.Orders.Where(o => o.Id == orderId).Take(1).FirstOrDefault(); selectedOrder.Id = order.Id; selectedOrder.Customer_Id = order.Customer_Id; selectedOrder.Price = order.Price; selectedOrder.Date = order.Date; entities.SaveChanges(); return(true); } return(false); } }