public Domain.Entities.User CreateUser(Domain.Entities.User newUser) { using (llisdb _context = new llisdb()) { UserAccount account = new UserAccount { CreatedById = 1, CreatedDate = DateTime.Now }; UserAccountOperation accountOperation = new UserAccountOperation { Action = "C", Address = newUser.Address, UpdatedById = 1, UpdatedDate = DateTime.Now, UserAccount = account, UserName = newUser.UserName }; _context.Entry(accountOperation).State = System.Data.EntityState.Added; _context.SaveChanges(); newUser.Id = account.Id; newUser.OperationId = accountOperation.Id; } return newUser; }
public IEnumerable<Domain.Entities.User> SelectAllUsers() { List<Domain.Entities.User> entities = new List<Domain.Entities.User>(); using (llisdb _context = new llisdb()) { var items = _context.UserAccountsViews.ToList<UserAccountsView>(); foreach (var operItem in items) { entities.Add(new Domain.Entities.User { Id = operItem.Id, Address = operItem.Address, OperationId = operItem.OperationsId, UserName = operItem.UserName, Action = operItem.Action, CreateDate = operItem.CreatedDate, UpdatedDate = operItem.UpdatedDate }); } } return entities; }
public IEnumerable<Domain.Entities.User> SelectAllUsersHistory() { List<Domain.Entities.User> entities = new List<Domain.Entities.User>(); using (llisdb _context = new llisdb()) { foreach (var item in _context.UserAccounts.Include("UserAccountOperations")) { foreach (var operItem in item.UserAccountOperations) { entities.Add(new Domain.Entities.User { Id = item.Id, Address = operItem.Address, OperationId = operItem.Id, UserName = operItem.UserName, Action = operItem.Action, CreateDate = item.CreatedDate, UpdatedDate = operItem.UpdatedDate }); } } } return entities.OrderBy(k => k.OperationId); }
public IEnumerable<Domain.Entities.User> SelectUserHistory(int userId) { List<Domain.Entities.User> entities = new List<Domain.Entities.User>(); using (llisdb _context = new llisdb()) { var item = _context.UserAccounts.Include("UserAccountOperations").FirstOrDefault<UserAccount>(f => f.Id == userId); foreach (var operItem in item.UserAccountOperations) { entities.Add(new Domain.Entities.User { Id = item.Id, Address = operItem.Address, OperationId = operItem.Id, UserName = operItem.UserName, Action = operItem.Action, CreateDate = item.CreatedDate, UpdatedDate = operItem.UpdatedDate }); } } return entities; }