public List <OrderCustomer> GetAllOrderCustomer()
{
using (FireBase_VS_MSSQLEntities3 entities = new FireBase_VS_MSSQLEntities3())
{
var list = entities.Order.Join(entities.Customer,
order => order.Customer_Id,
Customer => Customer.Id,
(order, Customer) => new OrderCustomer
{
Id = Customer.Id,
Name = Customer.Name,
Price = order.Price,
Date = order.Date
});
return(list.ToList());
//entities.Order.Join(entities.Customer,
// order => order.Customer_Id,
// Customer => Customer.Id,
// (order, Customer) => new OrderCustomer
// {
// Id = Customer.Id,
// Name = Customer.Name,
// Price = order.Price,
// Date = order.Date
// }).ToList().ForEach(r => Console.WriteLine(r.ToString()));
}
}
public List <Order> GetAllOrders()
{
using (FireBase_VS_MSSQLEntities3 entities = new FireBase_VS_MSSQLEntities3())
{
entities.Order.ToList().ForEach(o => Console.WriteLine(o.ToString()));
return(entities.Order.ToList());
}
}
public List <Customer> GetAllCustomers()
{
using (FireBase_VS_MSSQLEntities3 entities = new FireBase_VS_MSSQLEntities3())
{
entities.Customer.ToList().ForEach(c => Console.WriteLine(c.ToString()));
return(entities.Customer.ToList());
}
}
public List <Order> GetAllOrdersByCustomerId(int CustomerId)
{
using (FireBase_VS_MSSQLEntities3 entities = new FireBase_VS_MSSQLEntities3())
{
entities.Order.Where(p => p.Customer_Id == CustomerId).ToList().ForEach(p => Console.WriteLine($"get all oders cust by ID" + p.ToString()));
return(entities.Order.Where(p => p.Customer_Id == CustomerId).ToList());
}
}
public Customer GetCustomerByID(int customerId)
{
using (FireBase_VS_MSSQLEntities3 entities = new FireBase_VS_MSSQLEntities3())
{
Customer c = new Customer();
c = entities.Customer.SingleOrDefault(p => p.Id == customerId);
return(c);
}
}
public Order GetOrderById(int OrderId)
{
Order o = new Order();
using (FireBase_VS_MSSQLEntities3 entities = new FireBase_VS_MSSQLEntities3())
{
o = entities.Order.SingleOrDefault(p => p.Id == OrderId);
return(o);
}
}
public bool RemoveOrder(int orderId)
{
using (FireBase_VS_MSSQLEntities3 entities = new FireBase_VS_MSSQLEntities3())
{
bool has = entities.Order.Any(o => o.Id == orderId);
if (has == true)
{
entities.Order.Remove(entities.Order.Where(o => o.Id == orderId).FirstOrDefault());
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public bool RemoveCustomer(int customerId)
{
using (FireBase_VS_MSSQLEntities3 entities = new FireBase_VS_MSSQLEntities3())
{
bool has = entities.Customer.Any(cus => cus.Id == customerId);
if (has == true)
{
entities.Customer.Remove(entities.Customer.Where(c => c.Id == customerId).FirstOrDefault());
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public bool UpdateOrder(Order order)
{
using (FireBase_VS_MSSQLEntities3 entities = new FireBase_VS_MSSQLEntities3())
{
bool has = entities.Order.Any(o => o.Id == order.Id);
if (has == true)
{
entities.Order.Take(1).FirstOrDefault().Customer_Id = order.Customer_Id;
entities.Order.Take(1).FirstOrDefault().Date = order.Date;
entities.Order.Take(1).FirstOrDefault().Price = order.Price;
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public bool UpdateCustomer(Customer customer)
{
using (FireBase_VS_MSSQLEntities3 entities = new FireBase_VS_MSSQLEntities3())
{
bool has = entities.Customer.Any(c => c.Id == customer.Id);
if (has == true)
{
entities.Customer.Take(1).FirstOrDefault().Name = $"{customer.Name}";
entities.Customer.Take(1).FirstOrDefault().Country = $"{customer.Country}";
entities.Customer.Take(1).FirstOrDefault().Age = customer.Age;
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public bool AddCustomer(Customer customer)
{
using (FireBase_VS_MSSQLEntities3 entities = new FireBase_VS_MSSQLEntities3())
{
bool has = entities.Customer.Any(cus => cus.Id == customer.Id);
if (has == false)
{
entities.Customer.Add(new Customer {
Id = customer.Id, Name = customer.Name, Country = customer.Country, Age = customer.Age
});
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public bool AddOrder(Order order)
{
using (FireBase_VS_MSSQLEntities3 entities = new FireBase_VS_MSSQLEntities3())
{
bool has = entities.Order.Any(ord => ord.Id == order.Id);
if (has == false)
{
entities.Order.Add(new Order {
Id = order.Id, Customer_Id = order.Customer_Id, Price = order.Price, Date = order.Date
});
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}