public Bill CreateBill(int id, string name) //SE RECIBE EL ID DE LA FACTURA Y EL NOMBRE DE LA MISMA
{
decimal Tax = Cost * CostaRicaTax; //CALCULAN LOS IMPUESTOS
decimal FinalCost = Cost + Tax; //CALCULA EL TOTAL
if (string.IsNullOrEmpty(name))
{
return(null);
}
else
{
if (SearchByID(id) != null)
{
return(null);
}
else
{
Bill bill = new Bill()
{
ID = id, Name = name, Orders = BillOrders.ToString(), Cost = Cost, Tax = Tax, FinalCost = FinalCost
};
DBAccessConnection.CreateBill(bill); //CREA LA FACTURA EN LA BD
Bills = DBAccessConnection.GetBills(); //ACTUALIZA LA LISTA
return(bill);
}
}
}
public BillLogic(int Table) //CUANDO UN CAJERO VAYA A FACTURAR MANDE OBLIGATORIAMENTE LA MESA
{
Bills = DBAccessConnection.GetBills();
this.Table = Table;
BillOrders = new StringBuilder();
OrdersToPayInTheSameTable = Orders.GetOrdersToPay(Table); //SE OBTIENEN LAS ORDENES PENDIENTES DE ESA MESA
}
public Order_Product CreateOrder(int table, int product, decimal cost)
{
Order_Product order = new Order_Product()
{
Table_id = table, Product_id = product, Cost = cost, Completed = 0, Paid = 0
};
DBAccessConnection.CreateOrder(order);
LoadOrders();
return(order);
}
public void PayOrder(Order order)
{
foreach (var i in Orders)
{
if (i == order)
{
DBAccessConnection.PayOrder(i.ID);
}
}
LoadOrders();
}
private Product SearchProductById(int id)
{
List <Product> Products = DBAccessConnection.GetProducts();
foreach (var i in Products)
{
if (i.ID == id)
{
return(i);
}
}
return(null);
}
private void LoadOrders()
{
Orders.Clear();
OrderProduct = DBAccessConnection.GetOrders();
foreach (var i in OrderProduct)
{
Order order = new Order()
{
ID = i.ID, Table = i.Table_id, Cost = i.Cost, Paid = i.Paid, Completed = i.Completed, Product = SearchProductById(i.Product_id)
};
Orders.Add(order);
}
}
public Product DeleteProduct(int id)
{
if (SearchByID(id) == null)
{
return(null);
}
else
{
Product product = SearchByID(id);
DBAccessConnection.DeleteProduct(product);
Products = DBAccessConnection.GetProducts();
return(product);
}
}
public Table FreeTable(int id)
{
foreach (var table in Tables)
{
if (table.ID == id)
{
if (table.Available == 0)
{
DBAccessConnection.UpdateTableAvailability(table, 1);
Tables = DBAccessConnection.GetTables();
return(table);
}
}
}
return(null);
}
public Table AddTable(int id, int people)
{
if (people > 0 && SearchById(id) == null)
{
Table table = new Table {
ID = id, People = people, Available = 1
};
DBAccessConnection.CreateTable(table);
Tables = DBAccessConnection.GetTables();
return(table);
}
else
{
return(null);
}
}
public Product AddProduct(int id, string name, string description, decimal cost)
{
if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(description) || cost < 0)
{
return(null);
}
else
{
if (SearchByID(id) != null)
{
return(null);
}
else
{
Product product = new Product()
{
ID = id, Name = name, Description = description, Cost = cost
};
DBAccessConnection.CreateProduct(product);
Products = DBAccessConnection.GetProducts();
return(product);
}
}
}
public ProductLogic()
{
Products = DBAccessConnection.GetProducts();
}
public TableLogic()
{
Tables = DBAccessConnection.GetTables();
}
/// <summary>
/// Gestion de los usuario
/// Creacion de nuevos usuarios por parte de un usuario administrador
/// Busqueda de usuario por nombre de usuario
/// Deshabilitar usuario existentes
/// </summary>
public UserLogic()
{
Users = DBAccessConnection.GetUsers();
}
