public IEnumerable <Entities.User> UserSelectBySearch(Paging objPaging) { var storeProc = "Users_Select"; SqlParameter[] objSqlParameters = new SqlParameter[5]; //objSqlParameters[0] = new SqlParameter("@ActionId", objPaging.ActionId); objSqlParameters[0] = new SqlParameter("@CurrentPage", objPaging.CurrentPage); objSqlParameters[1] = new SqlParameter("@Uid", objPaging.Id); objSqlParameters[2] = new SqlParameter("@SortColumn", objPaging.SortColumn); objSqlParameters[3] = new SqlParameter("@SortOrder", objPaging.SortOrder); objSqlParameters[4] = new SqlParameter("@Search", objPaging.Search); var d = iSqlDbHelper.ExecuteDataTable(storeProc, CommandType.StoredProcedure, objSqlParameters); IEnumerable <Entities.User> users = d.AsEnumerable().Select(x => new Entities.User() { Uid = x.Field <int>("Uid"), Name = x.Field <string>("Name"), Email = x.Field <string>("Email"), Phone = x.Field <string>("Phone"), Created = x.Field <DateTime>("Created"), Modifed = x.Field <DateTime?>("Modifed"), Active = x.Field <bool>("Active"), UsersRole = new UsersRole() { UserRoleId = x.Field <int>("UserRoleId"), Role1 = new Role1() { Name = x.Field <string>("RoleName") } }, Paging = new Paging() { TotalCount = x.Field <int>("TotalCount"), PageSize = objPaging.PageSize, CurrentPage = objPaging.CurrentPage }, RentPayment = new Entities.RentPayment() { PaymentCount = x.Field <int>("Payments") } }).ToList(); return(users); }
public IEnumerable <Entities.RentPayment> Select(Entities.Models.Paging objPaging) { var storeProc = "RentPayment_Select"; SqlParameter[] objSqlParameters = new SqlParameter[6]; objSqlParameters[0] = new SqlParameter("@CurrentPage", objPaging.CurrentPage); objSqlParameters[1] = new SqlParameter("@SortColumn", objPaging.SortColumn); objSqlParameters[2] = new SqlParameter("@SortOrder", objPaging.SortOrder); objSqlParameters[3] = new SqlParameter("@Search", objPaging.Search); objSqlParameters[4] = new SqlParameter("@ActionID", objPaging.ActionId); objSqlParameters[5] = new SqlParameter("@Uid", objPaging.Id); var d = iSqlDbHelper.ExecuteDataTable(storeProc, CommandType.StoredProcedure, objSqlParameters); IEnumerable <Entities.RentPayment> users = d.AsEnumerable().Select(x => new Entities.RentPayment() { Uid = x.Field <int>("Uid"), RentPaymentId = x.Field <int>("RentPaymentId"), PaymentDate = x.Field <DateTime>("PaymentDate"), Payment = x.Field <double>("Payment"), Created = x.Field <DateTime>("Created"), Modifed = x.Field <DateTime?>("Modifed"), Active = x.Field <bool>("Active"), User = new Entities.User() { Name = x.Field <string>("Name"), Email = x.Field <string>("Email"), Phone = x.Field <string>("Phone"), }, Paging = new Paging() { TotalCount = x.Field <int>("TotalCount"), PageSize = objPaging.PageSize, CurrentPage = x.Field <int>("CurrentPage") }, RentPaymentNoticeSendLog = new Entities.RentPaymentNoticeSendLog() { NoticeCreated = x.Field <DateTime?>("NoticeCreated") } }).ToList(); return(users); }