/// <summary> /// Creates a new MapAttachment record using async /// </summary> public static async Task<int> CreateAsync(MapAttachmentDO DO) { SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int); SqlParameter _DateUploaded = new SqlParameter("DateUploaded", SqlDbType.DateTime); SqlParameter _UserToken = new SqlParameter("UserToken", SqlDbType.VarChar); SqlParameter _FileSize = new SqlParameter("FileSize", SqlDbType.Int); SqlParameter _Description = new SqlParameter("Description", SqlDbType.VarChar); SqlParameter _MimeType = new SqlParameter("MimeType", SqlDbType.VarChar); SqlParameter _FileName = new SqlParameter("FileName", SqlDbType.VarChar); SqlParameter _TOCID = new SqlParameter("TOCID", SqlDbType.Int); SqlParameter _ParentMapAttachmentID = new SqlParameter("ParentMapAttachmentID", SqlDbType.Int); SqlParameter _IsACopy = new SqlParameter("IsACopy", SqlDbType.Bit); _PermitKey.Value = DO.PermitKey; _DateUploaded.Value = DO.DateUploaded; _UserToken.Value = DO.UserToken; _FileSize.Value = DO.FileSize; _Description.Value = DO.Description; _MimeType.Value = DO.MimeType; _FileName.Value = DO.FileName; _TOCID.Value = DO.TOCID; _ParentMapAttachmentID.Value = DO.ParentMapAttachmentID; _IsACopy.Value = DO.IsACopy; SqlParameter[] _params = new SqlParameter[] { _PermitKey, _DateUploaded, _UserToken, _FileSize, _Description, _MimeType, _FileName, _TOCID, _ParentMapAttachmentID, _IsACopy }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return await DataCommon.ExecuteScalarAsync("[dbo].[MapAttachment_Insert]", _params, pid); }
public ActionResult Upload(int PermitKey, int TOCID) { try { HttpPostedFileBase File = Request.Files["File"]; MapAttachmentDO attachment = new MapAttachmentDO() { DateUploaded = DateTime.Now, Description = File.FileName, IsACopy = false, //FileLocation = "database", FileSize = File.ContentLength, MimeType = File.ContentType, PermitKey = PermitKey, TOCID = TOCID, UserToken = myCoalUser.UserToken }; // read content from stream byte[] content = new byte[File.ContentLength]; File.InputStream.Read(content, 0, (int)File.ContentLength); // Save it int MapAttachmentId = MapBLL.Save(attachment, content, DirectoryMapping.AttachmentContentFolder); AjaxResult result = new AjaxResult(AjaxResult.AjaxStatus.OK, "Map Uploaded"); result.Data.Add("TOCID", TOCID); result.Data.Add("PermitKey", PermitKey); result.Data.Add("MapAttachmentId", MapAttachmentId); return Json(result); } catch (Exception ex) { AjaxResult result = new AjaxResult(AjaxResult.AjaxStatus.ERROR, ex.Message); return Json(result); } }
public ActionResult Replace(int PermitKey, int MapAttachmentID, int TOCID) { MapAttachmentBO model = MapBLL.GetMap(MapAttachmentID); HttpPostedFileBase File = Request.Files["File"]; if (File == null) { ViewBag.Message = "Please attach a new map"; return PartialView(model); } try { MapAttachmentDO attachment = new MapAttachmentDO() { FileName = model.MapAttachment.FileName, MapAttachmentID = MapAttachmentID, DateUploaded = DateTime.Now, Description = File.FileName, IsACopy = false, FileSize = File.ContentLength, MimeType = File.ContentType, PermitKey = PermitKey, TOCID = TOCID, UserToken = myCoalUser.UserToken }; // read content from stream byte[] content = new byte[File.ContentLength]; File.InputStream.Read(content, 0, (int)File.ContentLength); // Save it int MapAttachmentId = MapBLL.Save(attachment, content, DirectoryMapping.AttachmentContentFolder); AjaxResult result = new AjaxResult(AjaxResult.AjaxStatus.OK, "The Map has been replaced"); return Json(result); } catch (Exception ex) { AjaxResult result = new AjaxResult(AjaxResult.AjaxStatus.ERROR, ex.Message); return Json(result); } }
/// <summary> /// copies properties from the data object to this derived instance /// </summary> /// <param name="dataObject"></param> private void CopyDOProperties(MapAttachmentDO dataObject) { this.IsACopy = dataObject.IsACopy; this.PermitKey = dataObject.PermitKey; this.MapAttachmentID = dataObject.MapAttachmentID; this.DateUploaded = dataObject.DateUploaded; this.Description = dataObject.Description; this.FileName = dataObject.FileName; this.FileSize = dataObject.FileSize; this.MimeType = dataObject.MimeType; this.ParentMapAttachmentID = dataObject.ParentMapAttachmentID; this.TOCID = dataObject.TOCID; this.UserToken = dataObject.UserToken; }
/// <summary> /// Create a new view model instance from a data object /// </summary> /// <param name="dataObject"></param> public MapAttachmentVM(MapAttachmentDO dataObject) : base() { CopyDOProperties(dataObject); }
/// <summary> /// Selects MapAttachment records by TOCID /// </summary> public static async Task<MapAttachmentDO[]> GetByTOCIDAsync(Int32 TOCID) { SqlParameter _TOCID = new SqlParameter("TOCID", SqlDbType.Int); _TOCID.Value = TOCID; SqlParameter[] _params = new SqlParameter[] { _TOCID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[MapAttachment_GetByTOCID]", _params, pid); List<MapAttachmentDO> objs = new List<MapAttachmentDO>(); while(sr.Read()) { MapAttachmentDO obj = new MapAttachmentDO(); obj.MapAttachmentID = sr.GetInt32(sr.GetOrdinal("MapAttachmentID")); obj.DateUploaded = sr.GetDateTime(sr.GetOrdinal("DateUploaded")); obj.UserToken = sr.GetString(sr.GetOrdinal("UserToken")); obj.FileSize = sr.GetInt32(sr.GetOrdinal("FileSize")); obj.Description = sr.GetString(sr.GetOrdinal("Description")); if (sr.IsDBNull(sr.GetOrdinal("PermitKey"))) { obj.PermitKey = null; } else { obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey")); } if (sr.IsDBNull(sr.GetOrdinal("MimeType"))) { obj.MimeType = null; } else { obj.MimeType = sr.GetString(sr.GetOrdinal("MimeType")); } if (sr.IsDBNull(sr.GetOrdinal("FileName"))) { obj.FileName = null; } else { obj.FileName = sr.GetString(sr.GetOrdinal("FileName")); } if (sr.IsDBNull(sr.GetOrdinal("TOCID"))) { obj.TOCID = null; } else { obj.TOCID = sr.GetInt32(sr.GetOrdinal("TOCID")); } if (sr.IsDBNull(sr.GetOrdinal("ParentMapAttachmentID"))) { obj.ParentMapAttachmentID = null; } else { obj.ParentMapAttachmentID = sr.GetInt32(sr.GetOrdinal("ParentMapAttachmentID")); } if (sr.IsDBNull(sr.GetOrdinal("IsACopy"))) { obj.IsACopy = null; } else { obj.IsACopy = sr.GetBoolean(sr.GetOrdinal("IsACopy")); } objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Gets all MapAttachment records /// </summary> public static MapAttachmentDO[] GetAll() { string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[MapAttachment_GetAll]", new SqlParameter[] { }, pid); List<MapAttachmentDO> objs = new List<MapAttachmentDO>(); while(sr.Read()){ MapAttachmentDO obj = new MapAttachmentDO(); obj.MapAttachmentID = sr.GetInt32(sr.GetOrdinal("MapAttachmentID")); obj.DateUploaded = sr.GetDateTime(sr.GetOrdinal("DateUploaded")); obj.UserToken = sr.GetString(sr.GetOrdinal("UserToken")); obj.FileSize = sr.GetInt32(sr.GetOrdinal("FileSize")); obj.Description = sr.GetString(sr.GetOrdinal("Description")); if (sr.IsDBNull(sr.GetOrdinal("PermitKey"))) { obj.PermitKey = null; } else { obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey")); } if (sr.IsDBNull(sr.GetOrdinal("MimeType"))) { obj.MimeType = null; } else { obj.MimeType = sr.GetString(sr.GetOrdinal("MimeType")); } if (sr.IsDBNull(sr.GetOrdinal("FileName"))) { obj.FileName = null; } else { obj.FileName = sr.GetString(sr.GetOrdinal("FileName")); } if (sr.IsDBNull(sr.GetOrdinal("TOCID"))) { obj.TOCID = null; } else { obj.TOCID = sr.GetInt32(sr.GetOrdinal("TOCID")); } if (sr.IsDBNull(sr.GetOrdinal("ParentMapAttachmentID"))) { obj.ParentMapAttachmentID = null; } else { obj.ParentMapAttachmentID = sr.GetInt32(sr.GetOrdinal("ParentMapAttachmentID")); } if (sr.IsDBNull(sr.GetOrdinal("IsACopy"))) { obj.IsACopy = null; } else { obj.IsACopy = sr.GetBoolean(sr.GetOrdinal("IsACopy")); } objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Deletes a MapAttachment record /// </summary> public static async Task<int> DeleteAsync(MapAttachmentDO DO) { SqlParameter _MapAttachmentID = new SqlParameter("MapAttachmentID", SqlDbType.Int); _MapAttachmentID.Value = DO.MapAttachmentID; SqlParameter[] _params = new SqlParameter[] { _MapAttachmentID }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return await DataCommon.ExecuteScalarAsync("[dbo].[MapAttachment_Delete]", _params, pid); }