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