public List<RawVisitModel> GetInvalidRawVisit()
{
var rawVisits = new List<RawVisitModel>();
var repo = new HealthInformationProgram.Data.Repositories.RawVisitRepository();
var exRepo = new HealthInformationProgram.Data.Repositories.LookupExceptionRepository();
var excpList = exRepo.GetAll();
foreach ( var raw in repo.GetAll().Where(v=>v.err_cd<0).OrderByDescending(v=>v.rec_creat_dt) )
{
var viewModel = new RawVisitModel();
var exception =excpList.Where(e => e.err_cd == raw.err_cd).FirstOrDefault();
viewModel.ErrorDescription = (exception != null) ? exception.exception_descn : "No error description in DB";
viewModel.ErrorCode = GetDataValue(raw.err_cd);
viewModel.VisitId = GetDataValue(raw.visit_uuid);
viewModel.VisitJson = GetDataValue(raw.visit_json);
viewModel.VisitStatus = GetDataValue(raw.visit_stat);
viewModel.UpdatedBy = GetDataValue(raw.rec_updt_user_id_cd);
viewModel.UpdateDate = GetDataValue(raw.rec_updt_dt);
viewModel.CreatedBy = GetDataValue(raw.rec_creat_user_id_cd);
viewModel.CreateDate = GetDataValue(raw.rec_creat_dt);
rawVisits.Add(viewModel);
}
return rawVisits;
}
internal int UpdateRawvisit(RawVisitModel model)
{
var repo = new HealthInformationProgram.Data.Repositories.RawVisitRepository();
var dataModel = new HealthInformationProgram.Data.Tables.raw_visit();
try
{
dataModel.visit_uuid = model.VisitId.Trim();
dataModel.visit_json = model.VisitJson;
dataModel.visit_stat = model.VisitStatus;
if ( String.IsNullOrEmpty(model.ErrorCode) == false )
{
dataModel.err_cd = Convert.ToInt32(model.ErrorCode);
}
dataModel.rec_updt_dt = DateTime.Now;
dataModel.rec_updt_user_id_cd = model.UpdatedBy;
var returnCode = repo.Update(dataModel);
return returnCode;
}catch(Exception ex)
{
throw ex;
}
}
