コード例 #1
0
ファイル: Form1.cs プロジェクト: nicolasdomarin/GestionMatos
        private void FillFormCombo()
        {
            try
            {
                //TYPE MATERIEL //
                DataSet1TableAdapters.typeTableAdapter typeAdaptater = new DataSet1TableAdapters.typeTableAdapter();
                DataSet1.typeDataTable tab1 = new DataSet1.typeDataTable();
                typeAdaptater.Fill(tab1);
                List <ListItem> listitem = new List <ListItem>();

                foreach (DataSet1.typeRow Row in tab1.Rows)
                {
                    listitem.Add(new ListItem(Row.nom, Row.id_type));
                }
                formFieldTypeMateriel.DataSource = listitem;

                //CLIENT //
                DataSet1TableAdapters.clientTableAdapter clientAdaptater = new DataSet1TableAdapters.clientTableAdapter();
                DataSet1.clientDataTable tab2 = new DataSet1.clientDataTable();
                clientAdaptater.Fill(tab2);
                List <ListItem> listitem2 = new List <ListItem>();

                foreach (DataSet1.clientRow Row in tab2.Rows)
                {
                    listitem2.Add(new ListItem(Row.name, Row.id_client));
                }
                formFieldClient.DataSource = listitem2;


                //SITE//
                DataSet1TableAdapters.siteTableAdapter siteAdaptater = new DataSet1TableAdapters.siteTableAdapter();
                DataSet1.siteDataTable tab3 = new DataSet1.siteDataTable();
                siteAdaptater.Fill(tab3);
                List <ListItem> listitem3 = new List <ListItem>();

                foreach (DataSet1.siteRow Row in tab3.Rows)
                {
                    listitem3.Add(new ListItem(Row.nom, Row.id_site));
                }
                formFieldSite.DataSource = listitem3;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            //   dbConnection.Close();
        }
コード例 #2
0
ファイル: Form1.cs プロジェクト: nicolasdomarin/GestionMatos
 private void FillComboIntervention()
 {
     try
     {
         DataSet1TableAdapters.clientTableAdapter clientAdaptater = new DataSet1TableAdapters.clientTableAdapter();
         DataSet1.clientDataTable tab1 = new DataSet1.clientDataTable();
         clientAdaptater.Fill(tab1);
         List <ListItem> listitem = new List <ListItem>();
         listitem.Add(new ListItem("Indifferent", 0));
         foreach (DataSet1.clientRow Row in tab1.Rows)
         {
             listitem.Add(new ListItem(Row.name, Row.id_client));
         }
         comboIntervention.DataSource = listitem;
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
コード例 #3
0
ファイル: Form1.cs プロジェクト: nicolasdomarin/GestionMatos
        private void buttonValiderClient_Click(object sender, EventArgs e)
        {
            if (isModif == false)
            {
                DataSet1TableAdapters.clientTableAdapter clientAdaptater      = new DataSet1TableAdapters.clientTableAdapter();
                DataSet1TableAdapters.clientTableAdapter intervetionAdaptater = new DataSet1TableAdapters.clientTableAdapter();
                DataSet1.clientDataTable tab1 = new DataSet1.clientDataTable();
                clientAdaptater.Insert(denominationClient.Text);
                MessageBox.Show("Client crée avec succès");
                client_initialize();
                denominationClient.Text = "";
                //ToggleFormClient();

                groupBoxClient.Enabled = false;
            }
            else
            {
                int             selectedrowindex = dataGrid_Listing_Client.SelectedCells[0].RowIndex;
                DataGridViewRow selectedRow      = dataGrid_Listing_Client.Rows[selectedrowindex];
                int             idClient         = Convert.ToInt32(selectedRow.Cells[0].Value);

                SqlCommand cmd  = connection.CreateCommand();
                string     name = denominationClient.Text;
                //cmd.CommandText = "UPDATE client SET name = "+ name +" WHERE id_client = "+idClient;
                cmd.CommandText = "UPDATE client SET name = @name WHERE id_client= " + idClient;
                cmd.Parameters.AddWithValue("name", name);
                SqlDataAdapter adap = new SqlDataAdapter(cmd);
                DataSet        ds   = new DataSet();
                adap.Fill(ds);
                client_initialize();
                MessageBox.Show("Client modifié avec avec succès");
                isModif = false;
                // ToggleFormClient();

                denominationClient.Text = "";
                groupBoxClient.Enabled  = false;
            }
        }
コード例 #4
0
ファイル: Form1.cs プロジェクト: nicolasdomarin/GestionMatos
        private void FillFormCombo()
        {
            try
            {
                //TYPE MATERIEL //
                DataSet1TableAdapters.typeTableAdapter typeAdaptater = new DataSet1TableAdapters.typeTableAdapter();
                DataSet1.typeDataTable tab1 = new DataSet1.typeDataTable();
                typeAdaptater.Fill(tab1);
                List<ListItem> listitem = new List<ListItem>();

                foreach (DataSet1.typeRow Row in tab1.Rows)
                {
                    listitem.Add(new ListItem(Row.nom, Row.id_type));
                }
                formFieldTypeMateriel.DataSource = listitem;

                //CLIENT //
                DataSet1TableAdapters.clientTableAdapter clientAdaptater = new DataSet1TableAdapters.clientTableAdapter();
                DataSet1.clientDataTable tab2 = new DataSet1.clientDataTable();
                clientAdaptater.Fill(tab2);
                List<ListItem> listitem2 = new List<ListItem>();

                foreach (DataSet1.clientRow Row in tab2.Rows)
                {
                    listitem2.Add(new ListItem(Row.name, Row.id_client));
                }
                formFieldClient.DataSource = listitem2;

                //SITE//
                DataSet1TableAdapters.siteTableAdapter siteAdaptater = new DataSet1TableAdapters.siteTableAdapter();
                DataSet1.siteDataTable tab3 = new DataSet1.siteDataTable();
                siteAdaptater.Fill(tab3);
                List<ListItem> listitem3 = new List<ListItem>();

                foreach (DataSet1.siteRow Row in tab3.Rows)
                {
                    listitem3.Add(new ListItem(Row.nom, Row.id_site));
                }
                formFieldSite.DataSource = listitem3;

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            //   dbConnection.Close();
        }
コード例 #5
0
ファイル: Form1.cs プロジェクト: nicolasdomarin/GestionMatos
        private void FillComboIntervention()
        {
            try
            {
                DataSet1TableAdapters.clientTableAdapter clientAdaptater = new DataSet1TableAdapters.clientTableAdapter();
                DataSet1.clientDataTable tab1 = new DataSet1.clientDataTable();
                clientAdaptater.Fill(tab1);
                List<ListItem> listitem = new List<ListItem>();
                listitem.Add(new ListItem("Indifferent", 0));
                foreach (DataSet1.clientRow Row in tab1.Rows)
                {

                    listitem.Add(new ListItem(Row.name, Row.id_client));
                }
                comboIntervention.DataSource = listitem;

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
コード例 #6
0
ファイル: Form1.cs プロジェクト: nicolasdomarin/GestionMatos
        private void buttonValiderClient_Click(object sender, EventArgs e)
        {
            if (isModif == false)
            {
                DataSet1TableAdapters.clientTableAdapter clientAdaptater = new DataSet1TableAdapters.clientTableAdapter();
                DataSet1TableAdapters.clientTableAdapter intervetionAdaptater = new DataSet1TableAdapters.clientTableAdapter();
                DataSet1.clientDataTable tab1 = new DataSet1.clientDataTable();
                clientAdaptater.Insert(denominationClient.Text);
                MessageBox.Show("Client crée avec succès");
                client_initialize();
                denominationClient.Text = "";
                //ToggleFormClient();

                groupBoxClient.Enabled = false;
            }
            else
            {

                int selectedrowindex = dataGrid_Listing_Client.SelectedCells[0].RowIndex;
                DataGridViewRow selectedRow = dataGrid_Listing_Client.Rows[selectedrowindex];
                int idClient = Convert.ToInt32(selectedRow.Cells[0].Value);

                SqlCommand cmd = connection.CreateCommand();
                string name = denominationClient.Text;
                //cmd.CommandText = "UPDATE client SET name = "+ name +" WHERE id_client = "+idClient;
                cmd.CommandText = "UPDATE client SET name = @name WHERE id_client= " + idClient;
                cmd.Parameters.AddWithValue("name", name);
                SqlDataAdapter adap = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                adap.Fill(ds);
                client_initialize();
                MessageBox.Show("Client modifié avec avec succès");
                isModif = false;
               // ToggleFormClient();

                denominationClient.Text = "";
                groupBoxClient.Enabled = false;
            }
        }