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 insertKhachHang(params object[] oParams)
{
try
{
if (oParams != null)
{
vo_KhachHang vo_KH = (vo_KhachHang)oParams[0];
ConnectionString cnn = new ConnectionString();
string query = "INSERT INTO KHACHHANG (MAKHACHHANG, TENKHACHHANG, SODIENTHOAI, SOTAIKHOAN, NGAYSINH, DIACHI, GIOITINH, CMND, NGAYDANGKY, GHICHU) " +
"output INSERTED.ID VALUES(@maKH, @tenKH, @sdt, @stk, @ngaySinh, @diaChi, @gioiTinh, @cmnd, @ngayDK , @ghiChu)";
string[] arrParam = new string[] { "@maKH", "@tenKH", "@sdt", "@stk", "@ngaySinh", "@diaChi", "@gioiTinh", "@cmnd", "@ngayDK", "@ghiChu" };
SqlDbType[] arrType = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar,
SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar };
object[] arrvalues = new object[] { vo_KH.MaKhachHang, vo_KH.TenKhachHang, vo_KH.SoDienThoai, vo_KH.SoTaiKhoan, vo_KH.NgaySinh,
vo_KH.DiaChi, vo_KH.GioiTinh, vo_KH.Cmnd, vo_KH.NgayDangKi, vo_KH.GhiChu };
return(cnn.conn.ExecuteQueryReturnID(query, arrParam, arrvalues, arrType));
}
return(0);
}
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;
}
}
public pl_windowThemKhachHang()
{
try
{
InitializeComponent();
bus_khachHang = new bus_KhachHang();
vo_khachHang = new vo_KhachHang();
string MaKh = bus_khachHang.generateMaKhachHang();
this.vo_khachHang.MaKhachHang = MaKh;
this.DataContext = this.vo_khachHang;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
public int updateKhachHang(params object[] oParams)
{
try
{
if (oParams != null)
{
vo_KhachHang vo_KH = (vo_KhachHang)oParams[0];
string query = "UPDATE KHACHHANG SET TENKHACHHANG=@tenKH, SOTAIKHOAN=@stk , SODIENTHOAI=@sdt, NGAYSINH=@ngaySinh, DIACHI=@diaChi" + "GIOITINH=@gioTinh, CMND=@cmnd,NGAYDANGKY=@ngayDK,GHICHU=@ghiChu WHERE OUTPUT INSERTED.ID ID=@id ";
ConnectionString cnn = new ConnectionString();
string[] arrParam = new string[] { "@tenKH", "@stk", "@sdt", "@ngaySinh", "@diaChi", "@gioiTinh", "@cmnd", "@ngayDK", "@ghiChu", "@id" };
SqlDbType[] arrType = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int };
object[] arrvalues = new object[] { vo_KH.TenKhachHang, vo_KH.SoTaiKhoan, vo_KH.SoDienThoai, vo_KH.NgaySinh, vo_KH.DiaChi, vo_KH.GioiTinh, vo_KH.Cmnd, vo_KH.NgayDangKi, vo_KH.GhiChu, vo_KH.Id };
return(cnn.conn.ExecuteQueryReturnID(query, arrParam, arrvalues, arrType));
}
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
