/// <summary>
/// Activates the List items
/// </summary>
/// <param name="siteURL">The site URL.</param>
/// <param name="listName">Name of the list.</param>
/// <param name="rowID">The row ID.</param>
/// <param name="auditlistName">Name of the auditlist.</param>
/// <param name="updatePageSequence">if set to <c>true</c> [update page sequence].</param>
/// <param name="updateAuditHistory">if set to <c>true</c> [update audit history].</param>
/// <returns>bool</returns>
public bool ActivateListValues(string siteURL, string listName, int rowID, string auditlistName, bool updatePageSequence, bool updateAuditHistory)
{
objCommonDAL = new CommonDAL();
objCommonUtility = new CommonUtility();
objCommonDAL.ListStatusUpdate(siteURL, listName, rowID, NO, updatePageSequence);
if (updateAuditHistory)
{
objCommonDAL.UpdateListAuditHistory(siteURL, auditlistName, rowID, objCommonUtility.GetUserName(), AUDIT_ACTION_ACTIVATE);
}
return true;
}
/// <summary>
/// Updates comments for Well Book Page.
/// </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="listEntry">ListEntry object contains the Comments.</param>
/// <param name="actionPerformed">Audit action.</param>
/// <returns>True/False</returns>
/// <exception cref="">Handled in calling method.</exception>
internal bool UpdateComments(string siteURL, string listName, string auditListName, ListEntry listEntry, string actionPerformed)
{
SPList list;
SPListItem objListItem;
SPFieldLookupValue lookupField;
bool blnUpdateSuccess = false;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite site = new SPSite(siteURL))
{
using (SPWeb web = site.OpenWeb())
{
web.AllowUnsafeUpdates = true;
list = web.Lists[listName];
if (string.Compare(AUDIT_ACTION_COMMENT_ADDED, actionPerformed, true) == 0)
{
if (listEntry != null && listEntry.PageComments != null)
{
objListItem = list.Items.Add();
objListItem["Page_ID"] = Convert.ToInt32(listEntry.PageComments.PageID);
objListItem["UserName"] = listEntry.PageComments.UserName;
objListItem["Comment"] = listEntry.PageComments.Comments;
/// Lookup column
if (!string.IsNullOrEmpty(listEntry.PageComments.DisciplineID))
{
lookupField = new SPFieldLookupValue(listEntry.PageComments.DisciplineID);
objListItem["Discipline"] = lookupField;
}
objListItem["Shared"] = listEntry.PageComments.ShareComments;
objListItem.Update();
objCommonDAL = new CommonDAL();
objCommonDAL.UpdateListAuditHistory(siteURL, auditListName, Int32.Parse(listEntry.PageComments.PageID), listEntry.PageComments.UserName, actionPerformed);
blnUpdateSuccess = true;
}
}
web.AllowUnsafeUpdates = false;
}
}
});
return blnUpdateSuccess;
}
/// <summary>
/// Adds the Pages to the Chapter Directly.
/// </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>
/// <returns>ID of the Chapter Page Created.</returns>
/// <exception cref="">Handled in calling method.</exception>
internal string AddPageToChapter(string siteURL, ListEntry listEntry, string listName, string auditListtname, string username, string actionPerformed)
{
string strPageID = string.Empty;
SPList list;
SPListItem objListItem;
int intRowId = 0;
int intPageSequence = 0;
DataTable dtlistItem = null;
int intMappingRowId = 0;
DataView dtDataView = null;
SPQuery query;
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];
objCommonDAL = new CommonDAL();
for (int i = 0; i < listEntry.ChapterPagesMapping.Count; i++)
{
objListItem = list.Items.Add();
objListItem["Master_Page_ID"] = listEntry.ChapterPagesMapping[i].MasterPageID;
objListItem["Page_Actual_Name"] = listEntry.ChapterPagesMapping[i].PageActualName;
objListItem["Page_Name"] = listEntry.ChapterPagesMapping[i].PageName;
objListItem["Owner"] = listEntry.ChapterPagesMapping[i].PageOwner;
objListItem["Discipline"] = listEntry.ChapterPagesMapping[i].Discipline;
objListItem["Chapter_ID"] = listEntry.ChapterDetails.RowID;
objListItem["Asset_Type"] = listEntry.ChapterPagesMapping[i].AssetType;
if (!string.IsNullOrEmpty(listEntry.ChapterPagesMapping[i].Empty))
objListItem["Empty"] = listEntry.ChapterPagesMapping[i].Empty;
objListItem["Page_Sequence"] = listEntry.ChapterPagesMapping[i].PageSequence;
if (!string.IsNullOrEmpty(listEntry.ChapterPagesMapping[i].SignOffStatus))
{
objListItem["Sign_Off_Status"] = listEntry.ChapterPagesMapping[i].SignOffStatus;
}
objListItem["Connection_Type"] = listEntry.ChapterPagesMapping[i].ConnectionType;
objListItem["Standard_Operating_Procedure"] = listEntry.ChapterPagesMapping[i].StandardOperatingProc;
if (!string.IsNullOrEmpty(listEntry.ChapterPagesMapping[i].PageURL))
{
objListItem["Page_URL"] = listEntry.ChapterPagesMapping[i].PageURL;
}
objListItem.Update();
/// Assing the Item ID to return
strPageID = Convert.ToString(objListItem["ID"]);
int.TryParse(Convert.ToString(objListItem["ID"]), out intRowId);
listEntry.ChapterPagesMapping[i].RowId = intRowId;
strCamlQuery = @"<Where><Eq><FieldRef Name='Chapter_ID' /><Value Type='Number'>" + listEntry.ChapterDetails.RowID + "</Value></Eq></Where>";
query = new SPQuery();
query.Query = strCamlQuery;
query.ViewFields = @"<FieldRef Name='Chapter_ID' /><FieldRef Name='ID' /><FieldRef Name='Page_Sequence' />";
dtlistItem = list.GetItems(query).GetDataTable();
if (dtlistItem != null && dtlistItem.Rows.Count > 0)
{
dtDataView = dtlistItem.DefaultView;
dtDataView.Sort = "Page_Sequence asc";
for (int j = 0; j < dtDataView.Count; j++)
{
intPageSequence = intPageSequence + 10;
intMappingRowId = (int)dtDataView[j]["ID"];
if (intMappingRowId != intRowId)
{
objListItem = list.GetItemById(intMappingRowId);
objListItem["Page_Sequence"] = intPageSequence;
objListItem.Update();
}
}
}
objCommonDAL.UpdateListAuditHistory(siteURL, auditListtname, intRowId, username, actionPerformed);
}
web.AllowUnsafeUpdates = false;
}
}
});
}
finally
{
if (dtlistItem != null) dtlistItem.Dispose();
}
return strPageID;
}
/// <summary>
/// Updates the Page sequence
/// </summary>
/// <param name="parentSiteUrl">Site URL.</param>
/// <param name="listName">List Name.</param>
/// <param name="auditListName">Name of the audit list.</param>
/// <param name="dvUpdateListitems">DataView.</param>
/// <param name="actionPerformed">Audit Action ID.</param>
/// <param name="userName">Name of the user.</param>
public void UpdateChapterSequence(string parentSiteUrl, string listName, string auditListName,
DataView dvUpdateListitems, string actionPerformed, string userName)
{
objCommonDAL = new CommonDAL();
objCommonDAL.UpdateSequence(parentSiteUrl, listName, dvUpdateListitems, "Chapter_Sequence");
if (dvUpdateListitems != null && dvUpdateListitems.Count > 0)
{
for (int rowIndex = 0; rowIndex < dvUpdateListitems.Count; rowIndex++)
{
objCommonDAL.UpdateListAuditHistory(parentSiteUrl, auditListName,
int.Parse(dvUpdateListitems[rowIndex]["ID"].ToString()), userName, actionPerformed);
}
}
if (dvUpdateListitems != null)
dvUpdateListitems.Dispose();
}
/// <summary>
/// Changes the Sign of status and the Chapter Page mapping list.
/// </summary>
/// <param name="siteURL">The site URL.</param>
/// <param name="signOffStatus">The sign off status.</param>
/// <param name="listName">Name of the list.</param>
/// <param name="username">The username.</param>
/// <param name="bookId">The book id.</param>
/// <param name="actionPerformed">The action performed.</param>
public void ChangeSignOffStatus(string siteURL, string signOffStatus, string listName, string username, string bookId, string actionPerformed)
{
objWellBookDAL = new WellBookDAL();
objCommonDAL = new CommonDAL();
objCommonBLL = new CommonBLL();
StringBuilder strChapterPageId = new StringBuilder();
Dictionary<string, string> listItemCollection =
new Dictionary<string, string>();
listItemCollection.Add("Sign_Off_Status", signOffStatus);
string strCAMLQuery = "<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>" + bookId + "</Value></Eq></Where>";
WellBookDAL.UpdateListItemCollectionValues(siteURL, listName,
strCAMLQuery, listItemCollection);
int intBookId = 0;
if (!string.IsNullOrEmpty(bookId))
{
intBookId = int.Parse(bookId);
}
objCommonDAL.UpdateListAuditHistory(siteURL, DWBWELLBOOKAUDITLIST, intBookId, username, actionPerformed);
#region Code Commented as per confirmation of UAT Feedback
/// Update Signoff Status for all pages in Book
//dtResult = GetPagesForBook(siteURL, bookId, "No");
//if (dtResult != null && dtResult.Rows.Count > 0)
//{
// for (int intRowIndex = 0; intRowIndex < dtResult.Rows.Count; intRowIndex++)
// {
// strChapterPageId.Append(Convert.ToString(dtResult.Rows[intRowIndex][IDCOLUMN]));
// strChapterPageId.Append(";");
// }
// strCAMLQuery = objCommonBLL.CreateCamlQueryWithoutWhere(strChapterPageId.ToString(), IDCOLUMN, IDCOLUMNTYPE);
// listItemCollection.Clear();
// listItemCollection.Add("Sign_Off_Status", signOffStatus);
// WellBookDAL.UpdateListItemCollectionValues(siteURL, chapterpageList, strCAMLQuery, listItemCollection);
//}
//if (dtResult != null)
//{
// dtResult.Dispose();
//}
#endregion Code Commented as per UAT Feedback
}
/// <summary>
/// Updates the Sign of Status
/// </summary>
/// <param name="siteUrl">Site URL.</param>
/// <param name="listName">List Name.</param>
/// <param name="signOffStatus">Yes/No.</param>
/// <param name="pageId">Page ID.</param>
/// <param name="actionperformed">ID of Audit Action.</param>
public void UpdateWellBookPageSignOffStatus(string siteURL, string listName, string signOffStatus, int pageId, string actionPerformed)
{
objWellBookDAL = new WellBookDAL();
Dictionary<string, string> listItemCollection =
new Dictionary<string, string>();
listItemCollection.Add("Sign_Off_Status", signOffStatus);
string strCAMLQuery = "<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>" + pageId + "</Value></Eq></Where>";
WellBookDAL.UpdateListItemCollectionValues(siteURL, listName, strCAMLQuery, listItemCollection);
objCommonDAL = new CommonDAL();
Shell.SharePoint.DREAM.Utilities.CommonUtility objCommonUtility = new Shell.SharePoint.DREAM.Utilities.CommonUtility();
string strUserName = objCommonUtility.GetUserName();
objCommonDAL.UpdateListAuditHistory(siteURL, CHAPTERPAGESMAPPINGAUDITLIST, pageId, strUserName, actionPerformed);
}
/// <summary>
/// Updates the list entry for Add/Edit template.
/// </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 class.</exception>
internal void UpdateListEntry(string siteUrl, ListEntry listEntry, string listName, string auditListName, string userName, string actionPerformed)
{
SPList list;
SPQuery query;
SPListItem objListItem;
SPListItemCollection objListCollection;
SPFieldLookupValue lookupField;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite site = new SPSite(siteUrl))
{
using (SPWeb web = site.OpenWeb())
{
web.AllowUnsafeUpdates = true;
list = web.Lists[listName];
query = new SPQuery();
objListItem = list.Items.Add();
if (string.Equals(actionPerformed, AUDIT_ACTION_UPDATION))
{
query.Query = @"<Where><Eq><FieldRef Name='ID' /><Value Type='Number'>" +
listEntry.TemplateDetails.RowId + "</Value></Eq></Where>";
objListCollection = list.GetItems(query);
foreach (SPListItem objList in objListCollection)
{
objListItem = objList;
}
}
/// Default Title column is renamed as Template_Name. Internal Name remains same as "Title"
objListItem["Title"] = listEntry.TemplateDetails.Title;
lookupField = new SPFieldLookupValue(listEntry.TemplateDetails.AssetID);
/// Asset_Type
objListItem["Asset_Type"] = lookupField;
/// Terminate_Status
objListItem["Terminate_Status"] = listEntry.TemplateDetails.Terminated;
objListItem.Update();
web.AllowUnsafeUpdates = false;
objCommonDAL = new CommonDAL();
objCommonDAL.UpdateListAuditHistory(siteUrl,auditListName, Int32.Parse(objListItem["ID"].ToString()), userName, actionPerformed);
}
}
});
}
/// <summary>
/// Updates the Narrative for Book Page.
/// </summary>
/// <param name="parentSiteUrl">Site URL.</param>
/// <param name="listName">List Name.</param>
/// <param name="auditListName"></param>
/// <param name="camlQuery">CAML Query.</param>
/// <param name="pageID">Page ID.</param>
/// <param name="narrative">Narrative.</param>
/// <param name="userName">User Name.</param>
/// <exception cref="">Handled in calling method.</exception>
internal void UpdateNarrative(string siteURL, string listName, string auditListName, string camlQuery, string pageID, string narrative, string userName)
{
SPList list;
SPQuery query;
SPListItemCollection objListItems;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite site = new SPSite(siteURL))
{
using (SPWeb web = site.OpenWeb())
{
web.AllowUnsafeUpdates = true;
list = web.Lists[listName];
query = new SPQuery();
query.Query = camlQuery;
objListItems = list.GetItems(query);
if (objListItems.Count > 1)
{
foreach (SPListItem objListItem in objListItems)
{
objListItem["Narrative"] = narrative;
objListItem["Page_ID"] = Convert.ToInt32(pageID);
objListItem.Update();
}
}
else
{
SPListItem objListItem = list.Items.Add();
objListItem["Narrative"] = narrative;
objListItem["Page_ID"] = Convert.ToInt32(pageID);
objListItem.Update();
}
objCommonDAL = new CommonDAL();
objCommonDAL.UpdateListAuditHistory(siteURL, auditListName, Convert.ToInt32(pageID), userName, "9");
web.AllowUnsafeUpdates = false;
}
}
});
}
/// Updating the Discipline column is added.
/// discipline parameter is added for the same.
/// <summary>
/// Updates the Page Owner details.
/// </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 UpdatePageOwner(string siteURL, ListEntry listEntry, string listName, string auditListName, string userName, string actionPerformed,string discipline)
{
SPList list;
SPQuery query;
SPListItem objListItem;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite site = new SPSite(siteURL))
{
using (SPWeb web = site.OpenWeb())
{
web.AllowUnsafeUpdates = true;
list = web.Lists[listName];
query = new SPQuery();
for (int intIndex = 0; intIndex < listEntry.ChapterPagesMapping.Count; intIndex++)
{
objListItem = list.GetItemById(listEntry.ChapterPagesMapping[intIndex].RowId);
objListItem["Owner"] = userName;
#region DREAM 4.0 - eWB 2.0 - Change discipline when page owner changed
objListItem["Discipline"] = discipline;
#endregion
objListItem.Update();
}
web.AllowUnsafeUpdates = false;
objCommonDAL = new CommonDAL();
for (int intIndex = 0; intIndex < listEntry.ChapterPagesMapping.Count; intIndex++)
{
/// userName contains the value of new page owner selected.
/// Instead of new page owner, current login user name should be used for audit history.
/// Fix is applied.
userName = string.Empty;
CommonUtility objCommonUtility = new CommonUtility();
userName = objCommonUtility.GetUserName();
objCommonDAL.UpdateListAuditHistory(siteURL, auditListName, listEntry.ChapterPagesMapping[intIndex].RowId, userName, actionPerformed);
}
}
}
});
}
/// <summary>
/// Updates the list entry.
/// </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 UpdateListEntry(string siteURL, ListEntry listEntry, string listName, string auditListName, string userName, string actionPerformed)
{
SPList list;
SPQuery query;
SPListItem objListItem;
SPFieldLookupValue lookupField;
int intRowId = 0;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite site = new SPSite(siteURL))
{
using (SPWeb web = site.OpenWeb())
{
web.AllowUnsafeUpdates = true;
list = web.Lists[listName];
query = new SPQuery();
objListItem = list.Items.Add();
if (string.Compare(actionPerformed, AUDIT_ACTION_BOOK_TITLE_UPDATED, true) == 0 || string.Compare(actionPerformed, AUDIT_ACTION_UPDATION, true) == 0)
{
objListItem = list.GetItemById(listEntry.WellBookDetails.RowId);
}
objListItem["Title"] = listEntry.WellBookDetails.Title;
if (!string.IsNullOrEmpty(listEntry.WellBookDetails.TeamID))
{
lookupField = new SPFieldLookupValue(listEntry.WellBookDetails.
TeamID);
objListItem["Team"] = lookupField;
int.TryParse(listEntry.WellBookDetails.TeamID, out intRowId);
objListItem["Team_ID"] = intRowId;
}
if (!string.IsNullOrEmpty(listEntry.WellBookDetails.BookOwnerID))
{
lookupField = new SPFieldLookupValue(listEntry.WellBookDetails.BookOwnerID);
objListItem["Owner"] = lookupField;
}
objListItem.Update();
listEntry.WellBookDetails.RowId = int.Parse(objListItem["ID"].ToString());
web.AllowUnsafeUpdates = false;
objCommonDAL = new CommonDAL();
CommonUtility objCommonUtility = new CommonUtility();
userName = objCommonUtility.GetUserName();
objCommonDAL.UpdateListAuditHistory(siteURL, auditListName, listEntry.WellBookDetails.RowId, userName, 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();
}
}
/// <summary>
/// Updates the Mapping between master page and template in DWB Template Pages Mapping list
/// </summary>
/// <param name="siteURL">URL of the Site where list available.</param>
/// <param name="listEntry">ListEntry object.</param>
/// <param name="listName">Template List Name.(DWB Template Pages Mapping)</param>
/// <param name="auditListName">Template Audit List Name.(DWB Template Pages Mapping Audit Trial)</param>
/// <param name="userName">User Name.</param>
/// <param name="actionPerformed">Audit Action.</param>
/// <param name="selectedTemplateID">TemplateID.</param>
/// <exception cref="">Handled in calling class.</exception>
internal void UpdateTemplatePageMapping(string siteUrl, ListEntry listEntry, string listName, string auditListName, string userName, string actionPerformed, string selectedTemplateID)
{
/// Query the Template Mapping List for the selected Template ID
/// If no records exist then insert all the new records
/// If records for the particular Template exists, update the existing records and insert if any new pages are added
int intNoOfMasterPages = 0;
DataTable dtListItemCollection = null;
DataTable dtresult = null;
try
{
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite site = new SPSite(siteUrl))
{
using (SPWeb web = site.OpenWeb())
{
web.AllowUnsafeUpdates = true;
SPList list = web.Lists[listName];
/// Insert the pages entry for the new template
if (string.Compare(actionPerformed, AUDIT_ACTION_CREATION, true) == 0)
{
if (listEntry != null && listEntry.TemplateConfiguration != null)
{
foreach (TemplateConfiguration objTemplateConfiguration in listEntry.TemplateConfiguration)
{
SPListItem objListItem = list.Items.Add();
objListItem["Page_Title_Template"] = objTemplateConfiguration.TemplateTitle;
objListItem["Page_Sequence"] = objTemplateConfiguration.PageSequence;
objListItem["Title"] = objTemplateConfiguration.MasterPageTitle;
objListItem["Master_Page_ID"] = objTemplateConfiguration.LinkedMasterPageId;
objListItem["Master_Page_Name"] = objTemplateConfiguration.MasterPageTitle;
objListItem["Asset_Type"] = objTemplateConfiguration.AssetType;
objListItem["Discipline"] = objTemplateConfiguration.Discipline;
objListItem["Connection_Type"] = objTemplateConfiguration.ConnectionType;
objListItem["Page_Owner"] = objTemplateConfiguration.PageOwner;
if (!string.IsNullOrEmpty(objTemplateConfiguration.PageURL))
{
objListItem["Page_URL"] = objTemplateConfiguration.PageURL;
}
objListItem["Standard_Operating_Procedure"] = objTemplateConfiguration.StandardOperatingProcedure;
objListItem["Template_ID"] = objTemplateConfiguration.TemplateID;
objListItem.Update();
intNoOfMasterPages++;
objCommonDAL = new CommonDAL();
objCommonDAL.UpdateListAuditHistory(siteUrl, auditListName, Convert.ToInt32(objListItem["ID"]),
userName, actionPerformed);
}
/// Update the Has_MasterPage column in DWB Templates list if no of master pages in a template >=1
UpdateHasMasterPageColumn(siteUrl, TEMPLATELIST, selectedTemplateID, intNoOfMasterPages);
}
}
else if (string.Compare(actionPerformed, AUDIT_ACTION_UPDATION, true) == 0)/// UPdate the pages details for the template
{
SPQuery query = new SPQuery();
query.Query = @"<OrderBy><FieldRef Name='Master_Page_ID'/></OrderBy><Where><Eq><FieldRef Name='Template_ID' /><Value Type='Number'>" +
selectedTemplateID + "</Value></Eq></Where>";
SPListItemCollection objListItemCollection = list.GetItems(query);
List<string> itemTobeAddedOrDeleted = new List<string>();
List<string> itemToAdded = new List<string>();
bool blnMasterPageFound = false;
/// If the entry in List Box is not in SPListItemCollection, add it
/// If the entry in List Box is in SPListItemCollection, update it
/// If the entry is not in ListBox but present in SPListItemCollection delete it
if (objListItemCollection != null)
{
string strMasterPageID = string.Empty;
foreach (SPListItem item in objListItemCollection)
{
blnMasterPageFound = false;
strMasterPageID = string.Empty;
strMasterPageID = item["ID"].ToString();
if (listEntry != null)
{
if (listEntry.TemplateConfiguration != null && listEntry.TemplateConfiguration.Count > 0)
{
foreach (TemplateConfiguration objTemplateConfiguration in listEntry.TemplateConfiguration)
{
if (string.Compare(strMasterPageID, objTemplateConfiguration.LinkedMasterPageId) == 0)
{
blnMasterPageFound = true;
break;
}
}
}
if (!blnMasterPageFound && !itemTobeAddedOrDeleted.Contains(item["ID"].ToString()))
{
itemTobeAddedOrDeleted.Add(item["ID"].ToString());
}
}
}
}
for (int index = 0; index < itemTobeAddedOrDeleted.Count; index++)
{
list.Items.DeleteItemById(Int32.Parse(itemTobeAddedOrDeleted[index]));
}
objListItemCollection = list.GetItems(query);
if (objListItemCollection != null)
{
dtListItemCollection = objListItemCollection.GetDataTable();
}
if (listEntry != null && listEntry.TemplateConfiguration != null)
{
SPListItem objListItem = null;
string[] splitter = { "New" };
string strRowID = string.Empty;
string strMasterPageID = string.Empty;
string[] strSplitted = null;
DataRow[] dtRow = null;
string strCAMLQuery = string.Empty;
string strfieldsToView = string.Empty;
foreach (TemplateConfiguration objTemplateConfiguration in listEntry.TemplateConfiguration)
{
objListItem = list.Items.Add();
strRowID = string.Empty;
strMasterPageID = string.Empty;
/// Check the LinkedMasterPageId contains "New" string
/// If contains split the string and assign the value at index 1
/// Else the assign the LinkedMasterPageId value to
if (objTemplateConfiguration.LinkedMasterPageId.IndexOf("New") != -1)
{
strSplitted = null;
strSplitted = objTemplateConfiguration.LinkedMasterPageId.Split(splitter, StringSplitOptions.None);
if (strSplitted != null && strSplitted.Length >= 2)
{
strMasterPageID = strSplitted[1];
}
}
else
{
strRowID = objTemplateConfiguration.LinkedMasterPageId;
strMasterPageID = objTemplateConfiguration.LinkedMasterPageId;
}
dtRow = null;
if (dtListItemCollection != null && !string.IsNullOrEmpty(strRowID))
{
dtRow = dtListItemCollection.Select("ID = " + strRowID);
}
if (dtRow != null && dtRow.Length > 0)
{
objListItem = list.Items.GetItemById(Convert.ToInt32(dtRow[0]["ID"]));
objListItem.Update();
intNoOfMasterPages++;
objCommonDAL = new CommonDAL();
objCommonDAL.UpdateListAuditHistory(siteUrl, auditListName, Convert.ToInt32(objListItem["ID"]),
userName, actionPerformed);
}
else
{
strCAMLQuery = string.Empty;
strCAMLQuery = @"<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>" + strMasterPageID + "</Value></Eq></Where>";
strfieldsToView = string.Empty;
/// Title column is renamed to MasterPageName - internal name remains as Title
strfieldsToView = "<FieldRef Name='Title' /><FieldRef Name='Title_Template' /><FieldRef Name='Page_Owner' /><FieldRef Name='Sign_Off_Discipline' /><FieldRef Name='Connection_Type' /><FieldRef Name='ID' /><FieldRef Name='Page_Sequence' /><FieldRef Name='Asset_Type' /><FieldRef Name='Page_URL' /><FieldRef Name='Standard_Operating_Procedure' /><FieldRef Name='Page_Sequence' /><FieldRef Name='Page_Sequence' />";
objCommonDAL = new CommonDAL();
dtresult = objCommonDAL.ReadList(siteUrl, MASTERPAGELIST, strCAMLQuery, strfieldsToView);
if (dtresult != null && dtresult.Rows.Count > 0)
{
foreach (DataRow objdataRow in dtresult.Rows)
{
objListItem["Page_Title_Template"] = objdataRow["Title_Template"].ToString();
objListItem["Page_Sequence"] = Int32.Parse(objdataRow["Page_Sequence"].ToString());
objListItem["Title"] = objdataRow["Title_Template"].ToString();
objListItem["Master_Page_ID"] = Int32.Parse(objdataRow["ID"].ToString());
objListItem["Master_Page_Name"] = objdataRow["Title"].ToString();
objListItem["Asset_Type"] = objdataRow["Asset_Type"].ToString();
objListItem["Discipline"] = objdataRow["Sign_Off_Discipline"].ToString();
objListItem["Connection_Type"] = objdataRow["Connection_Type"].ToString();
objListItem["Page_Owner"] = objdataRow["Page_Owner"].ToString();
if (!string.IsNullOrEmpty(objdataRow["Page_URL"].ToString()))
{
objListItem["Page_URL"] = objdataRow["Page_URL"].ToString();
}
objListItem["Standard_Operating_Procedure"] = objdataRow["Standard_Operating_Procedure"].ToString();
objListItem["Template_ID"] = selectedTemplateID;
objListItem.Update();
intNoOfMasterPages++;
objCommonDAL = new CommonDAL();
objCommonDAL.UpdateListAuditHistory(siteUrl, auditListName, Convert.ToInt32(objListItem["ID"]),
userName, actionPerformed);
}
}
}
}
UpdateHasMasterPageColumn(siteUrl, TEMPLATELIST, selectedTemplateID, intNoOfMasterPages);
}
}
web.AllowUnsafeUpdates = false;
}
}
});
}
finally
{
if (dtListItemCollection != null)
dtListItemCollection.Dispose();
if (dtresult != null)
dtresult.Dispose();
}
}
/// <summary>
/// Updates the Templates column in DWB Master Page list
/// </summary>
/// <param name="siteUrl">Site URL.</param>
/// <param name="listEntry">ListEntry object.</param>
/// <param name="listName">List Name(DWB Master Page).</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 class.</exception>
internal void UpdateTemplateIDinMasterPageList(string siteUrl, ListEntry listEntry, string listName, string auditListName, string userName, string actionPerformed)
{
DataTable dtAddMasterPages = null;
try
{
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();
string strTemplate_IDs = string.Empty;
string strTempIDs = string.Empty;
string strTemplateIDAdded = string.Empty;
if (listEntry != null)
{
/// Filter ListItems by AssetType and Terminated Status
query.Query = @"<Where><And><Eq><FieldRef Name='Asset_Type' /><Value Type='LookUp'>" + listEntry.TemplateDetails.AssetType + "</Value></Eq><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>No</Value></Eq></And></Where>";
string strSelectedTemplateID = listEntry.TemplateDetails.RowId.ToString();
SPListItemCollection objListItemCollection = list.GetItems(query);
/// LinkedMasterPageId property holds the item ID of the Template Page Mapping list or ID of the Master Page in Master Pages List prefixed with "New";
/// Get the MasterPages collection from DWB Template Master Page List for the selected TemplateID
/// Loop through each object in the collection and find the Master Page ID [objListItem["ID"].ToString()] is equal to
/// LinkedMasterPageID [dtRow["Master_Page_ID"].
/// If Equals, the master page is mapped to template, check the Template_ID column contains the selected TemplateID or not
/// If doesn't contains, append else do nothing
/// If not Equals, the master page is not mapped to the selected template, remove the TemplateID from the Template_ID column
SPList mappingList = web.Lists[TEMPLATEPAGESMAPPINGLIST];
SPQuery mappingQuery = new SPQuery();
mappingQuery.Query = @"<OrderBy><FieldRef Name='Page_Sequence' /></OrderBy><Where><Eq><FieldRef Name='Template_ID' /><Value Type='Number'>" + strSelectedTemplateID + "</Value></Eq></Where>";
mappingQuery.ViewFields = @"<FieldRef Name='Page_Sequence' /><FieldRef Name='ID' /><FieldRef Name='Master_Page_Name' /><FieldRef Name='Master_Page_ID' />";
SPListItemCollection objAddedMasterPages = mappingList.GetItems(mappingQuery);
if (objAddedMasterPages != null)
{
dtAddMasterPages = objAddedMasterPages.GetDataTable();
}
DataRow[] dtRow = null;
int index = -1;
foreach (SPListItem objListItem in objListItemCollection)
{
strTemplate_IDs = string.Empty;
strTempIDs = string.Empty;
if (objListItem["Template_ID"] != null)
{
strTemplate_IDs = objListItem["Template_ID"].ToString();
}
dtRow = null;
if (dtAddMasterPages != null)
{
dtRow = dtAddMasterPages.Select("Master_Page_ID = " + objListItem["ID"].ToString());
}
if (dtRow != null && dtRow.Length > 0)
{
/// The Master Pages exist in Mapping List for the selected Template
/// Check whether the TemplateID present in Template_ID column or not
/// If not exist, append else do nothing
strTempIDs = ";" + strTemplate_IDs;
index = strTempIDs.IndexOf(";" + strSelectedTemplateID + ";");
if (index == -1)
{
strTemplate_IDs = strTemplate_IDs + strSelectedTemplateID + ";";
}
}
else
{
/// The Master Page is not mapped to selected Template in Mapping List
/// Check whether the TemplateID present in Template_ID column or not
/// If exists remove and update the item else do nothing
strTempIDs = ";" + strTemplate_IDs;
index = strTempIDs.IndexOf(";" + strSelectedTemplateID + ";");
if (index != -1)
{
strTemplate_IDs = strTemplate_IDs.Remove(index, strSelectedTemplateID.Length + 1);
}
}
objListItem["Template_ID"] = strTemplate_IDs;
objListItem.Update();
objCommonDAL = new CommonDAL();
objCommonDAL.UpdateListAuditHistory(siteUrl, auditListName, Convert.ToInt32(objListItem["ID"]),
userName, actionPerformed);
}
web.AllowUnsafeUpdates = false;
}
}// Ends using SPWeb
}// Ends using SPSite
}); // Ends using RunWithElevatedPrivileges
}
finally
{
if (dtAddMasterPages != null)
dtAddMasterPages.Dispose();
}
}
/// <summary>
/// Updates the details of the Master Page whiled edited
/// Called from MasterPage.ascx
/// </summary>
/// <param name="siteUrl">Site URL.</param>
/// <param name="listName">List Name.</param>
/// <param name="auditListName">Audit List Name.</param>
/// <param name="objListEntry">List Entry object.</param>
/// <param name="actionPerformed">Audit Action.</param>
/// <param name="userName">User Name.</param>
/// <returns>returns the TemplateID associated with the master page.</returns>
/// <exception cref="">Handled in calling method.</exception>
internal int UpdateMasterPageDetail(string siteUrl, string listName, string auditListName, ListEntry objListEntry, string actionPerformed, string userName)
{
int intTemplateID = 0;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite site = new SPSite(siteUrl))
{
using (SPWeb web = site.OpenWeb())
{
web.AllowUnsafeUpdates = true;
SPList list = web.Lists[listName];
if (objListEntry != null && objListEntry.MasterPage != null)
{
SPListItem listItem = list.GetItemById(objListEntry.MasterPage.RowId);
if (listItem != null)
{
listItem["Discipline"] = objListEntry.MasterPage.SignOffDiscipline;//Discipline
listItem["Standard_Operating_Procedure"] = objListEntry.MasterPage.SOP;//Standard_Operating_Procedure
listItem["Page_Title_Template"] = objListEntry.MasterPage.TemplateTitle;//Page_Title_Template
listItem["Master_Page_Name"] = objListEntry.MasterPage.Name;//Master_Page_Name
listItem.Update();
intTemplateID = Convert.ToInt32(listItem["Template_ID"]);
}
web.AllowUnsafeUpdates = false;
objCommonDAL = new CommonDAL();
objCommonDAL.UpdateListAuditHistory(siteUrl, auditListName, objListEntry.MasterPage.RowId,
userName, actionPerformed);
}
}
}
});
return intTemplateID;
}
/// <summary>
/// Updates the list entry.
/// </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>
/// <returns>ID of the Chapter Created/Updated.</returns>
/// <exception cref="">Handled in calling method.</exception>
internal string UpdateListEntry(string siteURL, ListEntry listEntry, string listName, string auditListName, string userName, string actionPerformed)
{
SPList list;
SPQuery query;
SPListItem objListItem;
SPListItemCollection objListItemCollection;
SPFieldLookupValue lookupField;
int intPageSequence = 10;
int intListItemId = 0;
string strListGuid = string.Empty;
StringBuilder sbMethodBuilder = new StringBuilder();
string strChapterID = string.Empty;
string strBatch = string.Empty;
string strBatchFormat = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" +
"<ows:Batch OnError=\"Return\">{0}</ows:Batch>";
string strMethodFormat = "<Method ID=\"{0}\">" +
"<SetList>{1}</SetList>" +
"<SetVar Name=\"Cmd\">Save</SetVar>" +
"<SetVar Name=\"ID\">{2}</SetVar>" +
"<SetVar Name=\"urn:schemas-microsoft-com:office:office#Chapter_Sequence\">{3}</SetVar>" +
"</Method>";
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite site = new SPSite(siteURL))
{
using (SPWeb web = site.OpenWeb())
{
web.AllowUnsafeUpdates = true;
list = web.Lists[listName];
query = new SPQuery();
strListGuid = list.ID.ToString();
objListItem = list.Items.Add();
if (string.Equals(actionPerformed, AUDIT_ACTION_UPDATION))
{
objListItem = list.GetItemById(listEntry.ChapterDetails.RowID);
}
objListItem["Title"] = listEntry.ChapterDetails.ChapterTitle;
objListItem["Asset_Value"] = listEntry.ChapterDetails.AssetValue;
objListItem["Actual_Asset_Value"] = listEntry.ChapterDetails.ActualAssetValue;
objListItem["Country"] = listEntry.ChapterDetails.Country;
objListItem["Criteria"] = listEntry.ChapterDetails.Criteria;
objListItem["Column_Name"] = listEntry.ChapterDetails.ColumnName;
objListItem["Book_ID"] = listEntry.ChapterDetails.BookID;
if (!string.IsNullOrEmpty(listEntry.ChapterDetails.AssetType))
{
lookupField = new SPFieldLookupValue(Convert.ToInt32(listEntry.ChapterDetails.AssetType), "");
objListItem["Asset_Type"] = lookupField;
}
objListItem["Chapter_Description"] = listEntry.ChapterDetails.ChapterDescription;
objListItem["Template_ID"] = listEntry.ChapterDetails.TemplateID;
if (!string.IsNullOrEmpty(listEntry.ChapterDetails.Terminated))
{
objListItem["Terminate_Status"] = listEntry.ChapterDetails.Terminated;
}
objListItem.Update();
strChapterID = objListItem["ID"].ToString();
listEntry.ChapterDetails.RowID = int.Parse(objListItem["ID"].ToString());
string strNoOfActiveChapters = string.Empty;
if (string.Equals(actionPerformed, AUDIT_ACTION_CREATION))
{
query.Query = @"<OrderBy><FieldRef Name='Chapter_Sequence' /></OrderBy><Where><And><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>No</Value></Eq><Eq><FieldRef Name='Book_ID' /><Value Type='Number'>" + listEntry.ChapterDetails.BookID.ToString() + "</Value></Eq></And></Where>";
objListItemCollection = list.GetItems(query);
if (objListItemCollection != null && objListItemCollection.Count > 0)
{
strNoOfActiveChapters = objListItemCollection.Count.ToString();
for (int intIndex = 0; intIndex < objListItemCollection.Count; intIndex++)
{
int.TryParse(Convert.ToString(objListItemCollection[intIndex]["ID"]), out intListItemId);
if (intListItemId != listEntry.ChapterDetails.RowID)
{
intPageSequence = intPageSequence + 10;
sbMethodBuilder.AppendFormat(strMethodFormat, intListItemId, strListGuid, intListItemId, intPageSequence);
}
else
{
sbMethodBuilder.AppendFormat(strMethodFormat, intListItemId, strListGuid, intListItemId, 10);
}
}
strBatch = string.Format(strBatchFormat, sbMethodBuilder.ToString());
web.ProcessBatchData(strBatch);
}
objCommonDAL = new CommonDAL();
/// Update the DWB Books list with no of active chapters
objCommonDAL.UpdateNoOfActiveChapters(siteURL, DWBBOOKLIST, listEntry.ChapterDetails.BookID.ToString(), strNoOfActiveChapters.ToString());
}
web.AllowUnsafeUpdates = false;
objCommonDAL = new CommonDAL();
objCommonDAL.UpdateListAuditHistory(siteURL, auditListName, listEntry.ChapterDetails.RowID, userName, actionPerformed);
}
}
});
return strChapterID;
}
/// <summary>
/// Updates the list entry.
/// </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>
/// <returns>ID of the Chapter Page Created.</returns>
/// <exception cref="">Handled in calling method.</exception>
internal string AddChapterMasterPageMapping(string siteURL, ListEntry listEntry, string listName, string auditListtname, string username, string actionPerformed)
{
SPList list;
SPListItem objListItem;
int intRowId = 0;
StringBuilder strTemplatePageMappingRowId = new StringBuilder();
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPSite site = new SPSite(siteURL))
{
using (SPWeb web = site.OpenWeb())
{
web.AllowUnsafeUpdates = true;
list = web.Lists[listName];
objCommonDAL = new CommonDAL();
string strCAMLQuery = string.Empty;
string strViewFields = string.Empty;
string strBookTeamID = string.Empty;
string strPageOwner = string.Empty;
string strUserID = string.Empty;
DataTable dtTeamStaff = null;
DataTable dtBook = null;
DataTable dtUser = null;
if (listEntry != null)
{
/// Get the Team of the book
if (listEntry.ChapterDetails != null)
{
strCAMLQuery = @"<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>" + listEntry.ChapterDetails.BookID.ToString() + "</Value></Eq></Where>";
strViewFields =@"<FieldRef Name='ID' /><FieldRef Name='Team' /><FieldRef Name='Team_ID' />";
dtBook = objCommonDAL.ReadList(siteURL, DWBBOOKLIST, strCAMLQuery, strViewFields);
if (dtBook != null && dtBook.Rows.Count > 0)
{
strBookTeamID = Convert.ToString(dtBook.Rows[0]["Team_ID"]);
}
}
for (int i = 0; i < listEntry.ChapterPagesMapping.Count; i++)
{
strPageOwner = string.Empty;
objListItem = list.Items.Add();
objListItem["Master_Page_ID"] = listEntry.ChapterPagesMapping[i].MasterPageID;
objListItem["Page_Actual_Name"] = listEntry.ChapterPagesMapping[i].PageActualName;
objListItem["Page_Name"] = listEntry.ChapterPagesMapping[i].PageName;
objListItem["Discipline"] = listEntry.ChapterPagesMapping[i].Discipline;
objListItem["Chapter_ID"] = listEntry.ChapterDetails.RowID;
objListItem["Asset_Type"] = listEntry.ChapterPagesMapping[i].AssetType;
if (!string.IsNullOrEmpty(listEntry.ChapterPagesMapping[i].Empty))
objListItem["Empty"] = listEntry.ChapterPagesMapping[i].Empty;
objListItem["Page_Sequence"] = listEntry.ChapterPagesMapping[i].PageSequence;
if (!string.IsNullOrEmpty(listEntry.ChapterPagesMapping[i].SignOffStatus))
{
objListItem["Sign_Off_Status"] = listEntry.ChapterPagesMapping[i].SignOffStatus;
}
objListItem["Standard_Operating_Procedure"] = listEntry.ChapterPagesMapping[i].StandardOperatingProc;
objListItem["Connection_Type"] = listEntry.ChapterPagesMapping[i].ConnectionType;
if (!string.IsNullOrEmpty(listEntry.ChapterPagesMapping[i].PageURL))
{
objListItem["Page_URL"] = listEntry.ChapterPagesMapping[i].PageURL;
}
strCAMLQuery = string.Empty;
strViewFields = string.Empty;
/// Retrieve the User with Rank =1 for the selected Team(Book) and Discipline(MasterPage) , "DWB Team Staff" and assign to "Owner" column
if (!string.IsNullOrEmpty(strBookTeamID) && !string.IsNullOrEmpty(listEntry.ChapterPagesMapping[i].Discipline))
{
strCAMLQuery = @"<OrderBy><FieldRef Name='User_Rank' Ascending='TRUE' /></OrderBy><Where><And><And><Eq><FieldRef Name='Team_ID' /><Value Type='Number'>" + strBookTeamID + "</Value></Eq><Eq><FieldRef Name='Discipline' /><Value Type='Text'>" + listEntry.ChapterPagesMapping[i].Discipline + "</Value></Eq></And><Eq><FieldRef Name='User_Rank' /><Value Type='Number'>" + "1" + "</Value></Eq></And></Where>";
strViewFields = @"<FieldRef Name='ID' /><FieldRef Name='Team_ID' /><FieldRef Name='Discipline' /><FieldRef Name='User_Rank' /><FieldRef Name='User_ID' /><FieldRef Name='Title' />";
dtTeamStaff = objCommonDAL.ReadList(siteURL, DWBTEAMSTAFFLIST, strCAMLQuery, strViewFields);
}
if (dtTeamStaff != null && dtTeamStaff.Rows.Count > 0)
{
strUserID = Convert.ToString(dtTeamStaff.Rows[0]["User_ID"]);
strCAMLQuery = @"<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>" + strUserID + "</Value></Eq></Where>";
strViewFields = @"<FieldRef Name='ID' /><FieldRef Name='Windows_User_ID' />";
dtUser = objCommonDAL.ReadList(siteURL, DWBUSERLIST, strCAMLQuery, strViewFields);
if (dtUser != null && dtUser.Rows.Count > 0)
{
strPageOwner = dtUser.Rows[0]["Windows_User_ID"].ToString();
}
}
if (!string.IsNullOrEmpty(strPageOwner))
{
objListItem["Owner"] = strPageOwner;
}
else /// If no user with Rank =1 or no user for the selected discipline available, assign the Master Page Owner to "Owner" column
{
objListItem["Owner"] = listEntry.ChapterPagesMapping[i].PageOwner;
}
objListItem.Update();
int.TryParse(Convert.ToString(objListItem["ID"]), out intRowId);
listEntry.ChapterPagesMapping[i].RowId = intRowId;
objCommonDAL.UpdateListAuditHistory(siteURL, auditListtname, intRowId, username, actionPerformed);
}
}
web.AllowUnsafeUpdates = false;
if (dtBook != null)
{
dtBook.Dispose();
}
if (dtTeamStaff != null)
{
dtTeamStaff.Dispose();
}
if (dtUser != null)
{
dtUser.Dispose();
}
}
}
});
return strTemplatePageMappingRowId.ToString();
}
/// <summary>
/// Updates the Audit Trail
/// </summary>
/// <param name="siteURL">The site URL.</param>
/// <param name="pageId">The page id.</param>
/// <param name="auditListName">Name of the audit list.</param>
/// <param name="userName">Name of the user.</param>
/// <param name="actionPerformed">The action performed.</param>
public void UpdateAuditTrail(string siteURL, string pageId, string auditListName, string userName, string actionPerformed)
{
objCommonDAL = new CommonDAL();
objCommonDAL.UpdateListAuditHistory(siteURL, auditListName, Convert.ToInt32(pageId), userName, actionPerformed);
}
/// <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>
/// Method to update the Page Sequence for Master Pages in a Template
/// </summary>
/// <param name="siteURL">Site URL.</param>
/// <param name="listName">List Name.</param>
/// <param name="auditListName">Audit List Name.</param>
/// <param name="actionPerformed">Audit Action.</param>
/// <param name="userName">User Name.</param>
/// <param name="dvUpdateListitems">DataView.</param>
public void UpdatePageSequence(string siteURL, string listName, string auditListName, string actionPerformed, string userName, DataView dvUpdateListitems)
{
objCommonDAL = new CommonDAL();
objCommonDAL.UpdateSequence(siteURL, listName, dvUpdateListitems, "Page_Sequence");
if (dvUpdateListitems != null && dvUpdateListitems.Count > 0)
{
for (int i = 0; i < dvUpdateListitems.Count; i++)
{
objCommonDAL.UpdateListAuditHistory(siteURL, auditListName,
int.Parse(dvUpdateListitems[i]["ID"].ToString()), userName, actionPerformed);
}
}
dvUpdateListitems.Dispose();
}