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