public ICollection<Offer> GetOffers(Int32 page, Int32 size)
{
using (var dataManager = factory.GetDataManager())
{
var repository = dataManager.GetRepository<IOfferRepository>();
return repository.GetOffers(page, size);
}
}
public string GetConnectionByCommandName(string commandName)
{
if (connectionStringsDictionary.ContainsKey(commandName))
{
return(connectionStringsDictionary[commandName]);
}
string ConnString;
using (var dataManager = _factory.GetDataManager())
{
dataManager.CommandName = "usp_GetConnString";
dataManager.Parameters.AddWithValue("@ProcName", commandName);
dataManager.Connection.Open();
ConnString = dataManager.ExecuteScalar <string>();
dataManager.Connection.Close();
}
object lockobj = new object();
lock (lockobj)
{
connectionStringsDictionary.Add(commandName, ConnString);
}
return(ConnString);
}
public User Validate(String login, String password)
{
User user;
using (var dataManager = factory.GetDataManager())
{
var userRepository = dataManager.GetRepository <IUserRepository>();
user = userRepository.GetByLogin(login);
if (user == null)
{
return(null);
}
}
if (user.PasswordHash == null)
{
using (var dataManager = factory.GetDataManager(ConcurrencyLock.Pessimistic))
{
var userRepository = dataManager.GetRepository <IUserRepository>();
user = userRepository.GetByLogin(login);
if (user == null)
{
throw new NullReferenceException(String.Format("User with login \"{0}\" not found", login));
}
if (user.PasswordHash == null)
{
user.PasswordHash = algorithm.ComputeHash(new MemoryStream(Encoding.UTF8.GetBytes(password)));
userRepository.Save(user);
dataManager.Commit();
return(user);
}
}
}
return(user.PasswordHash.SequenceEqual(algorithm.ComputeHash(new MemoryStream(Encoding.UTF8.GetBytes(password)))) ? user : null);
}
public static DataManager GetSQLCacheDataManager()
{
return(sqlcacheFactory.GetDataManager());
}
public static DataManager GetSQLDataManager()
{
return(sqlFactory.GetDataManager());
}