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));
}
