コード例 #1
0
        /// <summary>
        ///     Processes the building creation.
        /// </summary>
        /// <param name = "db">The db.</param>
        /// <param name = "userId">The user id.</param>
        /// <param name = "params">The @params.</param>
        /// <returns></returns>
        public static int ProcessBuildingCreation(ref UrbanDataContext db, int userId, ProcessBuildingCreationParams @params)
        {
            //Check if already exists then return buidling Id
            var existingBuilding = DoesBuildingAlreadyExist(ref db, @params.PrimaryAddress, @params.SecondaryAddress, @params.City, @params.Zip, @params.State, userId);

            if (existingBuilding != null)
            {
                return(existingBuilding.Id);
            }

            //Check if valid if not return -1
            if (DoesBuildingAlreadyExistNotForUser(ref db, @params.PrimaryAddress, @params.SecondaryAddress, @params.City, @params.Zip, @params.State, userId))
            {
                return(-1);
            }

            //create new building then return new building id
            var building = new Building
            {
                PrimaryAddress   = @params.PrimaryAddress,
                SecondaryAddress = @params.SecondaryAddress,
                City             = @params.City,
                Zip    = @params.Zip,
                State  = @params.State,
                Name   = @params.Name,
                UserID = userId
            };

            db.Building.InsertOnSubmit(building);
            db.SubmitChanges();
            return(building.Id);
        }
コード例 #2
0
        /// <summary>
        ///     Processes the building creation.
        /// </summary>
        /// <param name = "db">The db.</param>
        /// <param name = "userId">The user id.</param>
        /// <param name = "params">The @params.</param>
        /// <returns></returns>
        public static int ProcessBuildingCreation(ref UrbanDataContext db, int userId, ProcessBuildingCreationParams @params)
        {
            //Check if already exists then return buidling Id
            var existingBuilding = DoesBuildingAlreadyExist(ref db, @params.PrimaryAddress, @params.SecondaryAddress, @params.City, @params.Zip, @params.State, userId);
            if (existingBuilding != null)
                return existingBuilding.Id;

            //Check if valid if not return -1 
            if (DoesBuildingAlreadyExistNotForUser(ref db, @params.PrimaryAddress, @params.SecondaryAddress, @params.City, @params.Zip, @params.State, userId))
                return -1;

            //create new building then return new building id
            var building = new Building
                               {
                                   PrimaryAddress = @params.PrimaryAddress,
                                   SecondaryAddress = @params.SecondaryAddress,
                                   City = @params.City,
                                   Zip = @params.Zip,
                                   State = @params.State,
                                   Name = @params.Name,
                                   UserID = userId
                               };
            db.Building.InsertOnSubmit(building);
            db.SubmitChanges();
            return building.Id;
        }