public Account GetAccountData(string username)
{
var query = "SELECT AccountID, Password, UserGroup, ServiceID FROM AccountData WHERE Username=@Username";
var sqlCommand = factory.GetCommand(sqlConnection);
sqlCommand.AddParameter("@Username", username);
sqlCommand.SetCommand(query);
var sqlReader = sqlCommand.ExecuteReader();
var pData = new Account();
if (sqlReader.Read())
{
pData.AccountID = (int)sqlReader.GetData("AccountID");
pData.Password = (string)sqlReader.GetData("Password");
pData.UserGroup = (int)sqlReader.GetData("UserGroup");
pData.ServiceID = Convert.ToByte(sqlReader.GetData("ServiceID"));
pData.AccountName = username;
}
sqlReader.Close();
return(pData);
}
