protected void HienThiDanhSach()
{
GiaiDoanDAO gddao = new GiaiDoanDAO();
gvDSGiaiDoan.DataSource = gddao.DSGiaiDoan();
gvDSGiaiDoan.DataBind();
}
protected void gvDSGiaiDoan_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GiaiDoanDAO gddao = new GiaiDoanDAO();
int autoid = int.Parse(gvDSGiaiDoan.DataKeys[e.RowIndex].Value.ToString());
gddao.XoaGiaiDoan(autoid);
HienThiDanhSach();
}
protected void btnThem_Click(object sender, EventArgs e)
{
GiaiDoanDAO gddao = new GiaiDoanDAO();
string ten = txtTenGiaiDoan.Text;
gddao.ThemGiaiDoan(ten);
HienThiDanhSach();
txtTenGiaiDoan.Text = "";
}
void load_GiaiDoan()
{
GiaiDoanDAO gd = new GiaiDoanDAO();
DataTable dt = new DataTable();
dt = gd.DSGiaiDoan();
drLoaiBaoCao.DataSource = dt;
drLoaiBaoCao.DataTextField = "TenGiaiDoan";
drLoaiBaoCao.DataValueField = "ID_GiaiDoanHoanThanh";
drLoaiBaoCao.DataBind();
}
void load_DropList()
{
if (!this.IsPostBack)
{
// Giam dinh vien
GiamDinhVienDAO gdv = new GiamDinhVienDAO();
DataTable dt = gdv.DanhSachGiamDinhVien();
drGDV1.DataSource = dt;
drGDV1.DataValueField = "ID_GDV";
drGDV1.DataTextField = "TenGDV";
drGDV1.DataBind();
drGDV2.DataSource = dt;
drGDV2.DataValueField = "ID_GDV";
drGDV2.DataTextField = "TenGDV";
drGDV2.DataBind();
drGDV3.DataSource = dt;
drGDV3.DataValueField = "ID_GDV";
drGDV3.DataTextField = "TenGDV";
drGDV3.DataBind();
// nha bao hiem
NhaBHDAO nbhdao = new NhaBHDAO();
drNBH.DataSource = nbhdao.DSCongTyTong();
drNBH.DataValueField = "ID_NhaBH";
drNBH.DataTextField = "TenNhaBH";
drNBH.DataBind();
// khach hang
KhachHangDAO khdao = new KhachHangDAO();
drKH.DataSource = khdao.DSNguoiDuocBaoHiem();
drKH.DataValueField = "ID_KhachHang";
drKH.DataTextField = "TenKhachHang";
drKH.DataBind();
// loai hinh ton that
LoaiHinhTonThatDAO lhTTdao = new LoaiHinhTonThatDAO();
drLoaiHinhTonThat.DataSource = lhTTdao.DSLoaiHinhTT();
drLoaiHinhTonThat.DataValueField = "ID_LoaiHinhTonThat";
drLoaiHinhTonThat.DataTextField = "LoaiHinhTonThat";
drLoaiHinhTonThat.DataBind();
// giai doan thuc hien
GiaiDoanDAO gddao = new GiaiDoanDAO();
}
}
protected void gvDSGiaiDoan_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = gvDSGiaiDoan.Rows[e.RowIndex];
TextBox txt2nd_column = row.Cells[1].Controls[0] as TextBox;
int a = Int32.Parse(gvDSGiaiDoan.DataKeys[e.RowIndex].Value.ToString());
string b = txt2nd_column.Text;
GiaiDoanDAO gddao = new GiaiDoanDAO();
gddao.SuaGiaiDoan(a, b);
e.Cancel = true;
gvDSGiaiDoan.EditIndex = -1;
HienThiDanhSach();
}
