/// <summary> /// Lấy nhanh sách nhân viên theo điều kiện /// </summary> /// <param name="employeeFilter"> /// Page /// PageSize /// Search /// </param> /// <returns>Danh sách nv</returns> /// CreatedBy KDLong 07/05/2021 public Pagging <Employee> GetEmployees(EmployeeFilter employeeFilter) { using (dbConnection = new MySqlConnection(connectionString)) { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Search", employeeFilter.Search); var totalRecords = dbConnection.QueryFirstOrDefault <int>("Proc_GetTotalEmployees", param: parameters, commandType: CommandType.StoredProcedure); var totalPages = Math.Ceiling((decimal)totalRecords / employeeFilter.PageSize); var employees = dbConnection.Query <Employee>("Proc_GetEmployeesFilter", param: employeeFilter, commandType: CommandType.StoredProcedure); // Dữ liệu pagging var paging = new Pagging <Employee>() { TotalRecords = totalRecords, TotalPages = (int)totalPages, Data = employees, PageIndex = employeeFilter.Page, PageSize = employeeFilter.PageSize }; return(paging); } }
/// <summary> /// Lấy dữ liệu phân trang /// </summary> /// <param name="customerFilter"> /// Page = Trang hiện tại /// PageSize = Số khách hàng trên 1 trang /// FullName = Tên dùng để filter /// PhoneNumber = Số điện thoại dùng để filter /// CustomerGroupId = Nhóm khách hàng dùng để filter /// </param> /// <returns></returns> /// CreatedBy KDLong 28/04/2021 public Pagging <Customer> GetCustomers(CustomerFilter customerFilter) { using (dbConnection = new MySqlConnection(connectionString)) { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@FullName", customerFilter.FullName); parameters.Add("@PhoneNumber", customerFilter.PhoneNumber); parameters.Add("@CustomerGroupId", customerFilter.CustomerGroupId); var totalRecords = dbConnection.QueryFirstOrDefault <int>("Proc_KDLong_GetTotalCustomers", param: parameters, commandType: CommandType.StoredProcedure); var totalPages = Math.Ceiling((decimal)totalRecords / customerFilter.PageSize); var customers = dbConnection.Query <Customer>("Proc_KDLong_GetEmployees", param: customerFilter, commandType: CommandType.StoredProcedure); // Dữ liệu pagging var paging = new Pagging <Customer>() { TotalRecords = totalRecords, TotalPages = (int)totalPages, Data = customers, PageIndex = customerFilter.Page, PageSize = customerFilter.PageSize }; return(paging); } }
/// <summary> /// Phân trang /// </summary> /// <param name="pageSize">số lượng bản ghi trong trang</param> /// <param name="pageIndex">vị trí trang</param> /// <param name="filter">lọc chuỗi</param> /// <returns> /// Danh sách bản ghi /// </returns> /// CreatedBy: LMDuc (11/05/2021) public Pagging <Employee> GetEmployees(int pageSize, int pageIndex, string filter) { //Khởi tạo trang var res = new Pagging <Employee>() { Page = pageIndex, PageSize = pageSize }; using (dbConnection = new MySqlConnection(connectionString)) { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@filter", filter); // Tính tổng nhân viên. int?totalRecord = dbConnection.QueryFirstOrDefault <int>("Proc_GetTotalEmployees", parameters, commandType: CommandType.StoredProcedure); if (totalRecord == null) { return(res); } res.TotalRecord = totalRecord; // Lấy danh sách nhân viên. DynamicParameters dynamicParameters = new DynamicParameters(); dynamicParameters.Add("@pageIndex", pageIndex); dynamicParameters.Add("@pageSize", pageSize); dynamicParameters.Add("@filter", filter); var employees = dbConnection.Query <Employee>("Proc_GetEmployeeFilter", dynamicParameters, commandType: CommandType.StoredProcedure); res.Data = employees; return(res); } }
public IEnumerable <Post> GetPosts(Pagging pagging) { IEnumerable <Post> requiredPosts = null; using var scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted }); requiredPosts = _dataContext.Set <Post>() .AsNoTracking() .Skip((pagging.CurrentPage - 1) * pagging.PageSize).Take(pagging.PageSize).ToList(); scope.Complete(); return(requiredPosts); }
/// <summary> /// Phân trang /// </summary> /// <param name="pagging"></param> /// <returns></returns> /// Created by: TMQuy public IEnumerable <Employee> Pagging(Pagging pagging) { using (dbConnection = new MySqlConnection(connectingDB)) { var sqlCommad = "Proc_PaggingEmployee"; DynamicParameters param = new DynamicParameters(); param.Add("@m_Page", pagging.pageIndex); param.Add("@m_PageSize", pagging.pageSize); param.Add("@fillter", pagging.fillter); var employees = dbConnection.Query <Employee>(sqlCommad, param: param, commandType: CommandType.StoredProcedure); return(employees); } }
/// <summary> /// Lọc dữ liệu phân trang /// </summary> /// <param name="filter"></param> /// <returns></returns> public Pagging <Customer> GetCustomers(CustomerFilter filter) { // Thiết lập kết nối cơ sở dữ liệu. var connection = new MySqlConnection(connectionString); // Tính tổng số khách hàng có điều kiện. var totalRecord = connection.QueryFirstOrDefault <int>("Proc_D_GetTotalCustomer", filter, commandType: CommandType.StoredProcedure); // Lấy danh sách khách hàng có phân trang. var customers = connection.Query <Customer>("Proc_CustomerFilter", filter, commandType: CommandType.StoredProcedure); // trả dữ liệu. var paging = new Pagging <Customer>() { totalRecord = totalRecord, data = customers, pageIndex = filter.PageIndex, pageSize = filter.PageSize }; return(paging); /* Pagging<Customer> pageNew = new Pagging<Customer>(); * * var sqlCommand = "Proc_PaggingCustomers"; * var customers = dbConnection.Query<Customer>(sqlCommand, param: filter, commandType: CommandType.StoredProcedure); * var totalPages = 1; * if (customers.Count() % 10 == 0) * { * totalPages = customers.Count() / 10; * } * else * { * totalPages = (customers.Count() / 10) + 1; * } * pageNew = new Pagging<Customer> * { * totalRecord = customers.Count(), * totalPages = totalPages, * pageIndex = filter.PageIndex, * data = customers, * pageSize = filter.PageSize * }; * pageNew.data = customers; * return pageNew;*/ }
public Pagging<Customer> GetCustomers(CustomerFilter filter) { using (dbConnection = new MySqlConnection(connectionString)) { Pagging<Customer> pageNew = new Pagging<Customer>(); //DynamicParameters dynamicParameters = new DynamicParameters(); //dynamicParameters.Add("@page", filter.Page); //dynamicParameters.Add("@pageSize", filter.PageSize); //dynamicParameters.Add("@filter", filter.filter); //dynamicParameters.Add("@customerGroupId", filter.CustomerGroupId); var sqlCommand = "Proc_PaggingCustomers"; var customers = dbConnection.Query<Customer>(sqlCommand, param: filter, commandType: CommandType.StoredProcedure); //var totalRecord = dbConnection.QueryFirstOrDefault<int>("Proc_GetTotalCustomers", param: dynamicParameters, commandType: CommandType.StoredProcedure); var totalPages = 1; if (customers.Count() % 10 == 0) { totalPages = customers.Count() / 10; } else { totalPages = (customers.Count() / 10) + 1; } pageNew = new Pagging<Customer> { totalRecord = customers.Count(), totalPages = totalPages, pageIndex = filter.Page, data = customers, pageSize = filter.PageSize }; pageNew.data = customers; return pageNew; } }
public IEnumerable <Post> Posts(Pagging pagging) { return(_postDataService.GetPosts(pagging)); }
public JsonResult GetListQuestion(int accountId, int examId, int page) { string functionName = System.Reflection.MethodBase.GetCurrentMethod().Name; try { if (!_accountRepository.AccountExists(accountId)) { Log4Net.log.Error(className + "." + functionName + " - " + Log4Net.AddErrorLog(Constants.accountNotFound)); return(Json(MessageResult.GetMessage(MessageType.ACCOUNT_NOT_FOUND))); } //Check id exam exist in the database if (!_examRepository.ExamExist(examId)) { Log4Net.log.Error(className + "." + functionName + " - " + Log4Net.AddErrorLog(Constants.groupNotFound)); return(Json(MessageResult.GetMessage(MessageType.GROUP_NOT_FOUND))); } if (!ModelState.IsValid) { Log4Net.log.Error(className + "." + functionName + " - " + Log4Net.AddErrorLog(Constants.notFound)); return(Json(MessageResult.GetMessage(MessageType.NOT_FOUND))); } //This is get all questions of the exam by id exam List <ExamQuestionEntity> examQuestionEntity = _examQuestionRepository.getListQuestions(examId); List <AnswerUserEntity> answerUsers = _answerUserRepository.GetAnswerUserEntities(accountId); List <QuestionEntity> listQuestionEntities = new List <QuestionEntity>(); foreach (var examQuestion in examQuestionEntity) { // Get all informations of the question by questionId and save it in the list QuestionEntity questionEntity = _questionRepository.getQuestionInformation(examQuestion.QuestionId); listQuestionEntities.Add(questionEntity); } List <QuestionListResult> questionLists = new List <QuestionListResult>(); foreach (var item in listQuestionEntities) { QuestionListResult q = new QuestionListResult(); q.questionId = item.QuestionId; q.part = item.Part; q.image = item.Image; q.fileMp3 = item.FileMp3; q.questionName = item.QuestionName; q.A = item.A; q.B = item.B; q.C = item.C; q.D = item.D; q.correctAnswer = item.CorrectAnswer; q.team = item.Team; foreach (var answer in answerUsers) { if (q.questionId == answer.QuestionId) { q.answerUser = answer.AnswerKey; } } questionLists.Add(q); } List <QuestionListResult> pagging = Pagging.GetQuestions(page, questionLists); return(Json(pagging)); } catch (Exception ex) { Log4Net.log.Error(className + "." + functionName + " - " + Log4Net.AddErrorLog(ex.Message)); return(Json(MessageResult.ShowServerError(ex.Message))); } }
public IActionResult Pagging([FromQuery] Pagging pagging) { var employees = _employeeService.Pagging(pagging); return(Ok(employees)); }
/// <summary> /// Phân trang /// </summary> /// <param name="pagging"></param> /// <returns></returns> /// Created by: TMQuy public IEnumerable <Employee> Pagging(Pagging pagging) { var employees = _employeeRepository.Pagging(pagging); return(employees); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!IsPostBack) { int _pageIndex = Lib.QueryString.PageIndex; _pageIndex = _pageIndex == 0 ? 1 : _pageIndex; _catID = Lib.QueryString.CategoryID; long news_ID = Lib.QueryString.NewsID; //_catID = Lib.QueryString.ParentCategory==0 ? Lib.QueryString.ParentCategory : Lib.QueryString.CategoryID; DataTable objCat = XpcHelper.SelectCategory(_catID); if (objCat != null && objCat.Rows.Count > 0) { CatName = string.Format("<a title=\"{1}\" href=\"{0}\">{1}</a>", objCat.Rows[0]["Cat_URL"], objCat.Rows[0]["Cat_Name"]); CatRSS = string.Format("<a title=\"{1}\" target=\"_blank\" class=\"rss\" href=\"{0}\"><img src=\"/images/IconRSS.gif\"/></a>", objCat.Rows[0]["RSS_URL"], objCat.Rows[0]["Cat_Name"]); Utility.SetPageHeader(this.Page, objCat.Rows[0]["Cat_Name"].ToString(), objCat.Rows[0]["Cat_Name"] + "-" + ", " + objCat.Rows[0]["Cat_displayURL"], objCat.Rows[0]["Cat_Name"] + ", " + objCat.Rows[0]["Cat_displayURL"], Lib.QueryString.PageIndex > 1); //Đặt SEO cho Facebook Utility.SetFaceBookSEO(this.Page, objCat.Rows[0]["Cat_Name"].ToString(), objCat.Rows[0]["Cat_Name"] + "-" + ", " + objCat.Rows[0]["Cat_displayURL"], System.Configuration.ConfigurationManager.AppSettings["WebDomain"] + "/images/BannerHome.png", System.Configuration.ConfigurationManager.AppSettings["WebDomain"] + "/" + objCat.Rows[0]["Cat_URL"]); } if (news_ID != 0) { DataTable detail = XpcHelper.displayMicrof_Detail(news_ID); if (detail != null && detail.Rows.Count > 0) { DataRow dtRow = detail.Rows[0]; string noHTML = Regex.Replace(dtRow["News_Content"].ToString(), @"<[^>]+>| ", "").Trim(); ltrBigVideo.Text = "<iframe width=\"595\" height=\"351\" src=\"" + noHTML + "\" frameborder=\"0\" allowfullscreen=\"\"></iframe>"; ltrBigTitle.Text = dtRow["News_Title"].ToString(); ltrDateTime.Text = dtRow["PublishDate"].ToString(); ltrBigInitContent.Text = dtRow["News_InitContent"].ToString(); string Seo_Title = dtRow["News_Title"].ToString(); string Seo_Des = dtRow["News_InitContent"].ToString(); string Seo_KeyWord = !String.IsNullOrEmpty(dtRow["Extension3"].ToString()) ? dtRow["Extension3"].ToString() : ""; Utility.SetPageHeaderDetail(this.Page, Seo_Title, objCat.Rows[0]["Cat_Name"].ToString(), Seo_Des, Seo_KeyWord); } } DataTable objTintuc = XpcHelper.displayGetDanhSachTin(_catID, 1, 5, 70); if (objTintuc != null && objTintuc.Rows.Count > 0) { if (news_ID == 0) { DataRow dtRow = objTintuc.Rows[0]; string noHTML = Regex.Replace(dtRow["News_Content"].ToString(), @"<[^>]+>| ", "").Trim(); ltrBigVideo.Text = "<iframe width=\"595\" height=\"351\" src=\"" + noHTML + "\" frameborder=\"0\" allowfullscreen=\"\"></iframe>"; ltrBigTitle.Text = dtRow["News_Title"].ToString(); ltrDateTime.Text = dtRow["PublishDate"].ToString(); ltrBigInitContent.Text = dtRow["News_InitContent"].ToString(); } rptData.DataSource = objTintuc; rptData.DataBind(); } DataTable objVideoTongHop = XpcHelper.displayGetDanhSachTin(_catID, _pageIndex, _pageSize, 120); if (objVideoTongHop != null && objVideoTongHop.Rows.Count > 0) { rptListVideo.DataSource = objVideoTongHop; rptListVideo.DataBind(); } Pagging.TotalPage = XpcHelper.GetDanhSachTinCount(_catID); Pagging.DoPagging(_pageIndex); } } }
public ActionResult Listar([FromBody] Pagging pagging) { return(Ok()); }
public async Task <ICollection <Elanat> > GetAllElanatsPaged(paggingData paggingData) { if (paggingData.Expression.IsNullOrEmpty()) { paggingData.Expression = ""; } if (paggingData.SortBy.IsNullOrEmpty()) { paggingData.SortBy = "ElanatId"; } var list = _entity.Where(c => c.MessageTopic.Contains(paggingData.Expression) || c.MessageText.Contains(paggingData.Expression)) .OrderBy(c => c.ElanatId); if (paggingData.SortMethod == "asc") { switch (paggingData.SortBy) { case "messageTopic": list = list.OrderBy(c => c.MessageTopic); break; case "messageText": list = list.OrderBy(c => c.MessageText); break; case "dateFrom": list = list.OrderBy(c => c.DateFrom); break; case "dateTo": list = list.OrderBy(c => c.DateTo); break; //case "DesLevel": // list = list.OrderBy(c => c.DesLevel); // break; default: list = list.OrderBy <Elanat>(paggingData.SortBy); break; } } else { switch (paggingData.SortBy) { case "messageTopic": list = list.OrderByDescending(c => c.MessageTopic); break; case "messageText": list = list.OrderByDescending(c => c.MessageText); break; case "dateFrom": list = list.OrderByDescending(c => c.DateFrom); break; case "dateTo": list = list.OrderByDescending(c => c.DateTo); break; default: list = list.OrderBy <Elanat>(paggingData.SortBy + " descending"); break; } } return(await Pagging.PagedResult(list, paggingData).ToListAsync()); }
public IList <Pessoa> List(Pagging pagging) { return(_pessoaCollection.Find("").Skip((pagging.CurrentPage - 1) * pagging.CurrentPage).Limit(pagging.PageSize).ToList()); }