public void Doctor_AddOPDTreatment(string appointmentToken, string treatmentDiagnosis) { Doctor_AddOPDTreatmentBO objAddOPDTreatmentBO = new Doctor_AddOPDTreatmentBO(); objAddOPDTreatmentBO.appointmentToken = appointmentToken; objAddOPDTreatmentBO.treatmentDiagnosis = treatmentDiagnosis; AddOPDTreatmentDL objAddOPDTreatmentDL = new AddOPDTreatmentDL(); objAddOPDTreatmentDL.AddOPDTreatment(objAddOPDTreatmentBO); }
public void AddOPDTreatment(Doctor_AddOPDTreatmentBO objAddOPDTreatmentBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("spAddOPDTreatment", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@appointmentToken", objAddOPDTreatmentBO.appointmentToken); cmd.Parameters.Add("@treatmentDiagnosis", objAddOPDTreatmentBO.treatmentDiagnosis); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }