// 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)); }