/// <summary>
/// Updates the story board information of the page into the the sharepoint list
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
protected void BtnSave_Click(object sender, EventArgs e)
{
string strSource = string.Empty;
string strApplicationPage = string.Empty;
string strApplicationTemplate = string.Empty;
try
{
TreeNodeSelection objTreeNodeSelection = null;
objTreeNodeSelection = (TreeNodeSelection)HttpContext.Current.Session[SESSIONWEBPARTPROPERTIES];
if (objTreeNodeSelection != null)
{
PageID = objTreeNodeSelection.PageID;
}
StoryBoard objPageStoryBoard = new StoryBoard();
objPageStoryBoard.PageId = Convert.ToInt32(PageID);
objPageStoryBoard.ApplicationPage = txtApplicationGeneratingPage.Text.Trim();
objPageStoryBoard.ApplicationTemplate = txtApplicationTemplate.Text.Trim();
objPageStoryBoard.CreatedBy = txtCreatedBy.Text.Trim();
objPageStoryBoard.CreationDate = txtCreationDate.Text.Trim();
objPageStoryBoard.Discipline = txtDiscipline.Text.Trim();
objPageStoryBoard.MasterPageName = txtMasterPageName.Text.Trim();
objPageStoryBoard.PageOwner = txtPageOwner.Text.Trim();
objPageStoryBoard.PageTitle = txtPageTitle.Text.Trim();
objPageStoryBoard.PageType = txtPageType.Text.Trim();
objPageStoryBoard.SOP = txtSOP.Text.Trim();
objPageStoryBoard.Source = txtSource.Text.Trim();
UpdateStoryBoard(DWBSTORYBOARD, CHAPTERPAGESMAPPINGAUDITLIST, PageID, objPageStoryBoard, AUDITACTIONSTORYBOARDUPDATED);
}
catch (WebException webEx)
{
CommonUtility.HandleException(strParentSiteURL, webEx);
}
catch (Exception Ex)
{
CommonUtility.HandleException(strParentSiteURL, Ex);
}
}
/// <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">The site URL.</param>
/// <param name="listName">Name of the list.</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="actionPerformed">Audit action.</param>
/// <param name="userName">User Name.</param>
/// <exception cref="">Handled in calling method.</exception>
internal void UpdateStoryBoard(string siteURL, string listName, string auditListName, string camlQuery, string pageID, StoryBoard pageStoryBoard, string actionPerformed, string userName)
{
SPList list;
SPListItem objListItem;
SPQuery spQuery = null;
SPListItemCollection objListItemCollection = null;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite site = new SPSite(siteURL))
{
using (SPWeb web = site.OpenWeb())
{
web.AllowUnsafeUpdates = true;
list = web.Lists[listName];
spQuery = new SPQuery();
spQuery.Query = camlQuery;
objListItemCollection = list.GetItems(spQuery);
if (objListItemCollection.Count > 0)
{
objListItem = objListItemCollection[0];
}
else
{
objListItem = list.Items.Add();
}
if (pageStoryBoard.PageId > 0)
objListItem["Page_ID"] = pageStoryBoard.PageId;
if (!string.IsNullOrEmpty(pageStoryBoard.PageTitle))
objListItem["Page_Title"] = pageStoryBoard.PageTitle;
if (!string.IsNullOrEmpty(pageStoryBoard.ConnectionType))
objListItem["Connection_Type"] = pageStoryBoard.ConnectionType;
if (!string.IsNullOrEmpty(pageStoryBoard.Source))
objListItem["Source"] = pageStoryBoard.Source;
if (!string.IsNullOrEmpty(pageStoryBoard.Discipline))
objListItem["Discipline"] = pageStoryBoard.Discipline;
if (!string.IsNullOrEmpty(pageStoryBoard.MasterPageName))
objListItem["Master_Page"] = pageStoryBoard.MasterPageName;
if (!string.IsNullOrEmpty(pageStoryBoard.ApplicationTemplate))
objListItem["Application_Template"] = pageStoryBoard.ApplicationTemplate;
if (!string.IsNullOrEmpty(pageStoryBoard.ApplicationPage))
objListItem["Application_Page"] = pageStoryBoard.ApplicationPage;
if (!string.IsNullOrEmpty(pageStoryBoard.SOP))
objListItem["SOP"] = pageStoryBoard.SOP;
if (!string.IsNullOrEmpty(pageStoryBoard.CreatedBy))
objListItem["Created_By"] = pageStoryBoard.CreatedBy;
if (!string.IsNullOrEmpty(pageStoryBoard.CreationDate))
objListItem["Creation_Date"] = Convert.ToDateTime(pageStoryBoard.CreationDate).ToString("yyyy-MM-ddTHH:mm:ssZ");
if (!string.IsNullOrEmpty(pageStoryBoard.PageOwner))
objListItem["Page_Owner"] = pageStoryBoard.PageOwner;
if (!string.IsNullOrEmpty(pageStoryBoard.PageType))
objListItem["Page_Type"] = pageStoryBoard.PageType;
objListItem.Update();
web.AllowUnsafeUpdates = false;
if (string.Compare(actionPerformed, AUDIT_ACTION_STORYBOARD_UPDATED, true) == 0)
{
objCommonDAL = new CommonDAL();
objCommonDAL.UpdateListAuditHistory(siteURL, auditListName, Convert.ToInt32(pageID), userName, actionPerformed);
}
}
}
});
}
/// <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 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();
}
}