public List <Tbl_Section> GetAllDepartments()
{
try
{
return(_context.Tbl_Section.ToList());
}
catch (Exception ex)
{
_logService.Insert(new Log()
{
Type = LogType.Error, Priority = LogPriority.High, Description = ex.Message, PageUrl = "GetAllDepartments", CreatedOn = DateTime.Now.ToString("yyyy-MM-dd HH:mm"), UpdatedOn = DateTime.Now.ToString("yyyy-MM-dd HH:mm")
});
return(new List <Tbl_Section>());
}
}
public List <Tbl_User> SearchUsers(string FirstName, string LastName, string PersonelId, string Username, int active, int section)
{
try
{
return(_context.Tbl_User.Where(x => x.Name.Contains(FirstName) || x.LastName.Contains(LastName) || x.PersonnelID.Contains(PersonelId) || x.UserName.Contains(Username) || x.Active.Equals(active) || x.Section_ID.Equals(section)).ToList());
}
catch (Exception ex)
{
_logService.Insert(new Log()
{
Type = LogType.Error, Priority = LogPriority.High, Description = ex.Message, PageUrl = "SearchUsers", CreatedOn = DateTime.Now.ToString("yyyy-MM-dd HH:mm"), UpdatedOn = DateTime.Now.ToString("yyyy-MM-dd HH:mm")
});
return(new List <Tbl_User>());
}
}