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