public List <clsLoaiTheKhachHang> LayLoaiTheKhachHang()
{
List <clsLoaiTheKhachHang> lstLoaiTheKH = new List <clsLoaiTheKhachHang>();
SqlConnection con = ThaoTacDuLieu_DAO.TaoKetNoi();
string query = "SELECT * FROM LoaiTheKhachHang";
SqlCommand cmd = ThaoTacDuLieu_DAO.TruyVan(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
clsLoaiTheKhachHang loaiTheKH = new clsLoaiTheKhachHang();
if (!reader.IsDBNull(0))
{
loaiTheKH.MaLoaiThe = (string)reader[0];
}
if (!reader.IsDBNull(1))
{
loaiTheKH.TenLoaiTheKH = (string)reader[1];
}
if (!reader.IsDBNull(2))
{
loaiTheKH.GiamGia = (float)(double)reader[2];
}
if (!reader.IsDBNull(3))
{
loaiTheKH.DonViGiamGia = (string)reader[3];
}
if (!reader.IsDBNull(4))
{
loaiTheKH.TrangThai = (bool)reader[4];
}
lstLoaiTheKH.Add(loaiTheKH);
}
ThaoTacDuLieu_DAO.DongKetNoi(con);
return(lstLoaiTheKH);
}
private void dgvDSTheKH_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (dgvDSTheKH.Columns[e.ColumnIndex].Name.ToString() == "colTrangThai")
{
if (Convert.ToBoolean(e.Value) == true)
{
e.Value = "Mở";
}
else
{
e.Value = "Khóa";
}
}
if (dgvDSTheKH.Columns[e.ColumnIndex].Name.ToString() == "colTenKH")
{
KhachHang_BUS bus = new KhachHang_BUS();
List <clsKhachHang_DTO> lstKH = bus.LayDanhSachKhachHang("", -1);
clsKhachHang_DTO KH = lstKH.First(u => u.MaKhachHang == e.Value.ToString());
e.Value = KH.TenKhachHang;
}
LoaiTheKhachHang_BUS LoaiTheKH_bus = new LoaiTheKhachHang_BUS();
List <clsLoaiTheKhachHang> lstLoaiTheKH = LoaiTheKH_bus.LayLoaiTheKhachHang();
if (dgvDSTheKH.Columns[e.ColumnIndex].Name.ToString() == "colLoaiThe")
{
clsLoaiTheKhachHang LoaiTheKH = lstLoaiTheKH.First(u => u.MaLoaiThe == e.Value.ToString());
e.Value = LoaiTheKH.TenLoaiTheKH;
}
//if (dgvDSTheKH.Columns[e.ColumnIndex].Name.ToString() == "colGiamGia")
//{
// e.Value = lstLoaiTheKH[0].GiamGia;
//}
//if (dgvDSTheKH.Columns[e.ColumnIndex].Name.ToString() == "colDonViGiamGia")
//{
// e.Value = lstLoaiTheKH[0].DonViGiamGia;
//}
if (dgvDSTheKH.Columns[e.ColumnIndex].Name.ToString() == "colNgayDangKy")
{
e.Value = DateTime.Parse(e.Value.ToString()).ToShortDateString();
}
foreach (DataGridViewRow r in dgvDSTheKH.Rows)
{
if (!Convert.ToBoolean(r.Cells["colTrangThai"].Value.ToString()))
{
r.DefaultCellStyle.ForeColor = Color.Gray;
}
else
{
r.DefaultCellStyle.ForeColor = Color.Black;
}
}
}
