public string UpdatePassword(string requestParam) { string RetVal = string.Empty; int UserNId; string Password, Language, UserName, EmailId; string[] Params; //Variables for creating XLS Logfile string XLSFileMsg = string.Empty; try { Params = Global.SplitString(requestParam, Constants.Delimiters.ParamDelimiter); UserNId = int.Parse(Params[0]); Password = Params[1].ToString(); Language = Params[2].ToString(); UserName = Params[3].ToString(); EmailId = Params[4].ToString(); AdaptationUsers.AdaptationUsers UserLoginService = new AdaptationUsers.AdaptationUsers(); UserLoginService.Url = ConfigurationManager.AppSettings[Constants.WebConfigKey.DiWorldWide4] + Constants.WSQueryStrings.AdaptationUserWebService; RetVal = UserLoginService.UpdateUserPassword(UserNId, Global.OneWayEncryption(Password)).ToString(); if (RetVal.ToUpper() == "TRUE") { Frame_ChangePassword_And_Send_Mail(UserName, EmailId, Language, Password); #region "Call method to write log in XLS file" XLSFileMsg = string.Format(Constants.CSVLogMessage.ChangePassword, EmailId); WriteLogInXLSFile(Constants.AdminModules.UserManagement.ToString(), XLSFileMsg); #endregion } } catch (Exception ex) { Global.CreateExceptionString(ex, null); } return RetVal; }
/// <summary> /// Set User As Admin for Current Adaptation /// </summary> /// <param name="requestParam"></param> /// <returns></returns> public string SetUserAsAdmin(string requestParam) { string RetVal = string.Empty; //string AdptationUrl = string.Empty; int UserNId; string Language, UserName, EmailId; string[] Params; //Variables for creating XLS Logfile string XLSFileMsg = string.Empty; try { //AdptationUrl = Global.GetAdaptationUrl(); Params = Global.SplitString(requestParam, Constants.Delimiters.ParamDelimiter); UserNId = int.Parse(Params[0]); Language = Params[1].ToString(); UserName = Params[2].ToString(); EmailId = Params[3].ToString(); AdaptationUsers.AdaptationUsers UserLoginService = new AdaptationUsers.AdaptationUsers(); UserLoginService.Url = ConfigurationManager.AppSettings[Constants.WebConfigKey.DiWorldWide4] + Constants.WSQueryStrings.AdaptationUserWebService; RetVal = UserLoginService.SetUserAsAdmin(UserNId, Global.GetAdaptationGUID()).ToString(); #region "Call method to write log in XLS file" if (RetVal.ToUpper() == "TRUE") { XLSFileMsg = string.Format(Constants.CSVLogMessage.UserSetAsAdmin, EmailId); WriteLogInXLSFile(Constants.AdminModules.UserManagement.ToString(), XLSFileMsg); #endregion Session[Constants.SessionNames.LoggedAdminUser] = null; Session[Constants.SessionNames.LoggedAdminUserNId] = null; Frame_Message_And_Send_Mail(UserName, EmailId, UserNId.ToString(), true, true, Language); this.Create_MaintenanceAgency_ForAdmin(UserNId.ToString(), UserName, Language); } } 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 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; }
public string GetAllAdaptations() { string RetVal = string.Empty; try { AdaptationUsers.AdaptationUsers UserLoginService = new AdaptationUsers.AdaptationUsers(); UserLoginService.Url = ConfigurationManager.AppSettings[Constants.WebConfigKey.DiWorldWide4] + Constants.WSQueryStrings.AdaptationUserWebService; RetVal = UserLoginService.GetAllAdaptations(); } catch (Exception ex) { Global.CreateExceptionString(ex, null); } return RetVal; }
private void Frame_Message_And_Send_Mail_DPRight(string AdminUser, string AdminUserId, string UserName, string EmailId, string Language, string UserNId) { string MessageContent = string.Empty; string Subject = string.Empty; string Body = string.Empty; string TamplatePath = string.Empty; DIConnection DIConnection; string Country = string.Empty; AdaptationUsers.AdaptationUsers UserLoginService = new AdaptationUsers.AdaptationUsers(); UserLoginService.Url = ConfigurationManager.AppSettings[Constants.WebConfigKey.DiWorldWide4] + Constants.WSQueryStrings.AdaptationUserWebService; if (ConfigurationManager.AppSettings[Constants.WebConfigKey.IsGlobalAllow].ToLower() == "true") { DataSet dsUsers = new DataSet(); dsUsers = UserLoginService.GetAreaForUser(Convert.ToInt32(UserNId)); Country = dsUsers.Tables[0].Rows[0][0].ToString(); } else { DataTable dtCountryNId = null; string AreaNId = string.Empty; string Query; DIConnection = new DIConnection(DIServerType.MsAccess, string.Empty, string.Empty, Server.MapPath("~//stock//Database.mdb"), string.Empty, string.Empty); Query = "SELECT User_Country FROM Users WHERE nid = " + UserNId + ";"; dtCountryNId = DIConnection.ExecuteDataTable(Query); if (dtCountryNId != null && dtCountryNId.Rows.Count > 0) { AreaNId = dtCountryNId.Rows[0]["User_Country"].ToString().Trim(); } DataSet dsUsers = new DataSet(); dsUsers = UserLoginService.GetAreaFromAreaNId(Convert.ToInt32(AreaNId)); Country = dsUsers.Tables[0].Rows[0][0].ToString(); } TamplatePath = Path.Combine(this.Page.Request.PhysicalApplicationPath, Constants.FolderName.EmailTemplates); TamplatePath += Language + "\\" + Constants.FileName.RequestDataProviderRights; MessageContent = GetEmailTamplate(TamplatePath); Subject = MessageContent.Split("\r\n".ToCharArray())[0].ToString(); Subject = Subject.Replace("[^^^^]", ""); Subject = Subject.Replace("[****]ADAPTATION_NAME[****]", Global.adaptation_name); Body = MessageContent.Replace(MessageContent.Split("\r\n".ToCharArray())[0], ""); Body = Body.Replace("[****]USER_EMAILID[****]", EmailId); Body = Body.Replace("[****]USER_NAME[****]", UserName); Body = Body.Replace("[****]COUNTRY[****]", Country); Body = Body.Replace("[****]ADAPTATION_NAME[****]", Global.adaptation_name); Body = Body.Replace("[****]ADAPTATION_URL[****]", this.Page.Request.Url.AbsoluteUri.Substring(0, this.Page.Request.Url.AbsoluteUri.IndexOf("libraries"))); this.Send_Email("WebMaster - " + Global.adaptation_name, "*****@*****.**", AdminUserId, Subject, Body, true, AdminUser); }