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();
 }
        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();
        }
 protected void HienThiDanhSach()
 {
     GiaiDoanDAO gddao = new GiaiDoanDAO();
     gvDSGiaiDoan.DataSource = gddao.DSGiaiDoan();
     gvDSGiaiDoan.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();

            }
        }