示例#1
0
        //PHOTOS - INSERT
        public static int PhotosInsert(PhotosAdd model)
        {
            int id = 0;//000-0000-0000-0000

            DataProvider.ExecuteNonQuery(GetConnection, "dbo.Photos_Insert"
                                         , inputParamMapper : delegate(SqlParameterCollection paramCollection)
            {
                paramCollection.AddWithValue("@URL", model.URL);
                paramCollection.AddWithValue("@isPrimary", 0);
                paramCollection.AddWithValue("@userId", model.userId);


                SqlParameter p = new SqlParameter("@PhotoId", System.Data.SqlDbType.Int);    //output parameter sending into proc to get value
                p.Direction    = System.Data.ParameterDirection.Output;

                paramCollection.Add(p);
            },
                                         returnParameters : delegate(SqlParameterCollection param)
            {
                int.TryParse(param["@PhotoId"].Value.ToString(), out id);
            }

                                         );

            return(id);
        }
示例#2
0
        public HttpResponseMessage UploadGalleryPhoto()
        {
            HttpResponseMessage result              = null;
            HttpRequest         httpRequest         = HttpContext.Current.Request;
            TransferUtility     fileTransferUtility = new TransferUtility(new AmazonS3Client(ConfigService.AwsAccessKeyId
                                                                                             , ConfigService.AwsSecretAccessKey
                                                                                             , Amazon.RegionEndpoint.USWest2));

            if (httpRequest.Files.Count > 0)
            {
                foreach (string file in httpRequest.Files)
                {
                    HttpPostedFile postedFile = httpRequest.Files[file];

                    string guid = Guid.NewGuid().ToString();

                    string remoteFilePath = ConfigService.RemoteFilePath + guid + "_" + postedFile.FileName;
                    TransferUtilityUploadRequest fileTransferUtilityRequest = new TransferUtilityUploadRequest
                    {
                        BucketName = ConfigService.BucketName,

                        InputStream = postedFile.InputStream,

                        Key = remoteFilePath,
                    };

                    fileTransferUtility.Upload(fileTransferUtilityRequest);

                    string paraRemoteFilePath = "/" + remoteFilePath;

                    ItemResponse <string> response = new ItemResponse <string>();

                    PhotosAdd model = new PhotosAdd(); //model binding by hand. creating a new instance of the model w/ file uploads

                    model.userId = UserService.GetCurrentUserId();
                    model.URL    = paraRemoteFilePath;

                    PhotosService.PhotosInsert(model);

                    response.Item = remoteFilePath;

                    return(Request.CreateResponse(HttpStatusCode.Created, response.Item));
                }
            }
            else
            {
                result = Request.CreateResponse(HttpStatusCode.BadRequest);
            }

            return(result);
        }