public AccountsDAL retrieveByAccId(int accId)
{
AccountsDAL p = null;
string strCommandText = "SELECT * FROM Accounts where AccountID = @accId";
string uName, pwd, fullNm, mobileNo, emailAdd, add, accountType;
// bool accIdConfirmed;
SqlConnection myConnection = new SqlConnection(strConnectionString);
SqlCommand cmd = new SqlCommand(strCommandText, myConnection);
cmd.Parameters.AddWithValue("@accId", accId);
try
{
myConnection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
accId = (int)reader["AccountID"];
uName = reader["userName"].ToString();
pwd = reader["password"].ToString();
fullNm = reader["fullName"].ToString();
mobileNo = reader["mobile"].ToString();
emailAdd = reader["email"].ToString();
add = reader["address"].ToString();
accountType = reader["accType"].ToString();
p = new AccountsDAL(accId, uName, pwd, fullNm, mobileNo, emailAdd, add, accountType);
p.uName = uName;
p.fullNm = fullNm;
p.accountType = accountType;
}
}
catch (Exception ex)
{
//throw new Exception(ex.ToString());
p = null;
}
finally { myConnection.Close(); }
return(p);
}
public AccountsDAL retrieveUser(string uName, string pwd)
{
AccountsDAL p = null;
string strCommandText = "SELECT * FROM Accounts WHERE userName = @uName AND password = @pwd";
string fullNm, mobileNo, emailAdd, add, accountType;
int accId;
SqlConnection myConnection = new SqlConnection(strConnectionString);
SqlCommand cmd = new SqlCommand(strCommandText, myConnection);
cmd.Parameters.AddWithValue("@uName", uName);
cmd.Parameters.AddWithValue("@pwd", pwd);
try
{
myConnection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
accId = (int)reader["AccountID"];
uName = reader["userName"].ToString();
pwd = reader["password"].ToString();
fullNm = reader["fullName"].ToString();
mobileNo = reader["mobile"].ToString();
emailAdd = reader["email"].ToString();
add = reader["address"].ToString();
accountType = reader["accType"].ToString();
p = new AccountsDAL(accId, uName, pwd, fullNm, mobileNo, emailAdd, add, accountType);
}
}
catch (Exception ex)
{
p = null;
}
finally { myConnection.Close(); }
return(p);
}
