//Logged as Customers public string BgetPassword(string Username) { DataSet dsSet = new DataSet(); SqlDataAdapter dataAdapter = new SqlDataAdapter(); string strResult = null; string strPassword = null; string DecPassword = null; int status = 0; SqlConnection connection = new SqlConnection(); connection = SQLHelper.GetSQLConnection(); connection.Open(); try { SqlCommand cmd = new SqlCommand("[dbo].[Usp_GetPasswordforlogged]", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@profileid", Username); SqlParameter outputParamStatus = cmd.Parameters.Add("@status", SqlDbType.Int); outputParamStatus.Direction = ParameterDirection.Output; dataAdapter.SelectCommand = cmd; dataAdapter.Fill(dsSet); if (Convert.ToInt32(cmd.Parameters[1].Value) == 0) { status = 0; } else { status = Convert.ToInt32(cmd.Parameters[1].Value); } if (dsSet != null && dsSet.Tables.Count > 0) { strPassword = !string.IsNullOrEmpty(dsSet.Tables[0].Rows[0]["Password"].ToString()) ? dsSet.Tables[0].Rows[0]["Password"].ToString() : null; DecPassword = !string.IsNullOrEmpty(strPassword) ? Commonclass.Decrypt(strPassword) : null; } } catch (Exception Ex) { Commonclass.ApplicationErrorLog("Usp_GetPasswordforlogged", Convert.ToString(Ex.Message), null, null, null); } finally { connection.Close(); } // return Commonclass.convertdataTableToArrayList(dsSet); strResult = "Password :"******";" + "DecPassword :" + DecPassword; SqlConnection.ClearAllPools(); return(strResult); }