//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()); } }