private void GiaoHang(DTO.GiaoHang giaoHang)
        {
            Call(giaoHang);

            using (var db = _connection.GetConnection())
            {
                db.Execute("INSERT INTO shipping.GiaoHang(ThongTinKhachHangId,SoDienThoai,TenKhachHang,DiaChiGiaoHang,NgayGiao) VALUES(@ThongTinKhachHangId,@SoDienThoai,@TenKhachHang,@DiaChiGiaoHang,@NgayGiao);", new
                {
                    giaoHang.ThongTinKhachHangId,
                    giaoHang.SoDienThoai,
                    giaoHang.TenKhachHang,
                    giaoHang.DiaChiGiaoHang,
                    giaoHang.NgayGiao
                });
            }

            // producer publish message
            _producer.Publish(new Message_Customer
            {
                Id = giaoHang.ThongTinKhachHangId,
                CustomerAddress = giaoHang.DiaChiGiaoHang,
                CustomerName    = giaoHang.TenKhachHang,
                PhoneNumber     = giaoHang.SoDienThoai,
                Status          = Status.Da_Giao_Hang
            });
        }
        private void Call(DTO.GiaoHang giaoHang)
        {
            Console.WriteLine($"Call to {giaoHang.SoDienThoai}");
            Console.ForegroundColor = ConsoleColor.DarkGreen;
            Console.WriteLine(" Grab-Services:");
            Console.WriteLine($"        Alo, xin chao (anh/chi) {giaoHang.TenKhachHang}");
            Console.WriteLine($"        Chung toi, co the giao hang den dia chi {giaoHang.DiaChiGiaoHang} duoc khong?");

            Console.ForegroundColor = ConsoleColor.DarkRed;
            Console.WriteLine($" {giaoHang.TenKhachHang}:");
            Console.WriteLine("         Duoc em!");
            Console.ResetColor();
        }