public EmpEntity GetEntity(int empID)
{
using (RepositoryTransaction trans = new RepositoryTransaction())
{
var repository = trans.GetEmpRepository();
return(repository.FindBySpecification(o => o.EmpID == empID).FirstOrDefault());
}
}
public IList <EmpEntity> GetEntities()
{
using (RepositoryTransaction trans = new RepositoryTransaction())
{
var repository = trans.GetEmpRepository();
return(repository.FindBySpecification(o => true).ToList());
}
}
public EmpEntity GetEntity(string username, string password)
{
using (RepositoryTransaction trans = new RepositoryTransaction())
{
var repository = trans.GetEmpRepository();
password = PasswordMD5(password);
username = username.ToLower();
return(repository.FindBySpecification(o => o.Username == username && o.Password == password).FirstOrDefault());
}
}
public void Merge(EmpEntity entity)
{
using (RepositoryTransaction trans = new RepositoryTransaction())
{
TrimFields(entity);
var repository = trans.GetEmpRepository();
if (entity.EmpID <= 0)
{
if (entity.Username.IsNullOrEmpty() || entity.Password.IsNullOrEmpty())
{
entity.Username = null;
entity.Password = null;
}
else
{
var sameUserameEntities = repository.FindBySpecification(o => o.Username == entity.Username.ToLower());
if (sameUserameEntities.Count() > 0)
{
throw new ApplicationException("Someone already has that username!Try another please!");
}
}
repository.Add(entity);
}
else
{
var orgEntity = repository.GetByKey(entity.EmpID);
orgEntity.EmpEmail = entity.EmpEmail;
orgEntity.EmpName = entity.EmpName;
if (entity.Username.IsNullOrEmpty())
{
orgEntity.Username = null;
orgEntity.Password = null;
}
else
{
if (orgEntity.Username != entity.Username)
{
var sameUserameEntities = repository.FindBySpecification(o => o.Username == entity.Username.ToLower());
if (sameUserameEntities.Count() > 0 && sameUserameEntities.Single().EmpID != entity.EmpID)
{
throw new ApplicationException("Someone already has that username!Try another please!");
}
orgEntity.Username = entity.Username;
}
if (!entity.Password.IsNullOrEmpty())
{
orgEntity.Password = entity.Password;
}
}
}
trans.Commit();
}
}