public void loadKhoanthu() { StudenGrade dt = new StudenGrade(); txtTenKhoanThu.Text = ReceivableDetailDAO.DemoReceibavleDetail.Name; txtMucThu.Text = ReceivableDetailDAO.DemoReceibavleDetail.Price.ToString(); txtTanso.Text = ReceivableDetailDAO.DemoReceibavleDetail.Frequency.ToString(); cbbDonViThoiGian.Text = ReceivableDetailDAO.DemoReceibavleDetail.TimeUnits; txtDv.Text = cbbDonViThoiGian.Text; txtTongthu.Text = ReceivableDetailDAO.DemoReceibavleDetail.TotalPriceDetail.ToString(); cbHoanLai.Checked = (bool)ReceivableDetailDAO.DemoReceibavleDetail.Feedback; int a = (int)ReceivableDetailDAO.DemoReceibavleDetail.GradeID; cbbKhoihoc.Text = dt.lookforGrade(a).Name; dtNgayBatDau.EditValue = (DateTime)ReceivableDetailDAO.DemoReceibavleDetail.StartDay; dtNgayKetThuc.EditValue = (DateTime)ReceivableDetailDAO.DemoReceibavleDetail.EndDay; if (ReceivableDetailDAO.DemoReceibavleDetail.PreferredID != "") { cbDoituongchinhsach.Checked = true; } else { cbDoituongchinhsach.Checked = false; } }
private void bntKhoitao_Click(object sender, EventArgs e) { if (txtTendotthu.Text == "") { MessageBox.Show("Bạn cần nhập đủ thông tin đợt thu"); } else { if (cbbHocky.Text != "") { try { // thêm đợt thu ReceivableIDAO rb = new ReceivableIDAO(); ReceivableDetailDAO rbd = new ReceivableDetailDAO(); Receivable rbdt = new Receivable(); rbdt.Name = txtTendotthu.Text; rbdt.CourseID = (int)cbbNamhoc.SelectedValue; rbdt.SemesterID = (int)cbbHocky.SelectedValue; rbdt.StartDate = dtNgaybatdau.Value; rbdt.EndDate = dtNgayketthuc.Value; rbdt.CreatedDate = dtNgaykhoitao.Value; rbdt.Note = txtGhiChu.Text; rbdt.Status = false; int c = rb.Insert(rbdt); // thêm khoản thu if (c != 0) { ReceivableDetail detail = new ReceivableDetail(); for (int i = 0; i < gridView1.RowCount; i++) { detail.Name = gridView1.GetRowCellValue(i, gridView1.Columns["Name"]).ToString(); detail.ReceivableID = c; detail.Price = (decimal)gridView1.GetRowCellValue(i, gridView1.Columns["Price"]); detail.Status = false; detail.TimeUnits = gridView1.GetRowCellValue(i, gridView1.Columns["TimeUnits"]).ToString(); detail.Frequency = (int)gridView1.GetRowCellValue(i, gridView1.Columns["Frequency"]); detail.TotalPriceDetail = (decimal)gridView1.GetRowCellValue(i, gridView1.Columns["TotalPriceDetail"]); detail.GradeID = (int)gridView1.GetRowCellValue(i, gridView1.Columns["GradeID"]); detail.Feedback = (bool)gridView1.GetRowCellValue(i, gridView1.Columns["Feedback"]); detail.PreferredID = gridView1.GetRowCellValue(i, gridView1.Columns["PreferredID"]).ToString(); int d = rbd.Insert(detail); if (d != 0) { //thêm khoản thu học cho học sinh theo lớp hiện hành StudenGrade gr = new StudenGrade(); ReceivableDetail_StudentDAO st = new ReceivableDetail_StudentDAO(); List <Student_Class> listClassID = gr.lookStudenbyGradeID((int)detail.GradeID); foreach (var j in listClassID) { if (j.Status == true) { ReceivableDetail_Student dt = new ReceivableDetail_Student(); dt.ReceivableDetailID = d; dt.StudentID = j.StudentID; dt.Status = false; if (st.Insert(dt) == true) { } else { MessageBox.Show("ban gi bi loi"); } } } } else { MessageBox.Show("Ban ghi " + i + " bi loi"); } } MessageBox.Show("Khoi tao hoan tat"); this.Close(); } } catch { MessageBox.Show("Loi"); } } } }