public async Task <SalesPersons> Update(SalesPersons sales) { _context.Update(sales); await _context.SaveChangesAsync(); return(sales); }
public List <SalesPersons> GetAllPersons() { List <SalesPersons> sp = new List <SalesPersons>(); string com = "SELECT * FROM SalesPersons"; using (SqlConnection con = new SqlConnection(ConString)) { con.Open(); using (SqlCommand command = new SqlCommand(com, con)) { DataSet ds = new DataSet(); SqlDataAdapter a = new SqlDataAdapter(command); a.Fill(ds); foreach (DataTable table in ds.Tables) { foreach (DataRow row in table.Rows) { SalesPersons p = new SalesPersons(row.Field <string>("Fornavn"), row.Field <string>("Efternavn"), row.Field <string>("Initialer"), row.Field <int>("PersonID")); if (p.ValidateData()) { sp.Add(p); } else { throw new Exception("A name on the list['SalesPersons'] does not compute."); } } } } } return(sp); }
private void btnNewCar_Click(object sender, RoutedEventArgs e) { SalesPersons p = (SalesPersons)cBoxEmployeeNames.SelectedItem; try { int stel = Int32.Parse(tBoxNewCarStelnummer.Text); int reg = Int32.Parse(tBoxNewCarRegistreringsnummer.Text); int trans = Int32.Parse(tBoxTransaktionsbeløb.Text); bool ny = (bool)chkBoxNewCarNew.IsChecked; bool ejet = (bool)chkBoxEjet.IsChecked; Car c = new Car(stel, tBoxNewCarMaerke.Text, tBoxNewCarModel.Text, reg, ny); Sale s = new Sale(0, trans, ejet, p, c); if (p.ValidateData() && c.ValidateData() && s.ValidateData()) { if (dbh.AddNewCar(c) && dbh.AddNewSale(c, p, trans, ejet)) { MessageBox.Show("En ny transaktion er blevet oprettet.", "succes"); } else { MessageBox.Show("Et eller flere problemer opstod under processen.", "Ups!"); } } } catch { ValidateInput(); } }
public async Task <SalesPersons> Add(SalesPersons sales) { await _context.SalesPersons.AddAsync(sales); await _context.SaveChangesAsync(); return(sales); }
public async Task <IActionResult> PutSalesPersons(int id, SalesPersons salesPersons) { if (id != salesPersons.SalesPersonsId) { return(BadRequest()); } await _salesPersonRepository.Update(salesPersons); return(NoContent()); }
public List <Sale> GetAllSales() { List <Sale> sales = new List <Sale>(); string com = "SELECT * FROM Sale"; using (SqlConnection con = new SqlConnection(ConString)) { con.Open(); using (SqlCommand command = new SqlCommand(com, con)) { DataSet ds = new DataSet(); SqlDataAdapter a = new SqlDataAdapter(command); a.Fill(ds); foreach (DataTable table in ds.Tables) { foreach (DataRow row in table.Rows) { List <SalesPersons> ps = GetAllPersons(); SalesPersons person = null; foreach (SalesPersons p in ps) { if (p.ID == row.Field <int>("PersonID")) { person = p; } } List <Car> cs = GetAllCars(); Car Car = null; foreach (Car c in cs) { if (c.Stelnummer == row.Field <int>("Stelnummer")) { Car = c; } } Sale s = new Sale(row.Field <int>("ID"), row.Field <int>("Transaktionsbeløb"), row.Field <bool>("Ejet"), person, Car); if (s.ValidateData()) { sales.Add(s); } else { throw new Exception("A name on the list['Sales'] does not compute."); } } } } } return(sales); }
public bool AddNewSale(Car c, SalesPersons p, int trans, bool ejet) { int saleRowsAffected; string sale = $"INSERT INTO Sale VALUES ({trans}, '{ejet}', {p.ID}, {c.Stelnummer})"; using (SqlConnection con = new SqlConnection(ConString)) { con.Open(); using (SqlCommand com = new SqlCommand(sale, con)) { saleRowsAffected = com.ExecuteNonQuery(); } } if (saleRowsAffected > 0) { return(true); } else { return(false); } }
public async Task <ActionResult <SalesPersons> > PostSalesPersons(SalesPersons salesPersons) { await _salesPersonRepository.Add(salesPersons); return(CreatedAtAction("GetSalesPersons", new { id = salesPersons.SalesPersonsId }, salesPersons)); }