//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);
}
