/// <summary> /// Creates a new UserTasks record using async /// </summary> public static async Task CreateAsync(UserTasksDO DO) { SqlParameter _UserToken = new SqlParameter("UserToken", SqlDbType.VarChar); SqlParameter _PermitId = new SqlParameter("PermitId", SqlDbType.VarChar); SqlParameter _BusinessProcess = new SqlParameter("BusinessProcess", SqlDbType.VarChar); SqlParameter _WorkflowCategory = new SqlParameter("WorkflowCategory", SqlDbType.VarChar); SqlParameter _PermitIdSiteName = new SqlParameter("PermitIdSiteName", SqlDbType.VarChar); SqlParameter _Subject = new SqlParameter("Subject", SqlDbType.VarChar); SqlParameter _SubjectDescription = new SqlParameter("SubjectDescription", SqlDbType.VarChar); SqlParameter _DateAssigned = new SqlParameter("DateAssigned", SqlDbType.DateTime); SqlParameter _DueDate = new SqlParameter("DueDate", SqlDbType.DateTime); SqlParameter _CompletionDate = new SqlParameter("CompletionDate", SqlDbType.DateTime); SqlParameter _SpecialInstructions = new SqlParameter("SpecialInstructions", SqlDbType.VarChar); _UserToken.Value = DO.UserToken; _PermitId.Value = DO.PermitId; _BusinessProcess.Value = DO.BusinessProcess; _WorkflowCategory.Value = DO.WorkflowCategory; _PermitIdSiteName.Value = DO.PermitIdSiteName; _Subject.Value = DO.Subject; _SubjectDescription.Value = DO.SubjectDescription; _DateAssigned.Value = DO.DateAssigned; _DueDate.Value = DO.DueDate; _CompletionDate.Value = DO.CompletionDate; _SpecialInstructions.Value = DO.SpecialInstructions; SqlParameter[] _params = new SqlParameter[] { _UserToken, _PermitId, _BusinessProcess, _WorkflowCategory, _PermitIdSiteName, _Subject, _SubjectDescription, _DateAssigned, _DueDate, _CompletionDate, _SpecialInstructions }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; await DataCommon.ExecuteNonQueryAsync("[dbo].[UserTasks_Insert]", _params, pid); }
/// <summary> /// Gets all UserTasks records /// </summary> public static async Task<UserTasksDO[]> GetAllAsync() { string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[UserTasks_GetAll]", new SqlParameter[] { }, pid); List<UserTasksDO> objs = new List<UserTasksDO>(); while(sr.Read()){ UserTasksDO obj = new UserTasksDO(); obj.UserToken = sr.GetString(sr.GetOrdinal("UserToken")); obj.PermitId = sr.GetString(sr.GetOrdinal("PermitId")); obj.BusinessProcess = sr.GetString(sr.GetOrdinal("BusinessProcess")); obj.WorkflowCategory = sr.GetString(sr.GetOrdinal("WorkflowCategory")); obj.PermitIdSiteName = sr.GetString(sr.GetOrdinal("PermitIdSiteName")); obj.Subject = sr.GetString(sr.GetOrdinal("Subject")); obj.SubjectDescription = sr.GetString(sr.GetOrdinal("SubjectDescription")); obj.DateAssigned = sr.GetDateTime(sr.GetOrdinal("DateAssigned")); if (sr.IsDBNull(sr.GetOrdinal("DueDate"))) { obj.DueDate = null; } else { obj.DueDate = sr.GetDateTime(sr.GetOrdinal("DueDate")); } if (sr.IsDBNull(sr.GetOrdinal("CompletionDate"))) { obj.CompletionDate = null; } else { obj.CompletionDate = sr.GetDateTime(sr.GetOrdinal("CompletionDate")); } if (sr.IsDBNull(sr.GetOrdinal("SpecialInstructions"))) { obj.SpecialInstructions = null; } else { obj.SpecialInstructions = sr.GetString(sr.GetOrdinal("SpecialInstructions")); } objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Selects UserTasks records by PK /// </summary> public static async Task<UserTasksDO[]> GetByPKAsync(String UserToken, String PermitId, String BusinessProcess, String Subject, DateTime DateAssigned) { SqlParameter _UserToken = new SqlParameter("UserToken", SqlDbType.VarChar); SqlParameter _PermitId = new SqlParameter("PermitId", SqlDbType.VarChar); SqlParameter _BusinessProcess = new SqlParameter("BusinessProcess", SqlDbType.VarChar); SqlParameter _Subject = new SqlParameter("Subject", SqlDbType.VarChar); SqlParameter _DateAssigned = new SqlParameter("DateAssigned", SqlDbType.DateTime); _UserToken.Value = UserToken; _PermitId.Value = PermitId; _BusinessProcess.Value = BusinessProcess; _Subject.Value = Subject; _DateAssigned.Value = DateAssigned; SqlParameter[] _params = new SqlParameter[] { _UserToken, _PermitId, _BusinessProcess, _Subject, _DateAssigned }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[UserTasks_GetByPK]", _params, pid); List<UserTasksDO> objs = new List<UserTasksDO>(); while(sr.Read()) { UserTasksDO obj = new UserTasksDO(); obj.UserToken = sr.GetString(sr.GetOrdinal("UserToken")); obj.PermitId = sr.GetString(sr.GetOrdinal("PermitId")); obj.BusinessProcess = sr.GetString(sr.GetOrdinal("BusinessProcess")); obj.WorkflowCategory = sr.GetString(sr.GetOrdinal("WorkflowCategory")); obj.PermitIdSiteName = sr.GetString(sr.GetOrdinal("PermitIdSiteName")); obj.Subject = sr.GetString(sr.GetOrdinal("Subject")); obj.SubjectDescription = sr.GetString(sr.GetOrdinal("SubjectDescription")); obj.DateAssigned = sr.GetDateTime(sr.GetOrdinal("DateAssigned")); if (sr.IsDBNull(sr.GetOrdinal("DueDate"))) { obj.DueDate = null; } else { obj.DueDate = sr.GetDateTime(sr.GetOrdinal("DueDate")); } if (sr.IsDBNull(sr.GetOrdinal("CompletionDate"))) { obj.CompletionDate = null; } else { obj.CompletionDate = sr.GetDateTime(sr.GetOrdinal("CompletionDate")); } if (sr.IsDBNull(sr.GetOrdinal("SpecialInstructions"))) { obj.SpecialInstructions = null; } else { obj.SpecialInstructions = sr.GetString(sr.GetOrdinal("SpecialInstructions")); } objs.Add(obj); } return objs.ToArray(); }
/// <summary> /// Deletes a UserTasks record /// </summary> public static async Task<int> DeleteAsync(UserTasksDO DO) { SqlParameter _UserToken = new SqlParameter("UserToken", SqlDbType.VarChar); SqlParameter _PermitId = new SqlParameter("PermitId", SqlDbType.VarChar); SqlParameter _BusinessProcess = new SqlParameter("BusinessProcess", SqlDbType.VarChar); SqlParameter _Subject = new SqlParameter("Subject", SqlDbType.VarChar); SqlParameter _DateAssigned = new SqlParameter("DateAssigned", SqlDbType.DateTime); _UserToken.Value = DO.UserToken; _PermitId.Value = DO.PermitId; _BusinessProcess.Value = DO.BusinessProcess; _Subject.Value = DO.Subject; _DateAssigned.Value = DO.DateAssigned; SqlParameter[] _params = new SqlParameter[] { _UserToken, _PermitId, _BusinessProcess, _Subject, _DateAssigned }; string pid = ConfigurationManager.AppSettings["ePermitDAL"]; return await DataCommon.ExecuteScalarAsync("[dbo].[UserTasks_Delete]", _params, pid); }