public ActionResult GetCategory(JqueryDataTableParamModel param) { var _list = _ICategoryRepository.GetAll(); return(Json(new { sEcho = param.sEcho, iTotalRecords = _list.Count(), iTotalDisplayRecords = _list.Count(), aaData = _list }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetProduct(JqueryDataTableParamModel param) { var _list = _IProductRepository.GetAll(); var result = _list.Select(s => new ProductViewModel { Id = s.Id, CategoryId = (int)s.CategoryId, Category = _ICategoryRepository.GetById((int)s.CategoryId).Name, Name = s.Name, Description = s.Description, Price = (decimal)s.Price, CreatedDate = s.CreatedDate.Value.ToString("dd-MM-yyyy h:mm tt") }); return(Json(new { sEcho = param.sEcho, iTotalRecords = _list.Count(), iTotalDisplayRecords = _list.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAll(JqueryDataTableParamModel model) { try { var donvi = db.UNITs.ToList().OrderBy(s => s.UNIT_ID); var lst = donvi.Skip(model.iDisplayStart).Take(model.iDisplayLength).ToList(); var entity = new List <UnitViewModel>(); foreach (var temp in donvi) { var tem = new UnitViewModel(); tem.UNIT_CODE = temp.UNIT_CODE; tem.UNIT_DES = temp.UNIT_DES; tem.UNIT_ID = temp.UNIT_ID; tem.UNIT_NAME = temp.UNIT_NAME; tem.UNIT_STATUS = temp.UNIT_STATUS; entity.Add(tem); } return(this.Json(new { data = entity, result = "success" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(this.Json(ex.Message.ToString(), JsonRequestBehavior.AllowGet)); } }
public JsonResult GetAll(JqueryDataTableParamModel model) { try { var loaiVe = db.TICKET_TYPE.OrderBy(c => c.TYPEID); if (!string.IsNullOrWhiteSpace(model.sSearch)) { string search = model.sSearch.Trim().ToUpper(); loaiVe = loaiVe.Where(c => (c.TYPENAME.ToUpper().Contains(search) || c.DESCRIPTIONS.ToUpper().Contains(search) || c.TYPE_CODE.ToUpper().Contains(search))).OrderBy(c => c.TYPEID); } switch (model.iSortCol_0) { case 1: { if (model.sSortDir_0 == "asc") { loaiVe = loaiVe.OrderBy(s => s.TYPENAME); } else { loaiVe = loaiVe.OrderByDescending(s => s.TYPENAME); } break; } case 2: { if (model.sSortDir_0 == "asc") { loaiVe.OrderBy(s => s.TYPE_CODE); } else { loaiVe.OrderByDescending(s => s.TYPE_CODE); } break; } default: break; } //Lấy bản ghi trả về view var lstArry = loaiVe.Skip(model.iDisplayStart).Take(model.iDisplayLength); int count = loaiVe.Count(); var entity = new List <TicketTypeModel>(); foreach (var item in lstArry) { var ticket = new TicketTypeModel(); ticket.TYPEID = item.TYPEID; ticket.TYPENAME = item.TYPENAME; ticket.DESCRIPTIONS = item.DESCRIPTIONS; ticket.TYPE_CHECK = item.TYPE_CHECK; ticket.TYPE_CODE = item.TYPE_CODE; entity.Add(ticket); } return(this.Json(new { sEcho = model.sEcho, iTotalRecords = count, iTotalDisplayRecords = count, data = entity }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json("error", JsonRequestBehavior.AllowGet)); } }
public JsonResult GetAll(JqueryDataTableParamModel model) { try { var donvi = db.UNITs.ToList().OrderBy(s => s.UNIT_ID); if (!string.IsNullOrWhiteSpace(model.sSearch)) { string search = model.sSearch.Trim().ToUpper(); donvi = donvi.Where(d => (d.UNIT_NAME ?? "").ToUpper().Contains(search) || (d.UNIT_CODE ?? "").ToUpper().Contains(search)).OrderBy(d => d.UNIT_ID); } switch (model.iSortCol_0) { case 0: { if (model.sSortDir_0 == "asc") { donvi = donvi.OrderBy(s => s.UNIT_CODE); } else { donvi = donvi.OrderByDescending(s => s.UNIT_CODE); } break; } case 1: { if (model.sSortDir_0 == "asc") { donvi = donvi.OrderBy(s => s.UNIT_NAME); } else { donvi = donvi.OrderByDescending(s => s.UNIT_NAME); } break; } default: break; } var lst = donvi.Skip(model.iDisplayStart).Take(model.iDisplayLength).ToList(); int count = db.UNITs.Count(); var entity = new List <UnitViewModel>(); foreach (var temp in lst) { var tem = new UnitViewModel(); tem.UNIT_CODE = temp.UNIT_CODE; tem.UNIT_DES = temp.UNIT_DES; tem.UNIT_ID = temp.UNIT_ID; tem.UNIT_NAME = temp.UNIT_NAME; tem.UNIT_STATUS = temp.UNIT_STATUS; entity.Add(tem); } return(this.Json(new { sEcho = model.sEcho, iTotalRecords = count, iTotalDisplayRecords = count, data = entity }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json("error", JsonRequestBehavior.AllowGet)); } }
/// <summary> /// get list user info /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonResult GetAll(JqueryDataTableParamModel model) { try { var khachHang = db.USER_INFO.Where(t => t.USER_TYPEID == 2).OrderBy(t => t.USER_ID); if (!string.IsNullOrWhiteSpace(model.sSearch)) { string search = model.sSearch.Trim().ToUpper(); // Lấy giá trị phù hợp với text nhập theo các cột muốn tìm khachHang = khachHang.Where(c => (c.USER_NAME.ToUpper().Contains(search) || c.USER_CODE.ToUpper().Contains(search) || c.EMAIL.ToUpper().Contains(search) || c.PHONE.ToUpper().Contains(search) )).OrderBy(c => c.USER_ID); } // Sort: Sắp xếp switch (model.iSortCol_0) { // Sort order: Thứ tự cột sắp xếp case 0: { // Cột 1 không sắp xếp: checkbox break; } // Sắp xếp theo tên khách hàng. case 1: { if (model.sSortDir_0 == "asc") { khachHang = khachHang.OrderBy(r => r.USER_NAME); } else { khachHang = khachHang.OrderByDescending(r => r.USER_NAME); } break; } // Sắp xếp theo mã khách hàng. case 2: { if (model.sSortDir_0 == "asc") { khachHang = khachHang.OrderBy(r => r.USER_CODE); } else { khachHang = khachHang.OrderByDescending(r => r.USER_CODE); } break; } // Sắp xếp theo số điện thoại. case 3: { if (model.sSortDir_0 == "asc") { khachHang = khachHang.OrderBy(r => r.PHONE); } else { khachHang = khachHang.OrderByDescending(r => r.PHONE); } break; } // Sắp xếp theo số CMND. case 4: { if (model.sSortDir_0 == "asc") { khachHang = khachHang.OrderBy(r => r.IDENTITY_NUMBER); } else { khachHang = khachHang.OrderByDescending(r => r.IDENTITY_NUMBER); } break; } // Sắp xếp theo giới tính. case 5: { if (model.sSortDir_0 == "asc") { khachHang = khachHang.OrderBy(r => r.SEX); } else { khachHang = khachHang.OrderByDescending(r => r.SEX); } break; } // Sắp xếp theo ngày sinh. case 6: { if (model.sSortDir_0 == "asc") { khachHang = khachHang.OrderBy(r => r.USER_BIRTH); } else { khachHang = khachHang.OrderByDescending(r => r.USER_BIRTH); } break; } // Sắp xếp theo email. case 7: { if (model.sSortDir_0 == "asc") { khachHang = khachHang.OrderBy(r => r.EMAIL); } else { khachHang = khachHang.OrderByDescending(r => r.EMAIL); } break; } // Sắp xếp theo điểm tích lũy. case 8: { if (model.sSortDir_0 == "asc") { khachHang = khachHang.OrderBy(r => Convert.ToDateTime(r.REDEEM_POINTS)); } else { khachHang = khachHang.OrderByDescending(r => Convert.ToDateTime(r.REDEEM_POINTS)); } break; } // Sắp xếp theo trạng thái. case 9: { if (model.sSortDir_0 == "asc") { khachHang = khachHang.OrderBy(r => Convert.ToDateTime(r.USER_STATUS)); } else { khachHang = khachHang.OrderByDescending(r => Convert.ToDateTime(r.USER_STATUS)); } break; } default: { break; } } // Lấy bản ghi trả về view var lstArray = khachHang.Skip(model.iDisplayStart).Take(model.iDisplayLength).ToList(); // Đếm số bản ghi int count = khachHang.Count(); var entity = new List <USER_INFOViewModel>(); foreach (var temp in lstArray) { var tem = new USER_INFOViewModel(); tem.USER_ID = temp.USER_ID; tem.USER_NAME = temp.USER_NAME; tem.USER_CODE = temp.USER_CODE; tem.USER_BIRTH = temp.USER_BIRTH; tem.SEX = temp.SEX; tem.REDEEM_POINTS = temp.REDEEM_POINTS; tem.PHONE = temp.PHONE; tem.IDENTITY_NUMBER = temp.IDENTITY_NUMBER; tem.USER_STATUS = temp.USER_STATUS; tem.EMAIL = temp.EMAIL; entity.Add(tem); } return(this.Json(new { sEcho = model.sEcho, iTotalRecords = count, iTotalDisplayRecords = count, data = entity }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json("error", JsonRequestBehavior.AllowGet)); } }