public FormAddItem()
{
InitializeComponent();
ctx = new PizzaServiceDataEF.PizzaServiceEntities();
SetTabIndexes(this);
}
public FormAdministration()
{
InitializeComponent();
ctx = new PizzaServiceDataEF.PizzaServiceEntities();
var orderHeaders = (from header in ctx.ORDER_HEADERS
select header).OrderByDescending(x => x.OH_DATE);
var historyHeaders = (from h in ctx.HISTORY_HEADERS
select h).OrderByDescending(x => x.HH_DATE);
var items = (from i in ctx.ITEMS
orderby i.I_CATEGORY, i.I_NAME
select i);
var customers = (from c in ctx.CUSTOMERS
select c);
var users = (from u in ctx.USERS
select u);
var stores = (from s in ctx.STORES
select s);
sTORESBindingSource.DataSource = stores.ToList();
uSERSBindingSource.DataSource = users.ToList();
iTEMSBindingSource.DataSource = items.ToList();
hISTORYHEADERSBindingSource.DataSource = historyHeaders.ToList();
cUSTOMERSBindingSource.DataSource = customers.ToList();
oRDERHEADERSBindingSource.DataSource = orderHeaders.ToList();
}
public FormTransaction(double sum)
{
InitializeComponent();
ctx = new PizzaServiceEntities();
labelSum.Text = sum.ToString() + " грн.";
SetTabIndexes(this);
}
public FormPizzaOrder(int user)
{
InitializeComponent();
ctx = new PizzaServiceDataEF.PizzaServiceEntities();
orderLines = new List <int>();
user_id = user;
InitializePizza();
}
public FormMaps(int storeID, string address_)
{
InitializeComponent();
store_id = storeID;
ctx = new PizzaServiceEntities();
address = address_;
SetMapRoute();
}
public FormPizzaAdd(string pizzaName, List <int> orders)
{
InitializeComponent();
pizza = pizzaName;
ctx = new PizzaServiceDataEF.PizzaServiceEntities();
this.Text = pizza;
orderLines = orders;
var query = (from i in ctx.ITEMS
where (i.I_NAME == pizza)
select i);
iTEMSBindingSource.DataSource = query.ToList();
labelPrice.Text = dataGridViewSizes.Rows[0].Cells["iPRICEDataGridViewTextBoxColumn"].Value.ToString() + " грн.";
}
public FormHistoryOrderSelected(int header, int user)
{
InitializeComponent();
ctx = new PizzaServiceDataEF.PizzaServiceEntities();
history_header = header;
user_id = user;
var query = (from line in ctx.HISTORY_LINES
where line.HL_ORDER_HEADER == history_header
select line);
var items = (from i in ctx.ITEMS
select i);
iTEMSBindingSource.DataSource = items.ToList();
hISTORYLINESBindingSource.DataSource = query.ToList();
}
public FormItemAdd(int id, List <int> orders)
{
InitializeComponent();
orderLines = orders;
item_id = id;
ctx = new PizzaServiceDataEF.PizzaServiceEntities();
var item = (from i in ctx.ITEMS
where i.I_ID == item_id
select i).First();
name = item.I_NAME;
price = (double)item.I_PRICE;
sumPrice = price * quantity;
this.Text = name;
labelPrice.Text = "Усього: " + sumPrice.ToString() + " грн.";
labelName.Text = name;
}
public FormOrderHeader(List <int> orders, int user_id, double s)
{
InitializeComponent();
ctx = new PizzaServiceDataEF.PizzaServiceEntities();
orderLines = orders;
user = user_id;
sum = s;
o_header_id = 0;
if (ctx.ORDER_HEADERS.Count() != 0)
{
var nonQuery = (from h in ctx.ORDER_HEADERS
select h.OH_ID).Max();
o_header_id = nonQuery;
}
labelOrder.Text += (o_header_id + 1).ToString();
iTEMSBindingSource.DataSource = ctx.ITEMS.ToList();
SetTabIndexes(this);
}
public FormMaps()
{
InitializeComponent();
ctx = new PizzaServiceEntities();
SetMap();
}
public FormReviewAdding(int customer)
{
InitializeComponent();
ctx = new PizzaServiceDataEF.PizzaServiceEntities();
customer_id = customer;
}