private string getPassWord(string userName)
{
EntUserPassword objentuserPass = new EntUserPassword();
UserPassword objUserPassword = new UserPassword();
objentuserPass = objUserPassword.getUserPassword(userName);
string Password = objentuserPass.Password;
return(Password);
}
public EntUserPassword getUserPassword(string userName)
{
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserName", userName) };
userInformation = new EntUserPassword();
if (objConnection.Connection.State == ConnectionState.Closed)
{
objConnection.Connection.Open();
}
reader = objConnection.ExecuteDataSetQuery(clsConstant.SP_GET_PASSWORD_BY_USERNAME, CommandType.StoredProcedure, param);
if (reader.Tables[0] != null && reader.Tables[0].Rows.Count > 0)
{
//------------------------
userInformation.Password = reader.Tables[0].Rows[0][0].ToString();
//userInformation.isUserActive = bool.Parse(reader.Tables[0].Rows[0][1].ToString());
}
return(userInformation);
}