private void AddCustomer() { try { long id; //Specifying id manualy because sqlite has problem with autoincrement if (_context.Customers.Count() > 0) { List <Customer> c = _context.Customers.ToList(); id = c[_context.Customers.Count() - 1].Id + 1; } else { id = 1; } Customer newCustomer = new Customer { Id = id, FirstName = FirstNameTB.Text, LastName = LastNameTB.Text }; _context.Customers.Add(newCustomer); _context.SaveChanges(); } catch (Exception ex) { MessageBox.Show("Customer add error: " + ex.Message); } }
private void AddService() { try { long id; if (_context.Services.Count() > 0) { List <Service> c = _context.Services.ToList(); id = c[_context.Services.Count() - 1].Id + 1; } else { id = 1; } Service newService = new Service { Id = id, Name = ServiceNameTB.Text, Price = Convert.ToDecimal(PriceTB.Text) }; _context.Services.Add(newService); _context.SaveChanges(); } catch (Exception ex) { MessageBox.Show("Service add error: " + ex.Message); } }
//Save- Add or Edit Company details private void button_Click(object sender, RoutedEventArgs e) { //Add Company if (CheckIfDataInFieldsAreValid())//Validation on form needs to be implemented { if (_context.Companies.Count() == 0) { try { Company newCompany = new Company { Name = CompanyNameTB.Text, Adress = AdressTB.Text, Telefon = TelephoneTB.Text, Website = WebSiteTB.Text, FileName = fileName, Data = imageInBytes }; _context.Companies.Add(newCompany); _context.SaveChanges(); } catch (Exception ex) { MessageBox.Show("Company add error: " + ex.Message); } }//Edit Company else { try { Company existingCompany = _context.Companies.FirstOrDefault(); if (existingCompany != null) { existingCompany.Name = CompanyNameTB.Text; existingCompany.Adress = AdressTB.Text; existingCompany.Telefon = TelephoneTB.Text; existingCompany.Website = WebSiteTB.Text; existingCompany.FileName = fileName; existingCompany.Data = imageInBytes; } _context.SaveChanges(); } catch (Exception ex) { MessageBox.Show("Company edit error: " + ex.Message); } } } }