public SmartCollection<Contact> GetContacts(int clientId) { try { SmartCollection<Contact> resultList = new SmartCollection<Contact>(); using (DbConnection = new MsSqlPersistence(DbConnectionSettings)) { if (DbConnection.IsConnected()) { using (DbCommand) { DbCommand.CommandType = CommandType.StoredProcedure; DbCommand.CommandText = "uspGetContacts"; DbCommand.Parameters.Clear(); DbCommand.Parameters.Add("@ClientId", System.Data.SqlDbType.Int).Value = clientId; DataTable contactsDT = DbConnection.ExecuteQuery(DbCommand); foreach (DataRow row in contactsDT.Rows) { Contact contact = new Contact(); contact.ContactId = Convert.ToInt32(row["ContactID"]); contact.ClientId = Convert.ToInt32(row["ClientID"]); contact.FirstName = row["FirstName"].ToString(); contact.LastName = row["LastName"].ToString(); contact.PrimaryEmail = row["PrimaryEmail"].ToString(); contact.PrimaryEmailSendYN = row["PrimaryEmailSendYN"] != DBNull.Value ? (bool)row["PrimaryEmailSendYN"] : false; contact.SecondaryEmail = row["SecondaryEmail"].ToString(); contact.SecondaryEmailSendYN = row["SecondaryEmailSendYN"] != DBNull.Value ? (bool)row["SecondaryEmailSendYN"] : false; contact.PrimaryPhone = row["PrimaryPhone"].ToString(); contact.SecondaryPhone = row["SecondaryPhone"].ToString(); contact.Fax = row["Fax"].ToString(); contact.FaxSendYN = row["FaxSendYN"] != DBNull.Value ? (bool)row["FaxSendYN"] : false; contact.Comments = row["Comments"].ToString(); contact.CreatedBy = row["CreatedBy"] != DBNull.Value ? Convert.ToInt32(row["CreatedBy"]) : -1; contact.CreatedUser = row["CreatedUser"].ToString(); contact.CreatedDate = row["CreatedDate"] != DBNull.Value ? (DateTime)row["CreatedDate"] : (DateTime)SqlDateTime.Null; contact.ModifiedBy = row["ModifiedBy"] != DBNull.Value ? Convert.ToInt32(row["ModifiedBy"]) : -1; contact.ModifiedUser = row["ModifiedUser"].ToString(); contact.ModifiedDate = row["ModifiedDate"] != DBNull.Value ? (DateTime)row["ModifiedDate"] : (DateTime)SqlDateTime.Null; resultList.Add(contact); } contactsDT = null; } } else { throw new Exception("Unable to Connect"); } } return resultList; } catch { throw; } }
public Contact GetContact(ref MsSqlPersistence dbConnection, ref SqlCommand dbCommand, int? contactId) { try { Contact contact = new Contact(); if (dbConnection.IsConnected()) { dbCommand.Parameters.Clear(); dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.CommandText = "uspGetContact"; dbCommand.Parameters.Add("@ContactId", System.Data.SqlDbType.Int).Value = contactId; DataTable contactDT = dbConnection.ExecuteQuery(dbCommand); if (contactDT.Rows.Count == 1) { DataRow row = contactDT.Rows[0]; contact.ContactId = Convert.ToInt32(row["ContactID"]); contact.ClientId = Convert.ToInt32(row["ClientID"]); contact.FirstName = row["FirstName"].ToString(); contact.LastName = row["LastName"].ToString(); contact.PrimaryEmail = row["PrimaryEmail"].ToString(); contact.PrimaryEmailSendYN = row["PrimaryEmailSendYN"] != DBNull.Value ? (bool)row["PrimaryEmailSendYN"] : false; contact.SecondaryEmail = row["SecondaryEmail"].ToString(); contact.SecondaryEmailSendYN = row["SecondaryEmailSendYN"] != DBNull.Value ? (bool)row["SecondaryEmailSendYN"] : false; contact.PrimaryPhone = row["PrimaryPhone"].ToString(); contact.SecondaryPhone = row["SecondaryPhone"].ToString(); contact.Fax = row["Fax"].ToString(); contact.FaxSendYN = row["FaxSendYN"] != DBNull.Value ? (bool)row["FaxSendYN"] : false; contact.Comments = row["Comments"].ToString(); contact.CreatedBy = row["CreatedBy"] != DBNull.Value ? Convert.ToInt32(row["CreatedBy"]) : -1; contact.CreatedUser = row["CreatedUser"].ToString(); contact.CreatedDate = row["CreatedDate"] != DBNull.Value ? (DateTime)row["CreatedDate"] : (DateTime)SqlDateTime.Null; contact.ModifiedBy = row["ModifiedBy"] != DBNull.Value ? Convert.ToInt32(row["ModifiedBy"]) : -1; contact.ModifiedUser = row["ModifiedUser"].ToString(); contact.ModifiedDate = row["ModifiedDate"] != DBNull.Value ? (DateTime)row["ModifiedDate"] : (DateTime)SqlDateTime.Null; contactDT = null; } else { contactDT = null; return null; } } else { throw new Exception("Unable to Connect"); } return contact; } catch { throw; } }