public ActionResult Index(FormCollection form, SkillSearchModel skillSearchModel)
{
var list = from skill in _dbContext.Skills.ToList()
join category in _dbContext.Categories.ToList()
on skill.CategoryId equals category.Id
where (
(!String.IsNullOrEmpty(skillSearchModel.SkillName) ?
skill.SkillName.Contains(skillSearchModel.SkillName,
StringComparison.OrdinalIgnoreCase) : true
) &&
((skillSearchModel.Id != default(int)) ?
skillSearchModel.Id == skill.Id : true
)
)
select new Skill
{
Id = skill.Id,
SkillName = skill.SkillName,
SkillDescription = skill.SkillDescription,
SkillStatus = skill.SkillStatus,
CreateDate = skill.CreateDate,
UpdateDate = skill.UpdateDate,
Category = category
};
skillSearchModel.Skills = list;
skillSearchModel.Queryables = GetQueryables();
return View(skillSearchModel);
}
public ActionResult Index()
{
SkillSearchModel skillSearchModel = new SkillSearchModel();
var list = from skill in _dbContext.Skills.ToList()
join category in _dbContext.Categories.ToList()
on skill.CategoryId equals category.Id
select new Skill
{
Id = skill.Id,
SkillName = skill.SkillName,
SkillDescription = skill.SkillDescription,
SkillStatus = skill.SkillStatus,
CreateDate = skill.CreateDate,
UpdateDate = skill.UpdateDate,
Category = category
};
skillSearchModel.Skills = list;
skillSearchModel.Queryables = GetQueryables();
skillSearchModel.Id = default(int);
return View(skillSearchModel);
}