public string SaveTreatMent(Treatment aTreatment)
{
if (gateway.SaveTreatMent(aTreatment) > 0)
{
return "Saved Succesfully";
}
else
{
return "Saving failed";
}
}
public int SaveTreatMent(Treatment aTreatment)
{
string query = string.Format("INSERT INTO Treatment VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')", aTreatment.VoterId, aTreatment.Observation, aTreatment.Date, aTreatment.DoctorId, aTreatment.DiseaseId, aTreatment.MedicineId, aTreatment.Dose, aTreatment.Meal, aTreatment.Quantity, aTreatment.Note, aTreatment.CenterId);
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return rowAffected;
}