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");
}
}
}
}
