//dossier table add , update
public void AddDossier(DossierMedical d1)
{
SqlCommand cmd = new SqlCommand();
string connString;
connString = ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString;
SqlConnection sqlConnection = new SqlConnection(connString);
sqlConnection.Close();
try
{
sqlConnection.Open();
cmd.Connection = sqlConnection;
cmd.CommandText = "insert into Dossier (IDD,NAME,Etatsante) values('" + d1.idd + "','" + d1.Nom + "','" + d1.EtatSente + "') ";
cmd.ExecuteNonQuery();
sqlConnection.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public void editDossie(DossierMedical d1)
{
SqlCommand cmd = new SqlCommand();
string connString;
connString = ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString;
SqlConnection sqlConnection = new SqlConnection(connString);
try
{
sqlConnection.Open();
cmd.Connection = sqlConnection;
cmd.CommandText = "update Dossier set NAME='" + d1.Nom + "',Etatsante='" + d1.EtatSente + "')";
cmd.ExecuteNonQuery();
sqlConnection.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
