private void cbBus_SelectedValueChanged(object sender, EventArgs e)
{
Bus bus = BusDao.findByNumero(cbBus.Text);
txtMarqBus.Text = bus.Marque;
txtCartBus.Text = bus.CarteGrise;
}
public UnitOfWork(IDbConnection connection)
{
_connection = connection;
AccountDao = new AccountDao(connection);
BusCoordinateDao = new BusCoordinateDao(connection);
BusDao = new BusDao(connection);
BusDriverDao = new BusDriverDao(connection);
CityDao = new CityDao(connection);
CountryDao = new CountryDao(connection);
DistanceDao = new DistanceDao(connection);
DistrictDao = new DistrictDao(connection);
DriverDao = new DriverDao(connection);
DriverContactDao = new DriverContactDao(connection);
LocationDao = new LocationDao(connection);
LookupsDao = new LookupsDao(connection);
LookupValuesDao = new LookupValuesDao(connection);
RepairSpecialistDao = new RepairSpecialistDao(connection);
RoleDao = new RoleDao(connection);
RouteDao = new RouteDao(connection);
RouteLocationDao = new RouteLocationDao(connection);
TripDao = new TripDao(connection);
TripBusDao = new TripBusDao(connection);
TripBusDriverDao = new TripBusDriverDao(connection);
UserDao = new UserDao(connection);
VehicleDao = new VehicleDao(connection);
ScheduleDao = new ScheduleDao(connection);
ScheduleLocationDao = new ScheduleLocationDao(connection);
StoredProcedureDao = new StoredProcedureDao(connection);
}
private void AddBusForm_Load(object sender, EventArgs e)
{
if (LabelTitle.Text == "ENREGISTREMENT BUS")
{
txtNumero.Text = BusDao.generateKey();
}
}
public void Form2Model()
{
affecter.Numero = txtNumero.Text;
affecter.DateDebut = cbDateD.Value;
affecter.DateFin = cbDateF.Value;
affecter.bus = BusDao.findByNumero(cbBus.Text);
affecter.ligne = LigneDao.findByNumero(cbLigne.Text);
}
public void Form2Model()
{
attribuer.Numero = txtNumero.Text;
attribuer.DateDebut = cbdateD.Value;
attribuer.DateFin = cbdateF.Value;
attribuer.bus = BusDao.findByNumero(cbBus.Text);
attribuer.chauffeur = ChauffeurDao.findByNumero(cbChauffeur.Text);
}
private void btnSave_Click(object sender, EventArgs e)
{
Form2Model();
BusDao.save(bus);
Vider();
if (LabelTitle.Text == "ENREGISTREMENT BUS")
{
txtNumero.Text = BusDao.generateKey();
}
}
private void dgBus_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
for (int i = 0; i < dgBus.RowCount; i++)
{
if ((bool)dgBus.Rows[i].Selected)
{
AddBusForm adf = new AddBusForm();
Bus bus = BusDao.findByNumero(dgBus.Rows[i].Cells[0].Value.ToString());
adf.LabelTitle.Text = "MODIFICATION BUS";
adf.Model2Form(bus);
adf.ShowDialog();
}
}
}
public void loadCombo()
{
List <Bus> buss = BusDao.findAll();
cbBus.Items.Clear();
foreach (Bus bus in buss)
{
cbBus.Items.Add(bus.Numero);
}
List <Ligne> chaus = LigneDao.findAll();
cbLigne.Items.Clear();
foreach (Ligne chau in chaus)
{
cbLigne.Items.Add(chau.Numero);
}
}
public void loadCombo()
{
List <Bus> buss = BusDao.findAll();
cbBus.Items.Clear();
foreach (Bus bus in buss)
{
cbBus.Items.Add(bus.Numero);
}
List <Chauffeur> chaus = ChauffeurDao.findAll();
cbChauffeur.Items.Clear();
foreach (Chauffeur chau in chaus)
{
cbChauffeur.Items.Add(chau.Numero);
}
}
private void btnChange_Click(object sender, EventArgs e)
{
if (DroitDao.findDroit(administrateur.Numero, "Bus", "Modifier"))
{
for (int i = 0; i < dgBus.RowCount; i++)
{
if ((bool)dgBus.Rows[i].Selected)
{
AddBusForm adf = new AddBusForm();
Bus bus = BusDao.findByNumero(dgBus.Rows[i].Cells[0].Value.ToString());
adf.LabelTitle.Text = "MODIFICATION BUS";
adf.Model2Form(bus);
adf.ShowDialog();
}
}
}
else
{
MessageBox.Show("Vous n\'avez pas ce droit");
}
}
public void DataBusload()
{
List <Bus> Buss = BusDao.findAll();
int i = 0;
dgBus.Rows.Clear();
foreach (Bus bus in Buss)
{
dgBus.Rows.Add();
dgBus.Rows[i].Cells[0].Value = bus.Numero;
dgBus.Rows[i].Cells[1].Value = bus.Type;
dgBus.Rows[i].Cells[2].Value = bus.Marque;
dgBus.Rows[i].Cells[3].Value = bus.Place;
dgBus.Rows[i].Cells[4].Value = bus.Kilometrage;
dgBus.Rows[i].Cells[5].Value = bus.Puissance;
dgBus.Rows[i].Cells[6].Value = bus.Energie;
dgBus.Rows[i].Cells[7].Value = bus.DateMise;
dgBus.Rows[i].Cells[8].Value = bus.CarteGrise;
dgBus.Rows[i].Cells[9].Value = bus.Chassis;
i++;
}
}
