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