public Company GetById(int id) { Company company = null; var connectionString = ConfigurationManager.ConnectionStrings["appDatabase"].ConnectionString; using (var connection = new SqlConnection(connectionString)) { var command = new SqlCommand { Connection = connection, CommandType = CommandType.StoredProcedure, CommandText = "uspGetCompanyById" }; var parameter = new SqlParameter("@CompanyId", SqlDbType.Int) { Value = id }; command.Parameters.Add(parameter); connection.Open(); var reader = command.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { company = new Company { Id = int.Parse(reader["CompanyId"].ToString()), Name = reader["Name"].ToString(), Classification = (Classification)int.Parse(reader["ClassificationId"].ToString()) }; } } return company; }
public virtual void TestSetup() { ValidCustomer = InitialiseCustomer.InitCustomer("John", "Doe", "*****@*****.**", new DateTime(1979, 08, 30)); InvalidCustomerAge = InitialiseCustomer.InitCustomer("John", "Doe", "*****@*****.**", new DateTime(1999, 08, 30)); InvalidCustomerEmail = InitialiseCustomer.InitCustomer("John", "Doe", "email", new DateTime(1979, 08, 30)); InvalidCustomerFirstName = InitialiseCustomer.InitCustomer(string.Empty, "Doe", "email.com", new DateTime(1979, 08, 30)); InvalidCustomerLastName = InitialiseCustomer.InitCustomer("John", string.Empty, "email.com", new DateTime(1979, 08, 30)); InvalidCustomerFirstNameAndLastName = InitialiseCustomer.InitCustomer(string.Empty, string.Empty, "email.com", new DateTime(1979, 08, 30)); GoldCompany = new Company { Classification = Classification.Gold, Id =1, Name = "GoldCompany" }; SilverCompany = new Company { Classification = Classification.Silver, Id = 2, Name = "SilverCompany" }; BrozneCompany = new Company { Classification = Classification.Bronze, Id = 3, Name = "BronzeCompany" }; }