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 List <Courbe1_Model> GetAll()
{
List <Courbe1_Model> b = new List <Courbe1_Model>();
CodeDB.Open();
String req = "SELECT * FROM [Courbe]";
SqlCommand getcom = new SqlCommand(req, CodeDB.Open());
SqlDataAdapter da = new SqlDataAdapter(getcom);
DataTable dt = new DataTable("Courbe1");
da.Fill(dt);
if (dt.Rows.Count != 0)
{
b = Courbe1_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();
}