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);
}
}
