protected void FillTables()
{
//fetch all entities data
FillTable <ClientTableAdapter, GestionMatosDataSet.ClientDataTable>(m_adapterClient, m_tblClient);
FillTable <Type_MaterielTableAdapter, GestionMatosDataSet.Type_MaterielDataTable>(m_adapterMaterielType, m_tblMaterielType);
FillTable <SiteTableAdapter, GestionMatosDataSet.SiteDataTable>(m_adapterSite, m_tblSites);
FillTable <BatimentTableAdapter, GestionMatosDataSet.BatimentDataTable>(m_adapterBatiment, m_tblBatiments);
FillTable <EtageTableAdapter, GestionMatosDataSet.EtageDataTable>(m_adapterEtage, m_tblEtage);
FillTable <SalleTableAdapter, GestionMatosDataSet.SalleDataTable>(m_adapterSalle, m_tblSalle);
FillTable <MaterielTableAdapter, GestionMatosDataSet.MaterielDataTable>(m_adapterMaterials, m_tblMaterial);
m_material = m_tblMaterial.FindByid_Materiel(m_updatedMaterial.id_Materiel);
}
public void AddIntervention(GestionMatosDataSet.MaterielRow material)
{
try
{
m_adapterIntervention.Insert(material.id_Materiel,
material.date_dernier_Intervention,
null,
"Prochaine intervention prévue le " + material.date_dernier_Intervention.ToString() +
" sur matériel " + material.nom_Materiel + "(" + material.guid_Materiel + ")",
false);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void delete_Click(object sender, EventArgs e)
{
m_adapterMaterials.Fill(m_tblMaterial);
GestionMatosDataSet.MaterielRow material = m_tblMaterial.FindByid_Materiel(m_selectedMaterial.id_Materiel);
m_adapterMaterials.Delete(material.id_Materiel,
material.nom_Materiel,
material.guid_Materiel,
material.id_type_Materiel,
material.id_Client,
material.id_Site,
material.id_Batiment,
material.id_Etage,
material.id_Salle,
material.date_dernier_Intervention,
material.description);
RebindMaterials();
}
