private static void AdaugareCumparatori()
{
using (var ctx = new LicitatiiContext())
{
ctx.Utilizatori.Add(
new Cumparator()
{
Nume = "Popa",
Prenume = "Vasile",
Username = "******",
Password = "******",
CNP = "1xxxxxxxxxxxx",
Telefon = "07********"
}
);
ctx.Utilizatori.Add(
new Cumparator()
{
Nume = "Popescu",
Prenume = "Ana-Maria",
Username = "******",
Password = "******",
CNP = "2xxxxxxxxxxxx",
Telefon = "07********"
}
);
ctx.SaveChanges();
}
}
private static void AdaugareVanzatori()
{
using (var ctx = new LicitatiiContext())
{
try
{
ctx.Utilizatori.Add(
new Vanzator()
{
Adresa = "Brasov, Brasov, Paraului nr. 5",
Nume = "Draghia",
Prenume = "Alin",
Username = "******",
Password = "******"
}
);
ctx.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
}
}
private void btnLiciteaza_Click(object sender, EventArgs e)
{
dynamic produsCurent = produsBindingSource.Current;
using (var ctx = new LicitatiiContext())
{
int produsId = produsCurent.Id;
var produsDb = ctx.Produse
.Where(p => p.Id == produsId)
.FirstOrDefault();
Decimal pretCurent;
Decimal.TryParse(tbPretLicitat.Text, out pretCurent);
if (produsDb.PretLicitat >= pretCurent || produsDb.PretDeInceput >= pretCurent)
{
errorProvider1.SetError(tbPretLicitat.TextBox, "Pretul licitat trebuie sa fie mai mare decat pretul curent.");
}
else
{
errorProvider1.SetError(tbPretLicitat.TextBox, null);
produsDb.CumparatorId = Program.Cumparator.Id;
produsDb.PretLicitat = pretCurent;
ctx.SaveChanges();
}
}
RefreshData();
}
private static void ListareCumparatori()
{
using (var ctx = new LicitatiiContext())
{
Console.WriteLine("Listare cumparatori");
var cumparatori = ctx.Utilizatori.OfType <Cumparator>().ToList();
foreach (var cumparator in cumparatori)
{
Console.WriteLine(cumparator.ToString());
}
}
}
private static void ListareVanzatori()
{
using (var ctx = new LicitatiiContext())
{
Console.WriteLine("Listare vanzatori");
var vanzatori = ctx.Utilizatori.OfType <Vanzator>().ToList();
foreach (var vanzator in vanzatori)
{
Console.WriteLine(vanzator);
}
}
}
static void Main()
{
using (var ctx = new LicitatiiContext())
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
var formAuth = new FormAutentificare();
var ret = formAuth.ShowDialog();
if (ret == DialogResult.OK)
{
Application.Run(new FormCumparator());
}
}
}
static void Main()
{
using (var ctx = new LicitatiiContext())
{
//ctx.Configuration.ProxyCreationEnabled = false;
Context = ctx;
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
var formularAutentificare = new FormularAutentificare();
var rezultatAutenficare = formularAutentificare.ShowDialog();
if (rezultatAutenficare == DialogResult.OK)
{
Application.Run(new FormVanzator());
}
//Application.Run();
//Application.Run(new Form1());
}
}
private void RefreshData()
{
Filtru filtru;
Enum.TryParse <Filtru>(cbFiltru.ComboBox.SelectedValue.ToString(), out filtru);
switch (filtru)
{
case Filtru.Active:
using (var ctx = new LicitatiiDAL.LicitatiiContext())
{
var produse = ctx.Produse
.Where(p => p.DataDeSfarsit > DateTime.Now)
.Select(p => new {
p.Id,
p.Nume,
p.Descriere,
p.DataDeInceput,
p.DataDeSfarsit,
p.PretDeInceput,
p.PretLicitat,
p.CumparatorId,
p.VanzatorId,
Vanzator = p.Vanzator.Nume + " " + p.Vanzator.Prenume
}).ToList();
produsBindingSource.DataSource = produse;
}
break;
case Filtru.Cumparate:
using (var ctx = new LicitatiiDAL.LicitatiiContext())
{
var cumparator = ctx
.Utilizatori
.OfType <LicitatiiDAL.Cumparator>()
.Where(c => c.Id == Program.Cumparator.Id).FirstOrDefault();
var produse = cumparator.Produs
.Where(p => p.DataDeSfarsit < DateTime.Now)
.Select(p => new {
p.Id,
p.Nume,
p.Descriere,
p.DataDeInceput,
p.DataDeSfarsit,
p.PretDeInceput,
p.PretLicitat,
p.CumparatorId,
p.VanzatorId,
Vanzator = p.Vanzator.Nume + " " + p.Vanzator.Prenume
}).ToList();
produsBindingSource.DataSource = produse;
}
break;
case Filtru.Licitate:
using (var ctx = new LicitatiiContext())
{
var cumparator = ctx
.Utilizatori
.OfType <LicitatiiDAL.Cumparator>()
.Where(c => c.Id == Program.Cumparator.Id).FirstOrDefault();
var produse = cumparator.Produs
.Where(p => p.DataDeSfarsit > DateTime.Now)
.Select(p => new
{
p.Id,
p.Nume,
p.Descriere,
p.DataDeInceput,
p.DataDeSfarsit,
p.PretDeInceput,
p.PretLicitat,
p.CumparatorId,
p.VanzatorId,
Vanzator = p.Vanzator.Nume + " " + p.Vanzator.Prenume
}).ToList();
produsBindingSource.DataSource = produse;
}
break;
default:
break;
}
using (var ctx = new LicitatiiContext())
{
var totalCheltuit = ctx.Produse
.Where(p => p.CumparatorId == Program.Cumparator.Id && p.DataDeSfarsit < DateTime.Now)
.Select(p => new { val = p.PretLicitat })
.Sum(p => p.val).GetValueOrDefault(0.0m);
tbTotalCheltuit.Text = totalCheltuit.ToString();
}
}
