Exemple #1
0
        public HttpResponseMessage Add()
        {
            string DocFile = "";
            int    MediaId = 0;

            HttpRequest HttpRequest = HttpContext.Current.Request;

            if (HttpRequest.Files.Count > 0)
            {
                string      FileName      = "";
                FileService NewFileUpload = new FileService();

                foreach (string file in HttpRequest.Files)
                {
                    HttpPostedFile PostedFile = HttpRequest.Files[file];
                    string         FilePath   = HttpContext.Current.Server.MapPath("~/" + PostedFile.FileName);
                    PostedFile.SaveAs(FilePath);

                    DocFile = FilePath;

                    //(string filePath, string newFileName,string s3Bucket,  bool deleteLocalFileOnSuccess)
                    FileName = Guid.NewGuid() + PostedFile.FileName;

                    NewFileUpload.UploadFile(DocFile, FileName, "seokbucket/yori", true);
                }

                MediaAddRequest MediaModel = new MediaAddRequest();

                string MimeType = System.Web.MimeMapping.GetMimeMapping(FileName);

                string UserId = UserService.GetCurrentUserId();

                MediaModel.FileName = FileName;
                //MediaModel.UserId = HttpRequest.Form["UserId"];
                MediaModel.UserId   = UserId;
                MediaModel.DataType = MimeType;
                MediaModel.Url      = NewFileUpload.getS3Url() + "/" + FileName;

                MediaId = _MediaService.InsertMedia(MediaModel);
            }
            ;

            ItemResponse <int> Response = new ItemResponse <int>();

            Response.Item = MediaId;

            return(Request.CreateResponse(HttpStatusCode.OK, Response));
        }
Exemple #2
0
        public int InsertMedia(MediaAddRequest model)
        {
            int uid = 0;

            DataProvider.ExecuteNonQuery(GetConnection, "dbo.Media_Insert"
                                         , inputParamMapper : delegate(SqlParameterCollection paramCollection)
            {
                paramCollection.AddWithValue("@userid", model.UserId);
                paramCollection.AddWithValue("@datatype", model.DataType);
                paramCollection.AddWithValue("@url", model.Url);

                SqlParameter p = new SqlParameter("@id", System.Data.SqlDbType.Int);
                p.Direction    = System.Data.ParameterDirection.Output;

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