/// <summary> /// Creates a new Correspondence record using async /// </summary> public static async Task<int> CreateAsync(CorrespondenceDO DO) { SqlParameter _CorrespondenceType = new SqlParameter("CorrespondenceType", SqlDbType.VarChar); SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int); SqlParameter _UserToken = new SqlParameter("UserToken", SqlDbType.VarChar); SqlParameter _Name = new SqlParameter("Name", SqlDbType.VarChar); SqlParameter _FileSize = new SqlParameter("FileSize", SqlDbType.Int); SqlParameter _FileName = new SqlParameter("FileName", SqlDbType.VarChar); SqlParameter _MimeType = new SqlParameter("MimeType", SqlDbType.VarChar); SqlParameter _DateUploaded = new SqlParameter("DateUploaded", SqlDbType.DateTime); SqlParameter _Guid = new SqlParameter("Guid", SqlDbType.UniqueIdentifier); SqlParameter _Approved = new SqlParameter("Approved", SqlDbType.Bit); SqlParameter _ApprovedBy = new SqlParameter("ApprovedBy", SqlDbType.VarChar); SqlParameter _ApprovedDate = new SqlParameter("ApprovedDate", SqlDbType.DateTime); _CorrespondenceType.Value = DO.CorrespondenceType; _PermitKey.Value = DO.PermitKey; _UserToken.Value = DO.UserToken; _Name.Value = DO.Name; _FileSize.Value = DO.FileSize; _FileName.Value = DO.FileName; _MimeType.Value = DO.MimeType; _DateUploaded.Value = DO.DateUploaded; _Guid.Value = DO.Guid; _Approved.Value = DO.Approved; _ApprovedBy.Value = DO.ApprovedBy; _ApprovedDate.Value = DO.ApprovedDate; SqlParameter[] _params = new SqlParameter[] { _CorrespondenceType, _PermitKey, _UserToken, _Name, _FileSize, _FileName, _MimeType, _DateUploaded, _Guid, _Approved, _ApprovedBy, _ApprovedDate }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return await DataCommon.ExecuteScalarAsync("[dbo].[Correspondence_Insert]", _params, pid); }
/// <summary> /// Selects Correspondence records by PK /// </summary> public static async Task<CorrespondenceDO[]> GetByPKAsync(Int32 CorrespondenceId) { SqlParameter _CorrespondenceId = new SqlParameter("CorrespondenceId", SqlDbType.Int); _CorrespondenceId.Value = CorrespondenceId; SqlParameter[] _params = new SqlParameter[] { _CorrespondenceId }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[Correspondence_GetByPK]", _params, pid); List<CorrespondenceDO> objs = new List<CorrespondenceDO>(); while(sr.Read()) { CorrespondenceDO obj = new CorrespondenceDO(); obj.CorrespondenceId = sr.GetInt32(sr.GetOrdinal("CorrespondenceId")); obj.CorrespondenceType = sr.GetString(sr.GetOrdinal("CorrespondenceType")); obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey")); obj.UserToken = sr.GetString(sr.GetOrdinal("UserToken")); obj.Name = sr.GetString(sr.GetOrdinal("Name")); obj.FileSize = sr.GetInt32(sr.GetOrdinal("FileSize")); obj.FileName = sr.GetString(sr.GetOrdinal("FileName")); obj.MimeType = sr.GetString(sr.GetOrdinal("MimeType")); obj.DateUploaded = sr.GetDateTime(sr.GetOrdinal("DateUploaded")); obj.Guid = sr.GetGuid(sr.GetOrdinal("Guid")); obj.Approved = sr.GetBoolean(sr.GetOrdinal("Approved")); if (sr.IsDBNull(sr.GetOrdinal("ApprovedBy"))) { obj.ApprovedBy = null; } else { obj.ApprovedBy = sr.GetString(sr.GetOrdinal("ApprovedBy")); } if (sr.IsDBNull(sr.GetOrdinal("ApprovedDate"))) { obj.ApprovedDate = null; } else { obj.ApprovedDate = sr.GetDateTime(sr.GetOrdinal("ApprovedDate")); } objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Gets all Correspondence records /// </summary> public static CorrespondenceDO[] GetAll() { string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[Correspondence_GetAll]", new SqlParameter[] { }, pid); List<CorrespondenceDO> objs = new List<CorrespondenceDO>(); while(sr.Read()){ CorrespondenceDO obj = new CorrespondenceDO(); obj.CorrespondenceId = sr.GetInt32(sr.GetOrdinal("CorrespondenceId")); obj.CorrespondenceType = sr.GetString(sr.GetOrdinal("CorrespondenceType")); obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey")); obj.UserToken = sr.GetString(sr.GetOrdinal("UserToken")); obj.Name = sr.GetString(sr.GetOrdinal("Name")); obj.FileSize = sr.GetInt32(sr.GetOrdinal("FileSize")); obj.FileName = sr.GetString(sr.GetOrdinal("FileName")); obj.MimeType = sr.GetString(sr.GetOrdinal("MimeType")); obj.DateUploaded = sr.GetDateTime(sr.GetOrdinal("DateUploaded")); obj.Guid = sr.GetGuid(sr.GetOrdinal("Guid")); obj.Approved = sr.GetBoolean(sr.GetOrdinal("Approved")); if (sr.IsDBNull(sr.GetOrdinal("ApprovedBy"))) { obj.ApprovedBy = null; } else { obj.ApprovedBy = sr.GetString(sr.GetOrdinal("ApprovedBy")); } if (sr.IsDBNull(sr.GetOrdinal("ApprovedDate"))) { obj.ApprovedDate = null; } else { obj.ApprovedDate = sr.GetDateTime(sr.GetOrdinal("ApprovedDate")); } objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Deletes a Correspondence record /// </summary> public static async Task<int> DeleteAsync(CorrespondenceDO DO) { SqlParameter _CorrespondenceId = new SqlParameter("CorrespondenceId", SqlDbType.Int); _CorrespondenceId.Value = DO.CorrespondenceId; SqlParameter[] _params = new SqlParameter[] { _CorrespondenceId }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return await DataCommon.ExecuteScalarAsync("[dbo].[Correspondence_Delete]", _params, pid); }
/// <summary> /// Saves a correspondence letter from the posted data /// </summary> /// <param name="PermitKey"></param> /// <param name="CorrespondenceType"></param> /// <returns></returns> private CorrespondenceBO SaveLetterFile(int PermitKey, ENUMBLL.PDFDocuments CorrespondenceType) { // Gets the posted file from the request HttpPostedFileBase File = Request.Files["File"]; // Build the letter data object CorrespondenceDO data = new CorrespondenceDO() { CorrespondenceId = 0, CorrespondenceType = CorrespondenceType.ToString(), DateUploaded = DateTime.Now, FileName = File.FileName, FileSize = File.ContentLength, MimeType = File.ContentType, Guid = Guid.NewGuid(), Name = ENUMBLL.EnumDescription(CorrespondenceType), PermitKey = PermitKey, UserToken = myCoalUser.UserToken, Approved = false }; // read content from stream byte[] content = new byte[File.ContentLength]; File.InputStream.Read(content, 0, (int)File.ContentLength); // post the information to create a new business object CorrespondenceBO letter = CorrespondenceBLL.AddCorrespondence(data, content, DirectoryMapping.CorrespondenceFolder); return letter; }
/// <summary> /// A partial view used to upload and approve correspondence letters /// </summary> /// <param name="PermitKey"></param> /// <param name="Type"></param> /// <returns></returns> public ActionResult LetterUploader(int PermitKey, ENUMBLL.PDFDocuments Type) { CorrespondenceDO DataObject = new CorrespondenceDO() { CorrespondenceType = Type.ToString(), PermitKey = PermitKey }; CorrespondenceBO model = new CorrespondenceBO() { DataObject = DataObject }; return PartialView(model); }