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