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(); } }