private void LapDat(DTO.LapDat lapDat)
        {
            Call(lapDat);

            using (var db = _connection.GetConnection())
            {
                db.Execute("INSERT INTO setting.LapDat(ThongTinKhachHangId,SoDienThoai,TenKhachHang,DiaChiGiaoHang,NgayLapDat) VALUES(@ThongTinKhachHangId,@SoDienThoai,@TenKhachHang,@DiaChiGiaoHang,@NgayLapDat);", new
                {
                    lapDat.ThongTinKhachHangId,
                    lapDat.SoDienThoai,
                    lapDat.TenKhachHang,
                    lapDat.DiaChiGiaoHang,
                    NgayLapDat = DateTime.Now
                });
            }

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

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