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