public async Task <List <AntibiogramDataDTO> > GetListByModelAsync(AntiHospitalSearchDTO searchData)
{
List <AntibiogramDataDTO> objList = new List <AntibiogramDataDTO>();
objList = await _apiHelper.GetDataListByModelAsync <AntibiogramDataDTO, AntiHospitalSearchDTO>("report_api/GetAntiHospModel", searchData);
return(objList);
}
public List <AntibiogramDataDTO> GetAntibiogramHospitalDataWithModel(AntiHospitalSearchDTO searchModel)
{
log.MethodStart();
List <AntibiogramDataDTO> objList = new List <AntibiogramDataDTO>();
//var searchModel = JsonSerializer.Deserialize<MenuSearchDTO>(param);
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objDataList = _db.DropdownListDTOs.FromSqlRaw <AntibiogramDataDTO>("sp_GET_RPAntibiogramHospital {0},{1},{2},{3},{4},{5},{6},{7}"
, searchModel.hos_code
, searchModel.prv_code
, searchModel.arh_code
, searchModel.gram
, searchModel.spc_code
, searchModel.org_code
, searchModel.start_date_str
, searchModel.end_date_str
).ToList();
objList = _mapper.Map <List <AntibiogramDataDTO> >(objDataList);
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objList);
}
public async Task <List <AntibiogramNationTemplateDTO> > GetAntibiogramNationTemplateListModelAsync(AntiHospitalSearchDTO searchData)
{
List <AntibiogramNationTemplateDTO> objList = new List <AntibiogramNationTemplateDTO>();
objList = await _apiHelper.GetDataListByModelAsync <AntibiogramNationTemplateDTO, AntiHospitalSearchDTO>("antitemplate_api/GetAntiNationTemplateModel", searchData);
return(objList);
}
public IEnumerable <AntibiogramHospitalTemplateDTO> GetAntibiogramHospitalTemplateModel([FromBody] AntiHospitalSearchDTO searchModel)
{
var objReturn = _service.GetAntibiogramHospitalTemplateWithModel(searchModel);
return(objReturn);
}
public List <AntibiogramHospitalTemplateDTO> GetAntibiogramHospitalTemplateWithModel(AntiHospitalSearchDTO searchModel)
{
log.MethodStart();
List <AntibiogramHospitalTemplateDTO> objList = new List <AntibiogramHospitalTemplateDTO>();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objDataList = _db.DropdownHospitalTemplateListDTOs.FromSqlRaw <AntibiogramHospitalTemplateDTO>("sp_GET_RPAntibiogramHospitalTemplateFile {0},{1},{2},{3},{4},{5}"
, searchModel.hos_code
, searchModel.prv_code
, searchModel.arh_code
, searchModel.spc_code
, searchModel.start_date
, searchModel.end_date
).ToList();
objList = _mapper.Map <List <AntibiogramHospitalTemplateDTO> >(objDataList);
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objList);
}
