internal void AddOrder(SampleOrderInformation order) { using (SqlConnection sqlConn = new SqlConnection(_connection)) { sqlConn.Open(); SqlCommand sqlCmd = new SqlCommand("AddOrder", sqlConn); sqlCmd.CommandType = System.Data.CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@customerId", order.CustomerId); sqlCmd.Parameters.AddWithValue("@count", order.Count); sqlCmd.Parameters.AddWithValue("@price", order.Price); sqlCmd.Parameters.AddWithValue("@description", order.Description); sqlCmd.Parameters.AddWithValue("@orderEntryDate", order.OrderEntryDate); sqlCmd.ExecuteNonQuery(); } }
internal void AddOrder(SampleOrderInformation order) { var shard = GetShard(order.CustomerId.ToString()); shard.AddOrder(order); }