protected IQueryable <UserAccount> GetAllUserAccountsImpl(
[NotNull] USTDataContext context)
{
ThrowIfNull(context);
return(context.UserAccounts);
}
protected static AuthenticationResult TryAuthenticate(string username, string password, out UserAccount userAccount)
{
try
{
using (var context = new USTDataContext())
{
var currentUserAccount = I.FetchUserFromUsernameAccountImpl(context, username);
if (currentUserAccount == null)
{
userAccount = default(UserAccount);
return(AuthenticationResult.UsernameError);
}
if (currentUserAccount.Password == password)
{
I.CurrentUserAccount = currentUserAccount;
userAccount = currentUserAccount;
return(AuthenticationResult.Success);
}
userAccount = default(UserAccount);
return(AuthenticationResult.PasswordError);
}
}
catch (Exception ex)
{
userAccount = default(UserAccount);
return(AuthenticationResult.UnknownError);
}
}
public State[] GetAllStates()
{
using (var context = new USTDataContext())
{
return(context.States.ToArray());
}
}
public UserAccount[] GetAllUserAccountsExcludingActive()
{
using (var context = new USTDataContext())
{
return(GetAllUserAccountsExcludingActiveImpl(context).ToArray());
}
}
protected UserAccount FetchUserFromUsernameAccountImpl(
[NotNull] USTDataContext context,
string username)
{
ThrowIfNull(context);
return(context.UserAccounts.SingleOrDefault(t => t.Username == username));
}
protected UserAccount FetchUserAccountImpl(
[NotNull] USTDataContext context,
int userAccountID)
{
ThrowIfNull(context);
return(context.UserAccounts.SingleOrDefault(t => t.UserAccountID == userAccountID));
}
protected State FetchStateImpl(
USTDataContext context,
int stateID)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
return(context.States.SingleOrDefault(t => t.StateID == stateID));
}
protected IQueryable <JobAssignment> GetJobAssignmentsImpl(
USTDataContext context,
int jobAssignmentID)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
return(context.JobAssignments.Where(t => t.JobAssignmentID == jobAssignmentID));
}
protected JobAssignmentGroup FetchJobAssignmentGroupImpl(
USTDataContext context,
int jobAssignmentGroupID)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
return(context.JobAssignmentGroups.SingleOrDefault(t => t.AssignmentGroupID == jobAssignmentGroupID));
}
protected City FetchCityByLegacyMonikerCaseInsensitiveImpl(
USTDataContext context,
string legacyCityMoniker)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
return(context.Cities.SingleOrDefault(t => SqlMethods.Like(t.LegacyLocationMoniker, legacyCityMoniker)));
}
protected City FetchCityImpl(
[NotNull] USTDataContext context,
int cityID)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
return(context.Cities.SingleOrDefault(t => t.CityID == cityID));
}
protected IQueryable <UserAccount> GetAllUserAccountsExcludingActiveImpl(
[NotNull] USTDataContext context)
{
ThrowIfNull(context);
if (!I.IsAuthenticated)
{
throw new AuthenticationException("There is no user currently authenticated.");
}
return(context.UserAccounts.Where(t => t.UserAccountID != I.CurrentUserAccount.UserAccountID));
}
protected State FetchStateByAbbreviationImpl(
USTDataContext context,
string abbreviation,
bool ignoreCase = false)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
return(context.States.SingleOrDefault(t => t.Abbreviation == abbreviation));
}
protected City FetchCityByNameImpl(
USTDataContext context,
string cityName,
bool ignoreCase = false)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
if (ignoreCase)
{
return(context.Cities.SingleOrDefault(t => SqlMethods.Like(t.CityName, cityName)));
}
return(context.Cities.SingleOrDefault(t => t.CityName == cityName));
}
protected State FetchStateByNameImpl(
USTDataContext context,
string stateName,
bool ignoreCase = false)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
if (ignoreCase)
{
return(context.States.SingleOrDefault(t => SqlMethods.Like(t.StateName, stateName)));
}
return(context.States.SingleOrDefault(t => t.StateName == stateName));
}
protected UserAccount AddUserAccountImpl(
[NotNull] USTDataContext context,
[NotNull] UserAccount userAccount,
bool submitChanges = true)
{
ThrowIfNull(context);
ThrowIfNull(userAccount);
context.UserAccounts.InsertOnSubmit(userAccount);
if (submitChanges)
{
context.SubmitChanges();
}
return(userAccount);
}
protected State AddStateImpl(
USTDataContext context,
State state,
bool deferSubmitChanges = false)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
context.States.InsertOnSubmit(state);
if (!deferSubmitChanges)
{
context.SubmitChanges();
}
return(state);
}
protected JobAssignmentGroup AddJobAssignmentGroupImpl(
USTDataContext context,
JobAssignmentGroup jobAssignmentGroup,
bool deferSubmitChanges = false)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
context.JobAssignmentGroups.InsertOnSubmit(jobAssignmentGroup);
if (!deferSubmitChanges)
{
context.SubmitChanges();
}
return(jobAssignmentGroup);
}
protected City AddCityImpl(
[NotNull] USTDataContext context,
City city,
bool deferSubmitChanges = false)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
context.Cities.InsertOnSubmit(city);
if (!deferSubmitChanges)
{
context.SubmitChanges();
}
return(city);
}
