Exemple #1
0
        // Display each admin List Individually
        //public async Task<List<admin_ActivityListModel>> each_admin_activityList(admin_ActivityListModel model)
        //{
        //    using (activityRepository = new ActivityRepository())
        //    {
        //        return await activityRepository.each_admin_activityList(model);
        //    }

        //}


        public List <admin_ActivityListModel> each_admin_activityList(admin_ActivityListModel model, out int RowCount)
        {
            using (activityRepository = new ActivityRepository())
            {
                return(activityRepository.each_admin_activityList(model, out RowCount));
            }
        }
        public List <admin_ActivityListModel> each_user_activityList(admin_ActivityListModel model, out int RowCount)
        {
            using (var connection = new SqlConnection(ConnectionString))
            {
                connection.Open();
                TranStatus        transaction = new TranStatus();
                DynamicParameters parameter   = new DynamicParameters();
                parameter.Add("@UserID", model.userId);
                parameter.Add("@pageIndex", model.pageIndex);
                parameter.Add("@pageSize", model.pageSize);

                parameter.Add("@RowCount", dbType: DbType.Int32, direction: ParameterDirection.Output);
                var result = connection.Query <admin_ActivityListModel>("each_user_activityList", parameter, commandType: CommandType.StoredProcedure);
                RowCount = parameter.Get <int>("@RowCount");
                return(result.ToList());
            }
        }
        public IActionResult each_user_activityList([FromBody] admin_ActivityListModel model)
        {
            TranStatus transaction = new TranStatus();
            Dictionary <String, Object> dctData = new Dictionary <string, object>();
            HttpStatusCode statusCode           = HttpStatusCode.OK;

            try
            {
                List <admin_ActivityListModel> each_user_activityList = new List <admin_ActivityListModel>();
                int rowcount = 0;
                each_user_activityList = iactivity.each_user_activityList(model, out rowcount);

                dctData.Add("each_user_activityList", each_user_activityList);
                dctData.Add("RowCount", rowcount);
            }
            catch (Exception ex)
            {
                transaction = CommonHelper.TransactionErrorHandler(ex);
                statusCode  = HttpStatusCode.BadRequest;
            }
            dctData.Add("Status", transaction);
            return(this.StatusCode(Convert.ToInt32(statusCode), dctData));
        }