//delete Casnegative
public void deleteCas(CasNegative casn)
{
string connString;
connString = ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString;
// create Sqlconnection object
SqlConnection sqlConnection = new SqlConnection(connString);
try
{
sqlConnection.Open();
SqlCommand cmd = new SqlCommand("Delete CasNegative Where ID=@ID)", sqlConnection);
cmd.Connection = sqlConnection;
cmd.CommandText = "delete from CasNegative where ID='" + casn.Id + "' ";
cmd.ExecuteNonQuery();
sqlConnection.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
//add casnegative
public void addcasnegative(CasNegative casn)
{
test t1 = new test();
//false meqns negative
if (t1.Result == false)
{
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 CasNegative (ID,NAME,CIN,PhoneNumber,Adresse,Etatsante,NeveauRisqueColor) values('" + casn.Id + "','" + casn.Nom + "','" + casn.CIN1 + "','" + casn.PhoneNumber1 + "','" + casn.Adresse + "','" + casn.Etatsante + "') ";
cmd.ExecuteNonQuery();
sqlConnection.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
}
}
//upadate casnegative
public void CasNegative(CasNegative casn)
{
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 CasNegative set NAME='" + casn.Nom + "',CIN='" + casn.CIN1 + "',PhoneNumber='" + casn.PhoneNumber1 + "',Adresse='" + casn.PhoneNumber1 + "',Etatsante='" + casn.Etatsante + "')";
cmd.ExecuteNonQuery();
sqlConnection.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
