コード例 #1
0
        /// <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);
        }
コード例 #2
0
ファイル: UserDAO.cs プロジェクト: ltkirin/ASPNetCoreApi
        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);
                }
            }
        }
コード例 #3
0
        /// <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);
                }
            }
        }
コード例 #4
0
ファイル: UserDAO.cs プロジェクト: ltkirin/ASPNetCoreApi
        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);
        }