public SearchFeeTypes SearchFeeTypes(SearchFeeTypes obj)
{
var model = (dynamic)null;
try
{
Int64 SearchFeetypeClassId = Convert.ToInt64(obj.SearchFeetypeClassId);
var FeeTypesList = _FeeTypesRepo.GetAll().ToList();
var classList = _classesRepo.GetAll().ToList();
var query = (from _FeeTypes in FeeTypesList
join _class in classList on _FeeTypes?.ClassId equals _class?.Id
where _FeeTypes.ClassId == SearchFeetypeClassId
select new { _FeeTypes, _class }).ToList();
var matchedClassName = (from p in FeeTypesList
join c in classList on p.ClassId equals c.Id
where p.ClassId == SearchFeetypeClassId
select c.Name.Single()).ToString();
var test = (from c in classList
where c.Id == SearchFeetypeClassId
select c).SingleOrDefault();
var list = new List <SearchFeeTypes_FeeTypes>();
foreach (var item in query)
{
var temp = new SearchFeeTypes_FeeTypes()
{
Id = item._FeeTypes.Id,
ClassId = item._FeeTypes.ClassId,
ClassName = item._class.Name,
Name = item._FeeTypes.Name,
IsActive = item._FeeTypes.IsActive
};
list.Add(temp);
}
;
model = new SearchFeeTypes()
{
_FeeTypes = list,
SearchClassName = test.Name
};
}
catch (Exception)
{
}
return(model);
}
public async Task <IActionResult> SearchFeeTypes(string SearchFeetypeClassId, int pg = 1)
{
try
{
if (String.IsNullOrEmpty(SearchFeetypeClassId))
{
var model = new IndexFeeTypesListVM()
{
_FeeTypes = null,
SearchFeetypeClassId = null
};
return(View("FeeTypesList", model));
}
else
{
var result = new SearchFeeTypes()
{
SearchFeetypeClassId = SearchFeetypeClassId
};
var SearchFeeTypes = await Task.Run(() => _FeeTypesServ.SearchFeeTypes(result));
ViewBag.ddlClass = _classesServ.dropdown_Class();
var list = new List <IndexFeeTypesListVM_FeeTypes>();
foreach (var item in SearchFeeTypes._FeeTypes.ToList())
{
var temp = new IndexFeeTypesListVM_FeeTypes()
{
Id = item.Id,
ClassId = item.ClassId,
ClassName = item.ClassName,
Name = item.Name,
IsActive = item.IsActive
};
list.Add(temp);
}
;
#region "Paging"
const int pageSize = 5;
if (pg < 1)
{
pg = 1;
}
int recsCount = list.Count();
var pager = new Pager(recsCount, pg, pageSize);
int recSkip = (pg - 1) * pageSize;
var data = list.Skip(recSkip).Take(pager.PageSize).ToList();
this.ViewBag.Pager = pager;
var model = new IndexFeeTypesListVM()
{
_FeeTypes = data,
SearchFeetypeClassId = SearchFeetypeClassId,
SearchClassName = SearchFeeTypes.SearchClassName.ToString()
};
#endregion "Paging"
return(View("FeeTypesList", model));
}
}
catch
{
return(BadRequest());
}
}
