public string DownloadIPDReport(OPDFilterSearchModel searchModel)
{
try
{
PatientDetail entity = new PatientDetail();
List <PatientDetailModel> model = entity.GetGenericReport(GetIPDPredicate(searchModel));
return(createIPDReport(model));
}
catch (Exception ex)
{
throw ex;
}
}
public string DownloadReport(OPDFilterSearchModel searchModel)
{
try
{
OPDHistory entity = new OPDHistory();
List <OPDHistoryModel> model = entity.GetGenericReport(GetPredicate(searchModel));
return(createReport(model));
}
catch (Exception ex)
{
throw ex;
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
OPDFilterSearchModel model = getSearchModel();
if (model != null)
{
string path = service.DownloadReport(model);
MessageBox.Show(Messages.reportCompleted + path, "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
Utility.ErrorLog.Logging("Report List", ex.Message.ToString(), ex.StackTrace.ToString());
}
}
private void Search()
{
try
{
OPDFilterSearchModel model = getSearchModel();
if (model != null)
{
List <OPDHistoryModel> list = service.GetGenericReport(model);
dgvList.AutoGenerateColumns = false;
dgvList.DataSource = list;
//dgvList.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
dgvList.Refresh();
}
}
catch (Exception ex)
{
Utility.ErrorLog.Logging("Report List", ex.InnerException.ToString(), ex.StackTrace.ToString());
}
}
public Expression <Func <PatientDetail, bool> > GetIPDPredicate(OPDFilterSearchModel model)
{
Expression <Func <PatientDetail, bool> > predicate = t => t.Id != Guid.Empty;
Expression <Func <PatientDetail, bool> > predicateFilter = null;
if (model.searchText != null)
{
predicateFilter = t => t.FullName.Contains(model.searchText) || t.CasePaperNumber.Contains(model.searchText);
predicate = PredicateBuilder.AndAlso <PatientDetail>(predicate, predicateFilter);
predicateFilter = null;
}
if (model.from.HasValue)
{
predicateFilter = t => t.ModifiedOn.Value >= model.from.Value && t.ModifiedOn.Value <= model.to.Value;
predicate = PredicateBuilder.AndAlso <PatientDetail>(predicate, predicateFilter);
predicateFilter = null;
}
return(predicate);
}
private OPDFilterSearchModel getSearchModel()
{
OPDFilterSearchModel model = new OPDFilterSearchModel();
if (!string.IsNullOrEmpty(txtSearch.Text) && txtSearch.Text != "Search...")
{
model.searchText = txtSearch.Text;
}
if (dtpFrom.Value.Date > dtpTo.Value.Date)
{
MessageBox.Show(ErrorMessages.FromDateToDate, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
model.from = Convert.ToDateTime(dtpFrom.Value.ToShortDateString());
model.to = Convert.ToDateTime(dtpTo.Value.AddDays(1).ToShortDateString());
}
return(model);
}
public Expression <Func <OPDHistory, bool> > GetPredicate(OPDFilterSearchModel model)
{
Expression <Func <OPDHistory, bool> > predicate = t => t.PatientId.HasValue;
Expression <Func <OPDHistory, bool> > predicateFilter = null;
if (model.searchText != null)
{
predicateFilter = t => t.PatientDetail.FullName.Contains(model.searchText) || t.PatientDetail.CasePaperNumber.Contains(model.searchText);
predicate = PredicateBuilder.AndAlso <OPDHistory>(predicate, predicateFilter);
predicateFilter = null;
}
if (model.ConsultingId.Any())
{
predicateFilter = t => model.ConsultingId.Contains(t.ConsultingDoctorId);
predicate = PredicateBuilder.AndAlso <OPDHistory>(predicate, predicateFilter);
predicateFilter = null;
}
if (model.StatusId.Any())
{
predicateFilter = t => model.StatusId.Contains(t.StatusId);
predicate = PredicateBuilder.AndAlso <OPDHistory>(predicate, predicateFilter);
predicateFilter = null;
}
if (model.type.Any())
{
predicateFilter = t => model.type.Contains(t.IsFollowUp);
predicate = PredicateBuilder.AndAlso <OPDHistory>(predicate, predicateFilter);
predicateFilter = null;
}
if (model.from.HasValue)
{
predicateFilter = t => t.InTime.Value >= model.from.Value && t.InTime.Value <= model.to.Value;
predicate = PredicateBuilder.AndAlso <OPDHistory>(predicate, predicateFilter);
predicateFilter = null;
}
return(predicate);
}
private OPDFilterSearchModel getSearchModel()
{
OPDFilterSearchModel model = new OPDFilterSearchModel();
model.ConsultingId = new List <Guid?>();
model.StatusId = new List <Guid?>();
model.type = new List <int?>();
if (!string.IsNullOrEmpty(txtSearch.Text) && txtSearch.Text != "Search...")
{
model.searchText = txtSearch.Text;
}
if (ddlConsulting.SelectedIndex == 0)
{
if (model.ConsultingId.Any())
{
model.ConsultingId.Clear();
}
List <DoctorDetailModel> docModel = refDoctorService.GetByType(true);
foreach (DoctorDetailModel item in docModel)
{
model.ConsultingId.Add(item.Id);
}
}
else
{
if (model.ConsultingId.Any())
{
model.ConsultingId.Clear();
}
model.ConsultingId.Add(new Guid(ddlConsulting.SelectedValue.ToString()));
}
if (ddlStatus.SelectedIndex == 0)
{
if (model.StatusId.Any())
{
model.StatusId.Clear();
}
List <LookupModel> statusModel = lookupService.Get(LookUp.Status);
foreach (LookupModel item in statusModel)
{
model.StatusId.Add(item.Id);
}
}
else
{
if (model.StatusId.Any())
{
model.StatusId.Clear();
}
model.StatusId.Add(new Guid(ddlStatus.SelectedValue.ToString()));
}
if (ddlFollowUp.SelectedIndex == 0)
{
if (model.type.Any())
{
model.type.Clear();
}
model.type.Add(1);
model.type.Add(0);
}
else
{
if (model.type.Any())
{
model.type.Clear();
}
model.type.Add(Convert.ToInt32(ddlFollowUp.SelectedValue));
}
if (dtpFrom.Value.Date > dtpTo.Value.Date)
{
MessageBox.Show(ErrorMessages.FromDateToDate, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
model.from = Convert.ToDateTime(dtpFrom.Value.ToShortDateString());
model.to = Convert.ToDateTime(dtpTo.Value.AddDays(1).ToShortDateString());
}
return(model);
}
