private void btnAchizitieAdaugare_Click(object sender, EventArgs e)
{
var currentEdit = GetEditAchizitieItem();
using (LabDataContext lb = new LabDataContext())
{
var newAchizitie = new achizitie()
{
IdFurnizor = currentEdit.Furnizor,
Data = currentEdit.Data,
SerieDocument = currentEdit.SerieDocument,
NrDocument = currentEdit.NrDocument
};
lb.achizitie.Add(newAchizitie);
lb.SaveChanges();
UpdateAchizitieGrid("Adauga");
}
}
private void btnAdaugare_Click(object sender, EventArgs e)
{
var currentEdit = GetEditItem();
using (LabDataContext lb = new LabDataContext())
{
var newClient = new client()
{
Nume = currentEdit.Nume,
Varsta = (int)currentEdit.Varsta,
Sex = currentEdit.Sex,
Email = currentEdit.Email
};
lb.client.Add(newClient);
lb.SaveChanges();
UpdateGrid("Adauga");
}
}
private void btnProdusAdaugare_Click(object sender, EventArgs e)
{
var currentEdit = GetEditLinieAchizitieItem();
using (LabDataContext lb = new LabDataContext())
{
var newLinieAchizitie = new linieachizitie()
{
IdAchizitie = currentEdit.IdAchizitie,
IdProdus = currentEdit.IdProdus,
Pret = currentEdit.Pret,
Cantitate = currentEdit.Cantitate
};
lb.linieachizitie.Add(newLinieAchizitie);
lb.SaveChanges();
UpdateLinieAchizitieGrid("Adauga");
}
}
private void btnProdusAdaugare_Click(object sender, EventArgs e)
{
var currentEdit = GetEditLinieOfertaItem();
using (LabDataContext lb = new LabDataContext())
{
var newLinieOferta = new linieoferta()
{
IdOferta = currentEdit.IdOferta,
IdProdus = currentEdit.IdProdus,
PretFurnizor = currentEdit.PretFurnizor,
Cantitate = currentEdit.Cantitate
};
lb.linieoferta.Add(newLinieOferta);
lb.SaveChanges();
UpdateLinieOfertaGrid("Adauga");
}
}
private void Oferta_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'librarieDataSet.linieoferta' table. You can move, or remove it, as needed.
this.linieofertaTableAdapter.Fill(this.librarieDataSet.linieoferta);
// TODO: This line of code loads data into the 'librarieDataSet.oferta' table. You can move, or remove it, as needed.
this.ofertaTableAdapter.Fill(this.librarieDataSet.oferta);
using (LabDataContext lb = new LabDataContext())
{
cmbFurnizor.Items.Clear();
cmbFurnizor.ValueMember = "IdFurnizor";
cmbFurnizor.DisplayMember = "Nume";
cmbFurnizor.Items.AddRange(lb.furnizor.Select(x => new { x.Nume, x.IdFurnizor }).ToArray <object>());
cmbTipProdus.Items.Clear();
cmbTipProdus.ValueMember = "IdTipProdus";
cmbTipProdus.DisplayMember = "TipProdus1";
cmbTipProdus.Items.AddRange(lb.tipprodus.Select(x => new { x.TipProdus1, x.IdTipProdus }).ToArray <object>());
}
}
private void btnStergere_Click(object sender, EventArgs e)
{
var currentEdit = GetEditItem();
using (LabDataContext lb = new LabDataContext())
{
if (lb.carte.Any(x => x.IdEditura == currentEdit.Id))
{
MessageBox.Show("Editura nu poate fi stearsa.\r\nExista carti care folosesc aceasta editura.");
}
else
{
var editura = lb.editura.FirstOrDefault(x => x.IdEditura == currentEdit.Id);
lb.editura.Remove(editura);
lb.SaveChanges();
UpdateGrid("Sterge");
}
}
}
private void btnModifica_Click(object sender, EventArgs e)
{
var currentEdit = GetEditItem();
using (LabDataContext lb = new LabDataContext())
{
var IdTipProdus = lb.tipprodus.FirstOrDefault(x => x.TipProdus1.Equals(currentEdit.TipProdus)).IdTipProdus;
switch (IdTipProdus)
{
//Carte
case 1:
var getCarte = lb.carte.Where(x => x.IdCarte.Equals(currentEdit.Id)).FirstOrDefault();
getCarte.ISBN = currentEdit.ISBN;
getCarte.Titlu = currentEdit.Titlu;
getCarte.Descriere = currentEdit.Descriere;
getCarte.IdEditura = lb.editura.FirstOrDefault(x => x.Nume.Equals(currentEdit.Editura)).IdEditura;
getCarte.An = (int)currentEdit.An;
getCarte.NrPagini = (int)currentEdit.NrPagini;
getCarte.Locatie = currentEdit.Locatie;
getCarte.IdAutor = lb.autor.FirstOrDefault(x => x.Nume.Equals(currentEdit.Autor)).IdAutor;
getCarte.IdDomeniu = lb.domeniu.FirstOrDefault(x => x.Domeniu1.Equals(currentEdit.Domeniu)).IdDomeniu;
lb.SaveChanges();
var getProdusCarte = lb.produs.Where(x => x.Produs1 == getCarte.IdCarte && x.IdTipProdus == IdTipProdus).FirstOrDefault();
getProdusCarte.Pret = (double)currentEdit.Pret;
getProdusCarte.Cantitate = (int)currentEdit.Cantitate;
lb.SaveChanges();
break;
//Birotica
case 2:
var getBirotica = lb.birotica.Where(x => x.IdBirotica.Equals(currentEdit.Id)).FirstOrDefault();
getBirotica.Denumire = currentEdit.Titlu;
getBirotica.Descriere = currentEdit.Descriere;
//lb.SaveChanges();
var getProdusBirotica = lb.produs.Where(x => x.Produs1 == getBirotica.IdBirotica && x.IdTipProdus == IdTipProdus).FirstOrDefault();
getProdusBirotica.Pret = (double)currentEdit.Pret;
getProdusBirotica.Cantitate = (int)currentEdit.Cantitate;
lb.SaveChanges();
break;
}
UpdateGrid("Modifica");
}
}
private void btnStergere_Click(object sender, EventArgs e)
{
var currentEdit = GetEditItem();
using (LabDataContext lb = new LabDataContext())
{
if (lb.carte.Any(x => x.IdAutor == currentEdit.Id))
{
MessageBox.Show("Domeniul nu poate fi sters.\r\nExista carti care folosesc acest domeniu.");
}
else
{
var domeniu = lb.domeniu.FirstOrDefault(x => x.IdDomeniu == currentEdit.Id);
lb.domeniu.Remove(domeniu);
lb.SaveChanges();
UpdateGrid("Sterge");
}
}
}
private void btnAdaugare_Click(object sender, EventArgs e)
{
var currentEdit = GetEditItem();
using (LabDataContext lb = new LabDataContext())
{
var newFurnizor = new furnizor()
{
Nume = currentEdit.Nume,
CUI = currentEdit.CUI,
Sold = (double)currentEdit.Sold,
Email = currentEdit.Email,
Telefon = currentEdit.Telefon
};
lb.furnizor.Add(newFurnizor);
lb.SaveChanges();
UpdateGrid("Adauga");
}
}
public static bool Connect(string id, string password)
{
return(true);
using (LabDataContext lb = new LabDataContext())
{
var utilizator = lb.utilizator.FirstOrDefault(x => x.IdUtilizator.Equals(id) && x.Parola.Equals(password));
if (utilizator != null)
{
Utilizator = utilizator.IdUtilizator;
GradSecuritate = utilizator.GradSecuritate;
return(true);
}
else
{
MessageBox.Show("Utilizatorul sau parola nu sunt introduse corect");
return(false);
}
}
}
private void btnOfertaStergere_Click(object sender, EventArgs e)
{
var currentEdit = GetEditOfertaItem();
DialogResult dialogResult = MessageBox.Show("ATENTIE!\r\nEsti sigur ca vrei sa stergi aceasta oferta?\r\nVei sterge si toate detaliile pe produse la oferta!", "Sterge Oferta", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (LabDataContext lb = new LabDataContext())
{
var liniiOferta = lb.linieoferta.Where(x => x.IdOferta == currentEdit.Id).ToList();
lb.linieoferta.RemoveRange(liniiOferta);
lb.SaveChanges();
var oferta = lb.oferta.FirstOrDefault(x => x.IdOferta == currentEdit.Id);
lb.oferta.Remove(oferta);
lb.SaveChanges();
UpdateOfertaGrid("");
}
}
}
private void btnAchizitieStergere_Click(object sender, EventArgs e)
{
var currentEdit = GetEditAchizitieItem();
DialogResult dialogResult = MessageBox.Show("ATENTIE!\r\nEsti sigur ca vrei sa stergi aceasta achizitie?\r\nVei sterge si toate detaliile pe produse la achizitie!", "Sterge achizitia", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (LabDataContext lb = new LabDataContext())
{
var liniiAchizitii = lb.linieachizitie.Where(x => x.IdAchizitie == currentEdit.Id).ToList();
lb.linieachizitie.RemoveRange(liniiAchizitii);
lb.SaveChanges();
var achizitie = lb.achizitie.FirstOrDefault(x => x.IdAchizitie == currentEdit.Id);
lb.achizitie.Remove(achizitie);
lb.SaveChanges();
UpdateAchizitieGrid("");
}
}
}
private void btnAdaugare_Click(object sender, EventArgs e)
{
var currentEdit = GetEditItem();
using (LabDataContext lb = new LabDataContext())
{
var newPlata = new plata()
{
Data = currentEdit.Data,
IdAchizitie = IdAchizitieSelected,
IdFurnizor = currentEdit.Furnizor,
SerieDocument = currentEdit.SerieDocument,
NrDocument = currentEdit.NrDocument,
Suma = currentEdit.Suma
};
lb.plata.Add(newPlata);
lb.SaveChanges();
UpdateGrid("Adauga");
}
}
private void btnStergere_Click(object sender, EventArgs e)
{
var currentEdit = GetEditItem();
DialogResult dialogResult = MessageBox.Show("ATENTIE!\r\nDaca stergi acest furnizor vei sterge si toate tranzactiile legate de furnizor\r\nVrei sa continui?", "StergeFurnizor", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (LabDataContext lb = new LabDataContext())
{
var furnizor = lb.furnizor.FirstOrDefault(x => x.IdFurnizor == currentEdit.Id);
lb.furnizor.Remove(furnizor);
lb.SaveChanges();
UpdateGrid("Sterge");
}
}
else if (dialogResult == DialogResult.No)
{
UpdateGrid("");
}
}
private void btnAdaugare_Click(object sender, EventArgs e)
{
var currentEdit = GetEditItem();
using (LabDataContext lb = new LabDataContext())
{
if (lb.domeniu.Any(x => x.Domeniu1.Equals(currentEdit.Domeniu, StringComparison.OrdinalIgnoreCase)))
{
MessageBox.Show("Exista deja domeniu cu acest nume.");
}
else
{
var newDomeniu = new domeniu()
{
Domeniu1 = currentEdit.Domeniu,
};
lb.domeniu.Add(newDomeniu);
lb.SaveChanges();
UpdateGrid("Adauga");
}
}
}
private EditLinieOfertaItem GetEditLinieOfertaItem()
{
var selectedTipProdus = (dynamic)cmbTipProdus.SelectedItem;
var selectedProdus = (dynamic)cmbProdus.SelectedItem;
var IdProdus = -1;
using (LabDataContext lb = new LabDataContext())
{
int selectedIdTipProdus = selectedTipProdus.IdTipProdus;
int selectedIdProdus = selectedProdus.Id;
IdProdus = lb.produs.FirstOrDefault(x => x.IdTipProdus == selectedIdTipProdus && x.Produs1 == selectedIdProdus).IdProdus;
}
var newEdit = new EditLinieOfertaItem()
{
IdOferta = IdOfertaSelected,
IdProdus = IdProdus,
PretFurnizor = (double)tbPret.Value,
Cantitate = (int)tbCantitate.Value
};
return(newEdit);
}
private void btnAdaugare_Click(object sender, EventArgs e)
{
var currentEdit = GetEditItem();
using (LabDataContext lb = new LabDataContext())
{
if (lb.editura.Any(x => x.Nume.Equals(currentEdit.Nume, StringComparison.OrdinalIgnoreCase)))
{
MessageBox.Show("Exista deja editura cu acest nume.");
}
else
{
var newEditura = new editura()
{
Nume = currentEdit.Nume,
};
lb.editura.Add(newEditura);
lb.SaveChanges();
UpdateGrid("Adauga");
}
}
}
public RelacaoTipoRepositorio(LabDataContext labDataContext) : base(labDataContext)
{
}
public PessoaJuridicaRepositorio(LabDataContext labDataContext) : base(labDataContext)
{
}
public FormaPagamentoRepositorio(LabDataContext labDataContext) : base(labDataContext)
{
}
public PessoaTipoRepositorio(LabDataContext labDataContext) : base(labDataContext)
{
}
public UsuarioRepositorio(LabDataContext labDataContext) : base(labDataContext)
{
}
public PedidoRepositorio(LabDataContext labDataContext) : base(labDataContext)
{
}
public EstadoRepositorio(LabDataContext labDataContext) : base(labDataContext)
{
}
public SubCategoriaProdutoRepositorio(LabDataContext labDataContext) : base(labDataContext)
{
}
public ProdutoRepositorio(LabDataContext labDataContext) : base(labDataContext)
{
}
public TelefoneRepositorio(LabDataContext labDataContext) : base(labDataContext)
{
}
public EnderecoPessoaRepositorio(LabDataContext labDataContext) : base(labDataContext)
{
}
public CidadeRepositorio(LabDataContext labDataContext) : base(labDataContext)
{
}
public BaseRepositorio(LabDataContext labDataContext)
{
LabDataContext = labDataContext;
}
