//delete casConfirmer
public void deleteCas(CasConfirmer Cas1)
{
string connString;
connString = ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString;
// create Sqlconnection object
SqlConnection sqlConnection = new SqlConnection(connString);
try
{
sqlConnection.Open();
SqlCommand cmd = new SqlCommand("Delete CasConfirmer Where ID=@ID)", sqlConnection);
cmd.Connection = sqlConnection;
cmd.CommandText = "delete from CasConfirmer where ID='" + Cas1.Id + "' ";
cmd.ExecuteNonQuery();
sqlConnection.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
//add casConfirmer
public void addcas(CasConfirmer cas1)
{
test t1 = new test();
//true means positive
if (t1.Result == true)
{
SqlCommand cmd = new SqlCommand();
string connString;
connString = ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString;
SqlConnection sqlConnection = new SqlConnection(connString);
try
{
sqlConnection.Open();
cmd.Connection = sqlConnection;
cmd.CommandText = "insert into CasConfirmer (ID,NAME,CIN,PhoneNumber,Adresse,Etatsante,NeveauRisqueColor) values('" + cas1.Id + "','" + cas1.Nom + "','" + cas1.CIN1 + "','" + cas1.PhoneNumber1 + "','" + cas1.Adresse + "','" + cas1.Etatsante + "','" + cas1.NeveauRisque1 + "') ";
cmd.ExecuteNonQuery();
sqlConnection.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}//false means nigative
}
//upadate casConfirmer
public void updateCas(CasConfirmer Cas1)
{
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 CasConfirmer set NAME='" + Cas1.Nom + "',CIN='" + Cas1.CIN1 + "',PhoneNumber='" + Cas1.PhoneNumber1 + "',Adresse='" + Cas1.PhoneNumber1 + "',Etatsante='" + Cas1.Etatsante + "',NeveauRisqueColor='" + Cas1.NeveauRisque1 + "')";
cmd.ExecuteNonQuery();
sqlConnection.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}