public string SaveDiagnosis(EDiagnosis eDiagnosis) { var msj = ""; const string sql = "INSERT INTO tb_diagnosis ( " + "reasons_for_consultation, " + "current_illness, " + "pathological_history, " + "id_clinic_history, " + "id_doctor ) " + "VALUES (@rc, @ci, @ph, @idhc, @iddoc)"; try { var cmd = new SqlCommand(sql, cn.DB()); if (String.IsNullOrEmpty(eDiagnosis.ReasonsForConsultation)) { cmd.Parameters.AddWithValue("@rc", Null.String(eDiagnosis.ReasonsForConsultation)); } else { cmd.Parameters.AddWithValue("@rc", eDiagnosis.ReasonsForConsultation); } if (String.IsNullOrEmpty(eDiagnosis.CurrentIllness)) { cmd.Parameters.AddWithValue("@ci", Null.String(eDiagnosis.CurrentIllness)); } else { cmd.Parameters.AddWithValue("@ci", eDiagnosis.CurrentIllness); } if (String.IsNullOrEmpty(eDiagnosis.PathologicalHistory)) { cmd.Parameters.AddWithValue("@ph", Null.String(eDiagnosis.PathologicalHistory)); } else { cmd.Parameters.AddWithValue("@ph", eDiagnosis.PathologicalHistory); } cmd.Parameters.AddWithValue("@idhc", eDiagnosis.IDClinicHistory); cmd.Parameters.AddWithValue("@iddoc", eDiagnosis.IDDdoctor); cn.DB().Open(); var response = cmd.ExecuteNonQuery(); msj = response != 1 ? "Row not Affected" : "Diagnosis created successfully"; return(msj); } catch (Exception e) { msj = $"diagnosis could not be created {e.Message}"; return(msj); } finally { cn.DB().Close(); } }
public string Update(EDiagnosis eDiagnosis) { var msj = ""; const string sql = "UPDATE tb_diagnosis SET " + "reasons_for_consultation = @rc, " + "current_illness = @ci, " + "pathological_history = @ph, " + "id_clinic_history = @idhc " + "WHERE id = @id"; try { var cmd = new SqlCommand(sql, cn.DB()); if (String.IsNullOrEmpty(eDiagnosis.ReasonsForConsultation)) { cmd.Parameters.AddWithValue("@rc", Null.String(eDiagnosis.ReasonsForConsultation)); } else { cmd.Parameters.AddWithValue("@rc", eDiagnosis.ReasonsForConsultation); } if (String.IsNullOrEmpty(eDiagnosis.CurrentIllness)) { cmd.Parameters.AddWithValue("@ci", Null.String(eDiagnosis.CurrentIllness)); } else { cmd.Parameters.AddWithValue("@ci", eDiagnosis.CurrentIllness); } if (String.IsNullOrEmpty(eDiagnosis.PathologicalHistory)) { cmd.Parameters.AddWithValue("@ph", Null.String(eDiagnosis.PathologicalHistory)); } else { cmd.Parameters.AddWithValue("@ph", eDiagnosis.PathologicalHistory); } cmd.Parameters.AddWithValue("@idhc", eDiagnosis.IDClinicHistory); cmd.Parameters.AddWithValue("@id", eDiagnosis.ID); cn.DB().Open(); var response = cmd.ExecuteNonQuery(); msj = response != 1 ? "Row not Affected" : "Diagnosis updated successfully"; return(msj); } catch (Exception e) { msj = $"diagnosis could not be updated {e.Message}"; return(msj); } finally { cn.DB().Close(); } }
public string Update(EDiagnosis eDiagnosis) { return(_dDiagnosis.Update(eDiagnosis)); }
public string SaveDiagnosis(EDiagnosis eDiagnosis) { return(_dDiagnosis.SaveDiagnosis(eDiagnosis)); }