private void BindGridView()
{
try
{
DC_PaitentDetails_Search _objSearch = new DC_PaitentDetails_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;
}
var result = _objDL.GetPatientDetails(_objSearch);
grdvwPatients.DataSource = result;
grdvwPatients.PageSize = intPageSize;
grdvwPatients.PageIndex = intPageIndex;
if (result != null && result.Count > 0)
{
grdvwPatients.VirtualItemCount = Convert.ToInt32(result[0].TotalRecord);
}
grdvwPatients.DataBind();
}
catch (Exception ex)
{
throw;
}
}
public List <DC_PatientDetails> GetPatientDetails(DC_PaitentDetails_Search _objSearch)
{
try
{
using (CLMS_DBEntities context = new CLMS_DBEntities())
{
var search = from a in context.tbl_PatientDetails select a;
if (_objSearch.ID.HasValue)
{
if (_objSearch.ID.Value != Guid.Empty)
{
Guid _PatientID = Guid.Parse(Convert.ToString(_objSearch.ID));
search = from a in search where a.ID == _PatientID select a;
}
}
if (!string.IsNullOrWhiteSpace(_objSearch.Name))
{
search = from a in search where a.Name.Contains(_objSearch.Name) select a;
}
if (!string.IsNullOrWhiteSpace(_objSearch.MobileNo))
{
search = from a in search where a.Mobile == _objSearch.MobileNo 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
orderby a.Name
select new DC_PatientDetails
{
ID = a.ID,
Name = a.Name,
Mobile = a.Mobile,
Age = a.Age,
Occupation = a.Occupation,
Address = a.Address,
Gender = a.Gender,
CreatedBy = a.CreatedBy,
CreatedDate = a.CreatedDate,
EditedBy = a.EditedBy,
EditedDate = a.EditedDate,
IsActive = a.IsActive,
TotalRecord = total
};
return(result.OrderBy(p => p.Name).Skip(skip).Take((_objSearch.PageSize ?? total)).ToList());
}
}
catch (Exception ex)
{
throw;
}
}
