private static void SauvegarderDataSetXml(object sender, EventArgs e)
{
if (sauvegardeEffectue)
{
return;
}
sauvegardeEffectue = true;
string cheminAbsolu = Path.Combine(Application.StartupPath, DOSSIER_XML);
Directory.CreateDirectory(cheminAbsolu);
BD5B6TP1_ConstantinBrassardLaheyDataSet dataset = new BD5B6TP1_ConstantinBrassardLaheyDataSet();
SoinTableAdapter soinTableAdapter = new SoinTableAdapter();
ClientTableAdapter clientTableAdapter = new ClientTableAdapter();
AssistantSoinTableAdapter assistanSoinDescriptionTableAdapter = new AssistantSoinTableAdapter();
AssistantTableAdapter assistantTableAdapter = new AssistantTableAdapter();
ChambreTableAdapter chambreTableAdapter = new ChambreTableAdapter();
ChambreEtPrixTableAdapter chambreEtPrixTableAdapter = new ChambreEtPrixTableAdapter();
InviteTableAdapter inviteTableAdapter = new InviteTableAdapter();
PlanifSoinTableAdapter planifSoinTableAdapter = new PlanifSoinTableAdapter();
ReservationChambreTableAdapter reservationChambreTableAdapter = new ReservationChambreTableAdapter();
TypeChambreTableAdapter typeChambreTableAdapter = new TypeChambreTableAdapter();
TypeSoinTableAdapter typeSoinTableAdapter = new TypeSoinTableAdapter();
TypeUtilisateurTableAdapter typeUtilisateurTableAdapter = new TypeUtilisateurTableAdapter();
UtilisateurTableAdapter utilisateurTableAdapter = new UtilisateurTableAdapter();
AssistantSoinTableAdapter assistantSoinTableAdapter = new AssistantSoinTableAdapter();
soinTableAdapter.Fill(dataset.Soin);
clientTableAdapter.Fill(dataset.Client);
assistantTableAdapter.Fill(dataset.Assistant);
assistantSoinTableAdapter.Fill(dataset.AssistantSoin);
chambreTableAdapter.Fill(dataset.Chambre);
chambreEtPrixTableAdapter.Fill(dataset.ChambreEtPrix);
inviteTableAdapter.Fill(dataset.Invite);
planifSoinTableAdapter.Fill(dataset.PlanifSoin);
reservationChambreTableAdapter.Fill(dataset.ReservationChambre);
typeChambreTableAdapter.Fill(dataset.TypeChambre);
typeSoinTableAdapter.Fill(dataset.TypeSoin);
typeUtilisateurTableAdapter.Fill(dataset.TypeUtilisateur);
utilisateurTableAdapter.Fill(dataset.Utilisateur);
foreach (DataTable table in dataset.Tables)
{
string nomFichier = CamelCaseToSnakeCase(table.TableName);
table.WriteXml($"{cheminAbsolu}\\{nomFichier}.xml", MODE_ECRITURE_XML);
}
}
public void deleteClient(int accCode)
{
using (ClientTableAdapter clientTableAdapter = new ClientTableAdapter())
{
try
{
clientTableAdapter.Delete(new int?(accCode));
}
catch (Exception exception)
{
throw new Exception(string.Concat("unable to delete Client. ", exception.Message));
}
}
}
public void insertClient(string name, string nation, long?id, long?phone, string address, int accCode, decimal balance)
{
using (ClientTableAdapter clientTableAdapter = new ClientTableAdapter())
{
try
{
clientTableAdapter.Insert(name, nation, id, address, phone, new int?(accCode), new decimal?(balance));
}
catch (Exception exception)
{
throw new Exception(string.Concat("Error inserting client. ", exception.Message));
}
}
}
public void updateClient(string name, string nation, long?id, long?phone, string address, int accCode, int oldAcc, int clientID)
{
using (ClientTableAdapter clientTableAdapter = new ClientTableAdapter())
{
try
{
clientTableAdapter.Update(new int?(clientID), name, nation, id, address, phone, new int?(accCode), new int?(oldAcc));
}
catch (Exception exception)
{
throw new Exception(string.Concat("Error updating Client. ", exception.Message));
}
}
}
static Clients()
{
// load data
dsNBD = new NBD_DataSet();
ClientTableAdapter daClient = new ClientTableAdapter();
ProjectLookupTableAdapter daProjects = new ProjectLookupTableAdapter();
try
{
daClient.Fill(dsNBD.Client);
daProjects.Fill(dsNBD.ProjectLookup);
}
catch { }
}
public ClientDataTable getClient()
{
ClientDataTable client;
using (ClientTableAdapter clientTableAdapter = new ClientTableAdapter())
{
try
{
client = clientTableAdapter.GetClient();
}
catch (Exception exception)
{
throw new Exception(string.Concat("unable to get Clients. ", exception.Message));
}
}
return(client);
}
public int getNextCode()
{
int num1;
int num2;
int num3;
using (ClientTableAdapter clientTableAdapter = new ClientTableAdapter())
{
try
{
int num4 = Convert.ToInt32(clientTableAdapter.getLastClient());
if (num4 == 0)
{
num3 = 231;
}
else
{
if (num4 < 1000)
{
num1 = num4 % 10;
num2 = Convert.ToInt32(num4 / 10);
}
else
{
if (num4 < 10000)
{
num1 = num4 % 100;
num2 = Convert.ToInt32(num4 / 100);
}
else
{
num1 = num4 % 1000;
num2 = Convert.ToInt32(num4 / 1000);
}
}
num3 = Convert.ToInt32(string.Concat(int num5 = num1 + 1, num5.ToString()));
throw new Exception(string.Concat("Could not get the next Code. ", exception.Message));
}
}
catch (Exception exception)
{
}
}
return(num3);
}
static DesignBid()
{
// load data
dsNBD = new NBD_DataSet();
ProjectTableAdapter daProject = new ProjectTableAdapter();
ClientTableAdapter daClient = new ClientTableAdapter();
WorkerTableAdapter daWorker = new WorkerTableAdapter();
MaterialReqTableAdapter daMatReq = new MaterialReqTableAdapter();
LabourReqTableAdapter daLabReq = new LabourReqTableAdapter();
try
{
daProject.Fill(dsNBD.Project);
daClient.Fill(dsNBD.Client);
daWorker.Fill(dsNBD.Worker);
daMatReq.Fill(dsNBD.MaterialReq);
daLabReq.Fill(dsNBD.LabourReq);
}
catch (DataException dex) { catcher = dex.Message; }// added a dex catcher
}
public void BindReport(int devisN)
{
DatabaseDataSet ds = new DatabaseDataSet();
var table1 = ds.Produit;
var adp = new ProduitTableAdapter();
adp.Fill(table1);
DataView dv1 = new DataView(table1, $"DevisN={devisN}", "", DataViewRowState.CurrentRows);
var produits = dv1.ToTable();
var table3 = ds.Devis;
var adp3 = new DevisTableAdapter();
adp3.Fill(table3);
DataView dv3 = new DataView(table3, $"DevisN={devisN}", "", DataViewRowState.CurrentRows);
var devis = dv3.ToTable();
var table2 = ds.Client;
var adp2 = new ClientTableAdapter();
adp2.Fill(table2);
DataView dv2 = new DataView(table2, $"IdClient={devis.Rows[0]["IdClient"]}", "", DataViewRowState.CurrentRows);
var client = dv2.ToTable();
DataSet n_ds = new DataSet();
n_ds.Tables.Add(produits);
n_ds.Tables.Add(devis);
n_ds.Tables.Add(client);
CrystalReport cr = new CrystalReport();
cr.SetDataSource(n_ds);
this.crystalReportViewer.ReportSource = cr;
this.crystalReportViewer.RefreshReport();
}
