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