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