private void BindGridView(Guid patient_ID)
{
try
{
DC_VitalDetails_Search _objSearch = new DC_VitalDetails_Search();
_objSearch.PageNo = intPageIndex;
_objSearch.PageSize = intPageSize;
//if (!String.IsNullOrWhiteSpace(txtPatientNameSearch.Text))
// _objSearch.Name = txtPatientNameSearch.Text;
//if (!String.IsNullOrWhiteSpace(txtMobilSearch.Text))
// _objSearch.MobileNo = txtMobilSearch.Text;
//if (!String.IsNullOrWhiteSpace(txtAgeSearch.Text))
// _objSearch.Name = txtAgeSearch.Text;
_objSearch.PatientID = patient_ID;
// var result = _objDL.GetPatientDetails(_objSearch);
var result = _objDL.GetVitalDetails(_objSearch);
grdvwVitals.DataSource = result;
grdvwVitals.PageSize = intPageSize;
grdvwVitals.PageIndex = intPageIndex;
if (result != null && result.Count > 0)
{
grdvwVitals.VirtualItemCount = Convert.ToInt32(result[0].TotalRecord);
}
grdvwVitals.DataBind();
}
catch (Exception ex)
{
throw;
}
}
public List <DC_VitalSingsDetails> GetVitalDetails(DC_VitalDetails_Search _objSearch)
{
try
{
using (CLMS_DBEntities context = new CLMS_DBEntities())
{
var search = from a in context.tbl_VitalSingsDetails select a;
if (_objSearch.TestReportID.HasValue)
{
search = from a in search where a.TestReportID == (_objSearch.TestReportID.HasValue ? _objSearch.TestReportID.Value : Guid.Empty) select a;
}
if (_objSearch.PatientID.HasValue && _objSearch.PatientID != Guid.Empty)
{
search = from a in search where a.PatientID == (_objSearch.PatientID.HasValue ? _objSearch.PatientID.Value : Guid.Empty) select a;
}
int total;
total = search.Count();
if (_objSearch.PageSize == 0)
{
_objSearch.PageSize = 10;
}
int skip = (_objSearch.PageNo ?? 0) * (_objSearch.PageSize ?? 0);
var canPage = skip < total;
var result = from a in search
join p in context.tbl_PatientDetails on a.PatientID equals p.ID
orderby a.CreatedDate
select new DC_VitalSingsDetails
{
TestReportID = a.TestReportID,
PatientName = p.Name,
BP = a.BP,
Pluse = a.Pluse,
Temperature = a.Temperature,
Weight = a.Weight,
TestDate = a.TestDate,
CreatedBy = a.CreatedBy,
CreatedDate = a.CreatedDate,
EditedBy = a.EditedBy,
EditedDate = a.EditedDate
};
return(result.OrderBy(p => p.CreatedDate).Skip(skip).Take((_objSearch.PageSize ?? total)).ToList());
}
}
catch (Exception ex)
{
throw;
}
}
