Пример #1
0
 private void btnXoaList_Click(object sender, EventArgs e)
 {
     if (id != -1)
     {
         PhieuMuon  pm     = new PhieuMuon();
         List <int> listID = new List <int>();
         foreach (DataGridViewRow check in GridViewPM.Rows)
         {
             if ((bool)check.Cells["status"].FormattedValue)
             {
                 listID.Add((int)check.Cells["MaPhieuMuon"].Value);
             }
         }
         foreach (int a in listID)
         {
             pm.xoaPM(a);
         }
         id = -1;
         loadPM();
     }
     else
     {
         ErrorMessage("Vui lòng chọn ít nhất một checkbox", "Missing ID");
     }
 }
Пример #2
0
        private void BtnSua_Click(object sender, EventArgs e)
        {
            int MaDocGia = 0;
            int MaSach   = 0;

            if (id == -1)
            {
                ErrorMessage("Vui lòng chọn PM để sửa!!!", "Data Error");
            }
            else
            {
                DataRowView rowDocGia = (DataRowView)cbHoTenDocGia.SelectedItem;
                if (rowDocGia != null)
                {
                    MaDocGia = (int)rowDocGia[0];
                }
                DataRowView rowSach = (DataRowView)cbTenSach.SelectedItem;
                if (rowSach != null)
                {
                    MaSach = (int)rowSach[0];
                }
                PhieuMuon pm = new PhieuMuon();
                pm.suaPM(datePickerNM.Value, MaDocGia, id, MaSach, Int32.Parse(txtTienNo.Text), Int32.Parse(txtSoTienThu.Text));
                setNullForText();
                loadPM();
                id = -1;
            }
        }
Пример #3
0
        private void loadPM()
        {
            //LVPM.Items.Clear();
            PhieuMuon pm = new PhieuMuon();
            DataTable dt = pm.layDSPM();

            GridViewPM.DataSource = dt;
        }
Пример #4
0
        private void loadCBDocGia()
        {
            cbHoTenDocGia.DataSource = null;
            PhieuMuon pm = new PhieuMuon();
            DataTable dt = pm.layDSDG();

            cbHoTenDocGia.DisplayMember = "HoTenDocGia";
            cbHoTenDocGia.ValueMember   = "MaDocGia";
            cbHoTenDocGia.DataSource    = dt;
            cbHoTenDocGia.SelectedIndex = -1;
            cbHoTenDocGia.Text          = "--Select--";
        }
Пример #5
0
        private void loadCBSach()
        {
            cbTenSach.DataSource = null;
            PhieuMuon pm = new PhieuMuon();
            DataTable dt = pm.layDSSach();

            cbTenSach.DataSource    = dt;
            cbTenSach.DisplayMember = "TenSach";
            cbTenSach.ValueMember   = "MaSach";
            cbTenSach.SelectedIndex = -1;
            cbTenSach.Text          = "--Select--";
        }
Пример #6
0
        private void loadCBNV()
        {
            //cbHoTenNV.Items.Clear();
            cbHoTenNV.DataSource = null;
            PhieuMuon pm = new PhieuMuon();
            DataTable dt = pm.layDSNV();

            cbHoTenNV.DisplayMember = "HoTenNhanVien";
            cbHoTenNV.ValueMember   = "MaNhanVien";
            cbHoTenNV.DataSource    = dt;
            cbHoTenNV.SelectedIndex = -1;
            cbHoTenNV.Text          = "--Select--";
        }
Пример #7
0
        private void BtnThem_Click(object sender, EventArgs e)
        {
            int MaDocGia = -1;
            int MaSach   = -1;
            int MaNV     = -1;


            DataRowView rowDocGia = (DataRowView)cbHoTenDocGia.SelectedItem;

            if (rowDocGia != null)
            {
                MaDocGia = (int)rowDocGia[0];
            }
            DataRowView rowSach = (DataRowView)cbTenSach.SelectedItem;

            if (rowSach != null)
            {
                MaSach = (int)rowSach[0];
            }
            DataRowView rowNV = (DataRowView)cbHoTenNV.SelectedItem;

            if (rowNV != null)
            {
                MaNV = (int)rowNV[0];
            }
            if (MaDocGia.Equals(-1))
            {
                ErrorMessage("Vui lòng chọn Độc Giả", "Missing Customer ID");
            }
            else if (MaSach.Equals(-1))
            {
                ErrorMessage("Vui lòng chọn Sách", "Missing Book ID");
            }
            else if (MaNV.Equals(-1))
            {
                ErrorMessage("Vui lòng chọn Nhân Viên", "Missing EmployeeID");
            }
            else
            {
                if (txtTienNo.Text.Trim().Equals("") && txtSoTienThu.Text.Trim().Equals(""))
                {
                    txtSoTienThu.Text = "0";
                    txtTienNo.Text    = "0";
                }
                PhieuMuon pm = new PhieuMuon();
                pm.themPM(DateTime.Now, MaDocGia, MaSach, Int32.Parse(txtTienNo.Text), Int32.Parse(txtSoTienThu.Text), MaNV);
                setNullForText();
                loadPM();
            }
        }
Пример #8
0
 private void BtnXoa_Click(object sender, EventArgs e)
 {
     if (id != -1)
     {
         PhieuMuon pm = new PhieuMuon();
         pm.xoaPM(id);
         setNullForText();
         loadPM();
         id = -1;
     }
     else
     {
         ErrorMessage("Vui lòng chọn Phiếu Mượn để xóa", "Missing ID");
     }
 }
Пример #9
0
        private void btnTraSach_Click(object sender, EventArgs e)
        {
            PhieuMuon pm = new PhieuMuon();

            if (id != -1)
            {
                pm.TraSach(id, datePickerNgayTra.Value);
                id = -1;
            }
            else
            {
                ErrorMessage("Vui lòng click chọn Phiếu Mượn để xóa", "Missing ID");
            }
            loadPM();
        }