// GET api/<controller>/5
        public IEnumerable <Entities.UsersLog> Post(Entities.Models.Paging obj)
        {
            IEnumerable <Entities.UsersLog> obUsersLogs = null;

            // paging object
            Entities.Models.Paging objPaging = new Paging();
            objPaging.Search      = obj.Search;
            objPaging.CurrentPage = (obj.CurrentPage == null ? 0 : obj.CurrentPage);
            objPaging.PageSize    = obj.PageSize;

            //if (User.IsInRole("Admin"))
            //{
            //    objPaging.ActionId = 1;
            //    objPaging.Id = obj.Id;
            //    _objRentPayment = _objSqlDb.RentPaymentSelectBySearch(objPaging);
            //}
            //else
            {
                objPaging.ActionId = 2;
                objPaging.Id       = obj.Id;
                obUsersLogs        = iUserLog.Select(objPaging);
            }

            return(obUsersLogs);
        }
示例#2
0
        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);
        }
        // POST api/<controller>
        public IHttpActionResult Post(Entities.Models.Paging obj)
        {
            IEnumerable <Entities.RentPayment> _objRentPayment = null;

            // log active
            Models.LogModels.CreateUserLog("Web Api Post - RentPayment", 1, HttpContext.Current.Request.UserHostAddress);

            // paging object
            Entities.Models.Paging objPaging = new Paging();

            objPaging.Search      = obj.Search;
            objPaging.CurrentPage = (obj.CurrentPage == null ? 0 : obj.CurrentPage);
            objPaging.PageSize    = obj.PageSize;
            objPaging.ActionId    = 2;
            objPaging.Id          = obj.Id;


            var viewModel = iRentPayment.Select(objPaging).ToList().Select(Mapper.Map <Entities.RentPayment, Rent.Web.ViewModels.RentPaymentViewModel>);

            return(Ok(viewModel));
        }