public void RefreshDrivers() { try { using (AceSoftDataEntities db = new AceSoftDataEntities()) { var drivers = db.Drivers.OrderBy(d => d.Surname).Select(d => new { DriverId = d.Id, Surname = d.Surname, Forname = d.Forename, Mobile = d.Mobile, City = d.City, LastContacted = d.Last_Contact, LastSpokeTo = d.Employee.Name, CPCExpiry = d.CPC_Expiry, DigiExpiry = d.Digi_Expiry, LicenseExpiry = d.License_Expiry, LicenseNextCheck = d.License_Next_Check, Prospect = d.Prospect, Archived = d.Archived }).ToList(); grdDrivers.DataSource = drivers.Where(d => (d.Prospect == _prospects)).ToList(); } } catch (NullReferenceException ex) { MessageBox.Show("Database has failed to load the driver data", "Error"); throw ex; } }
public void UpsertDriver(Driver driver) { using (AceSoftDataEntities db = new AceSoftDataEntities()) { if (driver != null) { var result = db.Drivers.AsNoTracking().SingleOrDefault(d => d.Id == driver.Id); if (result != null) { try { driver.Employee = null; db.Drivers.Attach(driver); db.Entry(driver).State = EntityState.Modified; db.SaveChanges(); } catch (Exception ex) { throw ex; } } else { Driver newDriver = new Driver(); newDriver = driver; //{ // Address = driver.Address, // Car_Owned = driver.Car_Owned, // City = driver.City, // CPC_Expiry = driver.CPC_Expiry, // Digi_Expiry = driver.Digi_Expiry, // DoB = driver.DoB, // Email = driver.Email, // Forename = driver.Forename, // Id = driver.Id, // Last_Contact = driver.Last_Contact, // License_Checked = driver.License_Checked, // License_Expiry = driver.License_Expiry, // License_Next_Check = driver.License_Next_Check, // License_Num = driver.License_Num, // License_Valid = driver.License_Valid, // Mobile = driver.Mobile, // Nationality = driver.Nationality, // NI_Num = driver.NI_Num, // Postcode = driver.Postcode, // Staff_Contacted = driver.Staff_Contacted, // Surname = driver.Surname, // Telephone = driver.Telephone, // Archived = driver.Archived //}; db.Drivers.Add(newDriver); db.SaveChanges(); } } } }
protected void BindControls() { using (AceSoftDataEntities db = new AceSoftDataEntities()) { //.Join( //db.Drivers, //employee => employee.Id, //driver => driver.Employee.Id, //(employee, driver) => new //{ // DriverId = driver.Id, // EmployeeId = employee.Id, // EmployeeName = employee.Name //} // ).ToList(); //} cmbStaffContacted.DataSource = db.Employees.ToList(); cmbStaffContacted.DisplayMember = "Name"; cmbStaffContacted.ValueMember = "Id"; if (_driver.Id != 0) { cmbStaffContacted.SelectedValue = _driver.Employee.Id; } else { cmbStaffContacted.SelectedValue = 1; } } }
public Driver GetDriverFromId(int id) { using (AceSoftDataEntities db = new AceSoftDataEntities()) { var result = db.Drivers.Include(e => e.Employee) .FirstOrDefault(e => e.Id == id); return(result); } }