public EditAantal()
{
InitializeComponent();
Global.ModifyForm(this);
nudAantal.Maximum = Decimal.MaxValue;
nudAantal.Value = AddOrder.aantal;
}
public EditProduct()
{
InitializeComponent();
Global.ModifyForm(this);
using (var ctx = new ProjectContext())
{
Leveranciers = ctx.Levranciers.ToList();
}
cmbLeverancier.DataSource = Leveranciers;
txtNaam.Text = Databeheer.product.ProductNaam;
prNaam = Databeheer.product.ProductNaam;
txtUnitprice.Text = Databeheer.product.UnitPrice.ToString();
txtUnitsOnStock.Text = Databeheer.product.UnitsOnStock.ToString();
txtProductNummer.Text = Databeheer.product.ProductNummer.ToString();
prNummer = Databeheer.product.ProductNummer.ToString();
txtBarcode.Text = Databeheer.product.BarCode;
prBarcode = Databeheer.product.BarCode;
txtGewicht.Text = Databeheer.product.Gewicht.ToString();
txtBreedte.Text = Databeheer.product.Breedte.ToString();
txtLengte.Text = Databeheer.product.Lengte.ToString();
txtHoogte.Text = Databeheer.product.Hoogte.ToString();
cmbLeverancier.Text = Databeheer.product.levrancier.ToString();
rtbOmschrijving.Text = Databeheer.product.Omschrijving;
cmb_Leveranciere = cmbLeverancier;
}
public Databeheer()
{
InitializeComponent();
Global.ModifyForm(this);
if (Login.user.Role == RoleUser.Admin)
{
userToolStripMenuItem.Enabled = true;
productToolStripMenuItem.Enabled = true;
klantToolStripMenuItem.Enabled = true;
bezorgersToolStripMenuItem.Enabled = true;
}
if (Login.user.Role == RoleUser.Magazijnier)
{
userToolStripMenuItem.Enabled = false;
productToolStripMenuItem.Enabled = true;
klantToolStripMenuItem.Enabled = false;
bezorgersToolStripMenuItem.Enabled = false;
}
if (Login.user.Role == RoleUser.Verkoper)
{
userToolStripMenuItem.Enabled = false;
productToolStripMenuItem.Enabled = false;
klantToolStripMenuItem.Enabled = true;
bezorgersToolStripMenuItem.Enabled = false;
}
}
public AddBezorger()
{
InitializeComponent();
using (var ctx = new ProjectContext())
Adresses = ctx.Adressen.ToList();
cmbAdress.DataSource = Adresses;
Global.ModifyForm(this);
}
public Overzicht()
{
InitializeComponent();
Global.ModifyForm(this);
Main.ActiveForm.Close();
nudTop.Value = 10;
crtTopverkocht.ChartAreas["ChartArea1"].AxisX.Interval = 1;
}
public AddUser()
{
InitializeComponent();
cmbRoles.DataSource = Enum.GetValues(typeof(RoleUser));
using (var ctx = new ProjectContext())
Adresses = ctx.Adressen.ToList();
cmbAdress.DataSource = Adresses;
Global.ModifyForm(this);
}
public AddProduct()
{
InitializeComponent();
using (var ctx = new ProjectContext())
{
Leveranciers = ctx.Levranciers.ToList();
}
cmbLeverancier.DataSource = Leveranciers;
cmb_Leveranciere = cmbLeverancier;
cmbLeverancier.SelectedIndex = -1;
Global.ModifyForm(this);
}
public EditOrder()
{
InitializeComponent();
Global.ModifyForm(this);
using (var ctx = new ProjectContext())
{
Klanten = ctx.Klanten.Include("adress").ToList();
Producten = ctx.Products.Include("levrancier").Where(p => p.UnitsOnStock > 0).ToList();
Bezorgers = ctx.Bezorgers.ToList();
ProductsOrdered = ctx.OrderDetails.Where(o => o.order.OrderId == Bestellingen.orderline.orderid).Join(ctx.Products, od => od.product.ProductId, p => p.ProductId, (od, p) => new ProductOrdered()
{
ProductId = p.ProductId, ProductNaam = p.ProductNaam, levrancier = p.levrancier, UnitPrice = p.UnitPrice, Omschrijving = p.Omschrijving, aantal = od.Aantal
}).ToList();
}
cmb_Klanten = cmbKlanten;
dgv_OrderProducten = dgvOrderProducten;
dgvOrderProducten.DataSource = ProductsOrdered;
DataGridViewButtonColumn EditButtonColumn = new DataGridViewButtonColumn();
EditButtonColumn.Name = "Aantal Bewerken";
EditButtonColumn.Text = "Bewerk Aantal";
EditButtonColumn.UseColumnTextForButtonValue = true;
DataGridViewButtonColumn DeleteButtonColumn = new DataGridViewButtonColumn();
DeleteButtonColumn.Name = "Verwijderen";
DeleteButtonColumn.Text = "Verwijder";
DeleteButtonColumn.UseColumnTextForButtonValue = true;
dgvOrderProducten.Columns.Insert(dgvOrderProducten.Columns.Count, EditButtonColumn);
dgvOrderProducten.Columns.Insert(dgvOrderProducten.Columns.Count, DeleteButtonColumn);
dgvOrderProducten.Columns["Verwijderen"].DisplayIndex = 7;
dgvOrderProducten.Columns["Aantal Bewerken"].DisplayIndex = 6;
if (dgvOrderProducten.Height < 250)
{
dgvOrderProducten.Height = dgvOrderProducten.Rows.GetRowsHeight(DataGridViewElementStates.None) + dgvOrderProducten.ColumnHeadersHeight + 2;
}
cmbKlanten.SelectedIndexChanged -= new System.EventHandler(cmbKlanten_SelectedIndexChanged);
cmbKlanten.DataSource = Klanten;
cmbKlanten.Text = Bestellingen.orderline.klant.ToString();
cmbKlanten.SelectedIndexChanged += new System.EventHandler(cmbKlanten_SelectedIndexChanged);
cmb_Klanten = cmbKlanten;
cmbBezorgers.DataSource = Bezorgers;
cmbProducten.SelectedIndexChanged -= new System.EventHandler(cmbProducten_SelectedIndexChanged);
cmbProducten.DataSource = Producten;
cmbProducten.SelectedIndexChanged += new System.EventHandler(cmbProducten_SelectedIndexChanged);
cmbStatus.DataSource = Enum.GetValues(typeof(OrderStatus));
cmbStatus.SelectedItem = Bestellingen.orderline.status;
cmbBezorgers.SelectedItem = Bestellingen.orderline.bezorgddoor;
lblKlantAdress.Text = Bestellingen.orderline.adress.ToString();
}
public EditBezorger()
{
InitializeComponent();
Global.ModifyForm(this);
using (var ctx = new ProjectContext())
Adresses = ctx.Adressen.ToList();
cmbAdress.DataSource = Adresses;
txtNaam.Text = Databeheer.bezorger.Naam;
rtbOmschrijving.Text = Databeheer.bezorger.Omschrijving;
txtTel1.Text = Databeheer.bezorger.Telefoon1;
txtTel2.Text = Databeheer.bezorger.Telefoon2;
txtEmail.Text = Databeheer.bezorger.Email;
cmbAdress.Text = Databeheer.bezorger.adress.ToString();
}
public Bestellingen()
{
InitializeComponent();
Global.ModifyForm(this);
Main.ActiveForm.Close();
dgv_Orders = dgvOrders;
using (var ctx = new ProjectContext())
{
OrderLines = ctx.Orders.Join(ctx.OrderDetails, o => o.OrderId, od => od.order.OrderId, (o, od) => new OrderLine()
{
orderid = o.OrderId, klant = o.klant, user = o.user, orderdate = o.OrderDatum, status = o.status, bezorgddoor = o.BezorgdDoor, adress = o.BezorgdAdress, orderdetailid = od.ID, product = od.product, aantal = od.Aantal
}).OrderByDescending(o => o.orderdate).ToList();
}
loaddgvOrders();
}
public EditUser()
{
InitializeComponent();
Global.ModifyForm(this);
newAd = false;
cmbRoles.DataSource = Enum.GetValues(typeof(RoleUser));
using (var ctx = new ProjectContext())
Adresses = ctx.Adressen.ToList();
cmbAdress.DataSource = Adresses;
txtVnaam.Text = Databeheer.user.Voornaam;
txtAnaam.Text = Databeheer.user.Achternaam;
dtpGD.Value = Databeheer.user.Geboortdatum;
txtTel.Text = Databeheer.user.Telefoon;
txtEmail.Text = Databeheer.user.Email;
cmbAdress.SelectedItem = Databeheer.user.adress;
cmbRoles.SelectedItem = Databeheer.user.Role;
}
public Main()
{
InitializeComponent();
Global.ModifyForm(this);
lblUser.Text = Program.user.Voornaam + " " + Program.user.Achternaam;
if (Login.user.Role != RoleUser.Admin)
{
if (Login.user.Role != RoleUser.Verkoper)
{
btnBestelling.Enabled = false;
btnOverzicht.Enabled = false;
}
else
{
btnOverzicht.Enabled = false;
}
}
}
public EditKlant()
{
InitializeComponent();
Global.ModifyForm(this);
newAd = false;
using (var ctx = new ProjectContext())
Adresses = ctx.Adressen.ToList();
cmbAdress.DataSource = Adresses;
txtVnaam.Text = Databeheer.klant.Voornaam;
txtAnaam.Text = Databeheer.klant.achternaam;
dtpGD.Value = Databeheer.klant.Geboortdatum;
txtTel1.Text = Databeheer.klant.Telefoon1;
txtTel2.Text = Databeheer.klant.Telefoon2;
txtEmail.Text = Databeheer.klant.Email;
cmbAdress.SelectedItem = Databeheer.klant.adress;
txtBTW.Text = Databeheer.klant.BTWNummer;
rtbComentaar.Text = Databeheer.klant.Commentaar;
cbBedrijf.Checked = Databeheer.klant.IsBedrijf;
}
public AddOrder()
{
InitializeComponent();
using (var ctx = new ProjectContext())
{
Klanten = ctx.Klanten.Include("adress").ToList();
Producten = ctx.Products.Include("levrancier").Where(p => p.UnitsOnStock > 0).ToList();
Bezorgers = ctx.Bezorgers.ToList();
}
dgv_OrderProducten = dgvOrderProducten;
cmbKlanten.DataSource = Klanten;
cmbBezorgers.DataSource = Bezorgers;
cmbBezorgers.SelectedIndex = -1;
cmb_Klanten = cmbKlanten;
cmbProducten.SelectedIndexChanged -= new System.EventHandler(cmbProducten_SelectedIndexChanged);
cmbProducten.DataSource = Producten;
cmbProducten.SelectedIndexChanged += new System.EventHandler(cmbProducten_SelectedIndexChanged);
cmbStatus.DataSource = Enum.GetValues(typeof(OrderStatus));
Global.ModifyForm(this);
if (dgvOrderProducten.Height < 250)
{
dgvOrderProducten.Height = dgvOrderProducten.Rows.GetRowsHeight(DataGridViewElementStates.None) + dgvOrderProducten.ColumnHeadersHeight + 2;
}
}
