public List <Entities.DrugDispense> SearchDrguDispense(Entities.DrugDispense drugDispense)
{
var drugDispenses = new List <Entities.DrugDispense>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.SearchDrugDispense))
{
database.AddInParameter(dbCommand, "@financial_year", DbType.String, drugDispense.FinancialYear);
database.AddInParameter(dbCommand, "@first_name", DbType.String, drugDispense.FirstName);
database.AddInParameter(dbCommand, "@last_name", DbType.String, drugDispense.LastName);
database.AddInParameter(dbCommand, "@dispense_from_date", DbType.String, drugDispense.DrugDispenseFromDate);
database.AddInParameter(dbCommand, "@dispense_to_date", DbType.String, drugDispense.DrugDispenseToDate);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var drugUtlisation = new DataModel.DrugDispenseDrugUtilisation();
var drugDispenseDetails = new Entities.DrugDispense()
{
DrugDispenseId = DRE.GetNullableInt32(reader, "drug_dispense_id", 0),
DrugDispenseNo = DRE.GetNullableInt32(reader, "drug_dispense_no", null),
DrugDispenseDate = DRE.GetNullableString(reader, "drug_dispense_date", null),
PatientId = DRE.GetNullableInt32(reader, "patient_id", null),
PatientCode = DRE.GetNullableInt32(reader, "patient_code", null),
PatientName = DRE.GetNullableString(reader, "full_name", null),
EmployerId = DRE.GetNullableInt32(reader, "employer_id", null),
EmployerCode = DRE.GetNullableInt32(reader, "employer_code", null),
EmployerName = DRE.GetNullableString(reader, "employer_name", null),
WorkingPeriodId = DRE.GetNullableInt32(reader, "working_period_id", null),
FinancialYear = DRE.GetNullableString(reader, "financial_year", null),
DrugDispenseDrugUtilisations = drugUtlisation.GetDrugUtilisationByDrugDispenseId(DRE.GetInt32(reader, "drug_dispense_id"))
};
drugDispenses.Add(drugDispenseDetails);
}
}
}
}
catch (Exception e)
{
throw e;
}
return(drugDispenses);
}
public List <Entities.Precautions> SearchDrguDispense(Entities.Precautions prescription)
{
var drugDispenses = new List <Entities.Precautions>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.SearchPrescription))
{
database.AddInParameter(dbCommand, "@patient_name", DbType.String, prescription.PatientName);
database.AddInParameter(dbCommand, "@employer_name", DbType.String, prescription.EmployerName);
database.AddInParameter(dbCommand, "@patient_code", DbType.Int32, prescription.PatientCode);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var drugUtlisation = new DataModel.DrugDispenseDrugUtilisation();
var drugDispenseDetails = new Entities.Precautions()
{
DrugDispenseId = DRE.GetNullableInt32(reader, "Precautions_id", 0),
DrugDispenseNo = DRE.GetNullableInt32(reader, "prescription_no", null),
DrugDispenseDate = DRE.GetNullableString(reader, "prescription_date", null),
PatientId = DRE.GetNullableInt32(reader, "patient_id", null),
PatientCode = DRE.GetNullableInt32(reader, "patient_code", null),
PatientName = DRE.GetNullableString(reader, "full_name", null),
EmployerId = DRE.GetNullableInt32(reader, "employer_id", null),
EmployerCode = DRE.GetNullableInt32(reader, "employer_code", null),
EmployerName = DRE.GetNullableString(reader, "employer_name", null),
DoctName = DRE.GetNullableString(reader, "DocName", null),
WorkingPeriodId = DRE.GetNullableInt32(reader, "working_period_id", null),
DrugDispenseDrugUtilisations = GetUtilisationByDrugDispenseId(DRE.GetInt32(reader, "Precautions_id"))
};
drugDispenses.Add(drugDispenseDetails);
}
}
}
}
catch (Exception e)
{
throw e;
}
return(drugDispenses);
}
