public Response <RfpAttachment> Add(RfpAttachment item, string user) { try { item.rfa_key = Guid.NewGuid(); DynamicParameters _params = new DynamicParameters(); _params.Add("@rfa_key", item.rfa_key, DbType.Guid); _params.Add("@rfa_rfp_key", item.rfa_rfp_key, DbType.Guid); _params.Add("@rfa_rfr_key", item.rfa_rfr_key, DbType.Guid); _params.Add("@rfa_cxr_key", item.rfa_cxr_key, DbType.Guid); _params.Add("@rfa_prd_key", item.rfa_prd_key, DbType.Guid); _params.Add("@rfa_org_key", item.rfa_org_key, DbType.Guid); _params.Add("@rfa_file_name", item.rfa_file_name, DbType.String); _params.Add("@rfa_file_path", item.rfa_file_path, DbType.String); _params.Add("@rfa_type", item.rfa_type, DbType.String); _params.Add("@rfa_mime", item.rfa_mime, DbType.String); _params.Add("@rfa_attachment", item.rfa_attachment, DbType.Binary); _params.Add("@rfa_add_user", user, DbType.String); _params.Add("@success", DbType.Boolean, direction: ParameterDirection.Output); var result = _dBConnection.Execute("USP_Rfp_Attachment_Add", _params, null, null, CommandType.StoredProcedure); return(new Response <RfpAttachment>(item) { Success = _params.Get <Int32>("success") == 1 ? true : false }); } catch (Exception ex) { throw ex; } }
public ActionResult Index() { try { if (Request.Files.Count > 0) { HttpPostedFileBase file = Request.Files[0]; string baseFolderPath = Server.MapPath(ConfigHelper.GetSettingAsString("UploadsFolderPath")); string folderPath = DateTime.Today.ToString("yyyyMM"); string fileName = Guid.NewGuid() + Path.GetFileNameWithoutExtension(file.FileName).RemoveSpecialChars() + Path.GetExtension(file.FileName); string fillFullName = Path.Combine(baseFolderPath, folderPath, fileName); Directory.CreateDirectory(Path.GetDirectoryName(fillFullName)); if (file.IsImage()) { Image.FromStream(file.InputStream).SaveImage(Path.Combine(baseFolderPath, folderPath), fileName); } else { file.SaveAs(fillFullName); } RfpAttachment upload = new RfpAttachment { rfa_key = Guid.NewGuid(), rfa_rfp_key = null, rfa_rfr_key = null, rfa_cxr_key = null, rfa_prd_key = null, rfa_org_key = null, rfa_file_name = fileName, rfa_file_path = folderPath, rfa_mime = file.ContentType, rfa_add_date = DateTime.Now, rfa_add_user = string.Empty, }; var result = _rfpAttachmentFacade.Add(upload, ""); return(Json(new { rfa_key = upload.rfa_key, message = "success", Url = Path.Combine(Utility.GetSetting("UploadsURL"), folderPath, fileName) }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { message = "error" }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(new { message = "error" }, JsonRequestBehavior.AllowGet)); } }
public Response <RfpAttachment> Update(RfpAttachment item, string user) { return(_rfpAttachmentRepositoryDAC.Update(item, user)); }