//starts UI and populates it with current EmployeeID. Default is 0 for none. public void Run() { InitializeComponent(); var _context = new AdventureWorksLTContext(); var query = from c in _context.Employee where c.EmployeeID == EmployeeID select c; this.DataContext = query.FirstOrDefault(); }
//starts UI and populates it with a selected EmployeeID. public void GetEmployeeByID(int id) { EmployeeID = id; InitializeComponent(); var _context = new AdventureWorksLTContext(); var query = from c in _context.Employee where c.EmployeeID == id select c; this.DataContext = query.FirstOrDefault(); Show(); }
//creates new employee and saves it to databse from input from user. private void NewEmployee() { using (var _context = new AdventureWorksLTContext()) { Employee employee = new Employee(); employee.FirstName = FirstNameTextBox.Text; employee.LastName = LastNameTextBox.Text; employee.Prefix = PrefixComboBox.Text; employee.HomePhone = HomePhoneTextBox.Text; employee.MobilePhone = MobilePhoneTextBox.Text; employee.Skype = SkypeTextBox.Text; employee.PhotoPath = ImageTextBox.Text; employee.Address = AddressTextBox.Text; _context.Employee.Add(employee); _context.SaveChanges(); } }
//deletes selected employee from database private void DeleteEmployee(int id) { try { using (var _context = new AdventureWorksLTContext()) { var employee = _context.Employee.Where(s => s.EmployeeID == id).First(); _context.Employee.Remove(employee); _context.SaveChanges(); Run(); } } catch { MessageBox.Show("Please try again."); } }
//updates employee information in database on selected employee private void UpdateEmployeeById(int id) { using (var _context = new AdventureWorksLTContext()) { Employee employee = _context.Employee.FirstOrDefault(c => c.EmployeeID == id); employee.FirstName = FirstNameTextBox.Text; employee.LastName = LastNameTextBox.Text; employee.Prefix = PrefixComboBox.Text; employee.HomePhone = HomePhoneTextBox.Text; employee.MobilePhone = MobilePhoneTextBox.Text; employee.Skype = SkypeTextBox.Text; employee.PhotoPath = ImageTextBox.Text; employee.Address = AddressTextBox.Text; _context.SaveChanges(); } }
public CustomersController(AdventureWorksLTContext context) { _context = context; }
public ProductsController(AdventureWorksLTContext context) { _context = context; }
public ReportDataController(AdventureWorksLTContext adventureWorksLTContext) { _dbContext = adventureWorksLTContext; }
public CustomersController(ILogger <CustomersController> logger, TelemetryClient telemetry, AdventureWorksLTContext context) { _logger = logger; _telemetry = telemetry; _context = context; }