Example #1
0
        private void RefreshThongTinMaDonVi(string maDonVi)
        {
            _flag2             = false;
            txtMaSoThue.Text   = string.Empty;
            txtAddress.Text    = string.Empty;
            txtSoTaiKhoan.Text = string.Empty;
            cboTenDonVi.Text   = string.Empty;

            if (cboMaDonVi.Text.Trim() != string.Empty)
            {
                Result result = ThongTinKhachHangBus.GetThongTinMaDonVi(maDonVi);
                if (result.IsOK)
                {
                    ThongTinKhachHang ttkh = result.QueryResult as ThongTinKhachHang;
                    if (ttkh == null)
                    {
                        _flag2 = true;
                        return;
                    }

                    cboTenDonVi.Text   = ttkh.TenDonVi;
                    txtMaSoThue.Text   = ttkh.MaSoThue;
                    txtAddress.Text    = ttkh.DiaChi;
                    txtSoTaiKhoan.Text = ttkh.SoTaiKhoan;
                    cboHinhThucThanhToan.SelectedIndex = ttkh.HinhThucThanhToan.Value;
                }
                else
                {
                    MsgBox.Show(this.Text, result.GetErrorAsString("ThongTinKhachHangBus.GetThongTinMaDonVi"), IconType.Error);
                    Utility.WriteToTraceLog(result.GetErrorAsString("ThongTinKhachHangBus.GetThongTinMaDonVi"));
                }
            }
            _flag2 = true;
        }
Example #2
0
        public JsonResult Login(FormCollection data)
        {
            String            email    = data["email"];
            String            password = data["password"];
            DBIO              database = new DBIO();
            JsonResult        json     = new JsonResult();
            ThongTinKhachHang ttkh     = new ThongTinKhachHang();

            ttkh = database.CheckLogin(email, password);
            if (ttkh == null)
            {
                json.Data = new
                {
                    status = "er",
                };
                return(Json(json, JsonRequestBehavior.AllowGet));
            }
            Session["user"] = ttkh;

            Session.Timeout = 5; // thời gian time out là 5 phút
            json.Data       = new
            {
                status = "OK",
                name   = ttkh.Ten_Khanh_Hang,
                phone  = ttkh.Phone,
                email  = ttkh.Email,
                adress = ttkh.Adress
            };
            return(Json(json, JsonRequestBehavior.AllowGet));
        }
 private void txt_MaKhach_TextChanged(object sender, EventArgs e)
 {
     try{
         khachHang = (from tk in db.TAIKHOAN
                      join kh in db.KHACHHANG on tk.MATAIKHOAN equals kh.MATAIKHOAN
                      where tk.SDT == txt_MaKhach.Text
                      select new ThongTinKhachHang {
             maKhach = kh.MAKH,
             ten = tk.TEN,
             diaChi = tk.DIACHI,
             soDienThoai = tk.SDT
         }).Single();
     }
     catch (Exception ex) { }
     if (txtMakhach == null)
     {
         khachHang = null;
     }
     if (khachHang != null)
     {
         txtLoaiKhach.Text   = "Thành viên";
         txtMakhach.Text     = khachHang.maKhach.ToString();
         txtTenKhach.Text    = khachHang.ten;
         txtDiaChi.Text      = khachHang.diaChi;
         txtSoDienThoai.Text = khachHang.soDienThoai;
     }
     else
     {
         txtLoaiKhach.Text   = "Khách chơi qua đường";
         txtMakhach.Text     = "";
         txtTenKhach.Text    = "";
         txtDiaChi.Text      = "";
         txtSoDienThoai.Text = "";
     }
 }
        public ActionResult SuaVe(ThongTinKhachHang ThongTin)
        {
            try
            {
                string ticketcode    = ThongTin.ticketcode;
                var    connection    = new AirLineDbContext();
                string passengercode = connection.KhachHang_ChuyenBay.Find(ticketcode).MaKhachHang;
                var    ticket        = connection.KhachHangs.Find(passengercode);

                if (ticket == null)
                {
                    return(HttpNotFound());
                }
                else
                {
                    ticket.HoTenKhachHang = ThongTin.fullname;
                    ticket.KhuVuc         = ThongTin.country;
                    ticket.DienThoai      = ThongTin.phone;
                    ticket.Email          = ThongTin.email;
                    ticket.Diachi         = ThongTin.address;

                    connection.SaveChanges();
                    return(View("Success", TempData["notice"] = "Sửa vé thành công!"));
                }
            }
            catch
            {
                return(View("Success", TempData["notice"] = "Đã có lỗi xảy ra!"));
            }
        }
        public List <ThongTinKhachHang> timTaiKhoan(string key)
        {
            List <ThongTinKhachHang> lst = null;
            long maInput;

            if (long.TryParse(key, out maInput) == true)
            {
                // nếu là số
                if (searchNhanVienTheoMa(maInput) != null)
                {
                    lst = new List <ThongTinKhachHang>();
                    ThongTinKhachHang tt = searchNhanVienTheoMa(maInput);
                    lst.Add(tt);
                }

                if (searchKhachHangTheoMa(maInput) != null)
                {
                    if (lst == null)
                    {
                        lst = new List <ThongTinKhachHang>();
                    }
                    ThongTinKhachHang tt = searchKhachHangTheoMa(maInput);
                    lst.Add(tt);
                }
                return(lst);
            }
            else
            {
                //Là từ khóa giống tên
                lst = searchTaiKhoanTheoKey(key);
            }
            return(lst);
        }
        public static Result GetThongTinKhachHang(string thongTinKhachHangGUID)
        {
            Result     result = new Result();
            MMOverride db     = null;

            try
            {
                db = new MMOverride();
                ThongTinKhachHang ttkh = db.ThongTinKhachHangs.FirstOrDefault(t => t.ThongTinKhachHangGUID.ToString().ToLower() == thongTinKhachHangGUID.ToLower());
                result.QueryResult = ttkh;
            }
            catch (System.Data.SqlClient.SqlException se)
            {
                result.Error.Code        = (se.Message.IndexOf("Timeout expired") >= 0) ? ErrorCode.SQL_QUERY_TIMEOUT : ErrorCode.INVALID_SQL_STATEMENT;
                result.Error.Description = se.ToString();
            }
            catch (Exception e)
            {
                result.Error.Code        = ErrorCode.UNKNOWN_ERROR;
                result.Error.Description = e.ToString();
            }
            finally
            {
                if (db != null)
                {
                    db.Dispose();
                    db = null;
                }
            }

            return(result);
        }
Example #7
0
        public void xoaKH(String _makh)
        {
            ThongTinKhachHang xoakh = qlbmp.ThongTinKhachHangs.Where(kh => kh.MaKhachHang == _makh).FirstOrDefault();

            qlbmp.ThongTinKhachHangs.DeleteOnSubmit(xoakh);
            qlbmp.SubmitChanges();
        }
Example #8
0
        public ActionResult DeleteConfirmed(int id)
        {
            ThongTinKhachHang thongTinKhachHang = db.ThongTinKhachHangs.Find(id);

            db.ThongTinKhachHangs.Remove(thongTinKhachHang);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 private void button4_Click(object sender, EventArgs e)
 {
     khachHang           = null;
     txtLoaiKhach.Text   = "Khách chơi qua đường";
     txtMakhach.Text     = "";
     txtTenKhach.Text    = "";
     txtDiaChi.Text      = "";
     txtSoDienThoai.Text = "";
 }
Example #10
0
        public static Result InsertThongTinKhachHang(ThongTinKhachHang ttkh)
        {
            Result     result = new Result();
            MMOverride db     = null;

            try
            {
                db = new MMOverride();
                using (TransactionScope t = new TransactionScope(TransactionScopeOption.RequiresNew))
                {
                    ThongTinKhachHang thongTinKhachHang = (from tt in db.ThongTinKhachHangs
                                                           where tt.TenKhachHang.Trim().ToLower() == ttkh.TenKhachHang.Trim().ToLower() &&
                                                           tt.MaDonVi.Trim().ToLower() == ttkh.MaDonVi.Trim().ToLower()
                                                           //tt.TenDonVi.Trim().ToLower() == ttkh.TenDonVi.Trim().ToLower() &&
                                                           //tt.DiaChi.Trim().ToLower() == ttkh.DiaChi.Trim().ToLower()
                                                           select tt).FirstOrDefault();

                    if (thongTinKhachHang == null)
                    {
                        ttkh.ThongTinKhachHangGUID = Guid.NewGuid();
                        db.ThongTinKhachHangs.InsertOnSubmit(ttkh);
                    }
                    else
                    {
                        //thongTinKhachHang.MaDonVi = ttkh.MaDonVi;
                        //thongTinKhachHang.TenDonVi = ttkh.TenDonVi;
                        //thongTinKhachHang.MaSoThue = ttkh.MaSoThue;
                        //thongTinKhachHang.DiaChi = ttkh.DiaChi;
                        thongTinKhachHang.SoTaiKhoan        = ttkh.SoTaiKhoan;
                        thongTinKhachHang.HinhThucThanhToan = ttkh.HinhThucThanhToan;
                    }

                    db.SubmitChanges();
                    t.Complete();
                }
            }
            catch (System.Data.SqlClient.SqlException se)
            {
                result.Error.Code        = (se.Message.IndexOf("Timeout expired") >= 0) ? ErrorCode.SQL_QUERY_TIMEOUT : ErrorCode.INVALID_SQL_STATEMENT;
                result.Error.Description = se.ToString();
            }
            catch (Exception e)
            {
                result.Error.Code        = ErrorCode.UNKNOWN_ERROR;
                result.Error.Description = e.ToString();
            }
            finally
            {
                if (db != null)
                {
                    db.Dispose();
                    db = null;
                }
            }

            return(result);
        }
Example #11
0
        //
        // GET: /User/

        public ActionResult Index()
        {
            if (Session["user"] != null)
            {
                ThongTinKhachHang ttkh = (ThongTinKhachHang)Session["user"];
                return(View(ttkh));
            }
            return(View());
        }
Example #12
0
 public ActionResult Edit([Bind(Include = "ID,TenKhachHang,DiaChi,SoDienThoai")] ThongTinKhachHang thongTinKhachHang)
 {
     if (ModelState.IsValid)
     {
         db.Entry(thongTinKhachHang).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(thongTinKhachHang));
 }
Example #13
0
        public static Result GetThongTinDonVi(string tenDonVi)
        {
            Result     result = new Result();
            MMOverride db     = null;

            try
            {
                if (tenDonVi == null)
                {
                    tenDonVi = string.Empty;
                }
                db = new MMOverride();
                ThongTinKhachHang thongTinKhachHang = null;
                Company           company           = db.Companies.FirstOrDefault(t => t.TenCty.Trim().ToLower() == tenDonVi.Trim().ToLower() &&
                                                                                  t.Status == (byte)Status.Actived);
                if (company != null)
                {
                    thongTinKhachHang                   = new ThongTinKhachHang();
                    thongTinKhachHang.MaDonVi           = company.MaCty;
                    thongTinKhachHang.TenDonVi          = company.TenCty;
                    thongTinKhachHang.DiaChi            = company.DiaChi;
                    thongTinKhachHang.MaSoThue          = company.MaSoThue;
                    thongTinKhachHang.HinhThucThanhToan = 0;

                    ThongTinKhachHang ttkh = db.ThongTinKhachHangs.FirstOrDefault(t => t.TenDonVi.Trim().ToLower() == tenDonVi.Trim().ToLower());
                    if (ttkh != null)
                    {
                        thongTinKhachHang.HinhThucThanhToan = ttkh.HinhThucThanhToan;
                        thongTinKhachHang.SoTaiKhoan        = ttkh.SoTaiKhoan;
                    }
                }

                result.QueryResult = thongTinKhachHang;
            }
            catch (System.Data.SqlClient.SqlException se)
            {
                result.Error.Code        = (se.Message.IndexOf("Timeout expired") >= 0) ? ErrorCode.SQL_QUERY_TIMEOUT : ErrorCode.INVALID_SQL_STATEMENT;
                result.Error.Description = se.ToString();
            }
            catch (Exception e)
            {
                result.Error.Code        = ErrorCode.UNKNOWN_ERROR;
                result.Error.Description = e.ToString();
            }
            finally
            {
                if (db != null)
                {
                    db.Dispose();
                    db = null;
                }
            }

            return(result);
        }
Example #14
0
        public ActionResult Create([Bind(Include = "ID,TenKhachHang,DiaChi,SoDienThoai")] ThongTinKhachHang thongTinKhachHang)
        {
            if (ModelState.IsValid)
            {
                db.ThongTinKhachHangs.Add(thongTinKhachHang);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(thongTinKhachHang));
        }
Example #15
0
        public void themKH(String _makh, String _tenkh, String _diachi, String _sdt, int _tichdiem, String _manhomnd)
        {
            ThongTinKhachHang kh = new ThongTinKhachHang();

            kh.MaKhachHang     = _makh;
            kh.TenKhachHang    = _tenkh;
            kh.DiaChi          = _diachi;
            kh.SoDienThoai     = _sdt;
            kh.TichDiem        = _tichdiem;
            kh.MaNhomNguoiDung = _manhomnd;
            qlbmp.ThongTinKhachHangs.InsertOnSubmit(kh);
            qlbmp.SubmitChanges();
        }
 public ActionResult Create(ThongTinKhachHang ttkh)
 {
     try
     {
         // TODO: Add insert logic here
         thongtinkh.ThemTTKH(ttkh);
         return(RedirectToAction("Index"));
     }
     catch
     {
         return(View());
     }
 }
Example #17
0
        // GET: ThongTinKhachHangs/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ThongTinKhachHang thongTinKhachHang = db.ThongTinKhachHangs.Find(id);

            if (thongTinKhachHang == null)
            {
                return(HttpNotFound());
            }
            return(View(thongTinKhachHang));
        }
Example #18
0
        public JsonResult SignIn(FormCollection data)
        {
            ThongTinKhachHang ttkh = new ThongTinKhachHang();
            JsonResult        js   = new JsonResult();
            DBIO provider          = new DBIO();

            try
            {
                ttkh.Ten_Khanh_Hang = data["name"];
                ttkh.Email          = data["email"];
                ttkh.Phone          = data["phone"];
                ttkh.Password       = data["password"];
                ttkh.Adress         = data["adress"];
            }
            catch (Exception e)
            {
                js.Data = new
                {
                    status  = "er",
                    message = e
                };
                return(Json(js, JsonRequestBehavior.AllowGet));
            }
            if (provider.CheckUserExit(ttkh.Email) == 1)
            {
                js.Data = new
                {
                    status = "exit",
                };
                return(Json(js, JsonRequestBehavior.AllowGet));
            }
            provider.InsertNewUser(ttkh);
            provider.SaveChange();
            //provider.InsertUserByQuery(ttkh.Ten_Khanh_Hang, ttkh.Email, ttkh.Phone, ttkh.Password, ttkh.Adress);
            Session["user"] = ttkh;
            Session.Timeout = 5;
            js.Data         = new
            {
                status = "OK",
                name   = ttkh.Ten_Khanh_Hang,
                email  = ttkh.Email,
                phone  = ttkh.Phone,
                pass   = ttkh.Password,
                diachi = ttkh.Adress
            };
            return(Json(js, JsonRequestBehavior.AllowGet));
        }
Example #19
0
 public ActionResult LayThongTinKhachHang(string ip_str_id_khach_hang)
 {
     try
     {
         BKI_CRMEntities   v_model         = new BKI_CRMEntities();
         DM_KHACH_HANG     v_dm_kh         = new DM_KHACH_HANG();
         ThongTinKhachHang v_dm_khach_hang = new ThongTinKhachHang();
         v_dm_kh         = v_model.DM_KHACH_HANG.Where(x => x.ID == new Guid(ip_str_id_khach_hang)).First();
         v_dm_khach_hang = v_dm_kh.CopyAs <ThongTinKhachHang>();
         return(Json(v_dm_khach_hang, JsonRequestBehavior.AllowGet));
     }
     catch (System.Exception v_e)
     {
         v_e.Log();
         return(Json(false));
     }
 }
        public ThongTinKhachHang ThongTinDonHang(int id)
        {
            var result = new ThongTinKhachHang();

            using (var db = _connection.GetConnection())
            {
                result = db.QuerySingle <ThongTinKhachHang>("SELECT * FROM info.ThongTinKhachHang WHERE Id=@Id;", new
                {
                    Id = id
                });
                result.SanPhams = db
                                  .Query <SanPhamMua
                                          >("SELECT Id,TenSanPham,SoLuong FROM info.SanPhamMua WHERE ThongTinKhachHangId=@ThongTinKhachHangId;",
                                            new
                {
                    ThongTinKhachHangId = id
                })
                                  .ToList();
            }

            return(result);
        }
        public void Them_DonHang(ThongTinKhachHang order)
        {
            using (var db = _connection.GetConnection())
            {
                // insert ThongTinKhachHang
                db.Execute("UPDATE info.ThongTinKhachHang SET TenKhachHang=@TenKhachHang,DiaChi=@DiaChi,DienThoai=@DienThoai,TrangThai=@TrangThai,NgayTao=@NgayTao,IsDeleted=@IsDeleted, IsInit=@IsInit WHERE Id=@Id;",
                           new
                {
                    order.Id,
                    order.TenKhachHang,
                    order.DiaChi,
                    order.DienThoai,
                    order.TrangThai,
                    order.NgayTao,
                    order.IsDeleted,
                    order.IsInit
                });
                // insert SanPhamMua

                db.Execute("INSERT INTO info.SanPhamMua(ThongTinKhachHangId,TenSanPham,SoLuong) VALUES(@ThongTinKhachHangId,@TenSanPham,@SoLuong);",
                           order.SanPhams.Select(p => new
                {
                    ThongTinKhachHangId = order.Id,
                    p.TenSanPham,
                    p.SoLuong
                }));
            }

            // producer publish message
            _producer.PublishMessage(new Message_Customer
            {
                Id = order.Id,                              //ThongTinKhachHangId
                CustomerAddress = order.DiaChi,
                PhoneNumber     = order.DienThoai,
                CustomerName    = order.TenKhachHang,
                Status          = Status.Da_Thanh_Toan
            });
        }
        ThongTinKhachHang searchNhanVienTheoMa(long ma)
        {
            ThongTinKhachHang tt = null;

            try
            {
                tt = (from tk in db.TAIKHOAN
                      join nv in db.NHANVIEN on tk.MATAIKHOAN equals nv.MATAIKHOAN
                      where nv.MANHANVIEN == ma
                      select new ThongTinKhachHang
                {
                    maKhach = nv.MANHANVIEN,
                    maTaiKhoan = tk.MATAIKHOAN,
                    ten = tk.TEN,
                    diaChi = tk.DIACHI,
                    soDienThoai = tk.SDT,
                    isNhanVien = true,
                    gioiTinh = (bool)tk.GIOITINH,
                    ngaySinh = (DateTime)tk.NGAYSINH
                }).Single();
            }
            catch (Exception ex) { }
            return(tt);
        }
        ThongTinKhachHang searchKhachHangTheoMa(long ma)
        {
            ThongTinKhachHang tt = null;

            try
            {
                tt = (from tk in db.TAIKHOAN
                      join kh in db.KHACHHANG on tk.MATAIKHOAN equals kh.MATAIKHOAN
                      where kh.MAKH == ma
                      select new ThongTinKhachHang
                {
                    maKhach = kh.MAKH,
                    maTaiKhoan = tk.MATAIKHOAN,
                    ten = tk.TEN,
                    diaChi = tk.DIACHI,
                    soDienThoai = tk.SDT,
                    isNhanVien = false,
                    gioiTinh = (bool)tk.GIOITINH,
                    ngaySinh = (DateTime)tk.NGAYSINH
                }).Single();
            }
            catch (Exception ex) { }
            return(tt);
        }
Example #24
0
 // insert người mới đăng kí cách 1
 public void InsertNewUser(ThongTinKhachHang ttkh)
 {
     bosstable.ThongTinKhachHangs.Add(ttkh);
 }
        List <ThongTinKhachHang> searchTaiKhoanTheoKey(string key)
        {
            List <TAIKHOAN> lst = null;

            try
            {
                lst = (from c in db.TAIKHOAN
                       where c.TEN.Contains(key)
                       select c).ToList();
            }
            catch (Exception ex) { }
            List <ThongTinKhachHang> resLst = null;

            if (lst != null)
            {
                resLst = new List <ThongTinKhachHang>();
                foreach (TAIKHOAN item in lst)
                {
                    bool isNhanVien = (bool)(from c in db.TAIKHOAN
                                             where c.MATAIKHOAN == item.MATAIKHOAN
                                             select c.ISNHANVIEN).Single();
                    if (isNhanVien == true)
                    {
                        // là nhân viên join với bản nhân viên để lấy mã
                        ThongTinKhachHang tt = (from c in db.TAIKHOAN
                                                join nv in db.NHANVIEN on c.MATAIKHOAN equals nv.MATAIKHOAN
                                                select new ThongTinKhachHang
                        {
                            maKhach = nv.MANHANVIEN,
                            maTaiKhoan = c.MATAIKHOAN,
                            ten = c.TEN,
                            diaChi = c.DIACHI,
                            gioiTinh = (bool)c.GIOITINH,
                            isNhanVien = true,
                            ngaySinh = (DateTime)c.NGAYSINH,
                            soDienThoai = c.SDT
                        }).Single();
                        resLst.Add(tt);
                    }
                    else
                    {
                        //là khách hàng join với bảng khách hàng để lấy mã
                        ThongTinKhachHang tt = (from c in db.TAIKHOAN
                                                join kh in db.KHACHHANG on c.MATAIKHOAN equals kh.MATAIKHOAN
                                                select new ThongTinKhachHang
                        {
                            maKhach = kh.MAKH,
                            maTaiKhoan = c.MATAIKHOAN,
                            ten = c.TEN,
                            diaChi = c.DIACHI,
                            gioiTinh = (bool)c.GIOITINH,
                            isNhanVien = false,
                            ngaySinh = (DateTime)c.NGAYSINH,
                            soDienThoai = c.SDT
                        }).Single();
                        resLst.Add(tt);
                    }
                }
            }
            return(resLst);
        }
Example #26
0
        private bool ExportInvoice()
        {
            try
            {
                if (!CheckInfo())
                {
                    return(false);
                }

                HoaDonXetNghiem invoice = new HoaDonXetNghiem();
                invoice.SoHoaDon          = _invoiceCode;
                invoice.NgayXuatHoaDon    = dtpkNgay.Value;
                invoice.TenNguoiMuaHang   = cboTenNguoiMuaHang.Text;
                invoice.DiaChi            = txtAddress.Text;
                invoice.TenDonVi          = cboTenDonVi.Text;
                invoice.MaDonVi           = cboMaDonVi.Text;
                invoice.MaSoThue          = txtMaSoThue.Text;
                invoice.SoTaiKhoan        = txtSoTaiKhoan.Text;
                invoice.HinhThucThanhToan = (byte)cboHinhThucThanhToan.SelectedIndex;
                invoice.VAT                = (double)numVAT.Value;
                invoice.CreatedDate        = DateTime.Now;
                invoice.CreatedBy          = Guid.Parse(Global.UserGUID);
                invoice.Status             = (byte)Status.Actived;
                invoice.ChuaThuTien        = !chkDaThuTien.Checked;
                invoice.MauSo              = Global.MauSoXetNghiemSauCung;
                invoice.KiHieu             = Global.KiHieuXetNghiemSauCung;
                invoice.HinhThucNhanHoaDon = raKhachTuLay.Checked ? "Khách tự lấy" : "Gởi qua bưu điện";
                invoice.Notes              = txtGhiChu.Text;

                List <ChiTietHoaDonXetNghiem> addedDetails = new List <ChiTietHoaDonXetNghiem>();
                for (int i = 0; i < dgDetail.RowCount - 1; i++)
                {
                    DataGridViewRow        row    = dgDetail.Rows[i];
                    ChiTietHoaDonXetNghiem detail = new ChiTietHoaDonXetNghiem();
                    detail.CreatedDate = DateTime.Now;
                    detail.CreatedBy   = Guid.Parse(Global.UserGUID);
                    detail.TenHangHoa  = row.Cells["TenHangHoa"].Value.ToString();

                    //if (row.Cells["DonViTinh"].Value != null)
                    //    detail.DonViTinh = row.Cells["DonViTinh"].Value.ToString();
                    //else
                    detail.DonViTinh = "Lần";

                    int soLuong = 1;
                    //if (row.Cells["SoLuong"].Value != null && row.Cells["SoLuong"].Value != DBNull.Value)
                    //    soLuong = Convert.ToInt32(row.Cells["SoLuong"].Value);
                    detail.SoLuong = soLuong;

                    //int donGia = 0;
                    //if (row.Cells["DonGia"].Value != null && row.Cells["DonGia"].Value != DBNull.Value)
                    //    donGia = Convert.ToInt32(row.Cells["DonGia"].Value);

                    //detail.DonGia = donGia;

                    int thanhTien = 0;
                    if (row.Cells["ThanhTien"].Value != null && row.Cells["ThanhTien"].Value != DBNull.Value)
                    {
                        thanhTien = Convert.ToInt32(row.Cells["ThanhTien"].Value);
                    }

                    detail.ThanhTien = thanhTien;
                    detail.DonGia    = thanhTien;

                    addedDetails.Add(detail);
                }

                Result result = HoaDonXetNghiemBus.InsertHoaDonXetNghiem(invoice, addedDetails);
                if (result.IsOK)
                {
                    //Insert thông tin khách hàng
                    ThongTinKhachHang thongTinKhachHang = new ThongTinKhachHang();
                    thongTinKhachHang.TenKhachHang = invoice.TenNguoiMuaHang;
                    //thongTinKhachHang.TenDonVi = invoice.TenDonVi;
                    thongTinKhachHang.MaDonVi = invoice.MaDonVi;
                    //thongTinKhachHang.MaSoThue = invoice.MaSoThue;
                    //thongTinKhachHang.DiaChi = invoice.DiaChi;
                    thongTinKhachHang.SoTaiKhoan        = invoice.SoTaiKhoan;
                    thongTinKhachHang.HinhThucThanhToan = invoice.HinhThucThanhToan;
                    result = ThongTinKhachHangBus.InsertThongTinKhachHang(thongTinKhachHang);
                    if (!result.IsOK)
                    {
                        MsgBox.Show(Application.ProductName, result.GetErrorAsString("ThongTinKhachHangBus.InsertThongTinKhachHang"), IconType.Error);
                        Utility.WriteToTraceLog(result.GetErrorAsString("ThongTinKhachHangBus.InsertThongTinKhachHang"));
                    }

                    _hoaDonXetNghiem = invoice;
                    if (!_isPrinted)
                    {
                        return(true);
                    }
                    OnPrint(invoice.HoaDonXetNghiemGUID.ToString());
                    return(true);
                }
                else
                {
                    MsgBox.Show(Application.ProductName, result.GetErrorAsString("HoaDonXetNghiemBus.InsertHoaDonXetNghiem"), IconType.Error);
                    Utility.WriteToTraceLog(result.GetErrorAsString("HoaDonXetNghiemBus.InsertHoaDonXetNghiem"));
                }
            }
            catch (Exception ex)
            {
                MsgBox.Show(Application.ProductName, ex.Message, IconType.Error);
                Utility.WriteToTraceLog(ex.Message);
            }

            return(false);
        }