/// <summary>
/// Gets the Master Pages for the selected Template
/// </summary>
/// <param name="siteUrl">Site URL.</param>
/// <param name="listName">List Name (DWB Template).</param>
/// <param name="queryString">CAML Query.</param>
/// <param name="viewFields">View Fields.</param>
/// <returns>List Entry object with TemplateConfiguration values assigned.</returns>
/// <exception cref="">Handled in calling method.</exception>
internal ListEntry GetMasterPageDetail(string siteUrl, string listName, string queryString, string viewFields)
{
ListEntry objListEntry = null;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite site = new SPSite(siteUrl))
{
using (SPWeb web = site.OpenWeb())
{
web.AllowUnsafeUpdates = true;
SPList list = web.Lists[listName];
SPQuery query = new SPQuery();
query.Query = queryString;
query.ViewFields = viewFields;
SPListItemCollection listItems = list.GetItems(query);
if (listItems != null)
{
objListEntry = new ListEntry();
MasterPageDetails objMasterPageDetails = new MasterPageDetails();
foreach (SPListItem item in listItems)
{
objMasterPageDetails.RowId = Convert.ToInt32(item["ID"]);//ID
objMasterPageDetails.AssetType = Convert.ToString(item["Asset_Type"]);//Asset_Type
objMasterPageDetails.ConnectionType = Convert.ToString(item["Connection_Type"]);// Connection_Type
objMasterPageDetails.PageOwner = Convert.ToString(item["Page_Owner"]); //Page_Owner
objMasterPageDetails.PageSequence = Convert.ToInt32(item["Page_Sequence"]);//Page_Sequence
objMasterPageDetails.PageURL = Convert.ToString(item["Page_URL"]);//Page_URL
objMasterPageDetails.SignOffDiscipline = Convert.ToString(item["Discipline"]);//Discipline
objMasterPageDetails.SOP = Convert.ToString(item["Standard_Operating_Procedure"]);//Standard_Operating_Procedure
objMasterPageDetails.TemplateTitle = Convert.ToString(item["Page_Title_Template"]);//Page_Title_Template
objMasterPageDetails.Templates = Convert.ToString(item["Template_ID"]);//Template_ID
objMasterPageDetails.Name = Convert.ToString(item["Master_Page_Name"]);//Master_Page_Name
objMasterPageDetails.MasterPageID = Convert.ToString(item["Master_Page_ID"]);//Master_Page_ID
objListEntry.MasterPage = objMasterPageDetails;
}
}
web.AllowUnsafeUpdates = false;
}
}
});
return objListEntry;
}
/// <summary>
/// Gets the Master Page Information from ChapterPage mapping List based on the CAML Query.
/// </summary>
/// <param name="parentSiteUrl">Site URL.</param>
/// <param name="listName">List Name.</param>
/// <param name="queryString">CAML Query.</param>
/// <returns>ListEntry object.</returns>
/// <exception cref="">Handled in calling method.</exception>
internal ListEntry SetChapterPage(string siteURL, string listName, string queryString)
{
ListEntry objListEntry = null;
DataTable objListItems = null;
DataRow objListRow;
int intRowId = 0;
MasterPageDetails objMasterpage = null;
ChapterDetails objChapterDetails = null;
try
{
objCommonDAL = new CommonDAL();
objListItems = objCommonDAL.ReadList(siteURL, listName, queryString);
if (objListItems != null)
{
objListEntry = new ListEntry();
objMasterpage = new MasterPageDetails();
for (int index = 0; index < objListItems.Rows.Count; index++)
{
objListRow = objListItems.Rows[index];
objMasterpage.Name = Convert.ToString(objListRow["Page_Name"]);
objMasterpage.TemplateTitle = Convert.ToString(objListRow["Page_Actual_Name"]);
if (objListRow["Page_Sequence"] != DBNull.Value)
{
objMasterpage.PageSequence = Convert.ToInt32(objListRow["Page_Sequence"]);
}
objMasterpage.SOP = Convert.ToString(objListRow["Standard_Operating_Procedure"]);
objMasterpage.AssetType = Convert.ToString(objListRow["Asset_Type"]);
objMasterpage.ConnectionType = Convert.ToString(objListRow["Connection_Type"]);
objMasterpage.SignOffDiscipline = Convert.ToString(objListRow["Discipline"]);
objChapterDetails = new ChapterDetails();
int.TryParse(Convert.ToString(objListRow["Chapter_ID"]), out intRowId);
objChapterDetails.RowID = intRowId;
int.TryParse(Convert.ToString(objListRow["ID"]), out intRowId);
objMasterpage.RowId = intRowId;
objListEntry.ChapterDetails = objChapterDetails;
objListEntry.MasterPage = objMasterpage;
}
}
return objListEntry;
}
finally
{
if (objListItems != null)
objListItems.Dispose();
}
}
/// <summary>
/// Sets the master page details data object from the UI.
/// </summary>
/// <returns></returns>
private MasterPageDetails SetMasterPageDetails()
{
MasterPageDetails objMasterPage = new MasterPageDetails();
int intRowId = 0;
objMasterPage.Name = txtPageTitle.Text.Trim();
objMasterPage.TemplateTitle = txtTitleTemplate.Text.Trim();
if (cboDiscipline.SelectedIndex > 0)
{
if ((string.Compare(strListType, BOOKPAGES, true) == 0) || (string.Compare(strListType,CHAPTERPAGES, true) == 0) ||
(string.Compare(strListType, TEMPLATEMASTERPAGES, true) == 0))
{
objMasterPage.SignOffDiscipline = cboDiscipline.SelectedItem.Text;
/// This property is used to update DWB Template Pages Mapping list details
objMasterPage.SignOffDisciplineText = cboDiscipline.SelectedItem.Text;
}
else
{
objMasterPage.SignOffDiscipline = cboDiscipline.SelectedItem.Value;
/// This property is used to update DWB Template Pages Mapping list details
objMasterPage.SignOffDisciplineText = cboDiscipline.SelectedItem.Text;
}
}
objMasterPage.SOP = txtSOP.Text.Trim();
if (string.Compare(strListType, TEMPLATEMASTERPAGES) == 0)
{
objMasterPage.ConnectionType = cboConnectionType.SelectedItem.Text;
objMasterPage.AssetType = cboAssetType.SelectedItem.Text;
/// This property is used to update DWB Template Pages Mapping list details
objMasterPage.ConnectionTypeText = cboConnectionType.SelectedItem.Text;
/// This property is used to update DWB Template Pages Mapping list details
objMasterPage.AssetTypeText = cboAssetType.SelectedItem.Text;
}
else
{
objMasterPage.ConnectionType = cboConnectionType.SelectedItem.Value;
objMasterPage.AssetType = cboAssetType.SelectedItem.Value;
/// This property is used to update DWB Template Pages Mapping list details
objMasterPage.ConnectionTypeText = cboConnectionType.SelectedItem.Text;
/// This property is used to update DWB Template Pages Mapping list details
objMasterPage.AssetTypeText = cboAssetType.SelectedItem.Text;
}
if (string.Equals(strMode, ADD))
{
objMasterPage.Terminated = "No";
if (cboConnectionType.SelectedItem.Value.Equals("2"))
{
objMasterPage.PageURL = DWBTYPE2PAGEURL;
}
else if (cboConnectionType.SelectedItem.Value.Equals("3"))
{
objMasterPage.PageURL = DWBTYPE3PAGEURL;
}
ListItemCollection templateList = lstTemplates.Items;
foreach (ListItem templateItem in templateList)
{
if (templateItem.Selected)
{
objMasterPage.Templates = objMasterPage.Templates + templateItem.Value + ";";
}
}
}
else
{
if (int.TryParse(strSelectedID, out intRowId))
{
objMasterPage.RowId = intRowId;
}
}
return objMasterPage;
}
/// <summary>
/// Gets the Master Page Details.
/// </summary>
/// <param name="parentSiteUrl">Site URL.</param>
/// <param name="listName">List Name.</param>
/// <param name="queryString">CAML Query.</param>
/// <returns>ListEntry object.</returns>
internal ListEntry GetMasterPageDetail(string parentSiteUrl, string listName, string queryString)
{
ListEntry objListEntry = null;
DataTable objListItems = null;
DataRow objListRow;
MasterPageDetails objMasterPage = null;
try
{
objCommonDAL = new CommonDAL();
objListItems = objCommonDAL.ReadList(parentSiteUrl, listName, queryString);
if (objListItems != null)
{
objListEntry = new ListEntry();
objMasterPage = new MasterPageDetails();
for (int index = 0; index < objListItems.Rows.Count; index++)
{
objListRow = objListItems.Rows[index];
objMasterPage.Name = objListRow["Title"].ToString();
objMasterPage.TemplateTitle = objListRow["Title_Template"].ToString();
if (objListRow["Page_Sequence"] != DBNull.Value)
{
objMasterPage.PageSequence = Convert.ToInt32(objListRow["Page_Sequence"]);
}
objMasterPage.AssetType = Convert.ToString(objListRow["Asset_Type"]);
objMasterPage.SignOffDiscipline = Convert.ToString(objListRow["Sign_Off_Discipline"]);
objMasterPage.SOP = Convert.ToString(objListRow["Standard_Operating_Procedure"]);
objMasterPage.ConnectionType = Convert.ToString(objListRow["Connection_Type"]);
objMasterPage.Terminated = Convert.ToString(objListRow["Terminate_Status"]);
objMasterPage.Templates = Convert.ToString(objListRow["Template_ID"]);
objListEntry.MasterPage = objMasterPage;
}
}
return objListEntry;
}
finally
{
if (objListItems != null)
objListItems.Dispose();
}
}
