public bool Find(int AccountID, bool ApprovedOnly) { Database data = new Database(); SqlDataReader reader = data.GetAccountInfo(AccountID, ApprovedOnly); if (reader.Read()) { this.EmployeeID = (int)reader["intEmployeeID"]; this.intAccountID = (int)reader["intAccountID"]; this.AccountName = (string)reader["strAccountName"]; this.Contact = (string)reader["strContact"]; this.Phone = (string)reader["strPhone"]; this.Locations = (int)reader["intLocations"]; this.ClosedRMR = (Decimal)reader["mnyClosedRMR"]; this.ClosedRSS = (Decimal)reader["mnyClosedRSS"]; this.RMR_10 = (Decimal)reader["mnyRMR_10"]; this.RSS_10 = (Decimal)reader["mnyRSS_10"]; this.RMR_50 = (Decimal)reader["mnyRMR_50"]; this.RSS_50 = (Decimal)reader["mnyRSS_50"]; this.RMR_90 = (Decimal)reader["mnyRMR_90"]; this.RSS_90 = (Decimal)reader["mnyRSS_90"]; this.Month = (DateTime)reader["dtmMonth"]; this.blActive = (bool)reader["bitActive"]; switch (((string)reader["charStatus"]).Trim()) { case "P": this.Status = AccountStatus.Pending; break; case "A": this.Status = AccountStatus.Approved; break; case "U": this.Status = AccountStatus.Updated; break; } data.Close(); data.Dispose(); return true; } data.Close(); data.Dispose(); return false; }