protected void Page_Load(object sender, EventArgs e)
        {
            string strRequestID = string.Empty;
            string filepath = string.Empty;
            string strCAMLQuery = string.Empty;
            string strLibraryName = string.Empty;
            CommonBLL objCommon = new CommonBLL();

            WindowsImpersonationContext ctx = WindowsIdentity.Impersonate(IntPtr.Zero);
            try
            {
                if (!string.IsNullOrEmpty(Page.Request.QueryString["requestID"]))
                    strRequestID = Page.Request.QueryString["requestID"].ToString();
                if (!string.IsNullOrEmpty(Page.Request.QueryString["mode"]))
                {
                    if (string.Equals(Page.Request.QueryString["mode"], "chapter"))
                        strLibraryName = "DWB Chapter Print Details";
                    else if (string.Equals(Page.Request.QueryString["mode"], "book"))
                        strLibraryName = "DWB Book Print details Library";
                    else
                        strLibraryName = "DWB Page Print details";
                }

                strCAMLQuery = @"<Where><Eq><FieldRef Name='RequestID' /><Value Type='Text'>" + strRequestID + "</Value></Eq></Where>";
                filepath = @objCommon.GetRequestID(SPContext.Current.Site.Url, strLibraryName, strCAMLQuery);
                FileInfo fInfo = new FileInfo(filepath);

                if (fInfo.Exists)
                {
                    HttpContext.Current.Response.ClearHeaders();
                    HttpContext.Current.Response.ClearContent();
                    HttpContext.Current.Response.ContentType = "application/pdf";
                    HttpContext.Current.Response.AppendHeader("Content-Disposition:", " attachment; filename=" + fInfo.Name);
                    HttpContext.Current.Response.AppendHeader("Content-Length", Convert.ToString(fInfo.Length));
                    HttpContext.Current.Response.Charset = "UTF-8";

                    HttpContext.Current.Response.TransmitFile(fInfo.FullName);
                    HttpContext.Current.Response.Flush();
                    HttpContext.Current.Response.Close();
                }
            }
            finally
            {
                ctx.Undo();
            }
        }
Exemple #2
0
        /// <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
        }
        protected void TransformAuditListDetail()
        {
            XmlTextReader xmlTextReader = null;
            XslTransform xslTransform = null;
            XmlDocument objXmlDocForXSL = null;
            XsltArgumentList xsltArgsList = null;
            XPathDocument objXPathDocument = null;
            MemoryStream objMemoryStream = null;
            string strSortBy = string.Empty;
            string strSortType = string.Empty;
            try
            {
                objCommonBLL = new CommonBLL();
                xmlTextReader = objCommonBLL.GetXSLTemplate("List Viewer", strSiteURL);
                if (xmlListDocument != null && xmlTextReader != null)
                {
                    xslTransform = new XslTransform();
                    XslCompiledTransform xslTransformTest = new XslCompiledTransform();
                    objXmlDocForXSL = new XmlDocument();
                    xsltArgsList = new XsltArgumentList();
                    objMemoryStream = new MemoryStream();
                    xmlListDocument.Save(objMemoryStream);
                    objMemoryStream.Position = 0;
                    objXPathDocument = new XPathDocument(objMemoryStream);

                    /// Inititlize the XSL
                    objXmlDocForXSL.Load(xmlTextReader);
                    xslTransform.Load(objXmlDocForXSL);

                    /// <!-- Set the number of records per page-->
                    /// <xsl:param name="recordsPerPage" select="0" />

                    if (!string.IsNullOrEmpty(HttpContext.Current.Request.Url.Query))
                    {
                        objCommonUtility = new CommonUtility();
                        string strURL = GetCurrentPageName(true);
                        xsltArgsList.AddParam("CurrentPageName", string.Empty, strURL);
                    }
                    else
                    {
                        xsltArgsList.AddParam("CurrentPageName", string.Empty, HttpContext.Current.Request.Url.AbsolutePath + "?");
                    }

                    xslTransform.Transform(objXPathDocument, xsltArgsList,
                        HttpContext.Current.Response.Output);

                }
                else
                {
                    throw new Exception("Invalid Arguments");
                }
            }
            catch
            {
                throw;
            }
            finally
            {
                if (objMemoryStream != null)
                {
                    objMemoryStream.Close();
                    objMemoryStream.Dispose();
                }
            }
        }
        /// <summary>
        /// This method retrieves the List Items to be rendered on the page
        /// The CAML is formed based on the CustomListType value
        /// </summary>
        /// <returns>DataTable</returns>
        protected DataTable GetRecords()
        {
            string strTerminated = string.Empty;
            DataTable dtListDetails = null;

            if (!ActiveStatus)
                strTerminated = STATUS_TERMINATED;
            else
                strTerminated = STATUS_ACTIVE;

            string strCamlQuery = @"<Where><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" +
                 strTerminated + "</Value></Eq></Where>";

            strCamlQuery = GetsCAMLQuery();
            objCommonBLL = new CommonBLL();
            if (!string.IsNullOrEmpty(strCamlQuery))
            {
                dtListDetails = objCommonBLL.ReadList(strSiteURL, ListName.ToString(), strCamlQuery);
            }
            if (string.Compare(ListReportName, CHAPTERPAGEMAPPINGREPORT, true) == 0 || string.Compare(ListReportName, WELLBOOKPAGEVIEW, true) == 0)
            {
                dtListDetails.Columns.Add(CHAPTERTITLE_COLUMNNAME);
                for (int rowIndex = 0; rowIndex < dtListDetails.Rows.Count; rowIndex++)
                {
                    string strChapterTitle = string.Empty;
                    if (dicChatperDetail != null)
                    {
                        dicChatperDetail.TryGetValue(Convert.ToString(dtListDetails.Rows[rowIndex]["Chapter_ID"]), out strChapterTitle);
                    }
                    dtListDetails.Rows[rowIndex][CHAPTERTITLE_COLUMNNAME] = strChapterTitle;
                }

                dtListDetails.DefaultView.Sort = string.Format(DATATABLE_SORTEXP, CHAPTERTITLE_COLUMNNAME, SORTDIR_ASC);
                dtListDetails = dtListDetails.DefaultView.ToTable();
            }
            return dtListDetails;
        }
 /// <summary>
 /// Gets the list XML.
 /// </summary>
 /// <returns></returns>
 protected DataTable GetListXml()
 {
     string strCamlQuery = string.Empty;
     string strTerminated = string.Empty;
     DataTable dtListDetails = null;
     StringBuilder strRecordID = new StringBuilder();
     try
     {
         if (!ActiveStatus)
             strTerminated = STATUS_TERMINATED;
         else
             strTerminated = STATUS_ACTIVE;
         strCamlQuery = @"<Where><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" +
             strTerminated + "</Value></Eq></Where>";
         strCamlQuery = GetsCAMLQuery();
         objCommonBLL = new CommonBLL();
         strSiteURL = SPContext.Current.Site.Url.ToString();
         if (!string.IsNullOrEmpty(strCamlQuery))
         {
             dtListDetails = objCommonBLL.ReadList(strSiteURL, ListName.ToString(), strCamlQuery);
         }
         if (dtListDetails != null && dtListDetails.Rows.Count > 0)
         {
             //dtHistoryDetails = objCommonBLL.ReadList(strSiteURL, AuditListName,
             //    "<OrderBy><FieldRef Name='Created' Ascending='False' /></OrderBy>");
             SetRecordsDataObject(dtListDetails);
             objListViewer = new ListViewerXMLGeneratorBLL();
             xmlListDocument = objListViewer.CreateListViewerXML(objRecords);
         }
     }
     catch
     { throw; }
     finally
     {
         if (dtListDetails != null)
         {
             dtListDetails.Dispose();
         }
     }
     return dtListDetails;
 }
        /// <summary>
        /// Binds the Data to ChapterName Dropdown        
        /// Added By: Praveena 
        /// Date:3/09/2010
        /// Reason: To Populate Values in ChapterName ListBox
        /// </summary>
        /// <param name="cboList"></param>
        /// <param name="strListname"></param>
        /// <param name="strCAMLQuery"></param>
        protected void BindChapterNameListBox(ListBox listBox, string strListname)
        {
            string strBookId = HttpContext.Current.Request.QueryString["BookId"];
            string strCamlQuery = @"<Where><And><Eq><FieldRef Name='Book_ID' />
                 <Value Type='Number'>" + strBookId + "</Value></Eq><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>No</Value></Eq></And></Where>";
            DataTable dtListData = null;
            DataRow drListData;
            ListItem lstItem;
            string strViewFields = string.Empty;
            strViewFields = @"<FieldRef Name='ID' /><FieldRef Name='Title' />";
            objCommonBLL = new CommonBLL();
            dtListData = objCommonBLL.ReadList(strSiteURL, strListname, strCamlQuery, strViewFields);
            if (dtListData != null && dtListData.Rows.Count > 0)
            {
                /// Loop through the list and add items
                listBox.Items.Clear();
                for (int intRowIndex = 0; intRowIndex < dtListData.Rows.Count; intRowIndex++)
                {
                    drListData = dtListData.Rows[intRowIndex];
                    lstItem = new ListItem();
                    lstItem.Text = drListData[DWBTITLECOLUMN].ToString();
                    lstItem.Value = drListData[DWBIDCOLUMN].ToString();
                    listBox.Items.Add(lstItem);
                }
            }

            if (dtListData != null)
                dtListData.Dispose();
        }
        /// <summary>
        /// Sets the book attributes.
        /// </summary>
        /// <param name="dataRow">The data row.</param>
        /// <returns>ArrayList.</returns>
        private ArrayList SetBookAttributes(DataRow dataRow)
        {
            ArrayList arlAttributes = null;
            string strCamlQuery = string.Empty;
            string strViewFields = string.Empty;
            string strPageOwner = string.Empty;
            DataTable dtUser = null;
            try
            {
                arlAttributes = new ArrayList();
                arlAttributes.Add(CreateAttribute("Name", Convert.ToString(dataRow["Title"]), "true"));
                arlAttributes.Add(CreateAttribute("Team", dataRow["Team"].ToString(), "true"));

                strCamlQuery = @"<Where><Eq><FieldRef Name='Windows_User_ID' /><Value Type='Text'>" + dataRow["Owner"].ToString() + "</Value></Eq></Where>";
                strViewFields = @"<FieldRef Name='ID' /><FieldRef Name='DWBUserName' />";
                objCommonBLL = new CommonBLL();
                dtUser = objCommonBLL.ReadList(strSiteURL, USERLIST, strCamlQuery, strViewFields);
                if (dtUser != null && dtUser.Rows.Count > 0)
                {
                    strPageOwner = dtUser.Rows[0]["DWBUserName"].ToString();
                }

                arlAttributes.Add(CreateAttribute("Well Book Owner", strPageOwner, "true"));
                return arlAttributes;
            }
            catch
            {
                throw;
            }
        }
        /// <summary>
        /// Gets the CAML query for well book summary pages.
        /// </summary>
        /// <returns> CAML query for well book summary pages.</returns>
        private string GetCAMLQueryForWellBookSummaryPages()
        {
            string strCamlQuery = string.Empty;
            StringBuilder sbChapterId = new StringBuilder();
            DataTable dtListDetails = null;
            string strTerminated = string.Empty;
            if (!ActiveStatus)
                strTerminated = STATUS_TERMINATED;
            else
                strTerminated = STATUS_ACTIVE;

            string strbookId = HttpContext.Current.Request.QueryString["BookId"];
            string wellbookStatus = HttpContext.Current.Request.QueryString["pageStatus"];
            string strPageOnwer = HttpContext.Current.Request.QueryString["pageOwner"];
            if (string.IsNullOrEmpty(strbookId))
                return string.Empty;
            objCommonBLL = new CommonBLL();
            strCamlQuery = @"<Where><Eq><FieldRef Name='Book_ID' /><Value Type='Number'>" +
             strbookId + "</Value></Eq></Where>";
            dtListDetails = objCommonBLL.ReadList(strSiteURL, CHAPTERLIST, strCamlQuery);
            if (dtListDetails != null && dtListDetails.Rows.Count > 0)
            {
                dicChatperDetail = new System.Collections.Generic.Dictionary<string, string>();

                for (int intRowIndex = 0; intRowIndex < dtListDetails.Rows.Count; intRowIndex++)
                {
                    if (!dicChatperDetail.ContainsKey(Convert.ToString(dtListDetails.Rows[intRowIndex]["ID"])))
                    {
                        dicChatperDetail.Add(Convert.ToString(dtListDetails.Rows[intRowIndex]["ID"]), Convert.ToString(dtListDetails.Rows[intRowIndex]["Title"]));
                        sbChapterId.Append(Convert.ToString(dtListDetails.Rows[intRowIndex]["ID"]));
                        sbChapterId.Append(";");
                    }
                }
                strCamlQuery = CreateCAMLQueryForSetOfCondtion(sbChapterId.ToString(), "Chapter_ID", "Number");
                sbChapterId.Remove(0, sbChapterId.Length);
                sbChapterId.Append(strCamlQuery);
                if (strPageOnwer.Equals("All") && wellbookStatus.Equals("Total"))
                {
                    sbChapterId.Append("<Eq><FieldRef Name='Sign_Off_Status' /><Value Type='Choice'>" + strSignedOffStatus + "</Value></Eq></And>");
                    sbChapterId.Append("<Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" + strTerminated + "</Value></Eq></And></Where>");
                    sbChapterId.Insert(0, "<Where><And><And>");
                }
                else if (!strPageOnwer.Equals("All") && wellbookStatus.Equals("Total"))
                {
                    sbChapterId.Append("<Eq><FieldRef Name='Sign_Off_Status' /><Value Type='Choice'>" + strSignedOffStatus + "</Value></Eq></And>");
                    sbChapterId.Append("<Eq><FieldRef Name='Owner' /><Value Type='Text'>" + strPageOnwer + "</Value></Eq></And>");
                    sbChapterId.Append("<Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" + strTerminated + "</Value></Eq></And></Where>");
                    sbChapterId.Insert(0, "<Where><And><And><And>");
                }
                else if (strPageOnwer.Equals("All") && !wellbookStatus.Equals("Total"))
                {
                    if (wellbookStatus.Equals("SignedOff"))
                    {
                        sbChapterId.Append("<Eq><FieldRef Name='Sign_Off_Status' /><Value Type='Choice'>Yes</Value></Eq></And>");
                    }
                    else if (wellbookStatus.Equals("NotSignedOff"))
                    {
                        sbChapterId.Append("<Eq><FieldRef Name='Sign_Off_Status' /><Value Type='Choice'>No</Value></Eq></And>");
                    }
                    else if (wellbookStatus.Equals("Empty"))
                    {
                        sbChapterId.Append("<Eq><FieldRef Name='Sign_Off_Status' /><Value Type='Choice'>" + strSignedOffStatus + "</Value></Eq></And>");
                        //need to add here also?
                        sbChapterId.Append("<Eq><FieldRef Name='Empty' /><Value Type='Choice'>Yes</Value></Eq></And>");
                    }

                    sbChapterId.Append("<Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" + strTerminated + "</Value></Eq></And></Where>");
                    if (wellbookStatus.Equals("Empty"))
                        sbChapterId.Insert(0, "<Where><And><And><And>");
                    else
                        sbChapterId.Insert(0, "<Where><And><And>");
                }
                else if (!strPageOnwer.Equals("All") && !wellbookStatus.Equals("Total"))
                {

                    if (wellbookStatus.Equals("SignedOff"))
                    {
                        sbChapterId.Append("<Eq><FieldRef Name='Sign_Off_Status' /><Value Type='Choice'>Yes</Value></Eq></And>");
                    }
                    else if (wellbookStatus.Equals("NotSignedOff"))
                    {
                        sbChapterId.Append("<Eq><FieldRef Name='Sign_Off_Status' /><Value Type='Choice'>No</Value></Eq></And>");
                    }
                    else if (wellbookStatus.Equals("Empty"))
                    {
                        sbChapterId.Append("<Eq><FieldRef Name='Sign_Off_Status' /><Value Type='Choice'>" + strSignedOffStatus + "</Value></Eq></And>");
                        sbChapterId.Append("<Eq><FieldRef Name='Empty' /><Value Type='Choice'>Yes</Value></Eq></And>");
                    }

                    sbChapterId.Append("<Eq><FieldRef Name='Owner' /><Value Type='Text'>" + strPageOnwer + "</Value></Eq></And>");

                    sbChapterId.Append("<Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" + strTerminated + "</Value></Eq></And></Where>");
                    if (wellbookStatus.Equals("Empty"))
                        sbChapterId.Insert(0, "<Where><And><And><And><And>");
                    else
                        sbChapterId.Insert(0, "<Where><And><And><And>");
                }
                sbChapterId.Insert(0, "<OrderBy><FieldRef Name='Connection_Type' /></OrderBy>");
            }
            if (dtListDetails != null)
            {
                dtListDetails.Dispose();
            }
            return sbChapterId.ToString();
        }
Exemple #9
0
        /// <summary>
        /// Publishe the Well book and updates the list item.
        /// </summary>
        /// <param name="siteURL">The site URL.</param>
        /// <param name="listName">Name of the list.</param>
        /// <param name="rowId">The row id.</param>
        public void PublishWellBook(string siteURL, string listName, int rowId)
        {
            objWellBookDAL = new WellBookDAL();
            objCommonDAL = new CommonDAL();
            objCommonBLL = new CommonBLL();
            DataTable dtResultTable = null;
            int intListItemRowId = 0;
            StringBuilder strID = new StringBuilder();
            string strCAMlQueryforPageId = string.Empty;
            Dictionary<string, string> listItemCollection = null;
            string strCamlQuery = string.Empty;

            listItemCollection = new Dictionary<string, string>();
            listItemCollection.Add("Sign_Off_Status", "No");
            /// Updating Sign_Off_Status column value to "No" in DWB Books list.
            objWellBookDAL.UpdateListItemValue(siteURL, listName, rowId, listItemCollection);

            strCamlQuery = "<Where><Eq><FieldRef Name='Book_ID' /><Value Type='Number'>" +
                  rowId.ToString() + "</Value></Eq></Where>";
            dtResultTable = objCommonDAL.ReadList(siteURL, DWBCHAPTERLIST, strCamlQuery);
            if (dtResultTable != null && dtResultTable.Rows.Count > 0)
            {
                for (int i = 0; i < dtResultTable.Rows.Count; i++)
                {
                    strID.Append(Convert.ToString(dtResultTable.Rows[i][IDCOLUMN]));
                    strID.Append(";");
                }
            }
            else
            {
                //the book does not have any chapters
                return;
            }

            /// Updating Sign_Off_Status column value to "No" in DWB Chapter Pages Mapping list.

            ///Build CAML Query to get all pages in the selected Book
            strCamlQuery = objCommonBLL.CreateCAMLQuery(strID.ToString(), "Chapter_ID", "Number");
            dtResultTable = objCommonDAL.ReadList(siteURL, CHAPTERPAGESMAPPINGLIST, strCamlQuery);
            strID.Remove(0, strID.Length);
            if (dtResultTable != null && dtResultTable.Rows.Count > 0)
            {
                listItemCollection.Clear();
                listItemCollection.Add("Sign_Off_Status", "No");
                for (int intRowIndex = 0; intRowIndex < dtResultTable.Rows.Count; intRowIndex++)
                {
                    int.TryParse(Convert.ToString(dtResultTable.Rows[intRowIndex][IDCOLUMN]), out intListItemRowId);
                    /// Updating Sign_Off_Status column value to "No" in DWB Chapter Pages Mapping list.
                    objWellBookDAL.UpdateListItemValue(siteURL, CHAPTERPAGESMAPPINGLIST, intListItemRowId, listItemCollection);
                    strID.Append(intListItemRowId.ToString());
                    strID.Append(";");

                }
            }

            /// Delete Comments for All Books Pages
            strCAMlQueryforPageId = objCommonBLL.CreateCAMLQuery(strID.ToString(), "Page_ID", "Number");
            objCommonDAL.DeleteAuditTrail(siteURL, DWBCOMMENT, strCAMlQueryforPageId);

            /// Delete audit trail of the Book.
            strCamlQuery = @"<Where><Eq><FieldRef Name='Master_ID' /><Value Type='Number'>" + rowId.ToString() + "</Value></Eq></Where>";
            objCommonDAL.DeleteAuditTrail(siteURL, DWBWELLBOOKAUDITLIST, strCamlQuery);

            if (dtResultTable != null)
            {
                dtResultTable.Dispose();
            }
        }
Exemple #10
0
        /// <summary>
        /// To Get TypeIII Pages for selected Book
        /// Added By: Praveena  
        /// Date:16/09/2010
        /// Reason: For module Add additional attributes to change page owner table
        /// </summary>
        /// <param name="siteURL"></param>
        /// <param name="bookId"></param>
        /// <param name="terminated"></param>
        /// <returns></returns>
        public DataTable GetTypeIIIPagesForBook(string siteURL, string bookId, string terminated)
        {
            DataTable dtResult = null;
            objCommonDAL = new CommonDAL();
            objCommonBLL = new CommonBLL();
            StringBuilder strChapterId = new StringBuilder();
            string strCamlQuery = @"<Where><And><Eq><FieldRef Name='Book_ID' />
            <Value Type='Number'> " + bookId + "</Value></Eq><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" + terminated + "</Value></Eq></And></Where>";
            dtResult = objCommonDAL.ReadList(siteURL, DWBCHAPTERLIST, strCamlQuery);
            if (dtResult != null && dtResult.Rows.Count > 0)
            {
                for (int intRowIndex = 0; intRowIndex < dtResult.Rows.Count; intRowIndex++)
                {
                    strChapterId.Append(Convert.ToString(dtResult.Rows[intRowIndex][IDCOLUMN]));
                    strChapterId.Append(";");
                }
                strCamlQuery = objCommonBLL.CreateCamlQueryWithoutWhere(strChapterId.ToString(), "Chapter_ID", "Number");
                strChapterId.Remove(0, strChapterId.Length);
                strChapterId.Append(strCamlQuery);
                strChapterId.Append("<Eq><FieldRef Name='Connection_Type' /><Value Type='Text'>3 - User Defined Document</Value></Eq></And>");
                strChapterId.Append("<Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" + terminated + "</Value></Eq></And></Where>");
                strChapterId.Insert(0, "<Where><And><And>");
                dtResult = objCommonDAL.ReadList(siteURL, CHAPTERPAGESMAPPINGLIST, strChapterId.ToString());

            }

            return dtResult;
        }
Exemple #11
0
        /// <summary>
        /// Get Pages for the selected Owner
        /// Modified By: Praveena  
        /// Date:03/09/2010
        /// Reason: For module Add additional attributes to change page owner table
        /// </summary>
        /// <param name="siteURL">Site URL.</param>
        /// <param name="listName">List Name.</param>
        /// <param name="queryString">CAML Query.</param>     
        /// <param name="username">Windows User ID of the selected Owner</param>
        /// <returns>DataTable</returns>
        public DataTable GetPagesForOwner(string siteURL, string listName, string CAMLQuery, string username, string pageName, string terminatedStatus, System.Text.StringBuilder chapterNames)
        {
            string strViewFields = string.Empty;
            strViewFields = @"<FieldRef Name='ID' /><FieldRef Name='Title' />";
            DataTable dtResultDatatable = null;
            DataView dvresultdataview = null;
            string strCAMLQuery = string.Empty;
            StringBuilder strChapterId = new StringBuilder();
            Dictionary<string, string> listItemCollection = null;
            objCommonDAL = new CommonDAL();
            dtResultDatatable = objCommonDAL.ReadList(siteURL, listName, CAMLQuery, strViewFields);
            if (dtResultDatatable != null && dtResultDatatable.Rows.Count > 0)
            {
                listItemCollection = new Dictionary<string, string>();
                for (int intRowIndex = 0; intRowIndex < dtResultDatatable.Rows.Count; intRowIndex++)
                {
                    strChapterId.Append(Convert.ToString(dtResultDatatable.Rows[intRowIndex][IDCOLUMN]));
                    strChapterId.Append(";");
                    if ((!listItemCollection.ContainsValue(Convert.ToString(dtResultDatatable.Rows[intRowIndex][TITLECOLUMN]))
                        && (!string.IsNullOrEmpty(Convert.ToString(dtResultDatatable.Rows[intRowIndex][TITLECOLUMN])))))
                    {
                        listItemCollection.Add(Convert.ToString(dtResultDatatable.Rows[intRowIndex][IDCOLUMN]), Convert.ToString(dtResultDatatable.Rows[intRowIndex][TITLECOLUMN]));
                    }
                }
                objCommonBLL = new CommonBLL();
                strCAMLQuery = objCommonBLL.CreateCAMLQuery(strChapterId.ToString(), CHAPTERIDCOLUMN, "Number");
                strViewFields = "<FieldRef Name='Connection_Type' /><FieldRef Name='Page_Name' /><FieldRef Name='Discipline' /><FieldRef Name='Owner' /><FieldRef Name='Empty' /><FieldRef Name='Sign_Off_Status' /><FieldRef Name='Chapter_ID' /><FieldRef Name='Terminate_Status' />";
                dtResultDatatable = objCommonDAL.ReadList(siteURL, CHAPTERPAGESMAPPINGLIST,
                   strCAMLQuery, strViewFields);

                if (dtResultDatatable != null && dtResultDatatable.Rows.Count > 0)
                {
                    Dictionary<string, string> ChapterDetails = listItemCollection;
                    DataColumn dcChapterName = dtResultDatatable.Columns.Add(CHAPTERNAMECOLUMN, typeof(string));
                    string str = string.Empty;
                    foreach (DataRow dtRow in dtResultDatatable.Rows)
                    {
                        if (ChapterDetails.ContainsKey(dtRow[CHAPTERIDCOLUMN].ToString()))
                        {
                            ChapterDetails.TryGetValue(dtRow[CHAPTERIDCOLUMN].ToString(), out str);
                            dtRow[CHAPTERNAMECOLUMN] = str;
                        }
                    }
                    dvresultdataview = dtResultDatatable.DefaultView;
                    //to apply filters to dataview
                    dvresultdataview = ApplyFilters(dvresultdataview, username, pageName, chapterNames, terminatedStatus);
                }
            }
            if (dvresultdataview != null)
            {
                return dvresultdataview.Table;
            }
            else
            {
                return dtResultDatatable;
            }
        }
Exemple #12
0
        /// <summary>
        /// Gets the owners list
        /// </summary>
        /// <param name="siteURL">Site URL.</param>
        /// <param name="listName">List Name.</param>
        /// <param name="queryString">CAML Query.</param>     
        /// <returns>Dictionary Object.</returns>
        public Dictionary<string, string> GetPageOwnerList(string siteURL, string listName, string CAMLQuery)
        {
            Dictionary<string, string> listItemCollection = null;
            DataTable dtResultDatatable = null;
            string strCAMLQuery = string.Empty;
            StringBuilder strChapterId = new StringBuilder();
            objCommonDAL = new CommonDAL();
            string strViewFields = string.Empty;
            strViewFields = @"<FieldRef Name='ID' />";
            dtResultDatatable = objCommonDAL.ReadList(siteURL, listName, CAMLQuery, strViewFields);

            if (dtResultDatatable != null && dtResultDatatable.Rows.Count > 0)
            {
                for (int intRowIndex = 0; intRowIndex < dtResultDatatable.Rows.Count; intRowIndex++)
                {
                    strChapterId.Append(Convert.ToString(dtResultDatatable.Rows[intRowIndex][IDCOLUMN]));
                    strChapterId.Append(";");
                }
                objCommonBLL = new CommonBLL();
                strCAMLQuery = objCommonBLL.CreateCAMLQuery(strChapterId.ToString(), "Chapter_ID", "Number", "Owner");
                if (string.IsNullOrEmpty(CAMLQuery))
                    return listItemCollection;
                dtResultDatatable = objCommonDAL.ReadList(siteURL, CHAPTERPAGESMAPPINGLIST, strCAMLQuery);
                if (dtResultDatatable != null && dtResultDatatable.Rows.Count > 0)
                {
                    listItemCollection = new Dictionary<string, string>();

                    for (int intRowIndex = 0; intRowIndex < dtResultDatatable.Rows.Count; intRowIndex++)
                    {

                        if ((!listItemCollection.ContainsValue(Convert.ToString(dtResultDatatable.Rows[intRowIndex]["Owner"]))
                            && (!string.IsNullOrEmpty(Convert.ToString(dtResultDatatable.Rows[intRowIndex]["Owner"])))))
                        {
                            listItemCollection.Add(Convert.ToString(dtResultDatatable.Rows[intRowIndex][IDCOLUMN]), Convert.ToString(dtResultDatatable.Rows[intRowIndex]["Owner"]));
                        }
                    }
                }

            }
            if (dtResultDatatable != null)
            {
                dtResultDatatable.Dispose();
            }
            return listItemCollection;
        }
Exemple #13
0
        /// <summary>
        /// Gets the PageNames List
        /// Added By: Praveena  
        /// Date:03/09/2010
        /// Reason: For module Add additional attributes to change page owner table
        /// </summary>
        /// <param name="siteURL">Site URL.</param>
        /// <param name="listName">List Name.</param>
        /// <param name="queryString">CAML Query.</param>     
        /// <returns>Dictionary Object.</returns>
        public Dictionary<string, string> GetPageNamesList(string siteURL, string listName, string CAMLQuery)
        {
            Dictionary<string, string> listItemCollection = null;
            DataTable dtResultDatatable = null;
            string strCAMLQuery = string.Empty;
            StringBuilder strChapterId = new StringBuilder();
            objCommonDAL = new CommonDAL();
            string strViewFields = string.Empty;
            strViewFields = @"<FieldRef Name='ID' />";

            //Get the chapter details
            dtResultDatatable = objCommonDAL.ReadList(siteURL, listName, CAMLQuery, strViewFields);
            if (dtResultDatatable != null && dtResultDatatable.Rows.Count > 0)
            {
                for (int intRowIndex = 0; intRowIndex < dtResultDatatable.Rows.Count; intRowIndex++)
                {
                    strChapterId.Append(Convert.ToString(dtResultDatatable.Rows[intRowIndex][IDCOLUMN]));
                    strChapterId.Append(";");
                }
                objCommonBLL = new CommonBLL();
                strCAMLQuery = objCommonBLL.CreateCAMLQuery(strChapterId.ToString(), "Chapter_ID", "Number");
                if (string.IsNullOrEmpty(CAMLQuery))
                    return listItemCollection;

                strViewFields = @"<FieldRef Name='Page_Name' /><FieldRef Name='Discipline' />";

                //Get the Page details by passing chapter Ids
                dtResultDatatable = objCommonDAL.ReadList(siteURL, CHAPTERPAGESMAPPINGLIST, strCAMLQuery, strViewFields);
                if (dtResultDatatable != null && dtResultDatatable.Rows.Count > 0)
                {
                    listItemCollection = new Dictionary<string, string>();
                    DataView dvResult = dtResultDatatable.DefaultView;

                    //PageName and Discipline are store into the dictionary collection.
                    dtResultDatatable = dvResult.ToTable(true, "Page_Name", "Discipline");
                    for (int intRowIndex = 0; intRowIndex < dtResultDatatable.Rows.Count; intRowIndex++)
                    {
                        if ((!listItemCollection.ContainsKey(Convert.ToString(dtResultDatatable.Rows[intRowIndex][PAGENAMECOLUMN]))) &&
                             (!string.IsNullOrEmpty(Convert.ToString(dtResultDatatable.Rows[intRowIndex][PAGENAMECOLUMN]))) &&
                             (!string.IsNullOrEmpty(Convert.ToString(dtResultDatatable.Rows[intRowIndex][DISCIPLINECOLUMN]))))
                        {
                            listItemCollection.Add(Convert.ToString(dtResultDatatable.Rows[intRowIndex][PAGENAMECOLUMN]), Convert.ToString(dtResultDatatable.Rows[intRowIndex][DISCIPLINECOLUMN]));
                        }
                    }
                }
            }
            if (dtResultDatatable != null)
            {
                dtResultDatatable.Dispose();
            }
            return listItemCollection;
        }
Exemple #14
0
        /// <summary>
        /// Gets the onwers of the team.
        /// </summary>
        /// <param name="siteURL">Site URL.</param>
        /// <param name="listName">List Name.</param>
        /// <param name="queryString">CAML Query.</param>     
        /// <returns>Dictionary object</returns>
        public Dictionary<string, string> GetOwnerForTeam(string siteURL, string listName, string CAMLQuery)
        {
            Dictionary<string, string> listItemCollection = null;
            DataTable dtResultDatatable = null;
            DataTable dtUserDetails = null;
            string strcamlQuery = string.Empty;
            StringBuilder strTeamId = new StringBuilder();
            objCommonDAL = new CommonDAL();
            dtResultDatatable = objCommonDAL.ReadList(siteURL, listName, CAMLQuery);
            if (dtResultDatatable != null && dtResultDatatable.Rows.Count > 0)
            {
                strcamlQuery = @"<Where><Eq><FieldRef Name='Team_ID' />
                 <Value Type='Number'>" + (Convert.ToString(dtResultDatatable.Rows[0]["Team_ID"])) + "</Value></Eq></Where>";
                dtResultDatatable = objCommonDAL.ReadList(siteURL, DWBTEAMSTAFF,
                   strcamlQuery);

                if (dtResultDatatable != null && dtResultDatatable.Rows.Count > 0)
                {
                    for (int intRowIndex = 0; intRowIndex < dtResultDatatable.Rows.Count; intRowIndex++)
                    {
                        strTeamId.Append(Convert.ToString(dtResultDatatable.Rows[intRowIndex]["User_ID"]));
                        strTeamId.Append(";");
                    }
                    objCommonBLL = new CommonBLL();
                    strcamlQuery = objCommonBLL.CreateCAMLQuery(strTeamId.ToString(), IDCOLUMN, IDCOLUMNTYPE, "DWBUserName");
                    dtUserDetails = objCommonDAL.ReadList(siteURL, DWBUSER, strcamlQuery);
                    listItemCollection = new Dictionary<string, string>();
                    for (int intRowIndex = 0; intRowIndex < dtUserDetails.Rows.Count; intRowIndex++)
                    {
                        if (!listItemCollection.ContainsKey(Convert.ToString(dtResultDatatable.Rows[intRowIndex]["ID"])))
                        {
                            listItemCollection.Add(Convert.ToString(dtUserDetails.Rows[intRowIndex][IDCOLUMN]), Convert.ToString(dtUserDetails.Rows[intRowIndex]["Windows_User_ID"]));
                        }
                    }
                }

            }
            if (dtResultDatatable != null)
            {
                dtResultDatatable.Dispose();
            }
            if (dtUserDetails != null)
            {
                dtUserDetails.Dispose();
            }
            return listItemCollection;
        }
Exemple #15
0
 /// <summary>
 /// Generates the DWB book XML.
 /// </summary>
 /// <param name="siteURL">The site URL.</param>
 /// <param name="rowId">The row id.</param>
 /// <param name="action">The action.</param>
 /// <param name="bookSelected">if set to <c>true</c> [book selected].</param>
 /// <param name="includeTOC">if set to <c>true</c> [include TOC].</param>
 /// <param name="includeStoryBoard">if set to <c>true</c> [include story board].</param>
 /// <returns></returns>
 public System.Xml.XmlDocument GenerateDWBBookXML(string siteURL, int rowId, string action, bool bookSelected, PrintOptions objPrintOptions)
 {
     BookInfo objBookInfo = null;
     System.Xml.XmlDocument xmlWellBookDetails = null;
     if (rowId > 0)
     {
         objBookInfo = SetBookDetailDataObject(siteURL, rowId.ToString(), action, bookSelected, objPrintOptions);
         objCommonBLL = new CommonBLL();
         xmlWellBookDetails = objCommonBLL.CreateWellBookDetailXML(objBookInfo);
     }
     return xmlWellBookDetails;
 }
        /// <summary>
        /// Transforms the list detail DWB home.
        /// </summary>
        /// <param name="noOfRecords">The no of records.</param>
        protected void TransformListDetailDWBHome(int noOfRecords)
        {
            XmlTextReader xmlTextReader = null;
            XslCompiledTransform xslTransform = null;
            XmlDocument objXmlDocForXSL = null;
            XsltArgumentList xsltArgsList = null;
            XPathDocument objXPathDocument = null;
            MemoryStream objMemoryStream = null;

            /// For Paging and Sorting
            int intrecordsPerPage = 0;
            int intPageNumber = 0;
            int intMaxPages = 5;
            int intCurrentPage = 1;
            string strSortBy = string.Empty;
            string strSortType = string.Empty;
            object objSessionUserPreference = null;
            Shell.SharePoint.DREAM.Business.Entities.UserPreferences objPreferences = null;
            try
            {
                objCommonBLL = new CommonBLL();
                xmlTextReader = objCommonBLL.GetXSLTemplate("List Viewer DWBHome", strSiteURL);
                if (xmlListDocument != null && xmlTextReader != null)
                {
                    xslTransform = new XslCompiledTransform();
                    XslCompiledTransform xslTransformTest = new XslCompiledTransform();
                    objXmlDocForXSL = new XmlDocument();
                    xsltArgsList = new XsltArgumentList();
                    objMemoryStream = new MemoryStream();
                    xmlListDocument.Save(objMemoryStream);
                    objMemoryStream.Position = 0;
                    objXPathDocument = new XPathDocument(objMemoryStream);

                    /// Inititlize the XSL
                    objXmlDocForXSL.Load(xmlTextReader);
                    xslTransform.Load(objXmlDocForXSL);
                    xsltArgsList.AddParam("listType", string.Empty, ListReportName);

                    /// Parameters for Paging/Sorting
                    xsltArgsList.AddParam("activeStatus", string.Empty, ActiveStatus.ToString().ToLower());
                    /// <!-- Set the number of records per page-->
                    /// <xsl:param name="recordsPerPage" select="0" />
                    objSessionUserPreference = CommonUtility.GetSessionVariable(Page, enumSessionVariable.UserPreferences.ToString());
                    if (objSessionUserPreference != null)
                    {
                        objPreferences = (Shell.SharePoint.DREAM.Business.Entities.UserPreferences)objSessionUserPreference;
                        intrecordsPerPage = Convert.ToInt32(objPreferences.RecordsPerPage);
                    }
                    xsltArgsList.AddParam("recordsPerPage", string.Empty, intrecordsPerPage);

                    /// <!-- Page Number field -->
                    /// <xsl:param name="pageNumber" select="1" />
                    if (HttpContext.Current.Request.QueryString["pageNumber"] != null)
                    {
                        intPageNumber = Int32.Parse(HttpContext.Current.Request.QueryString["pageNumber"]);
                        if (blnInitializePageNumber)
                            intPageNumber = 0;
                    }
                    if (HttpContext.Current.Request.QueryString["sortBy"] != null)
                    {
                        strSortBy = HttpContext.Current.Request.QueryString["sortBy"];
                    }
                    if (HttpContext.Current.Request.QueryString["sortType"] != null)
                    {
                        strSortType = HttpContext.Current.Request.QueryString["sortType"];
                    }
                    else
                    {
                        strSortType = "descending";
                    }
                    if (intPageNumber > (noOfRecords / intrecordsPerPage))
                    {
                        intPageNumber--;
                    }
                    xsltArgsList.AddParam("pageNumber", string.Empty, intPageNumber);

                    xsltArgsList.AddParam("recordCount", string.Empty, noOfRecords);
                    intMaxPages = 5;
                    xsltArgsList.AddParam("MaxPages", string.Empty, intMaxPages);
                    intCurrentPage = intPageNumber;
                    xsltArgsList.AddParam("CurrentPage", string.Empty, intPageNumber);
                    if (!string.IsNullOrEmpty(HttpContext.Current.Request.Url.Query))
                    {
                        objCommonUtility = new CommonUtility();
                        string strURL = GetCurrentPageName(true);
                        xsltArgsList.AddParam("CurrentPageName", string.Empty, strURL);
                    }
                    else
                    {
                        xsltArgsList.AddParam("CurrentPageName", string.Empty, HttpContext.Current.Request.Url.AbsolutePath + "?");
                    }
                    xsltArgsList.AddParam("sortBy", string.Empty, strSortBy);
                    xsltArgsList.AddParam("sortType", string.Empty, strSortType);

                    XmlNode xmlNode = xmlListDocument.SelectSingleNode("records/record/recordInfo/attribute[@name='" + strSortBy + "']");
                    if (xmlNode != null)
                    {
                        xsltArgsList.AddParam("sortDataType", string.Empty, xmlNode.Attributes["datatype"].Value);
                    }
                    xslTransform.Transform(objXPathDocument, xsltArgsList, HttpContext.Current.Response.Output);
                }
                else
                {
                    throw new Exception("Invalid Arguments");
                }
            }
            catch
            {
                throw;
            }
            finally
            {
                if (objMemoryStream != null)
                {
                    objMemoryStream.Close();
                    objMemoryStream.Dispose();
                }
            }
        }
 /// <summary>
 /// Gets the CAML query for well book pages.
 /// </summary>
 /// <returns>CAML query for well book pages.</returns>
 private string GetCAMLQueryForWellBookPages()
 {
     string strCamlQuery = string.Empty;
     StringBuilder sbChapterId = new StringBuilder();
     DataTable dtListDetails = null;
     string strTerminated = string.Empty;
     if (!ActiveStatus)
         strTerminated = STATUS_TERMINATED;
     else
         strTerminated = STATUS_ACTIVE;
     string strBookId = HttpContext.Current.Request.QueryString["BookId"];
     if (string.IsNullOrEmpty(strBookId))
         return string.Empty;
     objCommonBLL = new CommonBLL();
     strCamlQuery = @"<Where><Eq><FieldRef Name='Book_ID' /><Value Type='Number'>" +
      strBookId + "</Value></Eq></Where>";
     dtListDetails = objCommonBLL.ReadList(strSiteURL, CHAPTERLIST, strCamlQuery);
     if (dtListDetails != null && dtListDetails.Rows.Count > 0)
     {
         dicChatperDetail = new System.Collections.Generic.Dictionary<string, string>();
         for (int intRowIndex = 0; intRowIndex < dtListDetails.Rows.Count; intRowIndex++)
         {
             if (!dicChatperDetail.ContainsKey(Convert.ToString(dtListDetails.Rows[intRowIndex]["ID"])))
             {
                 dicChatperDetail.Add(Convert.ToString(dtListDetails.Rows[intRowIndex]["ID"]), Convert.ToString(dtListDetails.Rows[intRowIndex]["Title"]));
                 sbChapterId.Append(Convert.ToString(dtListDetails.Rows[intRowIndex]["ID"]));
                 sbChapterId.Append(";");
             }
         }
         strCamlQuery = CreateCAMLQueryForSetOfCondtion(sbChapterId.ToString(), "Chapter_ID", "Number");
         sbChapterId.Remove(0, sbChapterId.Length);
         sbChapterId.Append(strCamlQuery);
         sbChapterId.Append("<Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" + strTerminated + "</Value></Eq></And></Where>");
         sbChapterId.Insert(0, "<Where><And>");
         sbChapterId.Insert(0, "<OrderBy><FieldRef Name='Page_Name' /></OrderBy>");
     }
     if (dtListDetails != null)
     {
         dtListDetails.Dispose();
     }
     return sbChapterId.ToString();
 }
Exemple #18
0
        /// <summary>
        /// Sets the chapter details.
        /// </summary>
        /// <param name="siteURL">The site URL.</param>
        /// <param name="ChapterID">The chapter ID.</param>
        /// <param name="chapterSelected">if set to <c>true</c> [chapter selected].</param>
        /// <returns></returns>
        public ChapterInfo SetChapterDetails(string siteURL, string ChapterID, bool chapterSelected)
        {
            ChapterInfo objChapterInfo = null;
            string strCamlQuery = string.Empty;
            DataTable dtChapters = null;
            DataRow objDataRow;
            try
            {
                objCommonBLL = new CommonBLL();
                strCamlQuery = @"<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>" + ChapterID + "</Value></Eq></Where>";
                dtChapters = objCommonBLL.ReadList(siteURL, DWBCHAPTERLIST, strCamlQuery);

                for (int intIndex = 0; intIndex < dtChapters.Rows.Count; intIndex++)
                {
                    objChapterInfo = new ChapterInfo();
                    objDataRow = dtChapters.Rows[intIndex];
                    objChapterInfo.AssetType = objDataRow["Asset_Type"].ToString();
                    objChapterInfo.AssetValue = objDataRow["Asset_Value"].ToString();
                    objChapterInfo.ChapterID = objDataRow[IDCOLUMN].ToString();
                    objChapterInfo.ChapterTitle = objDataRow[TITLECOLUMN].ToString();
                    objChapterInfo.ActualAssetValue = objDataRow["Actual_Asset_Value"].ToString();
                    objChapterInfo.ColumnName = objDataRow["Column_Name"].ToString();
                    if (chapterSelected)
                    {
                        /// Call SetPageInfo method and assign the Page Collection
                        objChapterInfo.PageInfo = SetChapterPageInfo(siteURL, objChapterInfo.ChapterID, objChapterInfo.ActualAssetValue, objChapterInfo.ColumnName);
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
            if (dtChapters != null)
            {
                dtChapters.Dispose();
            }
            return objChapterInfo;
        }
        /// <summary>
        /// Gets the camlQuery based on the report type
        /// </summary>
        /// <returns></returns>
        private string GetsCAMLQuery()
        {
            string strTerminated = string.Empty;
            string strCamlQuery = string.Empty;
            string strMasterID = string.Empty;
            if (!ActiveStatus)
                strTerminated = STATUS_TERMINATED;
            else
                strTerminated = STATUS_ACTIVE;
            switch (ListReportName)
            {
                case "Audit Trail":
                    {
                        strMasterID = HttpContext.Current.Request.QueryString["auditID"];
                        strCamlQuery = @"<OrderBy><FieldRef Name='Created' Ascending='False' /></OrderBy><Where><Eq><FieldRef Name='Master_ID' /><Value Type='Number'>" + strMasterID + "</Value></Eq></Where>";
                        break;
                    }
                case MASTERPAGEREPORT:
                    {
                        strCamlQuery = @"<OrderBy><FieldRef Name='Page_Sequence' /></OrderBy><Where><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" +
                   strTerminated + "</Value></Eq></Where>";
                        break;
                    }
                case CHAPTERPAGEMAPPINGREPORT:
                    {
                        strCamlQuery = GetCAMLQueryForWellBookPages();
                        if (strCamlQuery.Length == 0)
                        {
                            strCamlQuery = @"<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>-9999</Value></Eq></Where>";
                        }
                        break;
                    }
                case WELLBOOKPAGEVIEW:
                    {
                        strCamlQuery = GetCAMLQueryForWellBookSummaryPages();
                        if (strCamlQuery.Length == 0)
                        {
                            strCamlQuery = @"<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>-9999</Value></Eq></Where>";
                        }
                        break;
                    }
                case CHAPTERREPORT:
                    {
                        strCamlQuery = GetCAMLQueryForWellBookChapters();
                        if (strCamlQuery.Length == 0)
                        {
                            #region DREAM 4.0 - eWB2.0 - Deletion Module
                            /// <Eq><FieldRef Name='ToBeDeleted' /><Value Type='Choice'>No</Value></Eq></And> is added.
                            /// And condition added to the CAML query
                            //strCamlQuery = @"<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>-9999</Value></Eq></Where>";
                            strCamlQuery = @"<Where><And><Eq><FieldRef Name='ID' /><Value Type='Counter'>-9999</Value></Eq>   <Or>
             <IsNull>
            <FieldRef Name='ToBeDeleted' />
             </IsNull><Eq>
            <FieldRef Name='ToBeDeleted' />
            <Value Type='Choice'>No</Value>
             </Eq>      </Or>
              </And></Where>";
                            #endregion
                        }
                        break;
                    }
                case CHAPTERPAGEREPORT:
                    {
                        strCamlQuery = @"<OrderBy><FieldRef Name='Page_Sequence' /></OrderBy><Where><And><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" +
                   strTerminated + "</Value></Eq><Eq><FieldRef Name='Chapter_ID'/><Value Type='Number'>" + HttpContext.Current.Request.QueryString["ChapterID"] + "</Value></Eq></And></Where>";
                        break;
                    }
                case TEMPLATEREPORT:
                    {
                        /// Title column in DWB Templates list is renamed to "Template_Name". the Internal name remains as "Title";
                        strCamlQuery = @"<OrderBy><FieldRef Name='Title' /></OrderBy><Where><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" + strTerminated + "</Value></Eq></Where>";
                        break;
                    }
                case TEMPLATEPAGESREPORT:
                    {
                        strCamlQuery = GetCAMLQueryForTemplatePages();
                        break;
                    }
                case USERREGISTRATION:
                    {
                        strCamlQuery = @"<OrderBy><FieldRef Name='DWBUserName' /></OrderBy><Where><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" + strTerminated + "</Value></Eq></Where>";
                        break;
                    }
                case TEAMREGISTRATION:
                    {
                        object objStoredPrivilege = CommonUtility.GetSessionVariable(Page, enumSessionVariable.UserPrivileges.ToString());
                        if (objStoredPrivilege != null)
                        {
                            Privileges objPrivileges = (Privileges)objStoredPrivilege;
                            if (objPrivileges != null)
                            {

                                if (objPrivileges.SystemPrivileges != null)
                                {
                                    if (objPrivileges.SystemPrivileges.AdminPrivilege)
                                    {
                                        /// Get all the teams from "DWB Team"
                                        strCamlQuery = @"<OrderBy><FieldRef Name='Title' /></OrderBy><Where><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" + strTerminated + "</Value></Eq></Where>";
                                    }
                                    else if (objPrivileges.SystemPrivileges.BookOwner)
                                    {
                                        /// Get the teams where loggedin user is member
                                        objCommonBLL = new CommonBLL();
                                        strCamlQuery = objCommonBLL.GetCAMLQueryForBOUsers(strSiteURL, "ID", "Counter", strTerminated,false);
                                    }
                                }

                            }
                        }

                        break;
                    }
                case STAFFREGISTRATION:
                    {
                        strCamlQuery = @"<OrderBy><FieldRef Name='Discipline' /><FieldRef Name='User_Rank' /></OrderBy><Where><Eq><FieldRef Name='Team_ID' /><Value Type='Number'>" + HttpContext.Current.Request.QueryString[IDVALUEQUERYSTRING] + "</Value></Eq></Where>";
                        break;
                    }
                case WELLBOOKREPORT:
                    {
                        strCamlQuery = string.Empty;
                        object objStoredPrivilege = CommonUtility.GetSessionVariable(Page, enumSessionVariable.UserPrivileges.ToString());
                        if (objStoredPrivilege != null)
                        {
                            Privileges objPrivileges = (Privileges)objStoredPrivilege;
                            if (objPrivileges != null && objPrivileges.SystemPrivileges != null)
                            {
                                if (objPrivileges.SystemPrivileges.AdminPrivilege)
                                {
                                    /// <Eq><FieldRef Name='ToBeDeleted' /><Value Type='Choice'>No</Value></Eq></And> is added.
                                    /// And condition added to the CAML query

               //                         strCamlQuery = @"<OrderBy><FieldRef Name='Title' /></OrderBy><Where><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" +
                                    //strTerminated + "</Value></Eq></Where>";
                                    #region DREAM 4.0 - eWB2.0 - Deletion Module
                                    strCamlQuery = @"<OrderBy><FieldRef Name='Title' /></OrderBy><Where><And><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" +
               strTerminated + "</Value></Eq><Or><IsNull><FieldRef Name='ToBeDeleted' /></IsNull><Eq><FieldRef Name='ToBeDeleted' /><Value Type='Choice'>No</Value></Eq></Or></And></Where>";
                                    #endregion
                                }
                                else if (objPrivileges.SystemPrivileges.BookOwner)
                                {
                                    /// Find the Team_IDs where user is member "DWB Team Staff" list
                                    /// and Get Only the Books where Team (DWB Books) == Team_Name(Title) in "DWB Team" list
                                    /// <TODO>
                                    /// Add the <Eq><FieldRef Name='ToBeDeleted' /><Value Type='Choice'>No</Value></Eq> at proper location
                                    /// </TODO>
                                    objCommonBLL = new CommonBLL();
                                    strCamlQuery = objCommonBLL.GetCAMLQueryForBOUsers(strSiteURL, "Team_ID", "Number", strTerminated,true);
                                }
                                else if (objPrivileges.SystemPrivileges.PageOwner || objPrivileges.SystemPrivileges.DWBUser)
                                {
                                    if (objPrivileges.FocalPoint != null && !string.IsNullOrEmpty(objPrivileges.FocalPoint.BookIDs))
                                    {
                                        objCommonUtility = new CommonUtility();
                                        /// Get only the Books where "Owner" = logged in user
                                        //strCamlQuery = @" <Where> <And><Eq><FieldRef Name='Owner' /><Value Type='Lookup'>" + objCommonUtility.GetUserName() + "</Value></Eq><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>No</Value></Eq></And></Where>";
                                        #region DREAM 4.0 - eWB2.0 - Deletion Module
                                        /// <Eq><FieldRef Name='ToBeDeleted' /><Value Type='Choice'>No</Value></Eq></And> is added.
                                        /// Another And condition added to the CAML query
                                        strCamlQuery = @" <Where><And> <Eq><FieldRef Name='Owner' /><Value Type='Lookup'>" + objCommonUtility.GetUserName() + "</Value></Eq><And><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>No</Value></Eq> <Or><IsNull><FieldRef Name='ToBeDeleted' /></IsNull><Eq><FieldRef Name='ToBeDeleted' /><Value Type='Choice'>No</Value></Eq></Or></And></And></Where>";
                                        #endregion
                                    }
                                }
                            }
                        }
                        break;
                    }
                case DWBHOME:
                    {
                        objCommonBLL = new CommonBLL();
                        strCamlQuery = @"<Where><Eq><FieldRef Name='Windows_User_ID' /><Value Type='Text'>" +
                         GetUserName() + "</Value></Eq></Where>";

                        DataTable dtListDetails = objCommonBLL.ReadList(strSiteURL, USERLIST, strCamlQuery);

                        string strFavoriteBooksIds = string.Empty;
                        if (dtListDetails.Rows.Count > 0)
                            strFavoriteBooksIds = Convert.ToString(dtListDetails.Rows[0]["FavoriteBooks"]);

                        ((HiddenField)FindControl("hdnUserFavorites")).Value = strFavoriteBooksIds;

                        RadioButtonList rdblFavorites = (RadioButtonList)FindControl("rdoFavourites");
                        if (rdblFavorites != null)
                        {
                            if (rdblFavorites.SelectedIndex == 0)
                            {
                                /// Get all the Books
                                /// strCamlQuery = @"<OrderBy><FieldRef Name='Title' /></OrderBy><Where><And><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>No</Value></Eq><Gt><FieldRef Name='NoOfActiveChapters' /><Value Type='Number'>0</Value></Gt></And></Where>";
                                #region DREAM 4.0 - eWB2.0 - Deletion Module
                                strCamlQuery = @"<OrderBy><FieldRef Name='Title' /></OrderBy><Where><And><And><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>No</Value></Eq>  <Or>
             <IsNull>
            <FieldRef Name='ToBeDeleted' />
             </IsNull>

            <Eq>
               <FieldRef Name='ToBeDeleted' />
               <Value Type='Choice'>No</Value>
            </Eq>
                </Or>
             </And><Gt><FieldRef Name='NoOfActiveChapters' /><Value Type='Number'>0</Value></Gt></And></Where>";
                                #endregion
                            }
                            else if (rdblFavorites.SelectedIndex == 1)
                            {
                                /// Get only Favourite Books
                                string[] strBookIds = strFavoriteBooksIds.Split(";".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
                                strCamlQuery = CreateCAMLQuery(strBookIds);
                            }
                        }
                        if (dtListDetails != null)
                        {
                            dtListDetails.Dispose();
                        }
                        break;
                    }
                default:
                    strCamlQuery = @"<OrderBy><FieldRef Name='Title' /></OrderBy><Where><Eq><FieldRef Name='Terminate_Status' /><Value Type='Choice'>" +
             strTerminated + "</Value></Eq></Where>";
                    break;

            }

            return strCamlQuery;
        }
Exemple #20
0
        /// <summary>
        /// Returns the array of selected Page Info objects.
        /// </summary>
        /// <param name="siteUrl">Site URL.</param>
        /// <param name="pageIds">PageIDs concatenated with "|".</param>
        /// <param name="chapterActualAssetValue">Actual Asset Value of Chapter.</param>
        /// <param name="columnName">Column Name of the Chapter.</param>
        /// <returns>ArrayList of PageInfo objects.</returns>
        public ArrayList SetSelectedPageInfo(string siteURL, string pageIds, string chapterActualAssetValue, string columnName)
        {
            /// Split the pageIds with "|" as splitter
            /// Format the CAML Query for the selected Pages
            /// Assign values to PageInfo object and add to Array list
            ArrayList arlPageInfo = null;
            PageInfo objPageInfo = null;
            string strCAMLQuery = string.Empty;
            string strViewFields = string.Empty;
            DataTable dtChapterPages = null;
            DataTable dtDocumentDetails = null;

            string strConnectionType = string.Empty;
            string strPageURL = string.Empty;
            string[] strConnectionTypeSplit = null;
            int intConnectionType = 0;
            if (!string.IsNullOrEmpty(pageIds) && pageIds.Length > 0)
            {
                objCommonBLL = new CommonBLL();
                strCAMLQuery = objCommonBLL.CreateCAMLQuery(pageIds, IDCOLUMN, IDCOLUMNTYPE);
                if (!string.IsNullOrEmpty(strCAMLQuery))
                {
                    strCAMLQuery = strCAMLQuery.Insert(0, "<OrderBy><FieldRef Name='Page_Sequence' Ascending='True'/></OrderBy>");
                }
                strViewFields = @"<FieldRef Name='Page_Sequence' /><FieldRef Name='ID' /><FieldRef Name='Title' /><FieldRef Name='Terminate_Status' /><FieldRef Name='Chapter_ID' /><FieldRef Name='Page_Name' /><FieldRef Name='Page_Actual_Name' /><FieldRef Name='Page_URL' /><FieldRef Name='Owner' /><FieldRef Name='Connection_Type' /><FieldRef Name='Sign_Off_Status' /><FieldRef Name='Asset_Type' />";
                objCommonDAL = new CommonDAL();
                dtChapterPages = objCommonDAL.ReadList(siteURL, CHAPTERPAGESMAPPINGLIST, strCAMLQuery, strViewFields);
                if (dtChapterPages != null && dtChapterPages.Rows.Count > 0)
                {
                    arlPageInfo = new ArrayList();
                    foreach (DataRow objDataRow in dtChapterPages.Rows)
                    {
                        objPageInfo = new PageInfo();
                        objPageInfo.PageID = objDataRow[IDCOLUMN].ToString();
                        objPageInfo.PageTitle = objDataRow["Page_Name"].ToString();
                        objPageInfo.PageActualName = objDataRow["Page_Actual_Name"].ToString();
                        objPageInfo.PageURL = objDataRow["Page_URL"].ToString();
                        if (objDataRow["Owner"] != null || objDataRow["Owner"] != DBNull.Value)
                        {
                            objPageInfo.PageOwner = objDataRow["Owner"].ToString();
                        }
                        strConnectionType = string.Empty;
                        strConnectionTypeSplit = null;
                        strConnectionType = objDataRow["Connection_Type"].ToString();
                        strConnectionTypeSplit = strConnectionType.Split("-".ToCharArray());
                        intConnectionType = 0;
                        if (strConnectionTypeSplit != null && strConnectionTypeSplit.Length > 0)
                        {
                            int.TryParse(strConnectionTypeSplit[0], out intConnectionType);
                        }
                        objPageInfo.ConnectionType = intConnectionType;
                        objPageInfo.SignOffStatus = objDataRow["Sign_Off_Status"].ToString();
                        objPageInfo.AssetType = objDataRow["Asset_Type"].ToString();
                        /// If connection type == 1, assign below properties
                        if (intConnectionType == 1)
                        {
                            objPageInfo.ActualAssetValue = chapterActualAssetValue;
                            objPageInfo.ColumnName = columnName;
                            /// Based on page URL assign "WellHistory/WellBoreHeader/Pre-Prod RFT"
                            /// DWBWellHistoryReport.aspx
                            /// DWBPreProductionRFT.aspx
                            /// DWBWellboreHeader.aspx
                            strPageURL = string.Empty;
                            strPageURL = objDataRow["Page_URL"].ToString();
                            if (string.Compare(strPageURL, "DWBWellHistoryReport.aspx", true) == 0)
                            {
                                objPageInfo.ReportName = WELLHISTORYREPORTNAME;
                            }
                            else if (string.Compare(strPageURL, "DWBPreProductionRFT.aspx", true) == 0)
                            {
                                objPageInfo.ReportName = PREPRODRFTREPORTNAME;
                            }
                            else if (string.Compare(strPageURL, "DWBWellboreHeader.aspx", true) == 0)
                            {
                                objPageInfo.ReportName = WELLBOREHEADERREPORTNAME;
                            }
                            else if (string.Compare(strPageURL, "WellSummary.aspx", true) == 0)
                            {
                                objPageInfo.ReportName = WELLSUMMARYRREPORTNAME;
                            }
                        }

                        //Added by Praveena for module "Add Last Updated date"
                        strCAMLQuery = objCommonBLL.CreateCAMLQuery(pageIds, "PageID", "Number");
                        strViewFields = @"<FieldRef Name='PageID' /><FieldRef Name='Modified' />";
                        if (intConnectionType == 3)
                        {
                            dtDocumentDetails = objCommonBLL.ReadList(siteURL, USERDEFINEDDOCUMENTLIST, strCAMLQuery, strViewFields);
                        }
                        else if (intConnectionType == 2)
                        {
                            dtDocumentDetails = objCommonBLL.ReadList(siteURL, PUBLISHEDDOCUMENTLIST, strCAMLQuery, strViewFields);
                        }
                        if (dtDocumentDetails != null && dtDocumentDetails.Rows.Count > 0)
                        {
                            foreach (DataRow dtRow in dtDocumentDetails.Rows)
                            {
                                objPageInfo.LastUpdatedDate = GetDateTime(dtRow["Modified"].ToString());
                            }
                        }

                        arlPageInfo.Add(objPageInfo);
                    }
                }
            }
            if (dtChapterPages != null)
            {
                dtChapterPages.Dispose();
            }
            return arlPageInfo;
        }
        /// <summary>
        /// Sets the book chapters attributes.
        /// </summary>
        /// <param name="dataRow">The data row.</param>
        /// <returns>ArrayList</returns>
        private ArrayList SetBookChaptersAttributes(DataRow dataRow)
        {
            ArrayList arlAttributes = null;
            try
            {
                arlAttributes = new ArrayList();

                arlAttributes.Add(CreateAttribute("Seq", Convert.ToString(dataRow["Chapter_Sequence"]), "true"));
                arlAttributes.Add(CreateAttribute("Chapter Name", Convert.ToString(dataRow["Title"]), "true"));
                arlAttributes.Add(CreateAttribute("Asset Type", Convert.ToString(dataRow["Asset_Type"]), "true"));
                string strCAMLQuery = @"<Where><Eq><FieldRef Name='ID'/><Value Type='ID'>" + dataRow["Template_ID"].ToString() + "</Value></Eq></Where>";
                string strViewFields = @"<FieldRef Name='ID'/><FieldRef Name='Title'/>";
                objCommonBLL = new CommonBLL();
                DataTable dtTemplate = objCommonBLL.ReadList(strSiteURL, TEMPLATELIST, strCAMLQuery, strViewFields);
                if (dtTemplate != null && dtTemplate.Rows.Count > 0)
                {
                    arlAttributes.Add(CreateAttribute("Template", Convert.ToString(dtTemplate.Rows[0]["Title"]), "true"));
                }
                else
                {
                    arlAttributes.Add(CreateAttribute("Template", string.Empty, "true"));
                }
                if (dtTemplate != null)
                {
                    dtTemplate.Dispose();
                }
                return arlAttributes;
            }
            catch
            {
                throw;
            }
        }
        /// <summary>
        /// Handles the Click event of the btnPrint control.
        /// </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 btnPrint_Click(object sender, EventArgs e)
        {
            string strAlertMessage = string.Empty;
            try
            {
                int intPrintedDocID = 0;
                string[] strPrintedDocURL = null;
                CommonBLL objCommonBLL = null;
                string strCamlQuery = string.Empty;
                PrintOptions objPrintOptions = new PrintOptions();

                //Set PrintOptions object properties through hidden fields
                objPrintOptions = SetPrintOptionsProperties(objPrintOptions);

                intPrintedDocID = Print(objPrintOptions, WELLBOOKVIEWERCONTROLBOOK, HttpContext.Current.Request.QueryString[MODEQUERYSTRING]);

                /// Open the generated document to show in IE
                if (intPrintedDocID > 0)
                {
                    objCommonBLL = new CommonBLL();
                    strCamlQuery = @"<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>" +
                   intPrintedDocID.ToString() + "</Value></Eq></Where>";
                    strPrintedDocURL = objCommonBLL.GetPrintedDocumentUrl(strParentSiteURL, PRINTEDDOCUMNETLIBRARY, strCamlQuery);
                    strAlertMessage = objCommonBLL.GetAlertMessage(strParentSiteURL, "Book");
                    this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "documentprinted", "alert('" + strAlertMessage + "');", true);
                }
                else if (intPrintedDocID == -1)
                {
                    this.Page.ClientScript.RegisterStartupScript(this.GetType(), HIDETABJSKEY, HIDETABJSPAGE);
                    this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "NoDocumentsFound", @"<Script language='javaScript'>alert('Please change the filter criteria');</Script>");
                }
                else
                {
                    this.Page.ClientScript.RegisterStartupScript(this.GetType(), HIDETABJSKEY, HIDETABJSPAGE);
                    this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "documentnotprinted", ALERTDOCUMENTNOTPRINTED, true);
                }
            }
            catch (System.Web.Services.Protocols.SoapException soapEx)
            {
                CommonUtility.HandleException(strParentSiteURL, soapEx, 1);
                lblException.Text = ALERTDOCUMENTNOTPRINTED;
                lblException.Visible = true;
                ExceptionBlock.Visible = true;
                PdfBLL objPdfBLL = new PdfBLL();
                objPdfBLL.PrintLog(strParentSiteURL, soapEx.StackTrace, soapEx.Message, "WellBookSummary.btnPrint_Click");

            }
            catch (WebException webEx)
            {
                CommonUtility.HandleException(strParentSiteURL, webEx, 1);
                lblException.Text = ALERTDOCUMENTNOTPRINTED;
                lblException.Visible = true;
                ExceptionBlock.Visible = true;
                PdfBLL objPdfBLL = new PdfBLL();
                objPdfBLL.PrintLog(strParentSiteURL, webEx.StackTrace, webEx.Message, "WellBookSummary.btnPrint_Click");

            }
            catch (Exception ex)
            {
                CommonUtility.HandleException(strParentSiteURL, ex, 1);
                lblException.Text = ALERTDOCUMENTNOTPRINTED;
                lblException.Visible = true;
                ExceptionBlock.Visible = true;
                PdfBLL objPdfBLL = new PdfBLL();
                objPdfBLL.PrintLog(strParentSiteURL, ex.StackTrace, ex.Message, "WellBookSummary.btnPrint_Click");

            }
            finally
            {
                this.Page.ClientScript.RegisterStartupScript(this.GetType(), HIDETABJSKEY, HIDETABJSPAGE);
            }
        }
        protected void DeleteListItem(int itemID,string reportName, string listName, string auditListName)
        {
            objCommonBLL = new CommonBLL();

            switch (reportName)
            {
                case WELLBOOKREPORT:
                case CHAPTERREPORT:
                    {
                        objCommonBLL.MarkItemToDelete(strSiteURL, listName, itemID);
                        break;
                    }
                case CHAPTERPAGEREPORT:
                    {
                        objCommonBLL.DeleteChapterPages(strSiteURL, itemID, string.Empty, listName, auditListName);
                        break;
                    }
                case TEMPLATEREPORT:
                    {
                        objCommonBLL.DeleteTemplate(strSiteURL, itemID, listName, auditListName);
                        break;
                    }
                case TEMPLATEPAGESREPORT:
                case MASTERPAGEREPORT:
                    {
                        objCommonBLL.DeleteListItemById(strSiteURL,itemID,listName,auditListName);
                        break;
                    }
                case USERREGISTRATION:
                    {
                        objCommonBLL.DeleteUser(strSiteURL,itemID,listName);
                        break;
                    }
                case TEAMREGISTRATION:
                    {
                        objCommonBLL.DeleteTeam(strSiteURL, itemID, listName, TEAMSTAFFLIST);
                        break;
                    }
            }
        }
        /// <summary>
        /// Loads default values 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (!Page.IsPostBack)
                {
                    if (HttpContext.Current.Request.QueryString["PageId"] != null)
                        hidPageId.Value = HttpContext.Current.Request.QueryString["PageId"];//.ToString();
                }
                //Added By Praveena
                //To get all File Types from List and passing to JavaScript
                DataTable dtListData = null;
                string strCamlQuery = @" <Where><IsNotNull><FieldRef Name='File_Type' /></IsNotNull></Where>";
                string strViewFields = string.Empty;
                strViewFields = @"<FieldRef Name='File_Type' />";
                objCommonBLL = new CommonBLL();
                dtListData = objCommonBLL.ReadList(strParentSiteURL, DWBFILETYPE, strCamlQuery, strViewFields);
                strFileTypes = new StringBuilder();
                for (int intRowIndex = 0; intRowIndex < dtListData.Rows.Count; intRowIndex++)
                {
                    strFileTypes.Append(Convert.ToString(dtListData.Rows[intRowIndex]["File_Type"]));
                    strFileTypes.Append("|");
                }
                btnUpload.OnClientClick = "javascript:return eWBValidateUpload('" + strFileTypes.ToString() + "')";
            }
            catch (WebException webEx)
            {

                RenderException(webEx.Message);
            }
            catch (Exception ex)
            {

                CommonUtility.HandleException(strParentSiteURL, ex);

            }
        }
        /// <summary>
        /// Gets the parent title for the selected item.
        /// </summary>
        /// <returns>Title of the selected item.</returns>
        protected string GetParentTitle()
        {
            string strTitle = string.Empty;
            string strCAMLQuery = string.Empty;
            string strFieldsToView = string.Empty;
            DataTable dtResultTable = null;
            switch (strReportName)
            {
                case TEMPLATEPAGESREPORT:
                    {
                        TemplateDetailBLL objTemplateDetail = new TemplateDetailBLL();
                        strCAMLQuery = @"<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>" + HttpContext.Current.Request.QueryString[IDVALUEQUERYSTRING] + "</Value></Eq></Where>";
                        ListEntry objTemplateListEntry = objTemplateDetail.GetTemplateDetail(strSiteURL, TEMPLATELIST, strCAMLQuery);
                        if (objTemplateListEntry != null && objTemplateListEntry.TemplateDetails != null)
                        {
                            strTitle = objTemplateListEntry.TemplateDetails.Title;
                        }
                        break;
                    }
                case STAFFREGISTRATION:
                    {
                        TeamStaffRegistrationBLL objTeamStaffRegistrationBLL = new TeamStaffRegistrationBLL();
                        ListEntry objTeamListEntry = objTeamStaffRegistrationBLL.GetTeamDetails(strSiteURL, HttpContext.Current.Request.QueryString[IDVALUEQUERYSTRING], TEAMLIST);
                        if (objTeamListEntry != null && objTeamListEntry.TeamDetails != null)
                        {
                            strTitle = objTeamListEntry.TeamDetails.TeamName;
                        }
                        break;
                    }
                case "Audit Trail":
                    {
                        if (HttpContext.Current.Request.QueryString["auditFor"] != null)
                            strTitle = HttpContext.Current.Request.QueryString["auditFor"];
                        else
                            strTitle = string.Empty;
                        break;
                    }
                case CHAPTERREPORT:
                case WELLBOOKPAGEVIEW:
                case CHAPTERPAGEMAPPINGREPORT:
                    {
                        strCAMLQuery = @"<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>" + HttpContext.Current.Request.QueryString["BookId"] + "</Value></Eq></Where>";
                        objCommonBLL = new CommonBLL();
                        strFieldsToView = "<FieldRef Name='ID'/><FieldRef Name='Title'/>";
                        dtResultTable = objCommonBLL.ReadList(strSiteURL, WELLBOOKLIST, strCAMLQuery, strFieldsToView);
                        if (dtResultTable != null && dtResultTable.Rows.Count > 0)
                        {
                            strTitle = Convert.ToString(dtResultTable.Rows[0]["Title"]);
                        }
                        break;
                    }

                case CHAPTERPAGEREPORT:
                    {

                        string strBookId = string.Empty;
                        strCAMLQuery = @"<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>" + HttpContext.Current.Request.QueryString["ChapterID"] + "</Value></Eq></Where>";
                        objCommonBLL = new CommonBLL();
                        strFieldsToView = "<FieldRef Name='Title'/><FieldRef Name='Book_ID'/>";
                        dtResultTable = objCommonBLL.ReadList(strSiteURL, CHAPTERLIST, strCAMLQuery, strFieldsToView);
                        if (dtResultTable != null && dtResultTable.Rows.Count > 0)
                        {
                            strTitle = Convert.ToString(dtResultTable.Rows[0]["Title"]);
                            strBookId = Convert.ToString(dtResultTable.Rows[0]["Book_ID"]);
                        }
                        if (!string.IsNullOrEmpty(strBookId))
                        {
                            strCAMLQuery = @"<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>" + strBookId + "</Value></Eq></Where>";

                            strFieldsToView = "<FieldRef Name='Title'/>";
                            dtResultTable = objCommonBLL.ReadList(strSiteURL, WELLBOOKLIST, strCAMLQuery, strFieldsToView);
                            if (dtResultTable != null && dtResultTable.Rows.Count > 0)
                            {
                                strTitle = strTitle + " ( " + Convert.ToString(dtResultTable.Rows[0]["Title"]) + " )";

                            }
                        }
                        break;
                    }
            }
            if (dtResultTable != null)
            {
                dtResultTable.Dispose();
            }
            return strTitle;
        }
Exemple #26
0
        /// <summary>
        /// Creates the chapter list XML incase of the preference xml 
        /// for the logged in user and selected book is not available in Doc Lib.
        /// </summary>
        /// <param name="wellBookDetails">The well book details.</param>
        /// <returns></returns>
        private XmlDocument CreateChapterListXml(XmlDocument wellBookDetails)
        {
            XmlDocument chapterListXml = new XmlDocument();
            CommonBLL objCommonBLL = new CommonBLL();
            if (wellBookDetails != null)
            {
                XmlNodeList xmlChapterNodes = wellBookDetails.SelectNodes("/BookInfo/Chapter");
                ChapterInfo objChapterInfo;
                BookInfo objBookInfo = new BookInfo();
                objBookInfo.BookName = wellBookDetails.SelectSingleNode("/BookInfo").Attributes["BookName"].Value;
                objBookInfo.BookID = wellBookDetails.SelectSingleNode("/BookInfo").Attributes["BookID"].Value;
                System.Collections.ArrayList arlChapters = new System.Collections.ArrayList();
                foreach (XmlNode xmlChapterNode in xmlChapterNodes)
                {
                    objChapterInfo = new ChapterInfo();
                    objChapterInfo.ChapterTitle = xmlChapterNode.Attributes["ChapterTitle"].Value;
                    objChapterInfo.ChapterID = xmlChapterNode.Attributes["ChapterID"].Value;
                    objChapterInfo.Display = true;
                    arlChapters.Add(objChapterInfo);
                }

                objBookInfo.Chapters = arlChapters;

                chapterListXml = objCommonBLL.CreateWellBookDetailXML(objBookInfo);
            }
            return chapterListXml;
        }
        /// <summary>
        /// Terminates the list element.
        /// </summary>
        /// <param name="strListName">Name of the STR list.</param>
        /// <param name="rowId">The row id.</param>
        /// <param name="strAuditListName">Name of the STR audit list.</param>
        protected void TerminateListElement(string listName, int rowId, string auditListName)
        {
            objCommonBLL = new CommonBLL();
            string strSequenceField = string.Empty;
            if (string.Equals(ListName, CHAPTERLIST))
            {
                strSequenceField = "Chapter_Sequence";
            }
            else
            {
                strSequenceField = "Page_Sequence";
            }
            if (string.Equals(ListName, CHAPTERLIST))
            {
                objCommonBLL.UpdateListItemStatus(strSiteURL, ListName, rowId, AuditListName, AUDIT_ACTION_TERMINATE, STATUS_TERMINATED, strSequenceField);
                objCommonBLL.ListItemStatusUpdateForChapterPages(strSiteURL, CHAPTERPAGEMAPPINGLIST, rowId, STATUS_TERMINATED);

            }
            else if (string.Equals(ListName, MASTERPAGELIST) || string.Equals(ListName, CHAPTERPAGEMAPPINGLIST))
            {
                objCommonBLL.UpdateListItemStatus(strSiteURL, ListName, rowId, AuditListName, AUDIT_ACTION_TERMINATE, STATUS_TERMINATED, strSequenceField);
            }
            else if (string.Equals(ListName, WELLBOOKLIST) || string.Equals(ListName, TEMPLATELIST))
            {
                objCommonBLL.TerminateListValues(strSiteURL, listName, rowId, auditListName, false, true);
            }
            else if (string.Equals(ListName, USERLIST) || string.Equals(ListName, TEAMLIST) || string.Equals(ListName, TEAMSTAFFLIST))
            {
                objCommonBLL.TerminateListValues(strSiteURL, listName, rowId, auditListName, false, false);
            }
            else
            {
                objCommonBLL.TerminateListValues(strSiteURL, listName, rowId, auditListName, true, true);
            }
        }
Exemple #28
0
        /// <summary>
        /// Gets the well book detail XML.
        /// </summary>
        /// <param name="action">The action.</param>
        /// <returns></returns>
        private XmlDocument GetWellBookDetailXML(string action)
        {
            XmlDocument xmlWellBookDetails = null;
            string strBookID = string.Empty;
            string strChapterID = string.Empty;
            if (HttpContext.Current.Request.QueryString[QUERYSTRING_BOOKID] != null)
            {
                strBookID = HttpContext.Current.Request.QueryString[QUERYSTRING_BOOKID];
            }
            if (strBookID.Length > 0)
            {
                WellBookBLL objWellBookBLL = new WellBookBLL();
                PrintOptions objPrintOptions = new PrintOptions();
                objPrintOptions.IncludeBookTitle = false;
                objPrintOptions.IncludePageTitle = false;
                objPrintOptions.IncludeStoryBoard = false;

                BookInfo objBookInfo = objWellBookBLL.SetBookDetailDataObject(strParentSiteURL, strBookID, action, true, objPrintOptions);
                CommonBLL objCommonBLL = new CommonBLL();
                HttpContext.Current.Session[SESSION_TREEVIEWDATAOBJECT] = objBookInfo;
                if (HttpContext.Current.Request.QueryString[QUERYSTRING_IDVALUE] != null)
                {
                    strChapterID = HttpContext.Current.Request.QueryString[QUERYSTRING_IDVALUE];
                }
                if (HttpContext.Current.Request.QueryString[QUERYSTRING_CHAPTERID] != null)
                {
                    strChapterID = HttpContext.Current.Request.QueryString[QUERYSTRING_CHAPTERID];
                }
                xmlWellBookDetails = objCommonBLL.CreateWellBookDetailXML(objBookInfo);
            }
            return xmlWellBookDetails;
        }
        /// <summary>
        /// Transforms the list detail.
        /// </summary>
        /// <param name="listType">Type of the list.</param>
        /// <param name="noOfRecords">The no of records.</param>
        protected void TransformListDetail(int noOfRecords)
        {
            XmlTextReader xmlTextReader = null;
            XslTransform xslTransform = null;
            XmlDocument objXmlDocForXSL = null;
            XsltArgumentList xsltArgsList = null;
            XPathDocument objXPathDocument = null;
            MemoryStream objMemoryStream = null;
            int intrecordsPerPage = 0;
            int intPageNumber = 0;
            int intMaxPages = 5;
            int intCurrentPage = 1;
            string strSortBy = string.Empty;
            string strSortType = string.Empty;
            object objSessionUserPreference = null;
            Shell.SharePoint.DREAM.Business.Entities.UserPreferences objPreferences = null;
            try
            {
                objCommonBLL = new CommonBLL();
                xmlTextReader = objCommonBLL.GetXSLTemplate("List Viewer", strSiteURL);
                if (xmlListDocument != null && xmlTextReader != null)
                {
                    xslTransform = new XslTransform();
                    XslCompiledTransform xslTransformTest = new XslCompiledTransform();
                    objXmlDocForXSL = new XmlDocument();
                    xsltArgsList = new XsltArgumentList();
                    objMemoryStream = new MemoryStream();
                    xmlListDocument.Save(objMemoryStream);
                    objMemoryStream.Position = 0;
                    objXPathDocument = new XPathDocument(objMemoryStream);

                    /// Inititlize the XSL
                    objXmlDocForXSL.Load(xmlTextReader);
                    xslTransform.Load(objXmlDocForXSL);

                    xsltArgsList.AddParam("historyColumn", string.Empty, IsExpandCollapseApplicable.ToString());
                    xsltArgsList.AddParam("editColumn", string.Empty, IsEditApplicable.ToString());
                    if (ActiveStatus)
                    {
                        xsltArgsList.AddParam("listItemAction", string.Empty, STATUSTERMINATE);
                    }
                    else
                    {
                        xsltArgsList.AddParam("listItemAction", string.Empty, STATUSACTIVATE);
                    }
                    xsltArgsList.AddParam("addMasterLinkColumn", string.Empty,
                        IsAddMasterApplicable.ToString());
                    xsltArgsList.AddParam("viewMasterLinkColumn", string.Empty,
                        IsViewMasterApplicable.ToString());
                    xsltArgsList.AddParam("listType", string.Empty, ListReportName);
                    xsltArgsList.AddParam("activeStatus", string.Empty, ActiveStatus.ToString().ToLower());
                    /// <!-- Set the number of records per page-->
                    /// <xsl:param name="recordsPerPage" select="0" />
                    objSessionUserPreference = CommonUtility.GetSessionVariable(Page, enumSessionVariable.UserPreferences.ToString());
                    if (objSessionUserPreference != null)
                    {
                        objPreferences = (Shell.SharePoint.DREAM.Business.Entities.UserPreferences)objSessionUserPreference;
                        intrecordsPerPage = Convert.ToInt32(objPreferences.RecordsPerPage);
                    }
                    xsltArgsList.AddParam("recordsPerPage", string.Empty, intrecordsPerPage);
                    xsltArgsList.AddParam("AuditListName", string.Empty, AuditListName);

                    if (!(string.Compare(ListReportName, WELLBOOKPAGEVIEW, true) == 0))
                    {
                        /// <!-- Page Number field -->
                        /// <xsl:param name="pageNumber" select="1" />
                        if (HttpContext.Current.Request.QueryString["pageNumber"] != null)
                        {
                            intPageNumber = Int32.Parse(HttpContext.Current.Request.QueryString["pageNumber"]);
                            if (blnInitializePageNumber)
                                intPageNumber = 0;
                        }
                        if (HttpContext.Current.Request.QueryString["sortBy"] != null)
                        {
                            strSortBy = HttpContext.Current.Request.QueryString["sortBy"];
                        }

                        if (HttpContext.Current.Request.QueryString["sortType"] != null)
                        {
                            strSortType = HttpContext.Current.Request.QueryString["sortType"];
                        }
                        else
                        {
                            strSortType = "descending";
                        }

                    }
                    else
                    {
                        intPageNumber = string.IsNullOrEmpty(pageNumber) ? 0 : Convert.ToInt32(pageNumber);
                        sortType = string.Equals(sortType, "ASC") ? "ascending" : "descending";
                        xsltArgsList.AddParam("sortBy", string.Empty, sortBy);
                        xsltArgsList.AddParam("sortType", string.Empty, sortType);
                        if (!(string.IsNullOrEmpty(sortBy)) && !(string.IsNullOrEmpty(sortBy)))
                        {
                            strSortBy = sortBy;
                        }

                    }

                    int intNoofPages = 0;
                    if (intrecordsPerPage > 0)
                    {
                        intNoofPages = noOfRecords / intrecordsPerPage;
                    }
                    if (intPageNumber > intNoofPages)
                    {
                        intPageNumber--;
                    }

                    xsltArgsList.AddParam("pageNumber", string.Empty, intPageNumber);

                    xsltArgsList.AddParam("recordCount", string.Empty, noOfRecords);
                    intMaxPages = 5;
                    xsltArgsList.AddParam("MaxPages", string.Empty, intMaxPages);
                    intCurrentPage = intPageNumber;
                    xsltArgsList.AddParam("CurrentPage", string.Empty, intPageNumber);
                    if (!string.IsNullOrEmpty(HttpContext.Current.Request.Url.Query))
                    {
                        objCommonUtility = new CommonUtility();
                        string strURL = GetCurrentPageName(true);
                        xsltArgsList.AddParam("CurrentPageName", string.Empty, strURL);
                    }
                    else
                    {
                        xsltArgsList.AddParam("CurrentPageName", string.Empty, HttpContext.Current.Request.Url.AbsolutePath + "?");
                    }
                    if (!(string.Compare(ListReportName, WELLBOOKPAGEVIEW, true) == 0))
                    {
                        xsltArgsList.AddParam("sortBy", string.Empty, strSortBy);
                        xsltArgsList.AddParam("sortType", string.Empty, strSortType);
                    }

                    XmlNode xmlNode = xmlListDocument.SelectSingleNode("records/record/recordInfo/attribute[@name='" + strSortBy + "']");
                    if (xmlNode != null)
                    {
                        xsltArgsList.AddParam("sortDataType", string.Empty, xmlNode.Attributes["datatype"].Value);
                    }
                    #region DREAM 4.0 - eWB 2.0 - AJAX Implemenation
                    //  xslTransform.Transform(objXPathDocument, xsltArgsList, HttpContext.Current.Response.Output);

                    StringBuilder builder = new StringBuilder();
                    StringWriter stringWriter = new StringWriter(builder);
                    xslTransform.Transform(objXPathDocument, xsltArgsList, stringWriter);
                    strResultTable = stringWriter.GetStringBuilder();
                    #endregion
                }
                else
                {
                    throw new Exception("Invalid Arguments");
                }
            }
            catch
            {
                throw;
            }
            finally
            {
                if (objMemoryStream != null)
                {
                    objMemoryStream.Close();
                    objMemoryStream.Dispose();
                }
            }
        }
        /// <summary>
        /// This method binds the values to DropDownLists
        /// </summary>
        /// <param name="cboList">DropDownListID</param>
        private void BindDropDown(DropDownList cboList)
        {
            DataTable dtListData = null;
            try
            {
                if (cboList.ID == "cboFileType")
                {
                    cboList.Items.Clear();
                    string strCamlQuery = @" <Where><IsNotNull><FieldRef Name='File_Type' /></IsNotNull></Where>";
                    string strViewFields = string.Empty;
                    strViewFields = @"<FieldRef Name='ID' /><FieldRef Name='File_Type' />";
                    objCommonBLL = new CommonBLL();
                    dtListData = objCommonBLL.ReadList(strParentSiteURL, DWBFILETYPE, strCamlQuery, strViewFields);
                    if (dtListData != null && dtListData.Rows.Count > 0)
                    {
                        cboList.DataSource = dtListData;
                        cboList.DataValueField = "ID";
                        cboList.DataTextField = "File_Type";
                        cboList.DataBind();
                    }
                }
                else
                {
                    cboList.Items.Clear();
                    string strCamlQuery = @" <Where><IsNotNull><FieldRef Name='Title' /></IsNotNull></Where>";
                    string strViewFields = string.Empty;
                    strViewFields = @"<FieldRef Name='Actual_Naming_Convention' /><FieldRef Name='Title' />";
                    objCommonBLL = new CommonBLL();
                    dtListData = objCommonBLL.ReadList(strParentSiteURL, DWBDOCUMENTNAMINGCONVENTION, strCamlQuery, strViewFields);
                    if (dtListData != null && dtListData.Rows.Count > 0)
                    {
                        cboList.DataSource = dtListData;
                        cboList.DataValueField = "Actual_Naming_Convention";
                        cboList.DataTextField = "Title";
                        cboList.DataBind();
                    }
                }
            }

            catch (WebException webEx)
            {
                lblException.Text = webEx.Message;
                lblException.Visible = true;
                ExceptionBlock.Visible = true;
            }
            finally
            {
                if (dtListData != null)
                    dtListData.Dispose();
            }
        }