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(); }
public diseases getDisease(int id) { 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(); diseases dis = new diseases(); SqlCommand myCommand = new SqlCommand(); myCommand.CommandText = "Select * from diseases where id = '" + id + "';"; myCommand.Connection = myConnection; SqlDataReader reader = myCommand.ExecuteReader(); dis.setId(0); if (reader.HasRows) { while (reader.Read()) { dis.setId(reader.GetInt32(0)); dis.setAnemia(Convert.ToBoolean(reader[1])); dis.setAsthma(Convert.ToBoolean(reader[2])); dis.setEpilipsy(Convert.ToBoolean(reader[3])); dis.setDepression(Convert.ToBoolean(reader[4])); dis.setDiabetes(Convert.ToBoolean(reader[5])); dis.setDiarrhea(Convert.ToBoolean(reader[6])); dis.setHeartAttack(Convert.ToBoolean(reader[7])); dis.setHepatitis(Convert.ToBoolean(reader[8])); dis.setRheumatism(Convert.ToBoolean(reader[9])); dis.SetScarletFever(Convert.ToBoolean(reader[10])); dis.setStd(Convert.ToBoolean(reader[11])); } } reader.Close(); myConnection.Close(); return(dis); }