public static UserSettingsViewModel ToUserSettingsViewModel(this MacheteUser user, bool isHirer)
{
if (user == null)
{
throw new ArgumentNullException(nameof(user));
}
var userSettingsViewModel = new UserSettingsViewModel
{
ProviderUserKey = user.Id,
UserName = user.UserName,
Email = user.Email,
IsApproved = user.IsApproved ? "Yes" : "No",
IsLockedOut = user.IsLockedOut ? "Yes" : "No",
IsOnline = SqlServerDbFunctionsExtensions
.DateDiffHour(null, user.LastLoginDate, DateTime.Now) < 1 ? "Yes" : "No",
CreationDate = user.CreateDate,
LastLoginDate = user.LastLoginDate,
IsHirer = isHirer
};
return(userSettingsViewModel);
}
public static void search(viewOptions o, TimeZoneInfo clientTimeZoneInfo, ref IQueryable <WorkOrder> q)
{
bool isDateTime = false;
DateTime parsedTime;
if (isDateTime = DateTime.TryParse(o.sSearch, out parsedTime))
{
var searchDateStartUtc = parsedTime.ToUtcFrom(clientTimeZoneInfo); // some date at midnight time + {offset} hours
var searchDateEndUtc = searchDateStartUtc.AddHours(24); // UTC end search dateTime
if (isMonthSpecific.IsMatch(o.sSearch)) //Regex for month/year
{
q = q.Where(p => SqlServerDbFunctionsExtensions
.DateDiffMonth(null, p.dateTimeofWork, searchDateStartUtc) == 0 ? true : false);
}
if (isDaySpecific.IsMatch(o.sSearch)) //Regex for day/month/year
{
q = q.Where(p =>
p.dateTimeofWork >= searchDateStartUtc &&
p.dateTimeofWork < searchDateEndUtc);
}
if (isTimeSpecific.IsMatch(o.sSearch)) //Regex for day/month/year time
{
q = q.Where(p => SqlServerDbFunctionsExtensions
.DateDiffHour(null, p.dateTimeofWork, searchDateStartUtc) == 0 ? true : false);
}
}
else
{
q = q
.Where(p => p.ID.ToString().Contains(o.sSearch) ||
p.paperOrderNum.ToString().Contains(o.sSearch) ||
p.contactName.Contains(o.sSearch) ||
p.workSiteAddress1.Contains(o.sSearch) ||
p.updatedby.Contains(o.sSearch));
}
}
