public void InsertIntoMedicalReport(MedicalReportEntity report)
{
CreateSqlCommandSP("InsertIntoMedicalReport");
AddParameterString("@report", report.report);
dataReader = ExecuteReader();
}
public void UpdateMedicalReportById(MedicalReportEntity report)
{
CreateSqlCommandSP("UpdateMedicalReportById");
AddParameterInt("@id", report.id);
AddParameterString("@report", report.report);
dataReader = ExecuteReader();
}
public MedicalReportEntity GetReportById(MedicalReportEntity report)
{
CreateSqlCommandSP("GetReportById");
AddParameterInt("@id", report.id);
dataReader = ExecuteReader();
if (dataReader.Read())
{
report.id = dataReader.GetInt32(0);
report.report = dataReader.GetString(1);
}
return(report);
}
public List <MedicalReportEntity> GetAllReports()
{
CreateSqlCommandSP("GetAllReports");
dataReader = ExecuteReader();
List <MedicalReportEntity> listReports = new List <MedicalReportEntity>();
while (dataReader.Read())
{
MedicalReportEntity report = new MedicalReportEntity();
report.id = dataReader.GetInt32(0);
report.report = dataReader.GetString(1);
listReports.Add(report);
}
return(listReports);
}
public void InsertIntoMedicalReport(MedicalReportEntity report)
{
data.InsertIntoMedicalReport(report);
}
public void UpdateMedicalReportById(MedicalReportEntity report)
{
data.UpdateMedicalReportById(report);
}
public MedicalReportEntity GetReportById(MedicalReportEntity report)
{
return(data.GetReportById(report));
}
