public IList <lmsDrug> GetAllDrug(QueryFilterAttribute queryFilterAttribute, string filterValue)
{
try
{
if (queryFilterAttribute == QueryFilterAttribute.none)
{
return(new List <lmsDrug>());
}
var resultDetails = _objLabManagementEntities.lmsDrugs.Select(x => x);
if (queryFilterAttribute == QueryFilterAttribute.allDrugs)
{
return(resultDetails.ToList());
}
if (!string.IsNullOrEmpty(filterValue))
{
var predicate = GetWhereClass(queryFilterAttribute, filterValue);
resultDetails = resultDetails.Where(predicate);
return(resultDetails.ToList());
}
return(resultDetails.OrderByDescending(x => x.DRUGID).ToList());
}
catch (Exception ex)
{
_objIAppLogger.LogError(ex);
return(null);
}
}
public ActionResult ViewAllPatient(QueryFilterAttribute queryFilterAttribute = QueryFilterAttribute.none, string filterValue = "", string viewMessage = "")
{
var getAll = _objIPatient.GetAllPatient(queryFilterAttribute, filterValue, "IN", true);
var filterList = _objIPatient.GetFilterList();
ViewBag.FilterList = new SelectList(filterList, "Value", "Text");
ViewBag.Message = viewMessage;
return(View(getAll));
}
public ActionResult ViewAllDrug(QueryFilterAttribute queryFilterAttribute = QueryFilterAttribute.none, string filterValue = "", string transactionType = "")
{
var getAll = _objIHospitalMaster.GetAllDrug(queryFilterAttribute, filterValue);
var filterList = _objIHospitalMaster.GetDrugFilterList();
ViewBag.FilterList = new SelectList(filterList, "Value", "Text");
ViewBag.TransactionType = transactionType;
return(View(getAll));
}
private Expression <Func <lmsDrug, bool> > GetWhereClass(QueryFilterAttribute filterBy, string value)
{
var predicate = PredicateBuilder.True <lmsDrug>();
switch (filterBy)
{
case QueryFilterAttribute.drugName:
return(predicate.And(x => x.DRUGNAME.Contains(value)));
case QueryFilterAttribute.expiredDrugs:
var todayDate = DateTime.Now.Date;
return(predicate.And(x => x.EXPIRYDATE.HasValue && EntityFunctions.TruncateTime(x.EXPIRYDATE.Value) < todayDate));
case QueryFilterAttribute.rackNumber:
return(predicate.And(x => x.RackNumber.Contains(value)));
}
return(predicate);
}
public IList <lmsPatientRegistration> GetAllPatient(QueryFilterAttribute queryFilterAttribute, string filterValue, string patientType, bool includeAll = false)
{
try
{
if (queryFilterAttribute == QueryFilterAttribute.none || string.IsNullOrEmpty(filterValue))
{
return(new List <lmsPatientRegistration>());
}
var resultDetails = _objLabManagementEntities.lmsPatientRegistrations.Select(x => x);
if (!string.IsNullOrEmpty(filterValue))
{
var predicate = GetWhereClass(queryFilterAttribute, filterValue);
resultDetails = resultDetails.Where(predicate);
return(resultDetails.ToList());
}
return(includeAll ? resultDetails.Take(100).OrderByDescending(x => x.PATIENTID).ToList() : resultDetails.Take(100).Where(x => x.PATIENTTYPE == patientType).OrderByDescending(x => x.PATIENTID).ToList());
}
catch (Exception ex)
{
_objIAppLogger.LogError(ex);
return(null);
}
}
private Expression <Func <lmsPatientRegistration, bool> > GetWhereClass(QueryFilterAttribute filterBy, string value)
{
var predicate = PredicateBuilder.True <lmsPatientRegistration>();
switch (filterBy)
{
case QueryFilterAttribute.firstname:
return(predicate.And(x => x.PATIENTNAME.Contains(value)));
case QueryFilterAttribute.customId:
return(predicate.And(x => x.CUSTOMID == value));
case QueryFilterAttribute.dob:
var dob = Convert.ToDateTime(value).Date;
return(predicate.And(x => x.DOB.HasValue && EntityFunctions.TruncateTime(x.DOB.Value) == dob));
case QueryFilterAttribute.mobileno:
return(predicate.And(x => x.CONTACT.Contains(value)));
case QueryFilterAttribute.email:
return(predicate = predicate.And(x => x.PATIENTEMAILID == value));
}
return(predicate);
}
