public ClassicRMSNumberProvider(IAdministrationUnitOfWork administrationUnitOfWork)
{
_administrationUnitOfWork = administrationUnitOfWork;
var vsiSystem = new VSI_SYSTEMContext();
_numberControlRepository = new Number_Control_Repository(vsiSystem);
}
/// <summary>
/// Modify the values of an Existing Number_Control.
/// </summary>
public void Modify(Number_Control numberControl)
{
var proc = new Number_Control_M(numberControl.Number_Control_Link,
numberControl.Source_Table,
numberControl.Sample_Number,
numberControl.Last_Number,
numberControl.Mask,
numberControl.Jurisdiction);
using (var ctx = new VSI_SYSTEMContext())
proc.Execute(ctx.Database);
}
public ClassicUser FindUserWithCredentials(string username, string password)
{
using (var vsiSystem = new VSI_SYSTEMContext())
{
// Get the connection string from the DbContext
var connectionString = new SqlConnectionStringBuilder(vsiSystem.Database.Connection.ConnectionString);
// Validate the Credentials against the Host.
SqlCredentialsValidator.ValidateCredentials(connectionString.DataSource, username, password, true);
// Find and Project the User_ID into a ClassicUser object.
var user = new User_ID_Repository(vsiSystem).Users.Where(x => x.User_ID1.Equals(username, StringComparison.OrdinalIgnoreCase))
.Select(ClassicUserProjection)
.FirstOrDefault();
if (user == null)
{
throw new InvalidCredentialException("The login is not associated with a valid User. Please contact your system administrator.");
}
// Return the User
return(user);
}
}
public User_ID_Repository(VSI_SYSTEMContext vsiSystemContext)
{
_vsiSystemContext = vsiSystemContext;
}
public Number_Control_Repository(VSI_SYSTEMContext context)
{
_context = context;
}
