public ActualizeazaAngajat(int id_angajat) { InitializeComponent(); using (var context = new HramulEntities()) { Angajati angajat = (from a in context.Angajatis where a.ID_ANGAJAT == id_angajat select a).First(); tbNume.Text = angajat.Nume; tbPrenume.Text = angajat.Prenume; tbFunctie.Text = angajat.Functie; tbAdresa.Text = angajat.Adresa; cbRating.Text = angajat.Rating.ToString(); cbDepartament.Text = (from d in context.Departamentes where d.ID_DEPARTAMENT == angajat.ID_DEPARTAMENT select d.Denumire).First(); tbSalariu.Text = (from s in context.State_de_platas where s.TIP_PLATA.Equals("SALARIU") where s.ID_ANGAJAT == 12 select s.Suma).First().ToString(); btSalveaza.Name = "Actualizeaza"; btSalveaza.Text = "Actualizeaza"; btSalveaza.Click -= btSalveaza_Click; btSalveaza.Click += (sender, e) => btActualizeaza_Click(id_angajat); FormBorderStyle = FormBorderStyle.FixedToolWindow; } }
private void menutItemPrima_Click(int id_angajat) { Form form = new PrimaInputForm(id_angajat); form.ShowDialog(); MessageBox.Show("Prima a fost adaugata"); using (var context = new HramulEntities()) { var results = from s in context.State_de_platas where s.ID_ANGAJAT == id_angajat select new { s.ID_PLATA, s.Suma, s.TIP_PLATA, s.Data }; dataGridViewState.DataSource = results.ToList(); } InitializeMyComponenets(); }
private void buttonAdd_Click(object sender, EventArgs e) { var client_name = comboBoxClient.Text; int client_ID = -1; foreach (var item in clientiQuery) { if (item.Nume == client_name) { client_ID = item.ID_CLIENT; } } var date = dateTimePicker3.Value.Date.ToString(); //TODO va lua ID ANGAJAT din username using (var context = new HramulEntities()) { ObjectParameter empID = new ObjectParameter("EmpID", typeof(int)); ObjectParameter cliID = new ObjectParameter("CliID", typeof(int)); ObjectParameter ordID = new ObjectParameter("Order_ID", typeof(int)); ObjectParameter dateest = new ObjectParameter("DateEST", typeof(DateTime)); context.MakeOrder(1, DateTime.Parse(date), client_ID, ordID); orderID = (int)ordID.Value; statuslabel_Comanda_ID.Text = "Comanda ID: " + orderID.ToString(); } GridViewComenzi.DataSource = (from c in context.ComenziExtendeds select c).ToList(); }
private void tbSearch_TextChanged(object sender, EventArgs e) { string name = tbSearch.Text; using (var context = new HramulEntities()) { var results = (from a in context.Angajatis join d in context.Departamentes on a.ID_DEPARTAMENT equals d.ID_DEPARTAMENT join s in context.State_de_platas on a.ID_ANGAJAT equals s.ID_ANGAJAT where s.TIP_PLATA.Equals("SALARIU") where s.Data.Value.Year == DateTime.Today.Year where s.Data.Value.Month == DateTime.Today.Month where a.Nume.StartsWith(name) orderby a.Nume select new { a.ID_ANGAJAT, a.Nume, a.Prenume, a.Adresa, a.Rating, a.Functie, a.Activ, d.Denumire, s.Suma }).ToList(); dataGridView.DataSource = results; } }
private void InitializeMyComponenets() { using (var context = new HramulEntities()) { var results = from a in context.Angajatis join d in context.Departamentes on a.ID_DEPARTAMENT equals d.ID_DEPARTAMENT join aa in context.SalariiCurentes on a.ID_ANGAJAT equals aa.ID_ANGAJAT orderby a.Nume select new { a.ID_ANGAJAT, a.Nume, a.Prenume, a.Adresa, a.Rating, a.Functie, a.Activ, d.Denumire, aa.Salariu }; dataGridView.DataSource = results.ToList(); tssNumarAngajati.Text = "Total Angajati: " + (from a in context.Salariis select a).Count(); tssTotalSalarii.Text = "Total salarii: " + (from a in context.Salariis select a.Salariu).Sum(); } }
private void menuItemActualizeaza_Click(int id_angajat) { using (var context = new HramulEntities()) { Form form = new ActualizeazaAngajat(id_angajat); form.ShowDialog(); InitializeMyComponenets(); } }
private void InitializeMyComponents() { string[] rating = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "10" }; cbRating.DataSource = rating; using (var context = new HramulEntities()) { var results = (from d in context.Departamentes select d.Denumire).ToList(); cbDepartament.DataSource = results; } }
private void btDataBase_Click(object sender, EventArgs e) { using (var context = new HramulEntities()) { var angajati = (from a in context.Salariis select a).ToList(); DataGridView grid = new DataGridView(); grid.DataSource = angajati; Controls.Add(grid); Controls.Remove(grid); PdfPTable pdfTable = new PdfPTable(grid.ColumnCount); pdfTable.DefaultCell.Padding = 3; pdfTable.WidthPercentage = 60; pdfTable.HorizontalAlignment = iTextSharp.text.Element.ALIGN_LEFT; pdfTable.DefaultCell.BorderWidth = 1; foreach (DataGridViewColumn column in grid.Columns) { PdfPCell cell = new PdfPCell(new iTextSharp.text.Phrase(column.HeaderText)); cell.BackgroundColor = new iTextSharp.text.Color(240, 240, 240); pdfTable.AddCell(cell); } foreach (DataGridViewRow row in grid.Rows) { foreach (DataGridViewCell cell in row.Cells) { pdfTable.AddCell(cell.Value.ToString()); } } string file = "DataBaseExport.pdf"; using (FileStream stream = new FileStream(file, FileMode.Create)) { iTextSharp.text.Document pdfDoc = new iTextSharp.text.Document(iTextSharp.text.PageSize.A2, 10f, 10f, 10f, 0f); PdfWriter.GetInstance(pdfDoc, stream); pdfDoc.Open(); pdfDoc.Add(pdfTable); pdfDoc.Close(); stream.Close(); } } MessageBox.Show("Baza de date a fost exportata"); }
private void btLogin_Click(object sender, EventArgs e) { string userName = tbUserName.Text; string parola = tbPassword.Text; using (var context = new HramulEntities()) { try { User user = (from u in context.Users where u.Username.Equals(userName) select u).First(); byte[] hash = MD5.Create().ComputeHash(ASCIIEncoding.ASCII.GetBytes(parola)); byte[] userHash = user.Password; for(int i = 0; i < hash.Count(); i++) { if (hash[i] != userHash[i]) throw new Exception(); } tbUserName.Hide(); tbPassword.Hide(); btLogin.Hide(); lbLogin.Visible = true; lbLogin.Text += userName; LOGGED_IN = true; DEPARTAMENT = (from d in context.Departamentes join a in context.Angajatis on d.ID_DEPARTAMENT equals a.ID_DEPARTAMENT join u in context.Users on a.ID_ANGAJAT equals u.ID_ANGAJAT where u.ID_ANGAJAT == user.ID_ANGAJAT select d.Denumire ).First(); } catch(Exception exception) { MessageBox.Show("Username-ul/parolele nu se potrivesc", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
public MainForm() { InitializeComponent(); using (var context = new HramulEntities()) { ObjectParameter cheltuieli = new ObjectParameter("Cheltuieli", typeof(decimal)); ObjectParameter castiguri = new ObjectParameter("Castiguri", typeof(decimal)); context.CalculateProfit(cheltuieli,castiguri); tssCheltuieli.Text += cheltuieli.Value; tssCastiguri.Text += castiguri.Value; lbDate.Text = DateTime.Today.ToString(); } }
private void btOK_Click(int id_angajat) { decimal suma = decimal.Parse(tbPrima.Text); using (var context = new HramulEntities()) { State_de_plata stat = new State_de_plata { ID_ANGAJAT = id_angajat, Suma = suma, Data = DateTime.Today, TIP_PLATA = "PRIMA" }; context.State_de_platas.Add(stat); context.SaveChanges(); } Hide(); }
private void dataGridView_MouseDown(object sender, MouseEventArgs e) { try { int row = dataGridView.HitTest(e.X, e.Y).RowIndex; var id_angajat = int.Parse(dataGridView.Rows[row].Cells[0].FormattedValue.ToString()); if (e.Button == MouseButtons.Left) { using (var context = new HramulEntities()) { var results = from s in context.State_de_platas where s.ID_ANGAJAT == id_angajat select new { s.ID_PLATA, s.Suma, s.TIP_PLATA, s.Data }; dataGridViewState.DataSource = results.ToList(); } } if (e.Button == MouseButtons.Right) { ContextMenu menu = new ContextMenu(); menu.MenuItems.Add(new MenuItem("Seteaza activ/inactiv", (s, ev) => menuItemSterge_Click(id_angajat))); menu.MenuItems.Add(new MenuItem("Actualizeaza", (s, ev) => menuItemActualizeaza_Click(id_angajat))); menu.MenuItems.Add(new MenuItem("Adauga prima", (s, ev) => menutItemPrima_Click(id_angajat))); menu.MenuItems.Add(new MenuItem("Creaza cont", (s, ev) => menuItemCont_Click(id_angajat))); menu.Show(dataGridView, new Point(e.X, e.Y)); } } catch (Exception exception) { MessageBox.Show("Esti in afara numarului de randuri din grid", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btInregistreaza_Click(int id_angajat) { string username = tbUtilizator.Text; string parola = tbParola.Text; byte[] hash = MD5.Create().ComputeHash(ASCIIEncoding.ASCII.GetBytes(parola)); User user = new User { Username = username, Password = hash, ID_ANGAJAT = id_angajat }; using (var context = new HramulEntities()) { context.Users.Add(user); context.SaveChanges(); Hide(); } }
private void button1_Click(object sender, EventArgs e) { string name = tbSearch.Text; using (var context = new HramulEntities()) { var results = (from a in context.Angajatis.DefaultIfEmpty() join d in context.Departamentes on a.ID_DEPARTAMENT equals d.ID_DEPARTAMENT join s in context.State_de_platas on a.ID_ANGAJAT equals s.ID_ANGAJAT where s.TIP_PLATA.Equals("SALARIU") where s.Data.Value.Year == DateTime.Today.Year where s.Data.Value.Month == DateTime.Today.Month where a.Nume.StartsWith(name) orderby a.Nume select new { a.ID_ANGAJAT, a.Nume, a.Prenume, a.Adresa, a.Rating, a.Functie, a.Activ, d.Denumire, s.Suma }).ToList(); if (results.Count == 0) { MessageBox.Show("Niciun angajat nu a fost gasit! Va rugam sa reintroduceti datele!"); } dataGridView.DataSource = results; } }
private void menuItemSterge_Click(int id_angajat) { using (var context = new HramulEntities()) { var angajat = (from a in context.Angajatis where a.ID_ANGAJAT == id_angajat select a).First(); if (angajat.Activ == true) { angajat.Activ = false; MessageBox.Show("Angajatul a fost trecut inactiv"); } else if (angajat.Activ == false) { angajat.Activ = true; MessageBox.Show("Angajatul a fost trecut activ"); } context.SaveChanges(); InitializeMyComponenets(); } }
private void button2_Click(object sender, EventArgs e) { string file = "raport.xls"; Workbook workbook = new Workbook(); Worksheet worksheet = new Worksheet("Salarii"); //Salarii worksheet.Cells[0, 0] = new Cell("Id"); worksheet.Cells[0, 1] = new Cell("Nume"); worksheet.Cells[0, 2] = new Cell("Preume"); worksheet.Cells[0, 3] = new Cell("Functie"); worksheet.Cells[0, 4] = new Cell("Rating"); worksheet.Cells[0, 5] = new Cell("Salariu"); using (var context = new HramulEntities()) { var angajati = (from a in context.Salariis select a).ToList(); int row = 1; foreach(var angajat in angajati) { worksheet.Cells[row, 0] = new Cell(angajat.ID_ANGAJAT); worksheet.Cells[row, 1] = new Cell(angajat.Nume); worksheet.Cells[row, 2] = new Cell(angajat.Prenume); worksheet.Cells[row, 3] = new Cell(angajat.Functie); worksheet.Cells[row, 4] = new Cell(angajat.Rating); worksheet.Cells[row, 5] = new Cell(angajat.Salariu); row++; } } workbook.Worksheets.Add(worksheet); //Facturi emise worksheet = new Worksheet("Facturi emise"); worksheet.Cells[0, 0] = new Cell("Nr"); worksheet.Cells[0, 1] = new Cell("Bani"); worksheet.Cells[0, 2] = new Cell("Observatii"); worksheet.Cells[0, 3] = new Cell("Data"); using (var context = new HramulEntities()) { int row = 1; var facturi = (from f in context.FacturiEmises select f).ToList(); foreach(var factura in facturi) { worksheet.Cells[row, 0] = new Cell(factura.Nr); worksheet.Cells[row, 1] = new Cell(factura.Bani); worksheet.Cells[row, 2] = new Cell(factura.Observatii); worksheet.Cells[row, 3] = new Cell(factura.Data); } row++; } workbook.Worksheets.Add(worksheet); worksheet = new Worksheet("Facturi primite"); worksheet.Cells[0, 0] = new ExcelLibrary.SpreadSheet.Cell("Nr"); worksheet.Cells[0, 1] = new Cell("Bani"); worksheet.Cells[0, 2] = new Cell("Observatii"); worksheet.Cells[0, 3] = new Cell("Data"); using (var context = new HramulEntities()) { int row = 1; var facturi = (from f in context.FacturiPrimites select f).ToList(); foreach (var factura in facturi) { worksheet.Cells[row, 0] = new Cell(factura.Nr); worksheet.Cells[row, 1] = new Cell(factura.Bani); worksheet.Cells[row, 2] = new Cell(factura.Observatii); worksheet.Cells[row, 3] = new Cell(factura.Data); } row++; } workbook.Worksheets.Add(worksheet); workbook.Save(file); MessageBox.Show("Raportul a fost generat!"); }
private void btActualizeaza_Click(int id_angajat) { string nume = null, prenume = null, adresa = null, functie = null, denumire = null; decimal salariu = 0; double rating = 1; try { if (Regex.IsMatch(tbNume.Text, "^[A-Z][a-z]*")) { nume = tbNume.Text; } else { throw new Exception("Numele trebuie sa contina doar litere si sa inceapa cu litera mare"); } if (Regex.IsMatch(tbPrenume.Text, "[A-Z][a-z]*")) { prenume = tbPrenume.Text; } else { throw new Exception("Prenumele trebuie sa contina doar litere si sa inceapa cu litera mare"); } if (!tbAdresa.Text.Equals("")) { adresa = tbAdresa.Text; } else { throw new Exception("Adresa trebuie sa nu fie nula"); } rating = double.Parse(cbRating.SelectedValue.ToString()); if (Regex.IsMatch(tbFunctie.Text, "[A-Z][a-z]*")) { functie = tbFunctie.Text; } else { throw new Exception("Functia trebuie sa contina doar litere si sa inceapa cu litera mare"); } salariu = decimal.Parse(tbSalariu.Text); denumire = cbDepartament.SelectedValue.ToString(); } catch (FormatException exception) { MessageBox.Show("Salariul trebuie sa fie de tip float", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception exception) { MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } using (var context = new HramulEntities()) { Angajati angajat = (from a in context.Angajatis where a.ID_ANGAJAT == id_angajat select a).First(); State_de_plata stat = (from s in context.State_de_platas where s.ID_ANGAJAT == id_angajat where s.Data.Value.Year == DateTime.Today.Year where s.Data.Value.Month == DateTime.Today.Month select s).First(); int departament_id = (from d in context.Departamentes where d.Denumire.Equals(denumire) select d.ID_DEPARTAMENT).First(); angajat.Nume = nume; angajat.Prenume = prenume; angajat.Functie = functie; angajat.Rating = rating; angajat.Adresa = adresa; angajat.ID_DEPARTAMENT = departament_id; stat.Suma = salariu; context.SaveChanges(); } MessageBox.Show("Angajatul a fost actualizat!"); Hide(); }
protected void btSalveaza_Click(object sender, EventArgs e) { string nume = null, prenume = null, adresa = null, functie = null, denumire = null; decimal salariu = 0; double rating = 1; try { if (Regex.IsMatch(tbNume.Text, "^[A-Z][a-z]*")) { nume = tbNume.Text; } else { throw new Exception("Numele trebuie sa contina doar litere si sa inceapa cu litera mare"); } if (Regex.IsMatch(tbPrenume.Text, "[A-Z][a-z]*")) { prenume = tbPrenume.Text; } else { throw new Exception("Prenumele trebuie sa contina doar litere si sa inceapa cu litera mare"); } if (!tbAdresa.Text.Equals("")) { adresa = tbAdresa.Text; } else { throw new Exception("Adresa trebuie sa nu fie nula"); } rating = double.Parse(cbRating.SelectedValue.ToString()); if (Regex.IsMatch(tbFunctie.Text, "[A-Z][a-z]*")) { functie = tbFunctie.Text; } else { throw new Exception("Functia trebuie sa contina doar litere si sa inceapa cu litera mare"); } salariu = decimal.Parse(tbSalariu.Text); denumire = cbDepartament.SelectedValue.ToString(); } catch (FormatException exception) { MessageBox.Show("Salariul trebuie sa fie de tip float", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception exception) { MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } using (var context = new HramulEntities()) { Departamente departament = (from d in context.Departamentes where d.Denumire.Equals(denumire) select d).First(); Angajati angajat = new Angajati { Nume = nume, Prenume = prenume, Adresa = adresa, Rating = rating, Functie = functie, Activ = true, Departamente = departament }; State_de_plata stat = new State_de_plata { Suma = salariu, TIP_PLATA = "SALARIU", Data = DateTime.Today, Angajati = angajat }; context.Angajatis.Add(angajat); context.State_de_platas.Add(stat); context.SaveChanges(); MessageBox.Show("Angajatul a fost adaugat!"); Hide(); } }