public JsonResult GetPendingProductHelpList(string searchTerm, int pageSize, int pageNum, int filter)//Order Header ID
{
var Records = new JobOrderInspectionRequestLineService(db).GetPendingProductHelpList(searchTerm, filter);
var temp = Records.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
var count = Records.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(new JsonpResult
{
Data = Data,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetPendingProdOrderProducts(string searchTerm, int pageSize, int pageNum, int filter)//DocTypeId
{
var Query = _ProdOrderCancelLineService.GetPendingProductsForProdOrderCancel(filter, searchTerm);
var temp = Query.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
var count = Query.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(new JsonpResult
{
Data = Data,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetPendingJobWorkerHelpList(string searchTerm, int pageSize, int pageNum, int filter)//Order Header ID
{
var Records = new JobInvoiceRateAmendmentLineService(_unitOfWork).GetPendingJobWorkerHelpList(filter, searchTerm);
var temp = Records.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
var count = Records.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(new JsonpResult
{
Data = Data,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetSaleInvoice(string searchTerm, int pageSize, int pageNum, int filter)//DocTypeId
{
var Query = _SaleDeliveryLineService.GetPendingSaleInvoiceForDelivery(filter, searchTerm);
var temp = Query.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
var count = Query.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(new JsonpResult
{
Data = Data,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetPendingCostCentersForFilters(string searchTerm, int pageSize, int pageNum, int filter)//Order Header ID
{
var Query = _RequisitionCancelLineService.GetPendingCostCentersForFilters(filter, searchTerm);
var temp = Query.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
var count = Query.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(new JsonpResult
{
Data = Data,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetOverTuftContentProducts(string searchTerm, int pageSize, int pageNum, int filter)//DocTypeId
{
var Query = _BomDetailService.GetOverTuftContentProductList(filter, searchTerm);
var temp = Query.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
var count = Query.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(new JsonpResult
{
Data = Data,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetDocTypeHelpList(string searchTerm, int pageSize, int pageNum, string filter)//Order Header ID
{
var Query = _DocumentTypeTimeExtensionService.GetDocTypesHelpList(filter, searchTerm).Skip(pageSize * (pageNum - 1));
var temp = Query.Take(pageSize).ToList();
var count = Query.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(new JsonpResult
{
Data = Data,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetProductHelpList(string searchTerm, int pageSize, int pageNum, int filter)//Indent Header ID
{
var Query = _PurchaseQuotationLineService.GetProductHelpList(filter, searchTerm);
var temp = Query.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
var count = Query.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(new JsonpResult
{
Data = Data,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult GetCustomPerson(string searchTerm, int pageSize, int pageNum, int filter)//DocTypeId
{
var Query = _SaleOrderHeaderService.GetCustomPerson(filter, searchTerm);
var temp = Query.Skip(pageSize * (pageNum - 1))
.Take(pageSize)
.ToList();
var count = Query.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(new JsonpResult
{
Data = Data,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult GetSaleOrderForProduct(string searchTerm, int pageSize, int pageNum, int PersonId)//DocTypeId
{
var Query = new SaleDispatchLineService(_unitOfWork).GetSaleOrderHelpListForProduct(PersonId, searchTerm);
var temp = Query.Skip(pageSize * (pageNum - 1))
.Take(pageSize)
.ToList();
var count = Query.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(new JsonpResult
{
Data = Data,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult GetSaleInvoiceForProduct(string searchTerm, int pageSize, int pageNum, int filter)//SaleInvoiceReturnHeaderId
{
var Query = _SaleInvoiceReturnLineService.GetSaleInvoiceHelpListForProduct(filter, searchTerm);
var temp = Query.Skip(pageSize * (pageNum - 1))
.Take(pageSize)
.ToList();
var count = Query.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(new JsonpResult
{
Data = Data,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetPendingMaterialPlans(string searchTerm, int pageSize, int pageNum, int filter)//DocTypeId
{
var Query = _MaterialPlanCanceliLine.GetPendingPlanningHelpList(filter, searchTerm);
var temp = Query.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
var count = Query.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(new JsonpResult
{
Data = Data,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
//return Json(new SaleOrderHeaderService(_unitOfWork).GetSaleOrdersForDocumentType(id, term), JsonRequestBehavior.AllowGet);
}
public ComboBoxPagedResult GetListWithProcess(string searchTerm, int pageSize, int pageNum, int ProcessId)
{
int CurrentSiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
int CurrentDivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
string DivId = "|" + CurrentDivisionId.ToString() + "|";
string SiteId = "|" + CurrentSiteId.ToString() + "|";
var list = (from b in _JobworkerRepository.Instance
join bus in _unitOfWork.Repository <BusinessEntity>().Instance on b.PersonID equals bus.PersonID into BusinessEntityTable
from BusinessEntityTab in BusinessEntityTable.DefaultIfEmpty()
join p in _unitOfWork.Repository <Person>().Instance on b.PersonID equals p.PersonID into PersonTable
from PersonTab in PersonTable.DefaultIfEmpty()
join pp in _unitOfWork.Repository <PersonProcess>().Instance on b.PersonID equals pp.PersonId into PersonProcessTable
from PersonProcessTab in PersonProcessTable.DefaultIfEmpty()
where PersonProcessTab.ProcessId == ProcessId &&
(string.IsNullOrEmpty(searchTerm) ? 1 == 1 : (PersonTab.Name.ToLower().Contains(searchTerm.ToLower()) || PersonTab.Code.ToLower().Contains(searchTerm.ToLower()))) &&
BusinessEntityTab.DivisionIds.IndexOf(DivId) != -1 &&
(PersonTab.IsActive == null ? 1 == 1 : PersonTab.IsActive == true) &&
BusinessEntityTab.SiteIds.IndexOf(SiteId) != -1
orderby PersonTab.Name
select new ComboBoxResult
{
id = b.PersonID.ToString(),
text = PersonTab.Name + "|" + PersonTab.Code,
}
);
var temp = list
.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
var count = list.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(Data);
}
public JsonResult GetPurchaseOrders(string searchTerm, int pageSize, int pageNum, int filter)//Receipt Header ID
{
var Records = _PurchaseOrderCancelLineService.GetPendingPurchaseOrderHelpList(filter, searchTerm);
var temp = Records.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
var count = Records.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(new JsonpResult
{
Data = Data,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
//return Json(_PurchaseOrderCancelLineService.GetPendingPurchaseOrderHelpList(id, term), JsonRequestBehavior.AllowGet);
}
public ComboBoxPagedResult GetUsersById(string searchTerm, int pageSize, int pageNum)
{
var Query = (from ur in _UserRepository.Instance
where (string.IsNullOrEmpty(searchTerm) ? 1 == 1 : (ur.UserName.ToLower().Contains(searchTerm.ToLower())))
orderby ur.UserName
select new ComboBoxResult
{
text = ur.UserName,
id = ur.Id,
}
);
var records = Query.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
var count = Query.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = records;
Data.Total = count;
return(Data);
}
public ComboBoxPagedResult GetList(string searchTerm, int pageSize, int pageNum)
{
var list = (from pr in _GateRepository.Instance
where (string.IsNullOrEmpty(searchTerm) ? 1 == 1 : (pr.GateName.ToLower().Contains(searchTerm.ToLower())))
orderby pr.GateName
select new ComboBoxResult
{
text = pr.GateName,
id = pr.GateId.ToString()
}
);
var temp = list
.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
var count = list.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(Data);
}
public ComboBoxPagedResult GetTaskList(string searchTerm, int pageSize, int pageNum, string User)
{
var list = (from tr in _TaskRepository.Instance
where (string.IsNullOrEmpty(searchTerm) ? 1 == 1 : (tr.TaskTitle.ToLower().Contains(searchTerm.ToLower()))) &&
tr.ForUser == User && tr.Status != (TaskStatusConstants.Close) && tr.Status != (TaskStatusConstants.Complete)
orderby tr.TaskTitle
select new ComboBoxResult
{
text = tr.TaskTitle,
id = tr.TaskId.ToString()
}
);
var temp = list.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
var count = list.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(Data);
}
public ComboBoxPagedResult GetEmployees(string searchTerm, int pageSize, int pageNum)
{
var Query = (from ur in _EmployeeRepository.Instance
join t in _unitOfWork.Repository <Person>().Instance on ur.PersonID equals t.PersonID
where (string.IsNullOrEmpty(searchTerm) ? 1 == 1 : (t.Name.ToLower().Contains(searchTerm.ToLower())))
orderby t.Name
select new ComboBoxResult
{
text = t.Name,
id = t.PersonID.ToString(),
}
);
var records = Query.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
var count = Query.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = records;
Data.Total = count;
return(Data);
}
