public static List <Mesure_Model> GetAllVValues() { List <Mesure_Model> b = new List <Mesure_Model>(); CodeDB.Open(); String req = "SELECT * FROM [Mesur] Type = \"V\""; SqlCommand getcom = new SqlCommand(req, CodeDB.Open()); SqlDataAdapter da = new SqlDataAdapter(getcom); DataTable dt = new DataTable("Mesure"); da.Fill(dt); if (dt.Rows.Count != 0) { b = Mesure_Model.GetList(dt); } CodeDB.Close(); return(b); }
public static void Create(Mesure_Model b) { CodeDB.Open(); string req = "INSERT INTO [Mesur] (Temps,Volt,Amper,Type) Values (@Temps,@Volt,@Amper,@Type)"; SqlCommand cmd = new SqlCommand(req, CodeDB.Open()); //declaration des prarmetre SqlParameter Titre = new SqlParameter("", DbType.String); SqlParameter Description = new SqlParameter("Description", DbType.String); SqlParameter Lieu = new SqlParameter("Lieu", DbType.String); SqlParameter pdate = new SqlParameter("pdate", DbType.DateTime); SqlParameter pIdcongre = new SqlParameter("@pIdCongre", DbType.Int16); //Remplissage des es param cmd.Parameters.AddWithValue("Temps", b.Temps); cmd.Parameters.AddWithValue("Volt", b.Volt); cmd.Parameters.AddWithValue("Amper", b.Amper); cmd.Parameters.AddWithValue("Type", b.Type); //excuter la requette cmd.ExecuteNonQuery(); CodeDB.Close(); }
private void addBtn_Click_1(object sender, EventArgs e) { if (TempTxt.Text.Length != 0 && VoltTxt.Text.Length != 0 && AmpereTxt.Text.Length != 0 && typeCmb.Text.Length != 0) { Mesure_Model m = new Mesure_Model(); try { m.Amper = float.Parse(AmpereTxt.Text); m.Volt = float.Parse(VoltTxt.Text); m.Type = typeCmb.Text.Trim(); m.Temps = float.Parse(TempTxt.Text); DAL.Dal_Mesure.Create(m); MesureDtv.DataSource = DAL.Dal_Mesure.GetAll(); } catch (Exception ex) { MessageBox.Show("Svp entrer des valeur valide"); } } else { MessageBox.Show("Svp entrer des valeur valide"); } }