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 List <TCStudentViewModle> listviewSD(int classID, int ReceivableID) { List <ReceivableDetail_Student> listStudenReceivableDetail = new List <ReceivableDetail_Student>(); List <TCStudentViewModle> listViewStuden = new List <TCStudentViewModle>(); List <ReceivableDetail> listReceivableDetail = new List <ReceivableDetail>(); // danh sách chi tiết khoản thu var a1 = dt.ReceivableDetails.Where(t => t.ReceivableID == ReceivableID); a1.ToList(); // lấy học sinh của lớp classID var a = dt.Student_Classes.Where(t => t.ClassID == classID); a.ToList(); //từ danh sách học sinh của lớp đó lấy ra danh sách học danh sách học sinh với khoản thu tương tứng foreach (var i in a) { ReceivableDetail_Student st = new ReceivableDetail_Student(); foreach (var item in a1) { st = dt.ReceivableDetail_Students.Where(t => t.StudentID == i.StudentID && t.ReceivableDetailID == item.ReceivableDetailID).FirstOrDefault(); if (st != null) { listStudenReceivableDetail.Add(st); } break; } } //danh sách học sinh theo các khoản thu foreach (var js in listStudenReceivableDetail) { Student b = new Student(); b = dt.Students.FirstOrDefault(t => t.StudentID == js.StudentID); //ListStudent.Add(b); TCStudentViewModle d = new TCStudentViewModle(); d.StudentID = b.StudentID; d.StudentCode = b.StudentCode; d.FirstName = b.FirstName; d.LastName = b.LastName; d.HomeName = b.HomeName; d.Birthday = b.Birthday; d.Gender = b.Gender == true ? "Nam" : "Nữ"; //d.Image = b.Image.ToArray(); d.Hobby = b.Hobby; d.Talent = b.Talent; d.DateStudy = b.DateStudy; d.EthnicGroupID = b.EthnicGroupID; d.ReligionID = b.ReligionID; d.BirthPlaceID = b.BirthPlaceID; d.LocationID = b.LocationID; d.AdressDetail = b.AdressDetail; //d.PreferredID = (int)b.PreferredID; d.Note = b.Note; d.Status = b.Status; listViewStuden.Add(d); } return(listViewStuden); }
public bool Remove(ReceivableDetail_Student entity) { ReceivableDetail_Student a = dt.ReceivableDetail_Students.Where(t => t.ReceivableDetailID == entity.ReceivableDetailID && t.StudentID == entity.StudentID).FirstOrDefault(); dt.ReceivableDetail_Students.DeleteOnSubmit(a); dt.SubmitChanges(); return(true); }
public bool Edit(ReceivableDetail_Student entity) { ReceivableDetail_Student a = dt.ReceivableDetail_Students.Where(t => t.ReceivableDetailID == entity.ReceivableDetailID && t.StudentID == entity.StudentID).FirstOrDefault(); a.ReceivableDetailID = entity.ReceivableDetailID; a.StudentID = entity.StudentID; a.Status = entity.Status; dt.SubmitChanges(); return(true); }
public bool Insert(ReceivableDetail_Student entity) { ReceivableDetail_Student a = new ReceivableDetail_Student(); a.ReceivableDetailID = entity.ReceivableDetailID; a.StudentID = entity.StudentID; a.Status = entity.Status; dt.ReceivableDetail_Students.InsertOnSubmit(a); dt.SubmitChanges(); return(true); }
public List <Student> ListStudent(int ClID) { var a = dt.Student_Classes.Where(t => t.ClassID == ClID); a.ToList(); List <ReceivableDetail_Student> listStudenReceivableDetail = new List <ReceivableDetail_Student>(); List <Student> ListStudent = new List <Student>(); List <TCStudentViewModle> listViewStuden = new List <TCStudentViewModle>(); foreach (var i in a) { ReceivableDetail_Student st = new ReceivableDetail_Student(); st = dt.ReceivableDetail_Students.Where(t => t.StudentID == i.StudentID).FirstOrDefault(); listStudenReceivableDetail.Add(st); } foreach (var js in listStudenReceivableDetail) { Student b = new Student(); b = dt.Students.FirstOrDefault(t => t.StudentID == js.StudentID); ListStudent.Add(b); } return(ListStudent); }
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 ReceivableDetail_Student loockReceivableDEtail_StudentByID(ReceivableDetail_Student a) { ReceivableDetail_Student b = dt.ReceivableDetail_Students.FirstOrDefault(t => t.StudentID == a.StudentID && t.ReceivableDetailID == a.ReceivableDetailID); return(a); }