C# Encrypt and Decrypt String

public string Encrypt(string plainText) { try { var sb = new System.Text.StringBuilder(); var bytes = System.Text.Encoding.Unicode.GetBytes(plainText); foreach (var t in bytes) sb.Append(t.ToString("X2")); return sb.ToString(); } catch { return null; } } public string Decrypt(string encryptedText) { try { var bytes = new byte[encryptedText.Length / 2]; for (var i = 0; i < bytes.Length; i++) bytes[i] = System.Convert.ToByte(encryptedText.Substring(i * 2, 2), 16); return System.Text.Encoding.Unicode.GetString(bytes); } catch { return null; } }

C# Get AD User Attribute

public string GetUserAttribute(string alias, string attribute) { try { attribute = attribute.ToLower(); string propertyValue = null; UserPrincipal user = UserPrincipal .FindByIdentity(GetPrincipalContext, IdentityType.SamAccountName, alias); if (user != null) { //Create a searcher on your DirectoryEntry DirectoryEntry directoryEntry = (user.GetUnderlyingObject() as DirectoryEntry); DirectorySearcher adSearch = new DirectorySearcher(directoryEntry); //Look into all subtree during the search adSearch.SearchScope = SearchScope.Subtree; adSearch.Filter = "(&(ObjectClass=user)(sAMAccountName=" + alias + "))"; SearchResult sResult = adSearch.FindOne(); if (sResult.Properties.Contains(attribute)) propertyValue = sResult.Properties[attribute][0].ToString(); } return propertyValue; } catch { return null; } }

C# Get Logged-in User in IIS and IISExpress

public string LoggedInUserNetworkId() { string loggedinUser = WindowsIdentity.GetCurrent().Name; // IIS Express loggedinUser = !string.IsNullOrEmpty(loggedinUser) && !loggedinUser.ToLower().Contains("apppool") ? loggedinUser : HttpContext.Current.User.Identity.Name; // IIS return (!string.IsNullOrEmpty("Impersonate".GetValueFromConfig()) ? "Impersonate".GetValueFromConfig() : loggedinUser.Replace("DOMAIN\\", "")).PrettyWord(); } public static string PrettyWord(this string word) => System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo .ToTitleCase(word.Trim().ToLower());

Find Currently Running Query in SQL Server

SELECT sqltext.TEXT, req.session_id, req.status, req.start_time, req.command, req.cpu_time, req.total_elapsed_time FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext