/// <summary>
/// Updates the list item.
/// </summary>
/// <param name="listValues">The list values.</param>
/// <param name="listName">Name of the list.</param>
public string UpdateListItem(Dictionary<string, string> listValues, string listName)
{
Common objCommon = null;
try
{
objCommon = new Common();
return objCommon.UpdateListItem(listValues, listName);
}
catch
{
throw;
}
}
/// <summary>
/// Reads the XML file from share point.
/// </summary>
/// <param name="currentSiteUrl">The current site URL.</param>
/// <param name="listName">Name of the list.</param>
/// <param name="query">The query.</param>
/// <returns></returns>
public XmlDocument ReadXmlFileFromSharePoint(string currentSiteUrl, string listName, string query)
{
Common objCommon = null;
try
{
objCommon = new Common();
return objCommon.ReadXmlFileFromSharePoint(currentSiteUrl, listName, query);
}
catch
{
throw;
}
}
/// <summary>
/// Saves the date format.
/// </summary>
/// <param name="key">The key.</param>
/// <param name="value">The value.</param>
public void SaveDateFormat(string key, string value, Dictionary<string, string> configItems)
{
Common objCommon = null;
try
{
objCommon = new Common();
objCommon.SaveDateFormat(key, value, configItems);
}
catch(Exception)
{
throw;
}
}
/// <summary>
/// Reads the list.
/// </summary>
/// <param name="parentSiteUrl">The parent site URL.</param>
/// <param name="listName">Name of the list.</param>
/// <param name="queryString">The query string.</param>
/// <param name="viewFields">The view fields.</param>
/// <returns></returns>
public DataTable ReadList(String parentSiteUrl, String listName, String queryString, string viewFields)
{
DataTable objDataTable = null;
Common objCommon = null;
try
{
objDataTable = new DataTable();
objCommon = new Common();
//Reads the sharepoint List
if(queryString.Length == 0)
{
objDataTable = objCommon.ReadList(parentSiteUrl, listName);
}
else
{
objDataTable = objCommon.ReadList(parentSiteUrl, listName, queryString, viewFields);
}
}
catch(Exception)
{
throw;
}
finally
{
if(objDataTable != null)
objDataTable.Dispose();
}
return objDataTable;
}
/// <summary>
/// Deletes the list item.
/// </summary>
/// <param name="listName">Name of the list.</param>
/// <param name="itemId">The item id.</param>
public void DeleteListItem(string listName, string itemId)
{
Common objCommon = null;
try
{
objCommon = new Common();
objCommon.DeleteListItem(listName, itemId);
}
catch
{
throw;
}
}
/// <summary>
/// Determines whether [is request exist] [the specified parent site URL].
/// </summary>
/// <param name="parentSiteURL">The parent site URL.</param>
/// <param name="strUserID">The STR user ID.</param>
/// <returns>
/// <c>true</c> if [is request exist] [the specified parent site URL]; otherwise, <c>false</c>.
/// </returns>
public bool IsRequestExist(string parentSiteURL, string userID)
{
DataTable objListData = null;
string strCamlQuery = string.Empty;
Common objCommon = null;
try
{
objCommon = new Common();
strCamlQuery = "<OrderBy><FieldRef Name=\"LinkTitleNoMenu\" /></OrderBy><Where><And><Eq><FieldRef Name=\"LinkTitle\" /><Value Type=\"Computed\">" + userID + "</Value></Eq><Eq><FieldRef Name=\"Access_x0020_Approval_x0020_Stat\" /><Value Type=\"Choice\">Approved</Value></Eq></And></Where>";
objListData = objCommon.ReadList(parentSiteURL, "User Access Request", strCamlQuery);
if(objListData.Rows.Count > 0)
{
return true;
}
else
{
return false;
}
}
catch(Exception)
{
throw;
}
finally
{
if(objListData != null)
objListData.Dispose();
}
}
/// <summary>
/// Reads the list.
/// </summary>
/// <param name="parentSiteUrl">The parent site URL.</param>
/// <param name="listName">Name of the list.</param>
/// <param name="queryString">The query string.</param>
/// <returns>Gives the filtered row of a list</returns>
public DataTable ReadFolderList(String parentSiteUrl, String listName, String queryString)
{
DataTable objDataTable = null;
Common objCommon = null;
try
{
objDataTable = new DataTable();
objCommon = new Common();
//Reads the sharepoint List
if(queryString.Length == 0)
{
objDataTable = objCommon.ReadFolderList(parentSiteUrl, listName, queryString);
}
else
{
objDataTable = objCommon.ReadFolderList(parentSiteUrl, listName, queryString);
}
}
catch(Exception)
{
throw;
}
return objDataTable;
}
/// <summary>
/// Gets the XSL template.
/// </summary>
/// <param name="strType">type</param>
/// <param name="strParentSiteUrl">parent site url.</param>
/// <returns></returns>
public XmlTextReader GetXSLTemplate(string type, string parentSiteUrl)
{
XmlTextReader objXmlTextReader = null;
Common objCommon = null;
try
{
objCommon = new Common();
//Get the XSLTemplate from sharepoint list
objXmlTextReader = objCommon.GetXSLTemplate(type, parentSiteUrl);
}
catch(Exception)
{
throw;
}
return objXmlTextReader;
}
/// <summary>
/// Gets the userpreferences value.
/// </summary>
/// <returns></returns>
public UserPreferences GetUserPreferencesValue(string userID, string parentSiteURL)
{
Common objCommon = null;
UserPreferences objPreferences = null;
UserPreferenceHandler objUserPreferenceHandler = null;
DataTable objDefaultPreferences = null;
try
{
objCommon = new Common();
objPreferences = new UserPreferences();
objUserPreferenceHandler = new UserPreferenceHandler();
objPreferences = objUserPreferenceHandler.GetUserPreferences(userID);
if(objPreferences != null)
{
return objPreferences;
}
else
{
//Read 'Default Preferences' list and set to the object
objDefaultPreferences = new DataTable();
objPreferences = new UserPreferences();
objDefaultPreferences = objCommon.ReadList(parentSiteURL, DEFAULTPREFERENCESLIST);
foreach(DataRow objDataRow in objDefaultPreferences.Rows)
{
if(string.Equals(objDataRow["Title"].ToString(), "Display"))
{
objPreferences.Display = objDataRow["Default_x0020_Value"].ToString();
}
else if(string.Equals(objDataRow["Title"].ToString(), "DepthUnits"))
{
objPreferences.DepthUnits = objDataRow["Default_x0020_Value"].ToString();
}
else if(string.Equals(objDataRow["Title"].ToString(), "RecordsPerPage"))
{
objPreferences.RecordsPerPage = objDataRow["Default_x0020_Value"].ToString();
}
}
return objPreferences;
}
}
catch(Exception)
{
throw;
}
finally
{
if(objDefaultPreferences != null)
objDefaultPreferences.Dispose();
}
}
/// <summary>
/// Gets the chached list items.
/// </summary>
/// <param name="currentSiteUrl">The current site URL.</param>
/// <param name="listName">Name of the list.</param>
/// <param name="spQuery">The sp query.</param>
/// <returns></returns>
public SiteMapNodeCollection GetChachedListItems(string currentSiteUrl, string listName, SPQuery spQuery)
{
Common objCommon = new Common();
return objCommon.GetChachedListItems(currentSiteUrl, listName, spQuery);
}
/// <summary>
/// Deletes the file.
/// </summary>
/// <param name="currentSiteUrl">The current site URL.</param>
/// <param name="docLibName">Name of the doc lib.</param>
/// <param name="fileName">Name of the file.</param>
/// <returns></returns>
public bool DeleteXMLFile(string currentSiteUrl, string docLibName, string fileName)
{
Common objCommon = new Common();
return objCommon.DeleteXMLFile(currentSiteUrl, docLibName, fileName);
}
/// <summary>
/// Determines whether the logged in user is a valid user or not.
/// </summary>
/// <param name="parentSiteURL">The parent site URL.</param>
/// <param name="strUserID">Logged in userID.</param>
/// <returns>
/// <c>true</c> if the logged in user is a valid User; otherwise, <c>false</c>.
/// </returns>
public bool IsValidUser(string parentSiteURL, string userID)
{
#region Method Variables
string strCompanyCode = string.Empty;
string strCountryCode = string.Empty;
string[] arrUserDetails = new string[2];
string strCAMLQuery = string.Empty;
string strCompanyCountryCode = string.Empty;
bool blnStatus = false;
DataTable objListData = null;
DataTable objCompanyList = null;
Common objCommon = null;
#endregion
try
{
objListData = new DataTable();
objCompanyList = new DataTable();
objCommon = new Common();
userID = objUtility.GetUserName();
try
{
strCompanyCountryCode = objADService.GetCompanyCountryCode(userID).ToString();
if (strCompanyCountryCode.Length > 0)
arrUserDetails = strCompanyCountryCode.Split('|');
else
arrUserDetails = null;
}
catch (Exception Ex)
{
CommonUtility.HandleException(HttpContext.Current.Request.Url.ToString(), Ex, 5);
}
if (arrUserDetails != null)
{
if (arrUserDetails[0] != null)
strCountryCode = arrUserDetails[0];
if (arrUserDetails[1] != null)
strCompanyCode = arrUserDetails[1];
strCAMLQuery = "<OrderBy><FieldRef Name=\"Title\" /></OrderBy><Where><Eq>"
+ "<FieldRef Name=\"Title\" /><Value Type=\"Text\">" + strCountryCode
+ "</Value></Eq></Where>";
objListData = objCommon.ReadList(parentSiteURL, COUNTRYCODELIST, strCAMLQuery);
strCAMLQuery = "<OrderBy><FieldRef Name=\"Title\" /></OrderBy><Where><Eq>"
+ "<FieldRef Name=\"Title\"/><Value Type=\"Text\">" + strCompanyCode
+ "</Value></Eq></Where>";
objCompanyList = objCommon.ReadList(parentSiteURL, COMPANYCODELIST, strCAMLQuery);
//if both the Country & Company code of logged in user's exist in SP list..
if ((objListData.Rows.Count > 0) && (objCompanyList.Rows.Count > 0))
{
blnStatus = true;
}
else
{
objListData.Clear();
strCAMLQuery = "<OrderBy><FieldRef Name=\"Title\" /></OrderBy><Where><And><And><Eq>"
+ "<FieldRef Name=\"Active\" /><Value Type=\"Text\">Yes</Value></Eq>"
+ "<Eq><FieldRef Name=\"Title\" /><Value Type=\"Text\">"
+ userID + "</Value></Eq></And><Eq><FieldRef Name=\"Access_x0020_Approval_x0020_Stat\" /><Value Type=\"Choice\">Approved</Value></Eq></And></Where>";
objListData = objCommon.ReadList(parentSiteURL, USERACCESSREQUESTLIST, strCAMLQuery);
if (objListData.Rows.Count > 0)
{
blnStatus = true;
}
else
{
blnStatus = false;
}
}
}
else
{
objListData.Clear();
strCAMLQuery = "<OrderBy><FieldRef Name=\"Title\" /></OrderBy><Where><And><And><Eq>"
+ "<FieldRef Name=\"Active\" /><Value Type=\"Text\">Yes</Value></Eq>"
+ "<Eq><FieldRef Name=\"Title\" /><Value Type=\"Text\">"
+ userID + "</Value></Eq></And><Eq><FieldRef Name=\"Access_x0020_Approval_x0020_Stat\" /><Value Type=\"Choice\">Approved</Value></Eq></And></Where>";
objListData = objCommon.ReadList(parentSiteURL, USERACCESSREQUESTLIST, strCAMLQuery);
if (objListData.Rows.Count > 0)
{
blnStatus = true;
}
else
{
blnStatus = false;
}
}
return blnStatus;
}
catch (Exception)
{
throw;
}
finally
{
if (objListData != null)
objListData.Dispose();
if (objCompanyList != null)
objCompanyList.Dispose();
}
}