public ObservableCollection <vo_KhachHang> getAllKhachHang() { try { dao_KhachHang dao = new dao_KhachHang(); DataTable dt = dao.getAllKhachHang(); ObservableCollection <vo_KhachHang> dsKhachHang = new ObservableCollection <vo_KhachHang>(); foreach (DataRow dr in dt.Rows) { vo_KhachHang vo = new vo_KhachHang(); vo.Id = int.Parse(dr["ID"].ToString()); vo.MaKhachHang = dr["MAKHACHHANG"].ToString(); vo.TenKhachHang = dr["TENKHACHHANG"].ToString(); vo.NgaySinh = dr["NGAYSINH"].ToString(); vo.NgayDangKi = dr["NGAYDANGKY"].ToString(); vo.SoDienThoai = dr["SODIENTHOAI"].ToString(); vo.SoTaiKhoan = dr["SOTAIKHOAN"].ToString(); vo.Cmnd = dr["CMND"].ToString(); vo.DiaChi = dr["DIACHI"].ToString(); vo.GhiChu = dr["GHICHU"].ToString(); vo.GioiTinh = int.Parse(dr["GIOITINH"].ToString()); dsKhachHang.Add(vo); } return(dsKhachHang); } catch (Exception ex) { throw ex; } }
public vo_KhachHang getKhachHangById(int id) { try { dao_KhachHang dao = new dao_KhachHang(); DataTable dt = dao.getKhachHangById(id); vo_KhachHang vo = new vo_KhachHang(); DataRow dr = dt.Rows[0]; vo.Id = int.Parse(dr["ID"].ToString()); vo.MaKhachHang = dr["MAKHACHHANG"].ToString(); vo.TenKhachHang = dr["TENKHACHHANG"].ToString(); vo.NgaySinh = dr["NGAYSINH"].ToString(); vo.NgayDangKi = dr["NGAYDANGKY"].ToString(); vo.SoDienThoai = dr["SODIENTHOAI"].ToString(); vo.SoTaiKhoan = dr["SOTAIKHOAN"].ToString(); vo.Cmnd = dr["CMND"].ToString(); vo.DiaChi = dr["DIACHI"].ToString(); vo.GhiChu = dr["GHICHU"].ToString(); vo.GioiTinh = int.Parse(dr["GIOITINH"].ToString()); return(vo); } catch (Exception ex) { throw ex; } }
public int addKhachHang(vo_KhachHang vo_KH) { try { dao_KhachHang dao = new dao_KhachHang(); int id = dao.insertKhachHang(vo_KH); return(id); } catch (Exception ex) { throw ex; } }
// mày kêu nó xóa thì m phải cho nó biết m xóa thằng nào chớ //phải truyền id của cái thằng cần xóa public int deleteKhachHang(int _id) { try { dao_KhachHang dao = new dao_KhachHang(); int id = dao.deleteKhachHang(_id); return(id); } catch (Exception ex) { throw ex; } }
public string generateMaKhachHang() { try { dao_KhachHang dao_KH = new dao_KhachHang(); int id = dao_KH.getLastKhachHangID() + 1; string code = "KH" + String.Format("{0:000000}", id); return(code); } catch (Exception ex) { throw ex; } }