// // GET: /DriverDetail/Details/5 public ViewResult Details(int id) { //DriverDetail driverdetail = db.DriverDetails.Find(id); //return View(driverdetail); DriverDetailDAL dal = new DriverDetailDAL(); DriverDetail driverdetail = dal.DriverDetailFindById(id); return View(driverdetail); }
/// <method> /// SetDriverDisqualifyStatus() sets status of drivers licence to disqualified /// </method> public void SetDriverDisqualifyStatus(int id) { //offences cannot be deleted from the database //as they are referenced in the drivingoffence table. //Instead an offence will have its status=false //so it cannot be used in new driving offences. //This ensures integrity within existing driving offences. DriverDetailDAL driverDAL = new DriverDetailDAL(); DriverDetail _driver = driverDAL.DriverDetailFindById(id); _driver.DdLicenceStatus= "Disqualified"; driverDAL.EditDriverDetail(_driver); }
// POST: /ListedOffence/Edit/5 public void EditDriverOffence(DriverOffenceUI driverOffenceUI) { DriverOffence _driverOffenceDB = _DAL.DriverOffenceFindById(driverOffenceUI.id); //Update offence details _driverOffenceDB.doStatus = driverOffenceUI.status.ToString(); _driverOffenceDB.doLocation = driverOffenceUI.location.ToString(); _driverOffenceDB.doGardaId = driverOffenceUI.gardaId.ToString(); _driverOffenceDB.doOffenceDate = driverOffenceUI.offenceDate; //Update driver details DriverDetailDAL driverDAL = new DriverDetailDAL(); DriverDetail driver = driverDAL.DriverDetailFindById(_driverOffenceDB.DriverDetail.Id); _driverOffenceDB.DriverDetail.DdLicenceNo = driverOffenceUI.LicenceNo.ToString(); _driverOffenceDB.DriverDetail.DdFName = driverOffenceUI.FName.ToString(); _driverOffenceDB.DriverDetail.DdSName = driverOffenceUI.SName.ToString(); _driverOffenceDB.DriverDetail.DdAddress1 = driverOffenceUI.Address1.ToString(); _driverOffenceDB.DriverDetail.DdAddress2 = driverOffenceUI.Address2.ToString(); _driverOffenceDB.DriverDetail.DdAddress3 = driverOffenceUI.Address3.ToString(); _driverOffenceDB.DriverDetail.DdLicenceStatus = driverOffenceUI.LicenceStatus.ToString(); //store updated driver details in database driverDAL.EditDriverDetail(_driverOffenceDB.DriverDetail); //update vehicle details VehicleDetailDAL vehicleDAL = new VehicleDetailDAL(); VehicleDetail vehicle = vehicleDAL.DeleteVehicleDetailById(_driverOffenceDB.VehicleDetails.Id); _driverOffenceDB.VehicleDetails.VdRegistration = driverOffenceUI.Registration.ToString(); _driverOffenceDB.VehicleDetails.VdMake = driverOffenceUI.Make.ToString(); _driverOffenceDB.VehicleDetails.VdType = driverOffenceUI.Type.ToString(); _driverOffenceDB.VehicleDetails.VdCubicCapacity = driverOffenceUI.Capacity; vehicleDAL.EditVehicleDetail(_driverOffenceDB.VehicleDetails); _DAL.EditDriverOffence(_driverOffenceDB); }
/// <method> /// Insert offenceUI object into database /// </method> public void CreateOffence(DriverOffenceUI driverOffenceUI) { // declare a new driver offence object. // if driver does not exist declare a new driver. // if vehicle does not exists declare a new vehicle. // if driver exists, use existing driver object // if vehicle exists, use existing vehicle object // retrieve existing offence object from list of offences // update driver offence object // insert the new driver offence object into the database. DriverOffence _driverOffenceDB = new DriverOffence(); //assign driver offence information to new driver offence _driverOffenceDB.doStatus = driverOffenceUI.status.ToString(); _driverOffenceDB.doLocation = driverOffenceUI.location.ToString(); _driverOffenceDB.doGardaId= driverOffenceUI.gardaId.ToString(); _driverOffenceDB.doOffenceDate = driverOffenceUI.offenceDate ; //Check to see if driver exists in database DriverDetailDAL driverDAL = new DriverDetailDAL(); List<DriverDetail> driversDB = driverDAL.ListOfDriverDetails(); int driverExists = 0; foreach (DriverDetail driver in driversDB) { if (driver.DdLicenceNo == driverOffenceUI.LicenceNo) { driverExists = driver.Id; break; } } //If driver does not exist declare a new driver object if (driverExists == 0) { _driverOffenceDB.DriverDetail = new DriverDetail(); //update driver attributes _driverOffenceDB.DriverDetail.DdLicenceNo = driverOffenceUI.LicenceNo.ToString(); _driverOffenceDB.DriverDetail.DdFName = driverOffenceUI.FName.ToString(); _driverOffenceDB.DriverDetail.DdSName = driverOffenceUI.SName.ToString(); _driverOffenceDB.DriverDetail.DdAddress1 = driverOffenceUI.Address1.ToString(); _driverOffenceDB.DriverDetail.DdAddress2 = driverOffenceUI.Address2.ToString(); _driverOffenceDB.DriverDetail.DdAddress3 = driverOffenceUI.Address3.ToString(); _driverOffenceDB.DriverDetail.DdLicenceStatus = driverOffenceUI.LicenceStatus.ToString(); _driverOffenceDB.DriverDetail = driverDAL.CreateDriverDetail(_driverOffenceDB.DriverDetail); } //if driver existed assign driver details to the new driver offence object; if (driverExists > 0) { _driverOffenceDB.DriverDetail = driverDAL.DriverDetailFindById(driverExists); //update driver attributes _driverOffenceDB.DriverDetail.DdLicenceNo = driverOffenceUI.LicenceNo.ToString(); _driverOffenceDB.DriverDetail.DdFName = driverOffenceUI.FName.ToString(); _driverOffenceDB.DriverDetail.DdSName = driverOffenceUI.SName.ToString(); _driverOffenceDB.DriverDetail.DdAddress1 = driverOffenceUI.Address1.ToString(); _driverOffenceDB.DriverDetail.DdAddress2 = driverOffenceUI.Address2.ToString(); _driverOffenceDB.DriverDetail.DdAddress3 = driverOffenceUI.Address3.ToString(); _driverOffenceDB.DriverDetail.DdLicenceStatus = driverOffenceUI.LicenceStatus.ToString(); //_driverOffenceDB.DriverDetail = driverDAL.DriverDetailFindById(driverDAL.EditDriverDetail(_driverOffenceDB.DriverDetail)); driverDAL.EditDriverDetail(_driverOffenceDB.DriverDetail); } //Check to see if vehicle exists in database VehicleDetailDAL vehicleDAL = new VehicleDetailDAL(); List<VehicleDetail> vehiclesDB = vehicleDAL.ListOfVehicleDetails(); int vehicleExists = 0; foreach (VehicleDetail vehicle in vehiclesDB) { if (vehicle.VdRegistration == driverOffenceUI.Registration) { vehicleExists = vehicle.Id; break; } } //If vehicle does not exist declare a new vehicle object if (vehicleExists == 0) { _driverOffenceDB.VehicleDetails = new VehicleDetail(); //update vechile attributes _driverOffenceDB.VehicleDetails.VdRegistration = driverOffenceUI.Registration.ToString(); _driverOffenceDB.VehicleDetails.VdMake = driverOffenceUI.Make.ToString(); _driverOffenceDB.VehicleDetails.VdType = driverOffenceUI.Type.ToString(); _driverOffenceDB.VehicleDetails.VdCubicCapacity = driverOffenceUI.Capacity; _driverOffenceDB.VehicleDetails = vehicleDAL.CreateVehicleDetail(_driverOffenceDB.VehicleDetails); } //if vehicle existed assign vehicle details to the vehicle offence object; if (vehicleExists > 0) { _driverOffenceDB.VehicleDetails = vehicleDAL.VehicleDetailFindById(vehicleExists); //update vechile attributes _driverOffenceDB.VehicleDetails.VdRegistration = driverOffenceUI.Registration.ToString(); _driverOffenceDB.VehicleDetails.VdMake = driverOffenceUI.Make.ToString(); _driverOffenceDB.VehicleDetails.VdType = driverOffenceUI.Type.ToString(); _driverOffenceDB.VehicleDetails.VdCubicCapacity = driverOffenceUI.Capacity; //_driverOffenceDB.VehicleDetails = vehicleDAL.VehicleDetailFindById( vehicleDAL.EditVehicleDetail(_driverOffenceDB.VehicleDetails)); vehicleDAL.EditVehicleDetail(_driverOffenceDB.VehicleDetails); } //assign offence details to the new driver offence object ListedOffenceDAL offenceDAL = new ListedOffenceDAL(); List<ListedOffence> offencesDB = offenceDAL.ListOfListedOffences(); foreach (ListedOffence offence in offencesDB) { if ((offence.LoDesc == driverOffenceUI.description) && (offence.LoStatus)) { _driverOffenceDB.ListedOffence = offenceDAL.ListedOffenceFindById(offence.Id); break; } } //Create a new driver offence int driverOffenceID = _DAL.CreateDriverOffence(_driverOffenceDB); //_driverOffenceDB = _DAL.DriverOffenceFindById(driverOffenceID); //Update driver offence object in database //_DAL.EditDriverOffence(_driverOffenceDB); }