public List <UserDepartment_View> getUserList(SQLQueryBuilder queryBuilder)
{
PageBase pageCondition = new PageBase();
IQueryable <UserDepartment_View> query = (from a in db.UserDepartment_View
select a);
return(queryBuilder.BindQueryToContext(ref query, ref pageCondition));
}
public List <OrgMaster> getMasterList(SQLQueryBuilder queryBuilder)
{
PageBase pageCondition = new PageBase();
IQueryable <OrgMaster> query = (from a in db.OrgMaster
select a);
return(queryBuilder.BindQueryToContext(ref query, ref pageCondition));
}
public List <Department> getDepartList(SQLQueryBuilder queryBuilder)
{
PageBase pageCondition = new PageBase();
IQueryable <Department> query = (from a in db.Department
select a);
return(queryBuilder.BindQueryToContext(ref query, ref pageCondition));
}
public List <PODetail_View> GetPODetailViews(SQLQueryBuilder queryBuilder, PageBase pageCondition)
{
IQueryable <PODetail_View> query = (from a in db.PODetail_View
orderby a.PODetailID
select a);
return(queryBuilder.BindQueryToContext(ref query, ref pageCondition));
}
public List <POEntity_View> GetPOViews(SQLQueryBuilder queryBuiler, PageBase pagecondition)
{
IQueryable <POEntity_View> query = (from a in db.POEntity_View
orderby a.POID
select a);
return(queryBuiler.BindQueryToContext <POEntity_View>(ref query, ref pagecondition));
}
public List <POEntity_View> GetSupplierDDLItem(SQLQueryBuilder queryBuilder)
{
PageBase pageCondition = new PageBase();
IQueryable <POEntity_View> query = (from a in db.POEntity_View
orderby a.POID
select a);
return(queryBuilder.BindQueryToContext(ref query, ref pageCondition));
}
public List <ProjectOrg_View> GetProjectDDLItem(SQLQueryBuilder queryBuilder)
{
PageBase pageCondtion = new PageBase();
IQueryable <ProjectOrg_View> query = (from a in db.ProjectOrg_View
orderby a.ProjectName
select a);
return(queryBuilder.BindQueryToContext(ref query, ref pageCondtion));
}
public List <Users> GetUserAccDetail(SQLQueryBuilder queryBuilder)
{
PageBase pageCondition = new PageBase();
IQueryable <Users> query = from a in db.Users
orderby a.FirstName
select a;
//System.Threading.Thread.Sleep(3000);
return(queryBuilder.BindQueryToContext(ref query, ref pageCondition));
}
public List <Account> GetAccountItems(SQLQueryBuilder queryBuilder)
{
PageBase pageCondition = new PageBase();
IQueryable <Account> query = from a in db.Account
orderby a.UserID
select a;
query.Count();
return(queryBuilder.BindQueryToContext(ref query, ref pageCondition));
}