/// <summary>
/// Add page to the chapter
/// </summary>
/// <param name="siteURL">The site URL.</param>
/// <param name="objListentry">ListEntry object.</param>
/// <param name="listName">Name of the list.</param>
/// <param name="auditListName">Name of the audit list.</param>
/// <param name="username">Windows User ID.</param>
/// <param name="actionPerformed">Audit Action ID</param>
public void AddPageToChapters(string siteURL, ListEntry objListentry, string listName, string auditListName, string username, string actionPerformed)
{
objWellBookChapterDAL = new WellBookChapterDAL();
string strPageID = objWellBookChapterDAL.AddPageToChapter(siteURL, objListentry, listName, auditListName, username, actionPerformed);
if (!string.IsNullOrEmpty(strPageID) && objListentry != null && objListentry.ChapterPagesMapping != null)
{
StoryBoard objStoryBoard = new StoryBoard();
objStoryBoard.PageId = Int32.Parse(strPageID);
objStoryBoard.PageOwner = objListentry.ChapterPagesMapping[0].PageOwner;
objStoryBoard.PageType = objListentry.ChapterPagesMapping[0].AssetType;
objStoryBoard.SOP = objListentry.ChapterPagesMapping[0].StandardOperatingProc;
objStoryBoard.PageTitle = objListentry.ChapterPagesMapping[0].PageName;
objStoryBoard.Discipline = objListentry.ChapterPagesMapping[0].Discipline;
objStoryBoard.ConnectionType = objListentry.ChapterPagesMapping[0].ConnectionType;
objStoryBoard.MasterPageName = objListentry.ChapterPagesMapping[0].PageActualName;
objStoryBoard.CreatedBy = objListentry.ChapterPagesMapping[0].Created_By;
objStoryBoard.CreationDate = objListentry.ChapterPagesMapping[0].Created_Date;
string strCAMLQuery = @"<Where><Eq><FieldRef Name='Page_ID' /><Value Type='Number'>" + strPageID + "</Value></Eq></Where>";
objWellBookChapterDAL.UpdateStoryBoard(siteURL, DWBSTORYBOARD, CHAPTERPAGESMAPPINGAUDITLIST, strCAMLQuery, strPageID, objStoryBoard, actionPerformed, username);
}
}
/// <summary>
/// Updates the Story Board
/// </summary>
/// <param name="parentSiteURL">Site URL.</param>
/// <param name="listName">List Name.</param>
/// <param name="auditListName">Audit List Name.</param>
/// <param name="camlQuery">CAML Query.</param>
/// <param name="pageID">Page ID.</param>
/// <param name="pageStoryBoard">StoryBoard object.</param>
/// <param name="userName">Windows User ID.</param>
/// <param name="actionPerformed">Audit Action ID.</param>
public void UpdateStoryBoard(string parentSiteURL, string listName, string auditListName, string camlQuery, string pageID, StoryBoard pageStoryBoard, string userName, string actionPerformed)
{
objWellBookChapterDAL = new WellBookChapterDAL();
objWellBookChapterDAL.UpdateStoryBoard(parentSiteURL, listName, auditListName, camlQuery, pageID, pageStoryBoard, actionPerformed, userName);
}
/// <summary>
/// Updates the list entry.
/// </summary>
/// <param name="siteURL">The site URL.</param>
/// <param name="listEntry">The list entry.</param>
/// <param name="auditListName">Name of the audit list.</param>
/// <param name="listName">Name of the list.</param>
/// <param name="userName">Name of the user.</param>
/// <param name="actionPerformed">The action performed.</param>
public void UpdateListEntry(string siteURL, ListEntry listEntry, string auditListName, string listName, string userName, string actionPerformed)
{
objWellBookChapterDAL = new WellBookChapterDAL();
objCommonDAL = new CommonDAL();
string strChapterID = objWellBookChapterDAL.UpdateListEntry(siteURL, listEntry, listName, auditListName, userName, actionPerformed);
if (listEntry != null && listEntry.ChapterPagesMapping != null)
{
if (listEntry.ChapterPagesMapping.Count > 0 && actionPerformed.Contains(AUDIT_ACTION_CREATION))
{
objWellBookChapterDAL.AddChapterMasterPageMapping(siteURL, listEntry, CHAPTERPAGESMAPPINGLIST, CHAPTERPAGESMAPPINGAUDITLIST, userName, actionPerformed);
string strCAMLQuery = string.Empty;
DataTable dtChapterPages = null;
DataTable dtMasterPage = null;
DataTable dtTemplate = null;
string strViewFields = string.Empty;
int intMasterPageID;
if (!string.IsNullOrEmpty(strChapterID))
{
strCAMLQuery = @"<Where><Eq><FieldRef Name='Chapter_ID'/><Value Type='Number'>" + strChapterID + "</Value></Eq></Where>";
dtChapterPages = objCommonDAL.ReadList(siteURL, CHAPTERPAGESMAPPINGLIST, strCAMLQuery);
}
if (dtChapterPages != null && dtChapterPages.Rows.Count > 0)
{
foreach (DataRow dtRow in dtChapterPages.Rows)
{
StoryBoard objStoryBoard = new StoryBoard();
objStoryBoard.PageId = Int32.Parse(dtRow["ID"].ToString());
objStoryBoard.PageOwner = dtRow["Owner"].ToString();
objStoryBoard.PageType = dtRow["Asset_Type"].ToString();
objStoryBoard.SOP = dtRow["Standard_Operating_Procedure"].ToString();
objStoryBoard.PageTitle = dtRow["Page_Actual_Name"].ToString();
objStoryBoard.Discipline = dtRow["Discipline"].ToString();
objStoryBoard.ConnectionType = dtRow["Connection_Type"].ToString();
intMasterPageID = Int32.Parse(dtRow["Master_Page_ID"].ToString());
strCAMLQuery = string.Empty;
strCAMLQuery = @"<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>" + intMasterPageID.ToString() + "</Value></Eq></Where>";
strViewFields = @"<FieldRef Name='ID'/><FieldRef Name='Master_Page_ID'/>";
dtTemplate = objCommonDAL.ReadList(siteURL, DWBTEMPLATEPAGESLIST, strCAMLQuery, strViewFields);
if (dtTemplate != null && dtTemplate.Rows.Count > 0)
{
intMasterPageID = Int32.Parse(dtTemplate.Rows[0]["Master_Page_ID"].ToString());
}
strCAMLQuery = @"<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>" + intMasterPageID.ToString() + "</Value></Eq></Where>";
strViewFields = @"<FieldRef Name='ID'/><FieldRef Name='Page_Owner'/><FieldRef Name='Created'/><FieldRef Name='Title'/>";
dtMasterPage = objCommonDAL.ReadList(siteURL, DWBMASTERPAGESLIST, strCAMLQuery, strViewFields);
if (dtMasterPage != null && dtMasterPage.Rows.Count > 0)
{
objStoryBoard.MasterPageName = dtMasterPage.Rows[0]["Title"].ToString();
objStoryBoard.CreatedBy = dtMasterPage.Rows[0]["Page_Owner"].ToString();
objStoryBoard.CreationDate = dtMasterPage.Rows[0]["Created"].ToString();
}
strCAMLQuery = string.Empty;
strCAMLQuery = @"<Where><Eq><FieldRef Name='Page_ID' /><Value Type='Number'>" + objStoryBoard.PageId.ToString() + "</Value></Eq></Where>";
objWellBookChapterDAL.UpdateStoryBoard(siteURL, DWBSTORYBOARD, CHAPTERPAGESMAPPINGAUDITLIST, strCAMLQuery, objStoryBoard.PageId.ToString(), objStoryBoard, actionPerformed, userName);
}
}
if (dtChapterPages != null)
{
dtChapterPages.Dispose();
}
if (dtMasterPage != null)
{
dtMasterPage.Dispose();
}
}
}
}
/// <summary>
/// Updates the Narrative field
/// </summary>
/// <param name="parentSiteURL">SiteURL.</param>
/// <param name="listName">List Name.</param>
/// <param name="auditListName">Audit List Name.</param>
/// <param name="camlQuery">CAML Query.</param>
/// <param name="pageID">Page ID.</param>
/// <param name="narrative">Narrative.</param>
/// <param name="userName">Windows User ID.</param>
public void UpdateNarrative(string parentSiteURL, string listName, string auditListName, string camlQuery, string pageID, string narrative, string userName)
{
objWellBookChapterDAL = new WellBookChapterDAL();
objWellBookChapterDAL.UpdateNarrative(parentSiteURL, listName, auditListName, camlQuery, pageID, narrative, userName);
}
/// <summary>
/// Set ChapterDetails.
/// </summary>
/// <param name="siteURL">Site URL.</param>
/// <param name="listName">List Name.</param>
/// <param name="queryString">CAML Query.</param>
/// <returns>ListEntry object.</returns>
public ListEntry SetChapterDetail(string siteURL, string listName, string CAMLQuery)
{
objWellBookChapterDAL = new WellBookChapterDAL();
return (objWellBookChapterDAL.GetChapterDetails(siteURL, listName, CAMLQuery));
}
/// <summary>
/// Get the Chapter Pages
/// </summary>
/// <param name="siteUrl">The site URL.</param>
/// <param name="listName">List Name.</param>
/// <param name="CAMLQuery">The CAML query.</param>
/// <returns>ListEntry object.</returns>
public ListEntry GetChapterPages(string siteUrl, string listName, string CAMLQuery)
{
objWellBookChapterDAL = new WellBookChapterDAL();
return objWellBookChapterDAL.SetChapterPage(siteUrl, listName, CAMLQuery);
}
/// <summary>
/// Get Pages for the Selected Book
/// </summary>
/// <param name="strParentSiteUrl">Site URL.</param>
/// <param name="listName">List Name.</param>
/// <param name="strCamlQuery">CAML Query.</param>
/// <returns>ListEntry object</returns>
public ListEntry GetBookPages(string siteURL, string listName, string CAMLQuery)
{
ListEntry objListEntry = null;
DataTable dtResultTable = null;
objWellBookChapterDAL = new WellBookChapterDAL();
objCommonDAL = new CommonDAL();
string strcamlQuery = string.Empty;
int intRowId = 0;
objListEntry = objWellBookChapterDAL.SetChapterPage(siteURL, listName, CAMLQuery);
strcamlQuery = @"<Where><Eq><FieldRef Name='ID' />
<Value Type='Counter'>" + Convert.ToString(objListEntry.ChapterDetails.RowID) + "</Value></Eq></Where>";
dtResultTable = objCommonDAL.ReadList(siteURL, DWBCHAPTERLIST,
strcamlQuery);
if (dtResultTable != null && dtResultTable.Rows.Count > 0)
{
int.TryParse(Convert.ToString(dtResultTable.Rows[0]["Book_ID"]), out intRowId);
objListEntry.ChapterDetails.BookID = intRowId;
objListEntry.ChapterDetails.ChapterTitle = Convert.ToString(dtResultTable.Rows[0][TITLECOLUMN]);
}
if (dtResultTable != null)
{
dtResultTable.Dispose();
}
return objListEntry;
}
/// <summary>
/// Updates the Comments for the Selected Page
/// </summary>
/// <param name="siteUrl">Site URL.</param>
/// <param name="listName">List Name.</param>
/// <param name="auditListName">Name of Audit List.</param>
/// <param name="listEntry">ListEntry object.</param>
/// <param name="actionPerformed">ID of the Audit Action</param>
/// <returns>bool</returns>
public bool UpdatePageComments(string siteURL, string listName, string auditListName, ListEntry listEntry, string actionPerformed)
{
objWellBookChapterDAL = new WellBookChapterDAL();
return objWellBookChapterDAL.UpdateComments(siteURL, listName, auditListName, listEntry, actionPerformed);
}
/// <summary>
/// Updates the Pages details in a Well Book.
/// </summary>
/// <param name="siteURL">The site URL.</param>
/// <param name="listEntry">The list entry.</param>
/// <param name="listName">Name of the list.</param>
/// <param name="auditListName">Audit List Name.</param>
/// <param name="userName">User Name.</param>
/// <param name="actionPerformed">Audit Action.</param>
/// <exception cref="">Handled in calling method.</exception>
internal void UpdateBookPage(string siteURL, ListEntry listEntry, string listName, string auditListName, string userName, string actionPerformed)
{
SPList list;
SPListItem objListItem;
DataTable dtlistItem = null;
int intId = 0;
int intRowId = 0;
int intPageSequence = 0;
DataView dvResultView;
SPQuery query = null;
string strCAMLQuery = string.Empty;
try
{
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite site = new SPSite(siteURL))
{
using (SPWeb web = site.OpenWeb())
{
web.AllowUnsafeUpdates = true;
list = web.Lists[listName];
objListItem = list.Items.Add();
if (string.Equals(actionPerformed, AUDIT_ACTION_UPDATION))
{
objListItem = list.GetItemById(listEntry.MasterPage.RowId);
}
objListItem["Page_Name"] = listEntry.MasterPage.Name;
objListItem["Page_Actual_Name"] = listEntry.MasterPage.TemplateTitle;
objListItem["Page_Sequence"] = listEntry.MasterPage.PageSequence;
objListItem["Standard_Operating_Procedure"] = listEntry.MasterPage.SOP;
objListItem["Discipline"] = listEntry.MasterPage.SignOffDiscipline;
objListItem.Update();
int.TryParse((objListItem["ID"].ToString()), out intId);
listEntry.MasterPage.RowId = intId;
/// start
query = new SPQuery();
query.Query = @"<Where><And><Eq><FieldRef Name='Terminate_Status' />
<Value Type='Choice'>No</Value></Eq><Eq><FieldRef Name='Chapter_ID' />
<Value Type='Number'>" + Convert.ToString(objListItem["Chapter_ID"]) + "</Value></Eq></And></Where>";
dtlistItem = list.GetItems(query).GetDataTable();
if (dtlistItem != null && dtlistItem.Rows.Count > 0)
{
dvResultView = dtlistItem.DefaultView;
dvResultView.Sort = "Page_Sequence asc";
for (int intIndex = 0; intIndex < dvResultView.Count; intIndex++)
{
intPageSequence = intPageSequence + 10;
intRowId = (int)dvResultView[intIndex]["ID"];
objListItem = list.GetItemById(intRowId);
objListItem["Page_Sequence"] = intPageSequence;
objListItem.Update();
}
}
/// end
web.AllowUnsafeUpdates = false;
objCommonDAL = new CommonDAL();
objCommonDAL.UpdateListAuditHistory(siteURL, auditListName, listEntry.MasterPage.RowId, userName, actionPerformed);
/// Update the values to StoryBoard list
WellBookChapterDAL objWellBookChapterDAL = new WellBookChapterDAL();
StoryBoard objStoryBoard = new StoryBoard();
objListItem = list.GetItemById(listEntry.MasterPage.RowId);
if (objListItem != null)
{
objStoryBoard.PageId = Int32.Parse(Convert.ToString(objListItem["ID"]));
objStoryBoard.SOP = Convert.ToString(objListItem["Standard_Operating_Procedure"]);
objStoryBoard.PageTitle = Convert.ToString(objListItem["Page_Actual_Name"]);
objStoryBoard.Discipline = Convert.ToString(objListItem["Discipline"]);
strCAMLQuery = string.Empty;
strCAMLQuery = @"<Where><Eq><FieldRef Name='Page_ID' /><Value Type='Number'>" + objStoryBoard.PageId.ToString() + "</Value></Eq></Where>";
objWellBookChapterDAL.UpdateStoryBoard(siteURL, DWBSTORYBOARD, CHAPTERPAGESMAPPINGAUDITLIST, strCAMLQuery, objStoryBoard.PageId.ToString(), objStoryBoard, actionPerformed, userName);
}
}
}
});
}
finally
{
if (dtlistItem != null) dtlistItem.Dispose();
}
}