private void bntLuu_Click(object sender, EventArgs e) { try { ReceivableDetail_StudentDAO dt = new ReceivableDetail_StudentDAO(); ReceivableIDAO dc = new ReceivableIDAO(); for (int i = 0; i < gridView1.RowCount; i++) { ReceivableDetail_Student a = new ReceivableDetail_Student(); a.ReceivableDetailID = (int)gridView1.GetRowCellValue(i, gridView1.Columns["ReceivableDetailID"]); a.StudentID = ClassStudentDAO.StudentID; a.Status = (bool)gridView1.GetRowCellValue(i, gridView1.Columns["Status"]); if (dt.Edit(a) == true) { } else { MessageBox.Show("Bản ghi thứ " + i + " Chưa được lưu"); } } MessageBox.Show("Lưu thành công"); this.Close(); } catch { MessageBox.Show("Lỗi"); } }
public void laodDotthu() { ReceivableIDAO dt = new ReceivableIDAO(); cbbDotthu.DataSource = dt.ListReceivable((int)cbbNamhoc.SelectedValue, (int)cbbHocky.SelectedValue); cbbDotthu.ValueMember = "ReceivableID"; cbbDotthu.DisplayMember = "Name"; }
public void LoadDataDotThu() { try { ReceivableIDAO db = new ReceivableIDAO(); grcDotThu.DataSource = db.ListReceivable((int)cbbNamhoc.SelectedValue, (int)cbbHocky.SelectedValue); } catch { } }
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"); } } } }
public void LoadDataDotThu() { ReceivableIDAO db = new ReceivableIDAO(); grDotThu.DataSource = db.ListReceivable((int)cbbHocky.SelectedValue, (int)cbbHocky.SelectedValue); }