private void btnInBienLai_Click(object sender, EventArgs e) { if (isSave) { frmReport frm = new frmReport(); DANGKY d = DangKy.Select(maHV, maKH, maPhieu); List <ReportParameter> _params = new List <ReportParameter>() { new ReportParameter("CenterName", GlobalSettings.CenterName), new ReportParameter("CenterWebsite", GlobalSettings.CenterWebsite), new ReportParameter("MaHV", maHV), new ReportParameter("TenHV", d.HOCVIEN.TenHV), new ReportParameter("TenKH", d.KHOAHOC.TenKH), new ReportParameter("HocPhi", ((decimal)d.KHOAHOC.HocPhi).ToString("C0")), new ReportParameter("DaDong", ((decimal)d.PHIEUGHIDANH.DaDong).ToString("C0")), new ReportParameter("ConNo", ((decimal)d.PHIEUGHIDANH.ConNo).ToString("C0")), }; frm.ReportViewer.LocalReport.ReportEmbeddedResource = "QuanLyHocVien.Reports.rptBienLaiHocPhi.rdlc"; frm.ReportViewer.LocalReport.SetParameters(_params); frm.ReportViewer.LocalReport.DisplayName = "Biên lai học phí"; frm.Text = "Biên lai học phí"; frm.ShowDialog(); } else { MessageBox.Show("Vui lòng lưu phiếu trước khi in", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public bool InsertDuLieuDangKy(DANGKY dangky) { try { SQLDataContext.SQLData.sp_InsertDuLieuDangKi(dangky.MADK, dangky.MASACH, dangky.MADG, dangky.NGAYDK, dangky.GHICHU); return(true); } catch { return(false); } }
private void buttonX2_Click(object sender, EventArgs e) { for (int i = 0; i < dataGridViewX1.Rows.Count; i++) { if (dataGridViewX1.Rows[i].Selected == true) { DANGKY _XoaDK = qlthi.DANGKies.Where(hv => (hv.makhoa == dataGridViewX1.Rows[i].Cells[0].Value.ToString() && hv.mamon == dataGridViewX1.Rows[i].Cells[1].Value.ToString() && hv.mahocvien == dataGridViewX1.Rows[i].Cells[2].Value.ToString())).FirstOrDefault(); if (_XoaDK != null) { qlthi.DANGKies.DeleteOnSubmit(_XoaDK); qlthi.SubmitChanges(); } } } MessageBox.Show("Xóa thành công"); loadDangKy(); }
public ActionResult AddNewDK(FormCollection form) { DANGKY dk = new DANGKY(); dk.MaHP = int.Parse(form["MaHP"]); dk.MaSV = int.Parse(form["MaSV"]); dk.NgayDK = DateTime.Parse(form["NgayDK"]); dk.DiemThi = float.Parse(form["DiemThi"]); dk.DiemTP = float.Parse(form["DiemTP"]); db.DANGKies.Add(dk); db.SaveChanges(); var listHP = db.HOCPHANs.ToList(); return(View("~/Views/Home/Index_List_HP.cshtml", listHP)); }
public int delete(string mahv, string malop) { try { using (QLTTEntities qltt = new QLTTEntities()) { DANGKY dk = qltt.DANGKies.Where(p => p.MALOP == malop && p.MAHV == mahv).FirstOrDefault(); if (dk != null) { qltt.DANGKies.Remove(dk); qltt.SaveChanges(); return(1); } return(0); } } catch { return(0); } }
private void btDangKy_Click(object sender, EventArgs e) { for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView1.Rows[i].Selected == true) { if (ktDangKy(comboBoxEx1.SelectedValue.ToString(), dataGridView1.Rows[i].Cells[0].Value.ToString(), comboBoxEx2.SelectedValue.ToString()) < 1) { DANGKY dk = new DANGKY(); dk.mahocvien = comboBoxEx2.SelectedValue.ToString(); dk.mamon = dataGridView1.Rows[i].Cells[0].Value.ToString(); dk.makhoa = comboBoxEx1.SelectedValue.ToString(); dk.diem = null; qlthi.DANGKies.InsertOnSubmit(dk); qlthi.SubmitChanges(); } } } MessageBox.Show("Đăng ký thành công"); loadDangKy(); }
public int insert(string mahv, string malop) { try { using (QLTTEntities qltt = new QLTTEntities()) { DANGKY dk = new DANGKY() { STT = qltt.DANGKies.Count() + 1, MAHV = mahv, MALOP = malop, }; qltt.DANGKies.Add(dk); qltt.SaveChanges(); return(1); } } catch { return(0); } }
/// <summary> /// Thêm một đăng ký /// </summary> /// <param name="dk"></param> public static void Insert(DANGKY dk) { Database.DANGKies.InsertOnSubmit(dk); Database.SubmitChanges(); }