void RefershStats()
{
dbEntities1 context = new dbEntities1();
cntUser.Text = context.Vartotojas.Count().ToString();
cntCategory.Text = context.Kategorija.Count().ToString();
cntProduct.Text = context.Preke.Count().ToString();
cntTransactions.Text = context.Transakcijos.Count().ToString();
}
public NaujaPreke()
{
InitializeComponent();
context = new dbEntities1();
var k = context.Set <Kategorija>();
foreach (var item in k)
{
comboBox1.Items.Add(item.Vardas);
}
comboBox1.SelectedIndex = 0;
}
private void updateTable()
{
listView1.Items.Clear();
context = new dbEntities1();
var products = context.Set <Preke>();
foreach (var item in products)
{
string[] arr =
{
item.Kategorija.Vardas,
item.Kiekis.ToString(),
item.Kaina.ToString()
};
listView1.Items.Add(item.Pavadinimas).SubItems.AddRange(arr);
}
}
public NaujaPreke(ListViewItem a)
{
InitializeComponent();
Text = "Prekės redagavimas";
button2.Text = "Atnaujinti";
context = new dbEntities1();
var k = context.Set <Kategorija>();
foreach (var item in k)
{
comboBox1.Items.Add(item.Vardas);
}
comboBox1.SelectedIndex = comboBox1.Items.IndexOf(a.SubItems[1].Text);
textBox1.Text = a.SubItems[0].Text;
textBox3.Text = a.SubItems[2].Text;
textBox4.Text = a.SubItems[3].Text;
pavadinimas = textBox1.Text;
update = true;
}
public PrekiuValdymas()
{
context = new dbEntities1();
InitializeComponent();
updateTable();
}
public VartotojuValdymas()
{
InitializeComponent();
context = new dbEntities1();
updateTable();
}