public string GetAllUsersHTMLForAdmin() { string RetVal; int Counter; diworldwide_userinfo.UserLoginInformation Service; DIConnection DIConnection = null; DataTable DtUsers = null; RetVal = string.Empty; Counter = 0; try { if (ConfigurationManager.AppSettings[Constants.WebConfigKey.IsGlobalAllow].ToLower() == "true") { Service = new diworldwide_userinfo.UserLoginInformation(); Service.Url = ConfigurationManager.AppSettings[Constants.WebConfigKey.DiWorldWide4] + Constants.WSQueryStrings.UserLoginService; DtUsers = Service.GetAllUsersGridHTML(Global.GetAdaptationGUID()); } else { DIConnection = new DIConnection(DIServerType.MsAccess, string.Empty, string.Empty, Server.MapPath("~//stock//Database.mdb"), string.Empty, string.Empty); DtUsers = DIConnection.ExecuteDataTable("SELECT NId, User_Email_Id as Email, User_First_Name as [First Name], User_Country as [User Country], User_Is_Admin as [Admin User], User_Is_Provider as [Provider User] FROM Users Where User_Is_Admin = 'False'"); } DtUsers = this.Replace_AreaNIds_With_Names(DtUsers); RetVal = "<table id=\"tblUsers\" style=\"width:100%;float:left\" border=\"0\" cellSpacing=\"0\" cellPadding=\"0\" class=\"roundedcorners\">"; RetVal += "<tbody>"; RetVal += "<tr class=\"HeaderRowStyle\">"; RetVal += "<td class=\"HeaderColumnStyle\"><span id=\"spanEmail\"></span></td>"; RetVal += "<td class=\"HeaderColumnStyle\"><span id=\"spanName\"></span></td>"; RetVal += "<td class=\"HeaderColumnStyle\"><span id=\"spanCountry\"></span></td>"; RetVal += "<td class=\"HeaderColumnStyle\"><span id=\"spanProvider\"></span></td>"; RetVal += "</tr>"; foreach (DataRow DrUsers in DtUsers.Rows) { Counter++; if (Counter % 2 == 0) { RetVal += "<tr class=\"SelectedDataRowStyle\">"; } else { RetVal += "<tr class=\"DataRowStyle\">"; } RetVal += "<td class=\"DataColumnStyle\">" + DrUsers["Email"].ToString() + "</td>"; RetVal += "<td class=\"DataColumnStyle\">" + DrUsers["First Name"].ToString() + "</td>"; RetVal += "<td class=\"DataColumnStyle\">" + DrUsers["User Country"].ToString() + "</td>"; if (DrUsers["Provider User"].ToString().ToLower() == "true") { RetVal += "<td class=\"CheckBoxDataColumnStyle\"><input type=\"checkbox\" id=\"chkUser_" + DrUsers["NId"].ToString() + "\" value=\"" + DrUsers["NId"].ToString() + "\" checked=\"checked\"/></td>"; } else { RetVal += "<td class=\"CheckBoxDataColumnStyle\"><input type=\"checkbox\" id=\"chkUser_" + DrUsers["NId"].ToString() + "\" value=\"" + DrUsers["NId"].ToString() + "\"/></td>"; } RetVal += "</tr>"; } RetVal += "</tbody>"; RetVal += "</table>"; } catch (Exception ex) { Global.CreateExceptionString(ex, null); throw ex; } finally { } return RetVal; }