/// <summary>
/// Get language list
/// </summary>
/// <param name="requestParam"></param>
/// <returns></returns>
public string AdminGetAllLanguageList()
{
string RetVal = string.Empty;
string LanguageFile = string.Empty;
XmlDocument XmlDoc;
XmlNodeList LngCodeList;
DataTable DtLanguage;
HTMLTableGenerator TableGenerator;
try
{
DtLanguage = new DataTable();
DtLanguage.Columns.Add("LngId");
DtLanguage.Columns.Add("Language Name");
DtLanguage.Columns.Add("Language Code");
DtLanguage.Columns.Add("Page Direction");
LanguageFile = Path.Combine(HttpContext.Current.Request.PhysicalApplicationPath, ConfigurationManager.AppSettings[Constants.WebConfigKey.LanguageFile]);
XmlDoc = new XmlDocument();
XmlDoc.Load(LanguageFile);
LngCodeList = XmlDoc.SelectNodes("/" + Constants.XmlFile.Language.Tags.Root + "/child::node()");
foreach (XmlNode xNode in LngCodeList)
{
DataRow Row;
Row = DtLanguage.NewRow();
Row[0] = xNode.Attributes[Constants.XmlFile.Language.Tags.LanguageAttributes.Code].Value;
Row[1] = xNode.Attributes[Constants.XmlFile.Language.Tags.LanguageAttributes.Name].Value;
Row[2] = xNode.Attributes[Constants.XmlFile.Language.Tags.LanguageAttributes.Code].Value;
Row[3] = xNode.Attributes[Constants.XmlFile.Language.Tags.LanguageAttributes.RTLDirection].Value == "T" ? "rtl" : "ltr";
DtLanguage.Rows.Add(Row);
}
TableGenerator = new HTMLTableGenerator();
TableGenerator.RowDisplayType = HTMLTableGenerator.DisplayType.RadioButtonType;
RetVal = TableGenerator.GetTableHmtl(DtLanguage, "LngId", "Lng", true);
}
catch (Exception ex)
{
Global.CreateExceptionString(ex, null);
}
return RetVal;
}
/// <summary>
/// Get required database details for editing
/// </summary>
/// <param name="requestParam"></param>
/// <returns></returns>
public string AdminGetAllDbConnections(string requestParam)
{
string RetVal = string.Empty;
string CategoryName = string.Empty;
string DBFile = string.Empty;
XmlDocument XmlDoc;
XmlNode xmlNode;
DataTable DtDatabase;
HTMLTableGenerator TableGenerator;
int i = 0;
string DefDbNId = string.Empty;
string ConnStr = string.Empty;
string DbType = string.Empty;
string DbTypeStr = string.Empty;
// string DefalutStr = string.Empty;
try
{
CategoryName = requestParam;
DefDbNId = Global.GetDefaultDbNId();
DtDatabase = new DataTable();
DtDatabase.Columns.Add("DbId");
DtDatabase.Columns.Add("Connection Name");
DtDatabase.Columns.Add("Database NId");
DtDatabase.Columns.Add("Database Type");
DtDatabase.Columns.Add("Created On");
// DtDatabase.Columns.Add("Default");
DBFile = Path.Combine(HttpContext.Current.Request.PhysicalApplicationPath, ConfigurationManager.AppSettings[Constants.WebConfigKey.DBConnectionsFile]);
XmlDoc = new XmlDocument();
XmlDoc.Load(DBFile);
xmlNode = XmlDoc.SelectSingleNode("/" + Constants.XmlFile.Db.Tags.Root + "/" + Constants.XmlFile.Db.Tags.Category + "[@" + Constants.XmlFile.Db.Tags.CategoryAttributes.Name + "='" + CategoryName + "']");
for (i = 0; i < xmlNode.ChildNodes.Count; i++)
{
if (xmlNode.ChildNodes[i].Attributes[Constants.XmlFile.Db.Tags.DatabaseAttributes.SDMXDb].Value.ToLower() == "false")
{
DataRow Row;
Row = DtDatabase.NewRow();
Row[0] = xmlNode.ChildNodes[i].Attributes[Constants.XmlFile.Db.Tags.DatabaseAttributes.Id].Value;
Row[1] = xmlNode.ChildNodes[i].Attributes[Constants.XmlFile.Db.Tags.DatabaseAttributes.Name].Value;
Row[2] = xmlNode.ChildNodes[i].Attributes[Constants.XmlFile.Db.Tags.DatabaseAttributes.Id].Value;
ConnStr = xmlNode.ChildNodes[i].Attributes[Constants.XmlFile.Db.Tags.DatabaseAttributes.DatabaseConnection].Value;
if (!string.IsNullOrEmpty(ConnStr))
{
DbType = Global.SplitString(ConnStr, "||")[0];
}
if (DbType == "0")
{
DbTypeStr = "Sql Server";
}
else if (DbType == "3")
{
DbTypeStr = "My Sql";
}
else if (DbType == "8")
{
DbTypeStr = "Firebird";
}
else
{
DbTypeStr = "";
}
Row[3] = DbTypeStr;
Row[4] = xmlNode.ChildNodes[i].Attributes[Constants.XmlFile.Db.Tags.DatabaseAttributes.LastModified].Value;
DtDatabase.Rows.Add(Row);
}
}
TableGenerator = new HTMLTableGenerator();
TableGenerator.RowDisplayType = HTMLTableGenerator.DisplayType.RadioButtonType;
RetVal = TableGenerator.GetTableHmtl(DtDatabase, "DbId", "db", true);
}
catch (Exception ex)
{
//Global.WriteErrorsInLog("Getting all database connection");
//Global.WriteErrorsInLog(ex.StackTrace);
//Global.WriteErrorsInLog(ex.Message);
Global.CreateExceptionString(ex, null);
}
return RetVal;
}
public string GetAllUsers(string requestParam)
{
string RetVal = string.Empty;
int AdapNId;
string[] Params;
string sortExp = "";
HTMLTableGenerator TableGenerator;
try
{
Params = Global.SplitString(requestParam, Constants.Delimiters.ParamDelimiter);
AdapNId = int.Parse(Params[0]);
int CurrentPage = int.Parse(Params[1]);
if (Params.Length > 1)
{
sortExp = Params[3].ToString() + " " + Params[2].ToString();
}
DataSet dsUsers = new DataSet();
AdaptationUsers.AdaptationUsers UserLoginService = new AdaptationUsers.AdaptationUsers();
UserLoginService.Url = ConfigurationManager.AppSettings[Constants.WebConfigKey.DiWorldWide4] + Constants.WSQueryStrings.AdaptationUserWebService;
dsUsers = UserLoginService.GetGlobalUsers(AdapNId);
DataTable dtUsers = dsUsers.Tables[0].Clone();
for (int i = ((CurrentPage - 1) * Convert.ToInt32(Global.AdapUserPageSize)) + 1; i <= (CurrentPage * Convert.ToInt32(Global.AdapUserPageSize)); i++)
{
if (i <= dsUsers.Tables[0].Rows.Count)
{
DataRow newRow = dsUsers.Tables[0].Rows[i - 1];
dtUsers.ImportRow(newRow);
}
else
{
break;
}
}
if (sortExp != "")
{
dtUsers.DefaultView.Sort = sortExp;
}
TableGenerator = new HTMLTableGenerator();
TableGenerator.ShowSorting = true;
TableGenerator.RowDisplayType = HTMLTableGenerator.DisplayType.RadioButtonType;
RetVal = TableGenerator.GetTableHmtl(dtUsers.DefaultView.ToTable(), "NId", "AdapUser", true) + Constants.Delimiters.ParamDelimiter + CalPageCount((dsUsers.Tables[0].Rows.Count), Convert.ToInt32(Global.AdapUserPageSize));
}
catch (Exception ex)
{
Global.CreateExceptionString(ex, null);
}
return RetVal;
}
///// <summary>
///// Get all users of current Adaptation
///// </summary>
///// <param name="requestParam"></param>
///// <returns></returns>
//public string GetCurentAdaptationsUser(string requestParam)
//{
// string RetVal = string.Empty;
// int AdapNId;
// string[] Params;
// string sortExp = "";
// HTMLTableGenerator TableGenerator;
// //string AdaptationURl = string.Empty;
// try
// {
// Params = Global.SplitString(requestParam, Constants.Delimiters.ParamDelimiter);
// AdapNId = int.Parse(Params[0]); // Not in use now
// int CurrentPage = int.Parse(Params[1]);
// if (Params.Length > 1)
// {
// sortExp = Params[3].ToString() + " " + Params[2].ToString();
// }
// // Get Adaptation URL
// //AdaptationURl = Global.GetAdaptationUrl();
// DataSet dsUsers = new DataSet();
// AdaptationUsers.AdaptationUsers UserLoginService = new AdaptationUsers.AdaptationUsers();
// UserLoginService.Url = ConfigurationManager.AppSettings[Constants.WebConfigKey.DiWorldWide4] + Constants.WSQueryStrings.AdaptationUserWebService;
// // Get ALL the users of current Adaptation by Adaptation URL
// dsUsers = UserLoginService.GetUsersByAdaptationURL(Global.GetAdaptationGUID());
// DataTable dtUsers = dsUsers.Tables[0].Clone();
// // Set Paging and creatwe data table
// for (int i = ((CurrentPage - 1) * Convert.ToInt32(Global.AdapUserPageSize)) + 1; i <= (CurrentPage * Convert.ToInt32(Global.AdapUserPageSize)); i++)
// {
// if (i <= dsUsers.Tables[0].Rows.Count)
// {
// DataRow newRow = dsUsers.Tables[0].Rows[i - 1];
// dtUsers.ImportRow(newRow);
// }
// else
// {
// break;
// }
// }
// // Sort Result
// if (sortExp != "")
// {
// dtUsers.DefaultView.Sort = sortExp;
// }
// TableGenerator = new HTMLTableGenerator();
// TableGenerator.ShowSorting = true;
// TableGenerator.RowDisplayType = HTMLTableGenerator.DisplayType.RadioButtonType;
// RetVal = TableGenerator.GetTableHmtl(dtUsers.DefaultView.ToTable(), "NId", "AdapUser", true) + Constants.Delimiters.ParamDelimiter + CalPageCount((dsUsers.Tables[0].Rows.Count), Convert.ToInt32(Global.AdapUserPageSize));
// }
// catch (Exception ex)
// {
// Global.CreateExceptionString(ex, null);
// }
// return RetVal;
//}
public string GetCurentAdaptationsUser(string requestParam)
{
//////string RetVal = string.Empty;
//////string[] Params;
//////string sortExp = "";
//////HTMLTableGenerator TableGenerator;
//////string SearchStr = string.Empty;
//////DataView DefDataView = null;
//////try
//////{
////// Params = Global.SplitString(requestParam, Constants.Delimiters.ParamDelimiter);
////// int CurrentPage = int.Parse(Params[1]);
////// if (Params.Length > 1)
////// {
////// sortExp = Params[3].ToString() + " " + Params[2].ToString();
////// if (Params.Length > 4)
////// {
////// SearchStr = Params[4].ToString();
////// }
////// }
////// DataSet dsUsers = new DataSet();
////// AdaptationUsers.AdaptationUsers UserLoginService = new AdaptationUsers.AdaptationUsers();
////// UserLoginService.Url = ConfigurationManager.AppSettings[Constants.WebConfigKey.DiWorldWide4] + Constants.WSQueryStrings.AdaptationUserWebService;
////// // Get ALL the users of current Adaptation Guid
////// dsUsers = UserLoginService.GetUsersByAdaptationURL(Global.GetAdaptationGUID());
////// DataTable DTFullTable = dsUsers.Tables[0];
////// DataTable DTFullTableClone = null;
////// if (Convert.ToBoolean(Global.ShowWebmasterAccount) == false)
////// {
////// DTFullTableClone = dsUsers.Tables[0].Clone();
////// DataRow[] Drows = DTFullTable.Select("IsMasterAccount <> 'true'");
////// foreach (DataRow dr in Drows)
////// {
////// DTFullTableClone.ImportRow(dr);
////// }
////// }
////// else
////// {
////// DTFullTableClone = DTFullTable;
////// }
////// DTFullTableClone.Columns.Remove("IsMasterAccount");
////// //dsUsers.Tables[0].Columns.Remove("IsMasterAccount");
////// //dsUsers.Tables[0] = DTFullTable;
////// DataTable dtUsers = dsUsers.Tables[0].Clone();
////// DataTable dtTempUsers = dsUsers.Tables[0].Clone();
////// DefDataView = new DataView();
////// if (!string.IsNullOrEmpty(SearchStr))
////// {
////// var FilteredTable = DTFullTableClone.Select(@"UserName like '%" + SearchStr + "%' or EmailId like '%" + SearchStr + "%'", sortExp);
////// foreach (DataRow Dr in FilteredTable)
////// {
////// dtTempUsers.ImportRow(Dr);
////// }
////// if (dtTempUsers.Rows.Count > 0)
////// {
////// DefDataView = dtTempUsers.DefaultView;
////// }
////// }
////// else
////// {
////// DefDataView = DTFullTableClone.DefaultView;
////// }
////// if (!string.IsNullOrEmpty(sortExp) && DefDataView.Table != null && DefDataView.Table.Rows != null && DefDataView.Table.Rows.Count > 0)
////// {
////// DefDataView.Sort = sortExp;
////// dtTempUsers = DefDataView.ToTable();
////// }
////// // Set Paging and creatwe data table
////// for (int i = ((CurrentPage - 1) * Convert.ToInt32(Global.AdapUserPageSize)) + 1; i <= (CurrentPage * Convert.ToInt32(Global.AdapUserPageSize)); i++)
////// {
////// if (i <= dtTempUsers.Rows.Count)
////// {
////// DataRow newRow = dtTempUsers.Rows[i - 1];
////// dtUsers.ImportRow(newRow);
////// }
////// else
////// {
////// break;
////// }
////// }
////// TableGenerator = new HTMLTableGenerator();
////// TableGenerator.ShowSorting = true;
////// TableGenerator.RowDisplayType = HTMLTableGenerator.DisplayType.RadioButtonType;
////// RetVal = TableGenerator.GetTableHmtl(dtUsers.DefaultView.ToTable(), "NId", "AdapUser", true) + Constants.Delimiters.ParamDelimiter + CalPageCount((dtTempUsers.Rows.Count), Convert.ToInt32(Global.AdapUserPageSize));
//////}
//////catch (Exception ex)
//////{
////// Global.CreateExceptionString(ex, null);
//////}
//////return RetVal;
string RetVal = string.Empty;
string[] Params;
string sortExp = "";
HTMLTableGenerator TableGenerator;
string SearchStr = string.Empty;
DataView DefDataView = null;
try
{
Params = Global.SplitString(requestParam, Constants.Delimiters.ParamDelimiter);
int CurrentPage = int.Parse(Params[1]);
if (Params.Length > 1)
{
sortExp = Params[3].ToString() + " " + Params[2].ToString();
if (Params.Length > 4)
{
SearchStr = Params[4].ToString();
}
}
DataSet dsUsers = new DataSet();
AdaptationUsers.AdaptationUsers UserLoginService = new AdaptationUsers.AdaptationUsers();
UserLoginService.Url = ConfigurationManager.AppSettings[Constants.WebConfigKey.DiWorldWide4] + Constants.WSQueryStrings.AdaptationUserWebService;
// Get ALL the users of current Adaptation Guid
//dsUsers = UserLoginService.GetUsersByAdaptationURL(Global.GetAdaptationGUID());
DataTable dtUsers = dsUsers.Tables[0].Clone();
DataTable dtTempUsers = dsUsers.Tables[0].Clone();
DefDataView = new DataView();
if (!string.IsNullOrEmpty(SearchStr))
{
var FilteredTable = dsUsers.Tables[0].Select(@"UserName like '%" + SearchStr + "%' or EmailId like '%" + SearchStr + "%'", sortExp);
foreach (DataRow Dr in FilteredTable)
{
dtTempUsers.ImportRow(Dr);
}
if (dtTempUsers.Rows.Count > 0)
{
DefDataView = dtTempUsers.DefaultView;
}
}
else
{
DefDataView = dsUsers.Tables[0].DefaultView;
}
if (!string.IsNullOrEmpty(sortExp) && DefDataView.Table != null && DefDataView.Table.Rows != null && DefDataView.Table.Rows.Count > 0)
{
DefDataView.Sort = sortExp;
dtTempUsers = DefDataView.ToTable();
}
// Set Paging and creatwe data table
for (int i = ((CurrentPage - 1) * Convert.ToInt32(Global.AdapUserPageSize)) + 1; i <= (CurrentPage * Convert.ToInt32(Global.AdapUserPageSize)); i++)
{
if (i <= dtTempUsers.Rows.Count)
{
DataRow newRow = dtTempUsers.Rows[i - 1];
dtUsers.ImportRow(newRow);
}
else
{
break;
}
}
TableGenerator = new HTMLTableGenerator();
TableGenerator.ShowSorting = true;
TableGenerator.RowDisplayType = HTMLTableGenerator.DisplayType.RadioButtonType;
RetVal = TableGenerator.GetTableHmtl(dtUsers.DefaultView.ToTable(), "NId", "AdapUser", true) + Constants.Delimiters.ParamDelimiter + CalPageCount((dtTempUsers.Rows.Count), Convert.ToInt32(Global.AdapUserPageSize));
}
catch (Exception ex)
{
Global.CreateExceptionString(ex, null);
}
return RetVal;
}
public string GetAllUsersGridHTML()
{
string RetVal = string.Empty;
DataTable DtUsers;
DIConnection DIConnection = null;
HTMLTableGenerator TableGenerator;
try
{
//AdaptationUrl = Global.GetAdaptationUrl();
GlobalUserWebService.Url = ConfigurationManager.AppSettings[Constants.WebConfigKey.DiWorldWide4] + Constants.WSQueryStrings.UserLoginService;
if (ConfigurationManager.AppSettings[Constants.WebConfigKey.IsGlobalAllow].ToLower() == "true")
{
DtUsers = GlobalUserWebService.GetAllUsersGridHTML(Global.GetAdaptationGUID());
}
else
{
DIConnection = new DIConnection(DIServerType.MsAccess, string.Empty, string.Empty, Server.MapPath("~//stock//Database.mdb"),
string.Empty, string.Empty);
string Query = "SELECT NId, User_Email_Id as Email, User_First_Name as [Name], User_Country as [User Country], User_Is_Admin as [Admin User], User_Is_Admin as [Provider User], User_Send_Updates AS [Send Updates] FROM Users Where User_Is_Admin = 'False'";
DtUsers = DIConnection.ExecuteDataTable(Query);
}
DtUsers = this.Replace_AreaNIds_With_Names(DtUsers);
TableGenerator = new HTMLTableGenerator();
TableGenerator.RowDisplayType = HTMLTableGenerator.DisplayType.RadioButtonType;
RetVal = TableGenerator.GetTableHmtl(DtUsers, "NId", "usr", true);
}
catch (Exception ex)
{
Global.CreateExceptionString(ex, null);
throw ex;
}
finally
{
if (DIConnection != null)
{
DIConnection.Dispose();
}
}
return RetVal;
}