public IQueryable <CustomerEnt> Get_one(dtParam param, IQueryable <CustomerEnt> src) { return(src.AsNoTracking().Where(o => param.Search.Value != null ? o.Address.ToString().Contains(param.Search.Value) || o.Name.Contains(param.Search.Value) || o.ClientPAN.ToString().Contains(param.Search.Value) || o.Telephone.Contains(param.Search.Value) : true)); }
public JsonResult Table(dtParam param) { dtEmployee res = new dtEmployee(); res.data = res.GetData(param, db.Employees.AsNoTracking()); res.draw = param.Draw; res.recordsTotal = db.Employees.AsNoTracking().Count(); res.recordsFiltered = res.Count(param, db.Employees); return(Json(res)); }
public JsonResult ReportData(dtParam param) { var query = db.Orders.AsNoTracking().Where(s => s.OrderDate <= param.repEnd && s.OrderDate >= param.repStart); Models.DataTableModel.dtOrder res = new Models.DataTableModel.dtOrder(); res.data = res.GetData(param, query); res.draw = param.Draw; res.recordsTotal = db.Orders.AsNoTracking().Count(); res.recordsFiltered = res.Count(param, query); return(Json(res)); }
public IQueryable <Object> Get_one(dtParam param, IQueryable <MoneyReceipt> src) { return(src.AsNoTracking().Where(o => param.Search.Value != null ? o.Amount.ToString().Contains(param.Search.Value) || o.CustomerEnt.Name.Contains(param.Search.Value) || o.CustomerEnt.ClientPAN.ToString().Contains(param.Search.Value) || o.ReceiptDate.ToString().Contains(param.Search.Value) || o.ReceiptID.ToString().Contains(param.Search.Value) : true).Select(s => new { Amount = s.Amount, Customer = s.CustomerEnt.Name, CustomerPAN = s.CustomerEnt.ClientPAN, ReceiptDate = s.ReceiptDate.ToString(), ReceiptID = s.ReceiptID })); }
public JsonResult Table(dtParam param) { var query = db.Orders.AsNoTracking(); Models.DataTableModel.dtOrder res = new Models.DataTableModel.dtOrder(); res.data = res.GetData(param, query); res.draw = param.Draw; res.recordsTotal = query.Count(); res.recordsFiltered = res.Count(param, query); return(Json(res)); }
public JsonResult ReportData(dtParam param) { var query = db.Suppliers.AsNoTracking().Where(s => s.Address.Contains("минск")); dtSupplier res = new dtSupplier(); res.data = res.GetData(param, query); res.draw = param.Draw; res.recordsTotal = db.Suppliers.AsNoTracking().Count(); res.recordsFiltered = res.Count(param, query); return(Json(res)); }
public JsonResult Report0(dtParam param) { var query = db.Products.AsNoTracking().Where(p => p.Balance == 0); dtProduct res = new dtProduct(); res.data = res.GetData(param, query); res.draw = param.Draw; res.recordsTotal = db.Products.AsNoTracking().Count(); res.recordsFiltered = res.Count(param, query); return(Json(res)); }
public JsonResult CMogilev(dtParam param) { var query = db.CustomerInds.AsNoTracking().Where(cus => cus.Address.Contains("могил")); dtCustomerInd res = new dtCustomerInd(); res.data = res.GetData(param, query); res.draw = param.Draw; res.recordsTotal = db.CustomerInds.AsNoTracking().Count(); res.recordsFiltered = res.Count(param, query); return(Json(res)); }
public JsonResult Table(dtParam param) { var query = db.Products.AsNoTracking(); dtProduct res = new dtProduct(); res.data = res.GetData(param, query); res.draw = param.Draw; res.recordsTotal = query.Count(); res.recordsFiltered = res.Count(param, query); return(Json(res)); }
public JsonResult ReportData(dtParam param) { dtEmployee res = new dtEmployee(); var query = db.Employees.AsNoTracking().Where(emp => (DateTime.Now.Year - emp.BirstDate.Value.Year) * 8755.2 > 525312); res.data = res.GetData(param, query); res.draw = param.Draw; res.recordsTotal = db.Employees.AsNoTracking().Count(); res.recordsFiltered = res.Count(param, query); return(Json(res)); }
public IQueryable <Object> Get_one(dtParam param, IQueryable <Supplier> src) { return(src.AsNoTracking().Where(o => param.Search.Value != null ? o.Address.Contains(param.Search.Value) || o.Description.Contains(param.Search.Value) || o.Name.Contains(param.Search.Value) || o.SupplierPAN.ToString().Contains(param.Search.Value) || o.Telephone.Contains(param.Search.Value) : true).Select(s => new { SupplierPAN = s.SupplierPAN, Name = s.Name, Address = s.Address, Telephone = s.Telephone })); }
public JsonResult ReportData(dtParam param) { dtMoneyReceipt res = new dtMoneyReceipt(); var query = db.MoneyReceipts.Where(s => s.ReceiptDate <= param.repEnd && s.ReceiptDate >= param.repStart); res.data = res.GetData(param, query); res.draw = param.Draw; res.recordsTotal = db.MoneyReceipts.AsNoTracking().Count(); res.recordsFiltered = res.Count(param, query); return(Json(res)); }
public IQueryable <CustomerInd> Get_one(dtParam param, IQueryable <CustomerInd> src) { return(src.AsNoTracking().Where(o => param.Search.Value != null ? o.Address.ToString().Contains(param.Search.Value) || o.BirstDate.ToString().Contains(param.Search.Value) || o.Description.Contains(param.Search.Value) || o.Email.Contains(param.Search.Value) || o.FirstName.Contains(param.Search.Value) || o.LastName.Contains(param.Search.Value) || o.PassportId.Contains(param.Search.Value) || o.Patronymic.Contains(param.Search.Value) || o.Telephone.Contains(param.Search.Value) : true)); }
public IQueryable <Product> Get_one(dtParam param, IQueryable <Product> src) { return(src.AsNoTracking().Where(o => param.Search.Value != null ? o.RegistrationDate.ToString().Contains(param.Search.Value) || o.Name.Contains(param.Search.Value) || o.Designation.Contains(param.Search.Value) || o.Weight.ToString().Contains(param.Search.Value) || o.Description.Contains(param.Search.Value) || o.Balance.ToString().Contains(param.Search.Value) || o.Delivery_time.ToString().Contains(param.Search.Value) || o.Price.ToString().Contains(param.Search.Value) || o.Price_with_vat.ToString().Contains(param.Search.Value) : true)); }
public IQueryable <Object> Get_one(dtParam param, IQueryable <Order> src) { return(src.AsNoTracking().Where(o => param.Search.Value != null ? o.AmountVat.ToString().Contains(param.Search.Value) || o.CustomerEnt.Name.Contains(param.Search.Value) || o.CustomerInd.LastName.Contains(param.Search.Value) || o.OrderDate.ToString().Contains(param.Search.Value) || o.OrderID.ToString().Contains(param.Search.Value) || o.OrderStatus.Contains(param.Search.Value) || o.PersonnelNumber.ToString().Contains(param.Search.Value) : true).Select(s => new { OrderID = s.OrderID, OrderDate = s.OrderDate.ToString(), Customer = s.CustomerInd.LastName + " " + s.CustomerInd.FirstName + s.CustomerEnt.Name, AmountVat = s.AmountVat, OrderStatus = s.OrderStatus, Employee = s.Employee.LastName })); }
public IQueryable <Object> Get_one(dtParam param, IQueryable <Employee> src) { return(src.AsNoTracking().Where(o => param.Search.Value != null ? o.BirstDate.ToString().Contains(param.Search.Value) || o.Address.Contains(param.Search.Value) || o.LastName.Contains(param.Search.Value) || o.Name.Contains(param.Search.Value) || o.PassportID.ToString().Contains(param.Search.Value) || o.Patronymic.Contains(param.Search.Value) || o.PersonnelNumber.ToString().Contains(param.Search.Value) || o.Position.Contains(param.Search.Value) || o.Telephone.ToString().Contains(param.Search.Value) : true).Select(s => new { PersonnelNumber = s.PersonnelNumber, LastName = s.LastName, Name = s.Name, Patronymic = s.Patronymic, Position = s.Position, Telephone = s.Telephone, BirstDate = s.BirstDate.ToString() })); }
public IQueryable <Object> GetData(dtParam param, IQueryable <Supplier> src) { if (param.Order != null) { if (param.Order[0].Dir == "asc") { return(Get_one(param, src).SortBy(param.Columns[param.Order[0].Column].Data) .Skip(param.Start) .Take(param.Length == -1 ? 2147483647 : param.Length)); } else { return(Get_one(param, src).SortBy(param.Columns[param.Order[0].Column].Data + " " + param.Order[0].Dir) .Skip(param.Start) .Take(param.Length == -1 ? 2147483647 : param.Length)); } } else { return(Get_one(param, src).SortBy("SupplierPAN") .Skip(param.Start) .Take(param.Length == -1 ? 2147483647 : param.Length)); } }
public IQueryable <CustomerInd> GetData(dtParam param, IQueryable <CustomerInd> src) { if (param.Order != null) { if (param.Order[0].Dir == "asc") { return(Get_one(param, src).SortBy(param.Columns[param.Order[0].Column].Data) .Skip(param.Start) .Take(param.Length == -1 ? 2147483647 : param.Length)); } else { return(Get_one(param, src).SortBy(param.Columns[param.Order[0].Column].Data + " " + param.Order[0].Dir) .Skip(param.Start) .Take(param.Length == -1 ? 2147483647 : param.Length)); } } else { return(Get_one(param, src).OrderBy(o => o.CustomerIndId) .Skip(param.Start) .Take(param.Length == -1 ? 2147483647 : param.Length)); } }
public int Count(dtParam param, IQueryable <Employee> src) { return(Get_one(param, src).Count()); }
public int Count(dtParam param, IQueryable <MoneyReceipt> src) { return(Get_one(param, src).Count()); }
public int Count(dtParam param, IQueryable <Supplier> src) { return(Get_one(param, src).Count()); }
public int Count(dtParam param, IQueryable <Product> src) { return(Get_one(param, src).Count()); }
public int Count(dtParam param, IQueryable <CustomerInd> src) { return(Get_one(param, src).Count()); }