internal bool PopulateFromReader(IDataReader reader)
{
if (reader.Read())
{
this.guid = new Guid(reader["Guid"].ToString());
this.siteGuid = new Guid(reader["SiteGuid"].ToString());
this.userGuid = new Guid(reader["UserGuid"].ToString());
this.moduleGuid = new Guid(reader["ModuleGuid"].ToString());
this.contentText = reader["ContentText"].ToString();
this.customData = reader["CustomData"].ToString();
object val = reader["CustomReferenceNumber"];
this.customReferenceNumber = val == DBNull.Value ? -1 : Convert.ToInt32(val);
val = reader["CustomReferenceGuid"];
this.customReferenceGuid = val == DBNull.Value ? Guid.Empty : new Guid(val.ToString());
this.createdDateUtc = Convert.ToDateTime(reader["CreatedDateUtc"]);
//val = reader["LastModUserGuid"];
//this.lastModUserGuid = val == DBNull.Value ? null : (Guid?)new Guid(val.ToString());
this.lastModUserGuid = new Guid(reader["LastModUserGuid"].ToString());
//val = reader["LastModUtc"];
//this.lastModUtc = val == DBNull.Value ? null : (DateTime?)DateTime.Parse(val.ToString());
this.lastModUtc = Convert.ToDateTime(reader["LastModUtc"]);
this.createdByUserLogin = reader["CreatedByUserLogin"].ToString();
this.createdByUserName = reader["CreatedByUserName"].ToString();
this.recentActionByUserLogin = reader["RecentActionByUserLogin"].ToString();
this.recentActionByUserName = reader["RecentActionByUserName"].ToString();
this.recentActionByUserEmail = reader["RecentActionByUserEmail"].ToString();
string statusVal = reader["Status"].ToString();
this.status = String.IsNullOrEmpty(statusVal)
? ContentWorkflowStatus.None
: (ContentWorkflowStatus)Enum.Parse(typeof(ContentWorkflowStatus), statusVal);
this.originalStatus = status;
this.notes = reader["Notes"].ToString();
//val = reader["RecentActionOn"];
//this.recentActionOn = val == null ? null : (DateTime?)DateTime.Parse(val.ToString());
if (reader["RecentActionOn"] != DBNull.Value)
{
this.recentActionOn = Convert.ToDateTime(reader["RecentActionOn"]);
}
this.moduleTitle = reader["ModuleTitle"].ToString();
return(true);
}
return(false);
}
public bool RejectContentChanges(Guid rejectorGuid, string rejectionReason)
{
this.status = ContentWorkflowStatus.ApprovalRejected;
this.lastModUserGuid = rejectorGuid;
this.lastModUtc = DateTime.UtcNow;
this.notes = rejectionReason;
return(Save());
//return DBContentWorkflow.RejectContentChanges(moduleGuid, rejectorGuid, rejectionReason);
}
internal bool PopulateFromReader(IDataReader reader)
{
if (reader.Read())
{
this.guid = new Guid(reader["Guid"].ToString());
this.siteGuid = new Guid(reader["SiteGuid"].ToString());
this.userGuid = new Guid(reader["UserGuid"].ToString());
this.moduleGuid = new Guid(reader["ModuleGuid"].ToString());
this.contentText = reader["ContentText"].ToString();
this.customData = reader["CustomData"].ToString();
object val = reader["CustomReferenceNumber"];
this.customReferenceNumber = val == DBNull.Value ? -1 : Convert.ToInt32(val);
val = reader["CustomReferenceGuid"];
this.customReferenceGuid = val == DBNull.Value ? Guid.Empty : new Guid(val.ToString());
this.createdDateUtc = Convert.ToDateTime(reader["CreatedDateUtc"]);
//val = reader["LastModUserGuid"];
//this.lastModUserGuid = val == DBNull.Value ? null : (Guid?)new Guid(val.ToString());
this.lastModUserGuid = new Guid(reader["LastModUserGuid"].ToString());
//val = reader["LastModUtc"];
//this.lastModUtc = val == DBNull.Value ? null : (DateTime?)DateTime.Parse(val.ToString());
this.lastModUtc = Convert.ToDateTime(reader["LastModUtc"]);
this.createdByUserLogin = reader["CreatedByUserLogin"].ToString();
this.createdByUserName = reader["CreatedByUserName"].ToString();
this.createdByUserFirstName = reader["CreatedByFirstName"].ToString();
this.createdByUserLastName = reader["CreatedByLastName"].ToString();
this.authorEmail = reader["CreatedByUserEmail"].ToString();
this.authorAvatar = reader["CreatedByAvatar"].ToString();
this.authorBio = reader["CreatedByAuthorBio"].ToString();
this.authorUserId = Convert.ToInt32(reader["CreatedByUserID"]);
this.lastModByUserLastName = reader["ModifiedByUserName"].ToString();
this.lastModByUserFirstName = reader["ModifiedByFirstName"].ToString();
this.lastModByUserLastName = reader["ModifiedByLastName"].ToString();
this.recentActionByUserLogin = reader["RecentActionByUserLogin"].ToString();
this.recentActionByUserName = reader["RecentActionByUserName"].ToString();
this.recentActionByUserEmail = reader["RecentActionByUserEmail"].ToString();
string statusVal = reader["Status"].ToString();
this.status = String.IsNullOrEmpty(statusVal)
? ContentWorkflowStatus.None
: (ContentWorkflowStatus)Enum.Parse(typeof(ContentWorkflowStatus), statusVal);
this.originalStatus = status;
this.notes = reader["Notes"].ToString();
//val = reader["RecentActionOn"];
//this.recentActionOn = val == null ? null : (DateTime?)DateTime.Parse(val.ToString());
if (reader["RecentActionOn"] != DBNull.Value)
{
this.recentActionOn = Convert.ToDateTime(reader["RecentActionOn"]);
}
this.moduleTitle = reader["ModuleTitle"].ToString();
return true;
}
return false;
}
public bool RejectContentChanges(Guid rejectorGuid, string rejectionReason)
{
this.status = ContentWorkflowStatus.ApprovalRejected;
this.lastModUserGuid = rejectorGuid;
this.lastModUtc = DateTime.UtcNow;
this.notes = rejectionReason;
return Save();
//return DBContentWorkflow.RejectContentChanges(moduleGuid, rejectorGuid, rejectionReason);
}
/// <summary>
/// Returns a DataSet with a page ContentWorkflow items and their related pagesettings info
/// </summary>
/// <param name="siteGuid"></param>
/// <param name="status"></param>
/// <param name="pageNumber"></param>
/// <param name="pageSize"></param>
/// <param name="totalPages"></param>
/// <returns></returns>
public static DataSet GetPageOfWorkflowsWithPageInfo(Guid siteGuid, ContentWorkflowStatus status, int pageNumber, int pageSize, out int totalPages)
{
DataSet dataSet = new DataSet();
DataTable workFlowsTable = GetEmptyTable();
using (IDataReader reader = DBContentWorkflow.GetPage(
siteGuid,
status.ToString(),
pageNumber,
pageSize,
out totalPages))
{
while (reader.Read())
{
DataRow row = workFlowsTable.NewRow();
row["Guid"] = new Guid(reader["Guid"].ToString());
row["SiteGuid"] = new Guid(reader["SiteGuid"].ToString());
row["UserGuid"] = new Guid(reader["UserGuid"].ToString());
row["LastModUserGuid"] = new Guid(reader["LastModUserGuid"].ToString());
row["ModuleGuid"] = new Guid(reader["ModuleGuid"].ToString());
row["CustomReferenceGuid"] = new Guid(reader["CustomReferenceGuid"].ToString());
row["ModuleID"] = Convert.ToInt32(reader["ModuleID"]);
row["ModuleTitle"] = reader["ModuleTitle"];
row["ContentText"] = reader["ContentText"];
row["CustomData"] = reader["CustomData"];
row["CustomReferenceNumber"] = Convert.ToInt32(reader["CustomReferenceNumber"]);
row["CreatedDateUtc"] = Convert.ToDateTime(reader["CreatedDateUtc"]);
row["LastModUtc"] = Convert.ToDateTime(reader["LastModUtc"]);
row["CreatedByUserLogin"] = reader["CreatedByUserLogin"];
row["CreatedByUserName"] = reader["CreatedByUserName"];
row["RecentActionByUserLogin"] = reader["RecentActionByUserLogin"];
row["RecentActionByUserName"] = reader["RecentActionByUserName"];
row["RecentActionByUserEmail"] = reader["RecentActionByUserEmail"];
row["Status"] = reader["Status"];
row["Notes"] = reader["Notes"];
if (reader["RecentActionOn"] != DBNull.Value)
{
row["RecentActionOn"] = Convert.ToDateTime(reader["RecentActionOn"]);
}
else
{
row["RecentActionOn"] = DateTime.UtcNow;
}
workFlowsTable.Rows.Add(row);
}
}
DataTable pageInfoTable = GetEmptyPageInfoTable();
using (IDataReader reader = DBContentWorkflow.GetPageInfoForPage(
siteGuid,
status.ToString(),
pageNumber,
pageSize))
{
while (reader.Read())
{
DataRow row = pageInfoTable.NewRow();
int pageId = Convert.ToInt32(reader["PageID"]);
row["PageID"] = pageId;
row["PageGuid"] = new Guid(reader["PageGuid"].ToString());
row["WorkflowGuid"] = new Guid(reader["WorkflowGuid"].ToString());
row["PageName"] = reader["PageName"];
bool useUrl = Convert.ToBoolean(reader["UseUrl"]);
if (useUrl)
{
row["PageUrl"] = reader["PageUrl"];
}
else
{
row["PageUrl"] = "~/Default.aspx?pageid=" + pageId.ToString(CultureInfo.InvariantCulture);
}
pageInfoTable.Rows.Add(row);
}
}
workFlowsTable.TableName = "WorkFlows";
dataSet.Tables.Add(workFlowsTable);
pageInfoTable.TableName = "PageInfo";
dataSet.Tables.Add(pageInfoTable);
// create a relationship
dataSet.Relations.Add("workflowPages",
dataSet.Tables["WorkFlows"].Columns["Guid"],
dataSet.Tables["PageInfo"].Columns["WorkflowGuid"]);
return dataSet;
}
/// <summary>
/// Returns a DataSet with a page ContentWorkflow items and their related pagesettings info
/// </summary>
/// <param name="siteGuid"></param>
/// <param name="status"></param>
/// <param name="pageNumber"></param>
/// <param name="pageSize"></param>
/// <param name="totalPages"></param>
/// <returns></returns>
public static DataSet GetPageOfWorkflowsWithPageInfo(Guid siteGuid, ContentWorkflowStatus status, int pageNumber, int pageSize, out int totalPages)
{
DataSet dataSet = new DataSet();
DataTable workFlowsTable = GetEmptyTable();
using (IDataReader reader = DBContentWorkflow.GetPage(
siteGuid,
status.ToString(),
pageNumber,
pageSize,
out totalPages))
{
while (reader.Read())
{
DataRow row = workFlowsTable.NewRow();
row["Guid"] = new Guid(reader["Guid"].ToString());
row["SiteGuid"] = new Guid(reader["SiteGuid"].ToString());
row["UserGuid"] = new Guid(reader["UserGuid"].ToString());
row["LastModUserGuid"] = new Guid(reader["LastModUserGuid"].ToString());
row["ModuleGuid"] = new Guid(reader["ModuleGuid"].ToString());
row["CustomReferenceGuid"] = new Guid(reader["CustomReferenceGuid"].ToString());
row["ModuleID"] = Convert.ToInt32(reader["ModuleID"]);
row["ModuleTitle"] = reader["ModuleTitle"];
row["ContentText"] = reader["ContentText"];
row["CustomData"] = reader["CustomData"];
row["CustomReferenceNumber"] = Convert.ToInt32(reader["CustomReferenceNumber"]);
row["CreatedDateUtc"] = Convert.ToDateTime(reader["CreatedDateUtc"]);
row["LastModUtc"] = Convert.ToDateTime(reader["LastModUtc"]);
row["CreatedByUserLogin"] = reader["CreatedByUserLogin"];
row["CreatedByUserName"] = reader["CreatedByUserName"];
row["RecentActionByUserLogin"] = reader["RecentActionByUserLogin"];
row["RecentActionByUserName"] = reader["RecentActionByUserName"];
row["RecentActionByUserEmail"] = reader["RecentActionByUserEmail"];
row["Status"] = reader["Status"];
row["Notes"] = reader["Notes"];
if (reader["RecentActionOn"] != DBNull.Value)
{
row["RecentActionOn"] = Convert.ToDateTime(reader["RecentActionOn"]);
}
else
{
row["RecentActionOn"] = DateTime.UtcNow;
}
workFlowsTable.Rows.Add(row);
}
}
DataTable pageInfoTable = GetEmptyPageInfoTable();
using (IDataReader reader = DBContentWorkflow.GetPageInfoForPage(
siteGuid,
status.ToString(),
pageNumber,
pageSize))
{
while (reader.Read())
{
DataRow row = pageInfoTable.NewRow();
int pageId = Convert.ToInt32(reader["PageID"]);
row["PageID"] = pageId;
row["PageGuid"] = new Guid(reader["PageGuid"].ToString());
row["WorkflowGuid"] = new Guid(reader["WorkflowGuid"].ToString());
row["PageName"] = reader["PageName"];
bool useUrl = Convert.ToBoolean(reader["UseUrl"]);
if (useUrl)
{
row["PageUrl"] = reader["PageUrl"];
}
else
{
row["PageUrl"] = "~/Default.aspx?pageid=" + pageId.ToString(CultureInfo.InvariantCulture);
}
pageInfoTable.Rows.Add(row);
}
}
workFlowsTable.TableName = "WorkFlows";
dataSet.Tables.Add(workFlowsTable);
pageInfoTable.TableName = "PageInfo";
dataSet.Tables.Add(pageInfoTable);
// create a relationship
dataSet.Relations.Add("workflowPages",
dataSet.Tables["WorkFlows"].Columns["Guid"],
dataSet.Tables["PageInfo"].Columns["WorkflowGuid"]);
return(dataSet);
}
