/// <summary>
/// Method that returns a client by an id
/// </summary>
/// <param name="id">long</param>
/// <returns>SelectUserDTO</returns>
public static SelectUserDTO GetUserById(long id)
{
SelectUserDTO selectUserDTO;
using (StoreXYEntities db = new StoreXYEntities())
{
selectUserDTO = new SelectUserDTO(db.Clients.Where(x => x.id == id).FirstOrDefault());
}
return(selectUserDTO);
}
/// <summary>
/// Method that returns all productss
/// </summary>
/// <returns>List<ListProductDTO></returns>
public static List <ListProductDTO> GetAllProducts()
{
List <ListProductDTO> ListProductDTOs = new List <ListProductDTO>();
using (StoreXYEntities db = new StoreXYEntities())
{
foreach (Products product in db.Products)
{
ListProductDTOs.Add(new ListProductDTO(product));
}
}
return(ListProductDTOs);
}
/// <summary>
/// Method that returns all orders
/// </summary>
/// <returns>List<ListOrderDTO></returns>
public static List <ListOrderDTO> GetAllOrders()
{
List <ListOrderDTO> listOrderDTOs = new List <ListOrderDTO>();
using (StoreXYEntities db = new StoreXYEntities())
{
foreach (Orders order in db.Orders)
{
listOrderDTOs.Add(new ListOrderDTO(order));
}
}
return(listOrderDTOs);
}
/// <summary>
/// Method that returns all clients
/// </summary>
/// <returns>List<SelectUserDTO></returns>
public static List <SelectUserDTO> GetAllUsers()
{
List <SelectUserDTO> selectUserDTOs = new List <SelectUserDTO>();
using (StoreXYEntities db = new StoreXYEntities())
{
foreach (Clients user in db.Clients)
{
selectUserDTOs.Add(new SelectUserDTO(user));
}
}
return(selectUserDTOs);
}
public static void UpdateOrder(long id, string newState)
{
try
{
using (StoreXYEntities db = new StoreXYEntities())
{
Orders order = db.Orders.FirstOrDefault(x => x.id == id);
order.status = newState;
db.SaveChanges();
}
}
catch (Exception ex)
{
throw;
}
}
public static OrderDetailDTO GetOrderById(long idOrder)
{
try
{
Orders order;
OrderDetailDTO orderDetailDTO;
using (StoreXYEntities db = new StoreXYEntities())
{
order = db.Orders.FirstOrDefault(x => x.id == idOrder);
orderDetailDTO = new OrderDetailDTO(order);
}
return(orderDetailDTO);
}
catch (Exception ex)
{
throw;
}
}
public static void SaveNewOrder(CreateOrderDTO createOrderDTO, long idClientSelected)
{
Orders order = new Orders
{
customer_name = createOrderDTO.ClientName,
customer_email = createOrderDTO.ClientEmail,
customer_mobile = createOrderDTO.ClientMobile,
status = "CREATED",
created_at = DateTime.Now,
idClient = idClientSelected,
idProduct = createOrderDTO.IdProductSelected
};
using (StoreXYEntities db = new StoreXYEntities())
{
db.Orders.Add(order);
db.SaveChanges();
}
}
