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)); }
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); }