public void updateDiseases(diseases disease)
{
string connectionString = @"Data Source=cdb.c1lbyzt9l8fn.us-west-2.rds.amazonaws.com,1433;" + "Initial Catalog=cis;" + "User id=sonaaaa;" + "Password=mo7senzzzz;";
SqlConnection myConnection = new SqlConnection(connectionString);
myConnection.Open();
SqlCommand myCommand = new SqlCommand();
myCommand.CommandText = "UPDATE diseases SET id =" + disease.getId().ToString() + ",anemia ='" + disease.getAnemia() + "',asthma ='" + disease.getAsthma() + "', epilipsy ='" + disease.getEpilipsy() + "', depression = '" + disease.getDepression() + "',diabetes = '" + disease.getDiabetes() + "', diarrhea = '" + disease.getDiarrhea() + "', heartAttack = '" + disease.getHeartAttack() + "',hepatitis = '" + disease.getHepatitis() + "', rheumatism = '" + disease.getRheumatism() + "', scarletFever = '" + disease.getScarletFever() + "',std = '" + disease.getSTD() + "' WHERE id = " + disease.getId().ToString() + ";";
myCommand.Connection = myConnection;
myCommand.ExecuteNonQuery();
myConnection.Close();
}
public void insertDiseases(diseases disease)
{
string connectionString = @"Data Source=cdb.c1lbyzt9l8fn.us-west-2.rds.amazonaws.com,1433;" + "Initial Catalog=cis;" + "User id=sonaaaa;" + "Password=mo7senzzzz;";
SqlConnection myConnection = new SqlConnection(connectionString);
myConnection.Open();
SqlCommand myCommand = new SqlCommand();
myCommand.CommandText = "insert into diseases (id,anemia,asthma,epilipsy,depression,diabetes,diarrhea,heartAttack,hepatitis,rheumatism,scarletFever,std) Values ('" + disease.getId().ToString() + "','" + disease.getAnemia() + "','" + disease.getAsthma() + "','" + disease.getEpilipsy() + "','" + disease.getDepression() + "','" + disease.getDiabetes() + "','" + disease.getDiarrhea() + "','" + disease.getHeartAttack() + "','" + disease.getHepatitis() + "','" + disease.getRheumatism() + "','" + disease.getScarletFever() + "','" + disease.getSTD() + "') ; ";
myCommand.Connection = myConnection;
myCommand.ExecuteNonQuery();
myConnection.Close();
}