public ActionResult Contragents_getItems()
{
var parameters = AjaxModel.GetParameters(HttpContext);
var mng = new FinanceManager();
var items = mng.GetFinContragents().AsQueryable();
string nameFilter;
if (GetStringFilter(parameters.filter, "name", out nameFilter))
{
items = items.Where(i => i.name.Contains(nameFilter));
}
int clientId;
if (GetIntFilter(parameters.filter, "clientName", out clientId))
{
items = items.Where(i => i.clientID == clientId);
}
int humanId;
if (GetIntFilter(parameters.filter, "humanName", out humanId))
{
items = items.Where(i => i.humanID == humanId);
}
var orderedItems = items.OrderByDescending(x => x.name);
var sorts = parameters.sort.Split(",".ToArray(), StringSplitOptions.RemoveEmptyEntries);
var directions = parameters.direction.Split(",".ToArray(), StringSplitOptions.RemoveEmptyEntries);
if (sorts.Length > 0 && directions.Length > 0)
{
var sortExpression = GetSortExpression(sorts[0]);
if (sortExpression != null)
{
orderedItems = (directions[0] == "up")
? orderedItems.OrderBy(sortExpression)
: orderedItems.OrderByDescending(sortExpression);
}
}
var total = orderedItems.Count();
var res2 = orderedItems.Skip(parameters.pageSize * (parameters.page - 1)).Take(parameters.pageSize).ToList();
return(Json(new
{
items = res2.Select(x => new
{
x.id,
x.name,
x.clientID,
clientName = x.crm_clients != null ? x.crm_clients.fio : "",
x.humanID,
humanName = x.hr_humans != null ? x.hr_humans.fio : ""
}),
total
}, JsonRequestBehavior.AllowGet));
}
public ActionResult Docs()
{
var mng = new DocsManager();
var finMng = new FinanceManager();
ViewBag.DocTypes = mng.GetDocTypes();
ViewBag.DocStatuses = mng.GetDocStatuses();
ViewBag.FinProjects = finMng.GetProjects().OrderBy(x => x.name).ToList();
ViewBag.FinContragents = finMng.GetFinContragents().OrderBy(x => x.name).ToList();
return(View());
}
// GET: Finances
public ActionResult Index()
{
var mng = new FinanceManager();
var mng_hr = new HRManager();
var mng_crm = new CRMManager();
ViewBag.contragentName = mng.GetFinContragents();
ViewBag.typeName = mng.GetFinTypes();
ViewBag.projectName = mng.GetProjects();
ViewBag.statusName = mng.GetFinStatuses();
ViewBag.hrName = mng_hr.GetHumans();
ViewBag.crmName = mng_crm.GetClients();
return(View());
}