/// <summary> /// Find Team by given paramataers /// </summary> /// <param name="searchParameeters">DTO with given parameeters</param> /// <returns>Collection of found </returns> public IList <TeamDTO> Find(TeamDTO searchParameeters) { List <TeamDTO> result = new List <TeamDTO>(); using (AirsoftBaseContext context = new AirsoftBaseContext()) { Team foundEntity; if (searchParameeters.Id != 0) { foundEntity = context.Teams .Where(t => t.Id == searchParameeters.Id) .FirstOrDefault(); } else { foundEntity = context.Teams .Where(t => t.Title == searchParameeters.Title) .FirstOrDefault(); } if (foundEntity != null) { result.Add(DataConverter.Instance.GetDTO(foundEntity) as TeamDTO); } } return(result); }
public int Save(UserDTO dtoToSave) { User userToSave = DataConverter.Instance.GetEntity(dtoToSave) as User; //TODO: Ask if the Context is better to initialize with the DAO intialization, or create a new one each time using (AirsoftBaseContext context = new AirsoftBaseContext()) { if (!context.Users.Where(u => u.Login == userToSave.Login).Any()) { context.Users.Add(userToSave); context.SaveChanges(); return((int)SaveStatusCode.SaveOK); } else { return((int)SaveStatusCode.NameAllreadyTaken); } } }
/// <summary> /// Try to save a new Entity to Database and get operation result code /// </summary> /// <param name="dtoToSave">Object to save</param> /// <returns>Operation result code</returns> public int Save(TeamDTO dtoToSave) { Team teamToSave = DataConverter.Instance.GetEntity(dtoToSave) as Team; //TODO: Ask if the Context is better to initialize with the DAO intialization, or create a new one each time using (AirsoftBaseContext context = new AirsoftBaseContext()) { if (!context.Teams.Where(t => t.Title == teamToSave.Title).Any()) { context.Teams.Add(teamToSave); context.SaveChanges(); return((int)SaveStatusCode.SaveOK); } else { return((int)SaveStatusCode.NameAllreadyTaken); } } }
public IList <UserDTO> Find(UserDTO searchParameters) { List <UserDTO> result = new List <UserDTO>(); using (AirsoftBaseContext context = new AirsoftBaseContext()) { IList <User> foundEntities = new List <User>(); if (searchParameters.Id != 0) { foundEntities = context.Users .Where(u => u.Id == searchParameters.Id).ToList(); } else { if (searchParameters.Team != null) { foundEntities = context.Users .Where(t => t.Team.Id == searchParameters.Team.Id) .ToList(); } else if (!string.IsNullOrEmpty(searchParameters.Callsign)) { foundEntities = context.Users .Where(t => t.Callsign == searchParameters.Callsign) .ToList(); } else if (!string.IsNullOrEmpty(searchParameters.Login)) { foundEntities = context.Users .Where(t => t.Login == searchParameters.Login) .ToList(); } } if (foundEntities.Any()) { result.AddRange(DataConverter.Instance.GetDTO(foundEntities as IList <EntityBase>) as IList <UserDTO>); } } return(result); }