public string SaveTreatment(Treatment treatment)
        {
            if (treatment.MedicineQuantity.ToString() == "")
            {
                return "Medicine Quantity is missing";
            }

            else if (treatment.Note == "")
            {
                return "Treatment Note is missing";
            }

            else if (treatment.Observation=="")
            {
                return "Observation is missing";
            }

            else
            {

                int value = centerGateway.InsertTreatment(treatment);

                if (value > 0)
                {
                    return "Saved Successfully";
                }

                else
                {
                    return "Operation Failed";
                }
            }
        }
        public int InsertTreatment(Treatment treatment)
        {
            SqlConnection connection = new SqlConnection(connectionstring);

            string query = "INSERT INTO Table_Treatment VALUES ('"+treatment.VoterId+"','"+treatment.Observation+"','"+treatment.Date+"','"+treatment.DoctorId+"','"+treatment.DiseaseName+"','"+treatment.MedicineName+"','"+treatment.Dose+"','"+treatment.Schedule+"','"+treatment.MedicineQuantity+"','"+treatment.Note+"','"+treatment.CenterId+"')";

            SqlCommand command = new SqlCommand(query, connection);

            connection.Open();

            int rowsAffected = command.ExecuteNonQuery();

            connection.Close();

            return rowsAffected;
        }