private void Add()
{
var id = data.LOP_HOCs.Where(u => u.MaLopHoc == txt_id.Text.Trim()).SingleOrDefault <LOP_HOC>();
if (id != null)
{
tb_Thongbao.Text = "Mã Lớp đã tồn tại.";
return;
}
else
{
try
{
LOP_HOC l = new LOP_HOC();
l.MaKhoaHoc = cb_khoa.SelectedValue.ToString();
l.MaLopHoc = txt_id.Text;
l.SiSoDK = 0;
l.HocPhi = int.Parse(txt_hocphi.Text);
l.TenLopHoc = txt_lop.Text;
data.LOP_HOCs.InsertOnSubmit(l);
data.SubmitChanges();
tb_Thongbao.Text = "Thêm thành công!";
}
catch
{
}
finally
{
GetData();
}
}
}
public ActionResult DeleteConfirmed(Guid id)
{
LOP_HOC lOP_HOC = db.LOP_HOC.Find(id);
db.LOP_HOC.Remove(lOP_HOC);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Admin/LOP_HOC/Details/5
public ActionResult Details(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LOP_HOC lOP_HOC = db.LOP_HOC.Find(id);
if (lOP_HOC == null)
{
return(HttpNotFound());
}
return(View(lOP_HOC));
}
public ActionResult Edit([Bind(Include = "MA_LOP,TEN_LOP,SI_SO,MA_LOAI,MA_MON,MA_KHOI,MA_GV")] LOP_HOC lOP_HOC)
{
if (ModelState.IsValid)
{
db.Entry(lOP_HOC).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MA_GV = new SelectList(db.GIAO_VIEN, "MA_GV", "HO_TEN", lOP_HOC.MA_GV);
ViewBag.MA_KHOI = new SelectList(db.KHOI_LOP, "MA_KHOI", "TEN_KHOI", lOP_HOC.MA_KHOI);
ViewBag.MA_LOAI = new SelectList(db.LOAI_LOP, "MA_LOAI", "TEN_LOAI", lOP_HOC.MA_LOAI);
ViewBag.MA_MON = new SelectList(db.MON_HOC, "MA_MON", "TEN_MON", lOP_HOC.MA_MON);
return(View(lOP_HOC));
}
// GET: Admin/LOP_HOC/Edit/5
public ActionResult Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LOP_HOC lOP_HOC = db.LOP_HOC.Find(id);
if (lOP_HOC == null)
{
return(HttpNotFound());
}
ViewBag.MA_GV = new SelectList(db.GIAO_VIEN, "MA_GV", "HO_TEN", lOP_HOC.MA_GV);
ViewBag.MA_KHOI = new SelectList(db.KHOI_LOP, "MA_KHOI", "TEN_KHOI", lOP_HOC.MA_KHOI);
ViewBag.MA_LOAI = new SelectList(db.LOAI_LOP, "MA_LOAI", "TEN_LOAI", lOP_HOC.MA_LOAI);
ViewBag.MA_MON = new SelectList(db.MON_HOC, "MA_MON", "TEN_MON", lOP_HOC.MA_MON);
return(View(lOP_HOC));
}
public ActionResult Create(FormCollection f)
{
if (ModelState.IsValid)
{
LOP_HOC lh = new LOP_HOC();
lh.MA_LOP = Guid.NewGuid();
lh.MA_KHOI = Guid.Parse(f["makhoi"]);
lh.MA_LOAI = Guid.Parse(f["maloai"]);
lh.MA_MON = Guid.Parse(f["mamon"]);
lh.MA_GV = f["magiaovien"];
lh.TEN_LOP = f["tenlop"];
lh.SI_SO = 0;
db.LOP_HOC.Add(lh);
db.SaveChanges();
return(RedirectToAction("Index", "LOP_HOC", new { area = "Admin" }));
}
return(View());
}
private void Remove()
{
try
{
if (System.Windows.Forms.MessageBox.Show("Xác nhận xoá? ", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
LOP_HOC l = data.LOP_HOCs.Single(item => item.MaLopHoc == txt_id.Text);
data.LOP_HOCs.DeleteOnSubmit(l);
data.SubmitChanges();
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
GetData();
}
}
private void Update()
{
LOP_HOC l = (data.LOP_HOCs.Where(t => t.MaLopHoc == txt_id.Text).SingleOrDefault <LOP_HOC>());
try
{
l.HocPhi = int.Parse(txt_hocphi.Text);
l.TenLopHoc = txt_lop.Text;
data.SubmitChanges();
tb_Thongbao.Text = "Chỉnh sửa thành công!";
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.Message, "Lỗi");
}
finally
{
GetData();
}
}
private void datagrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
int rowindex = datagrid.SelectedIndex;
if (rowindex == -1)
{
Clear();
}
else
{
LOP_HOC lop = (LOP_HOC)datagrid.SelectedItem;
txt_id.Text = lop.MaLopHoc;
txt_lop.Text = lop.TenLopHoc;
txt_hocphi.Text = lop.HocPhi.ToString();
txt_ss.Text = lop.SiSoDK.ToString();
cb_khoa.SelectedValue = lop.MaKhoaHoc;
}
}
catch (Exception ex)
{
}
}
