public int GetCount(string word, EStatusContract statusContract)
{
return(_context.Contract.Where(ContractSpecs.GetSearchContract(word, statusContract)).Count());
}
public static Expression <Func <Contract, bool> > GetSearchContract(string word, EStatusContract statusContract)
{
if (string.IsNullOrEmpty(word) || word.Equals("null"))
{
return(x => !x.IdContract.Equals(null) && x.StatusContract == statusContract);
}
return(x => x.Company.CompanyName.Contains(word) && x.StatusContract == statusContract);
}
public List <Contract> GetByRange(int skip, int take, string word, EStatusContract statusContract)
{
return(_context.Contract.Include("Company").Where(ContractSpecs.GetSearchContract(word, statusContract))
.OrderBy(x => x.IdContract).Skip((skip - 1) * take).Take(take).ToList());
}
public Task <HttpResponseMessage> GetCount(string word, EStatusContract status)
{
var countContract = _service.GetCount(word, status);
return(CreateResponse(HttpStatusCode.OK, countContract));
}
public Task <HttpResponseMessage> GetByRange(int skip, string word, EStatusContract status, int take = 12)
{
var contract = _service.GetByRange(skip, take, word, status);
return(CreateResponse(HttpStatusCode.OK, contract));
}
public UpdateContractCommand(int idContract, int idCompany, int idDayOfMonth, DateTime dateStart, DateTime dateEnd, EStatusContract statusContract, string note)
{
this.IdContract = idContract;
this.IdCompany = idCompany;
this.DateStart = dateStart;
this.DateEnd = dateEnd;
this.StatusContract = statusContract;
this.Note = note;
}
public int GetCount(string word, EStatusContract status)
{
return(_repository.GetCount(word, status));
}
public List <Contract> GetByRange(int skip, int take, string word, EStatusContract statusContract)
{
return(_repository.GetByRange(skip, take, word, statusContract));
}
