private void _search(string search)
{
var staticSettings = new StaticSettings();
var ob = new UnitOfWork().ObligationsRepo.Fetch(m => m.OfficeId == staticSettings.OfficeId && m.FT == staticSettings.FT);
if (ob.Any(x => x.Description.Contains(search)))
{
ob = ob.Where(x => x.Description.Contains(search));
}
else if (ob.Any(x => x.ControlNo.Contains(search)))
{
ob = ob.Where(x => x.ControlNo.Contains(search));
}
else if (ob.Any(x => x.Payees.Name.Contains(search)))
{
ob = ob.Where(x => x.Payees.Name.Contains(search));
}
else
{
ob = new List <Obligations>().AsQueryable();
} if (uc.cboStatus.Text != "All")
{
ob = ob.Where(x => x.Status.Contains(uc.cboStatus.Text));
}
this.uc.OBGridControl.DataSource =
new BindingList <Obligations>(ob.Where(x => x.OfficeId == staticSettings.OfficeId).ToList());
Detail(ob.FirstOrDefault());
}
public IHttpActionResult Search([FromBody] string search)
{
var year = 2020;
var ft = "GF";
IQueryable <Appropriations> obj =
new UnitOfWork().AppropriationsRepoRepo.Fetch(m => m.FT == ft && m.OfficeId == officeId);
if (ft == "GF")
{
obj = obj.Where(x => x.Year == year);
}
if (obj.Any(x => x.AccountCode.Contains(search)))
{
obj = obj.Where(x => x.AccountCode.Contains(search));
}
else if (obj.Any(x => x.AccountCodeText.Contains(search)))
{
obj = obj.Where(x => x.AccountCodeText.Contains(search));
}
else if (obj.Any(x => x.AccountName.Contains(search)))
{
obj = obj.Where(x => x.AccountName.Contains(search));
}
else if (obj.Any(x => x.ORDetails.Any(m => m.Obligations.BudgetControlNo.Contains(search))))
{
obj = obj.Where(x => x.ORDetails.Any(m => m.Obligations.BudgetControlNo.Contains(search)));
}
else if (obj.Any(x => x.ORDetails.Any(m => m.Particulars.Contains(search))))
{
obj = obj.Where(x => x.ORDetails.Any(m => m.Particulars.Contains(search)));
}
var ret = obj.ToList().Select(x => new
{
x.PurchaseRequestEarmarked,
x.Appropriation,
x.Allotment,
x.AppropriationBalance,
x.ObligationsOffice,
x.AllotmentBalanceExcEM,
x.AllotmentBalanceIncEM,
x.ReAlignment,
x.AccountCode,
x.AccountName,
x.BudgetAccountBalance,
x.PurchaseRequestCancelled,
});
return(Ok(ret));
}
