public static List <Model.Employee> GetAllEmployees()
{
List <Model.Employee> employees = new List <Model.Employee>();
string query = "select * from employee order by id";
DataTable table = DB_Handler.GetDataTable(query);
foreach (DataRow row in table.Rows)
{
employees.Add(RowToEntity(row));
}
return(employees);
}
public static List <Model.Food_Type> GetAllFood_Types()
{
List <Model.Food_Type> food_Types = new List <Model.Food_Type>();
string query = "select * from food_type order by id";
DataTable table = DB_Handler.GetDataTable(query);
foreach (DataRow row in table.Rows)
{
food_Types.Add(RowToEntity(row));
}
return(food_Types);
}
public static List <POS_Order> GetOrders(DateTime first, DateTime second)
{
List <POS_Order> orders = new List <POS_Order>();
string query = "select * from pos_order where place_time between TO_DATE('" + first.ToString(string.Format("MM-dd-yyyy")) + "', 'mm-dd-yyyy') and TO_DATE('" + second.ToString(String.Format("MM-dd-yyyy")) + "', 'mm-dd-yyyy')";
DataTable table = DB_Handler.GetDataTable(query);
foreach (DataRow row in table.Rows)
{
orders.Add(RowToEntity(row));
}
return(orders);
}
public static List <Model.Rotten_Ingredient> GetAllRotten_Ingredients()
{
List <Model.Rotten_Ingredient> rotten_Ingredients = new List <Model.Rotten_Ingredient>();
string query = "select * from rotten_ingredient order by id";
DataTable table = DB_Handler.GetDataTable(query);
foreach (DataRow row in table.Rows)
{
rotten_Ingredients.Add(RowToEntity(row));
}
return(rotten_Ingredients);
}
public static List <Model.Unit_Type> GetAllUnit_Types()
{
List <Model.Unit_Type> types = new List <Model.Unit_Type>();
string query = "SELECT * FROM UNIT_TYPE ORDER BY ID";
DataTable table = DB_Handler.GetDataTable(query);
foreach (DataRow row in table.Rows)
{
types.Add(RowToEntity(row));
}
return(types);
}
public static List <Model.Data> GetAllChangelog()
{
List <Model.Data> Data = new List <Model.Data>();
string query = "select * from Data order by id";
DataTable table = DB_Handler.GetDataTable(query);
foreach (DataRow row in table.Rows)
{
Data.Add(RowToEntity(row));
}
return(Data);
}
public static List <string> GetAllJobTitles()
{
List <string> titles = new List <string>();
string query = "SELECT Job_Title FROM JOB ORDER BY ID";
DataTable table = DB_Handler.GetDataTable(query);
foreach (DataRow row in table.Rows)
{
titles.Add(row["Job_Title"].ToString());
}
return(titles);
}
public static List <Model.Customer> GetAllCustomers()
{
List <Model.Customer> customers = new List <Model.Customer>();
string query = "select * from customer order by id";
DataTable table = DB_Handler.GetDataTable(query);
foreach (DataRow row in table.Rows)
{
customers.Add(RowToEntity(row));
}
return(customers);
}
public static List <Model.Job> GetAllJobs()
{
List <Model.Job> jobs = new List <Model.Job>();
string query = "SELECT * FROM JOB ORDER BY ID";
DataTable table = DB_Handler.GetDataTable(query);
foreach (DataRow row in table.Rows)
{
jobs.Add(RowToEntity(row));
}
return(jobs);
}
public static void UpdateStockCount(int Id)
{
string query =
"DECLARE " +
"COUNT number; " +
"BEGIN " +
"COUNT := generate_StockCount(" + Id + "); " +
"UPDATE food SET STOCK_COUNT = COUNT WHERE Id = " + Id + "; " +
"END;";
DB_Handler.ExecuteQuery(query);
}
public static List <Model.POS_Purchase> GetPurchases(DateTime first, DateTime second)
{
List <Model.POS_Purchase> purchases = new List <Model.POS_Purchase>();
string query = "select * from pos_purchase where time between TO_DATE('" + first.ToString(string.Format("MM-dd-yyyy")) + "', 'mm-dd-yyyy') and TO_DATE('" + second.ToString(String.Format("MM-dd-yyyy")) + "', 'mm-dd-yyyy')";
DataTable table = DB_Handler.GetDataTable(query);
foreach (DataRow row in table.Rows)
{
purchases.Add(RowToEntity(row));
}
return(purchases);
}
public static List <Model.Period> GetAllPeriods()
{
List <Model.Period> period = new List <Model.Period>();
string query = "select * from PERIOD order by id";
DataTable table = DB_Handler.GetDataTable(query);
foreach (DataRow row in table.Rows)
{
period.Add(RowToEntity(row));
}
return(period);
}
public static List <Model.Order_Food> GetAllFoods()
{
List <Model.Order_Food> foods = new List <Model.Order_Food>();
string query = "select name, price, id from food where availability = 'Yes' order by id";
DataTable table = DB_Handler.GetDataTable(query);
foods.Add(new Model.Order_Food {
}); // taqui - patch
foreach (DataRow row in table.Rows)
{
foods.Add(RowToEntity(row));
}
return(foods);
}
public static List <Model.Purchase_Ingredient> GetAllIngredients()
{
List <Model.Purchase_Ingredient> ingredients = new List <Model.Purchase_Ingredient>();
string query = "select name, unit_cost, id from ingredient order by id";
DataTable table = DB_Handler.GetDataTable(query);
ingredients.Add(new Model.Purchase_Ingredient {
}); // taqui - patch
foreach (DataRow row in table.Rows)
{
ingredients.Add(RowToEntity(row));
}
return(ingredients);
}
public static List <Model.Food_Ingredient> GetUsedIngredients(int Id)
{
List <Model.Food_Ingredient> f_ingredients = new List <Model.Food_Ingredient>();
string query = "select fi.Ingredient_Id, i.Name, i.unit_cost, fi.Amount from ingredient i, food_ingredient fi where i.id = fi.ingredient_id and fi.food_id = " + Id;
DataTable table = DB_Handler.GetDataTable(query);
f_ingredients.Add(new Model.Food_Ingredient {
}); // taqui - patch
foreach (DataRow row in table.Rows)
{
f_ingredients.Add(RowToEntity(row));
}
return(f_ingredients);
}
public static List <Model.Food_Ingredient> GetUnusedIngredients(int Id)
{
List <Model.Food_Ingredient> ingredients = new List <Model.Food_Ingredient>();
string query = "select i.id, i.name, i.unit_cost from ingredient i where i.id not in (select i.id from ingredient i, food_ingredient fi where i.id = fi.ingredient_id and fi.food_id = " + Id + ") order by i.id";
DataTable table = DB_Handler.GetDataTable(query);
ingredients.Add(new Model.Food_Ingredient {
}); // taqui - patch
foreach (DataRow row in table.Rows)
{
ingredients.Add(RowToEntity2(row));
}
return(ingredients);
}
public static void loginQuery(string query)
{
DB_Handler.ExecuteQuery(query);
}
