public ActionResult List(FormCollection formCollection)
{
if (ModelState.IsValid)
{
//ViewBag.MaHKNH = new SelectList(db.HKNHs, "MaHKNH", "HocKy", dS_MONHOC_MO.MaHKNH);
var MaMo_last = db.DS_MONHOC_MO.OrderByDescending(p => p.MaMo).FirstOrDefault();
int id_MaMo = 1001;
if (MaMo_last == null)
{
id_MaMo = 1001;
}
else
{
id_MaMo = Int32.Parse(MaMo_last.MaMo);
}
//int id_num = Int32.Parse(MaMo_last.MaMo) + 1;
//var employee = db.DS_MONHOC_MO.SingleOrDefault(p => p.MaMonHoc == id);
string[] ids = formCollection["ID"]?.Split(new char[] { ',' });
if (ids == null)
{
ViewBag.IsNull = 1;
return(RedirectToAction("Index", new { id = hk }));
}
try
{
foreach (string id in ids)
{
DS_MONHOC_MO a = new DS_MONHOC_MO()
{
MaMo = (++id_MaMo).ToString(),
MaHKNH = hk,
MaMonHoc = id
};
//db.DS_MONHOC_MO.Remove(employee);
//employee.MaMo = (Int32.Parse(employee.MaMo) + 1).ToString();
db.DS_MONHOC_MO.Add(a);
db.SaveChanges();
}
}
catch
{
ViewBag.err = 1;
return(RedirectToAction("Create", new { @isErr = ViewBag.err }));
}
//db.DS_MONHOC_MO.Add(dS_MONHOC_MO);
//db.SaveChanges();
return(RedirectToAction("Index", new { id = hk }));
}
//ViewBag.MaHKNH = new SelectList(db.HKNHs, "MaHKNH", "HocKy", dS_MONHOC_MO.MaHKNH);
//ViewBag.MaMonHoc = new SelectList(db.MONHOCs, "MaMonHoc", "TenMonHoc", dS_MONHOC_MO.MaMonHoc);
return(View());
}
public ActionResult Edit([Bind(Include = "SoPhieuDK,MaMo,GhiChu")] CT_PHIEUDK cT_PHIEUDK)
{
if (ModelState.IsValid)
{
db.Entry(cT_PHIEUDK).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaMo = new SelectList(db.DS_MONHOC_MO, "MaMo", "MaHKNH", cT_PHIEUDK.MaMo);
ViewBag.SoPhieuDK = new SelectList(db.PHIEU_DK, "SoPhieuDK", "MaSinhVien", cT_PHIEUDK.SoPhieuDK);
return(View(cT_PHIEUDK));
}
public ActionResult Create([Bind(Include = "MaHKNH,MaSinhVien,SoTienConLai")] BAOCAO_SV_NOHP bAOCAO_SV_NOHP)
{
if (ModelState.IsValid)
{
db.BAOCAO_SV_NOHP.Add(bAOCAO_SV_NOHP);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaSinhVien = new SelectList(db.HKNHs, "MaHKNH", "HocKy", bAOCAO_SV_NOHP.MaSinhVien);
ViewBag.MaSinhVien = new SelectList(db.SINHVIENs, "MaSinhVien", "HoTen", bAOCAO_SV_NOHP.MaSinhVien);
return(View(bAOCAO_SV_NOHP));
}
private void btSua_Click(object sender, EventArgs e)
{
using (CNPMEntities db = new CNPMEntities())
{
var xe = (from x in db.Xes
where x.Biensoxe == GetBSX
select x).FirstOrDefault();
xe.Biensoxe = txtBSX.Text;
xe.idLoaiXe = (int)cbbLoaiXe.SelectedValue;
xe.TenXe = txtTenXe.Text;
xe.PhiXang = txtPhiXang.Text;
xe.PhiQuaKm = txtPhiQuaKm.Text;
xe.DonGia = txtDonGia.Text;
xe.MoTaTT = txtMoTaTT.Text;
xe.TrangThai = int.Parse(txtTrangThai.Text);
db.SaveChanges();
MessageBox.Show("Edit success", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
GetBSX = null;
CNPMEntities context = new CNPMEntities();
List <Xe> xes = context.Xes.ToList();
BindGrid(xes);
}
private void btSua_Click(object sender, EventArgs e)
{
using (CNPMEntities db = new CNPMEntities())
{
var dbhd = (from hd in db.HopDongs
where hd.MaHD == GetMaHD
select hd).FirstOrDefault();
dbhd.MaHD = txtSoDH.Text.ToString();
dbhd.idXe = (int)cbbSoXe.SelectedValue;
dbhd.idNV = (int)cbbMaNV.SelectedValue;
dbhd.idKH = (int)cbbMaKH.SelectedValue;
dbhd.NgayHD = DateTime.Parse(msktbNgayHD.Text.ToString());
dbhd.TienDat = txtTienDat.Text;
dbhd.KhuyenMai = txtKhuyenMai.Text.ToString();
dbhd.NoiDungHD = txtNoiDungHD.Text.ToString();
dbhd.GiayToGiuLai = txtGiayTo.Text.ToString();
db.SaveChanges();
XtraMessageBox.Show("Edit success", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
GetMaHD = null;
CNPMEntities context = new CNPMEntities();
List <HopDong> lstHopDong = context.HopDongs.ToList();
BindGrid(lstHopDong);
}
private void btSua_Click(object sender, EventArgs e)
{
using (CNPMEntities db = new CNPMEntities())
{
var bbgn = (from bb in db.BBGNs
where bb.MaBBGN == GetMaBBGN
select bb).FirstOrDefault();
bbgn.MaBBGN = txtMaBBGN.Text;
bbgn.NgayGiao = DateTime.Parse(mskNgayGiao.Text.ToString());
bbgn.idXe = (int)cbbSoXe.SelectedValue;
bbgn.idKH = (int)cbbMaKH.SelectedValue;
bbgn.idNV = (int)cbbMaNV.SelectedValue;
bbgn.KmDi = int.Parse(txtKmDi.Text);
bbgn.XangDi = txtXangDi.Text;
bbgn.TrangThaiDi = txtTTDi.Text;
bbgn.NgayNhan = DateTime.Parse(mskNgayNhan.Text.ToString());
bbgn.KmVe = int.Parse(txtKmVe.Text);
bbgn.XangVe = txtXangVe.Text;
bbgn.TrangThaiVe = txtTTVe.Text;
db.SaveChanges();
XtraMessageBox.Show("Edit success", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
GetMaBBGN = null;
CNPMEntities context = new CNPMEntities();
List <BBGN> lstBBGn = context.BBGNs.ToList();
BindGrid(lstBBGn);
}
public static bool AddLoaiXe(LoaiXe loaixe)
{
using (var _context = new CNPMEntities())
{
_context.LoaiXes.Add(loaixe);
_context.SaveChanges();
return(true);
}
}
public static bool AddBBGN(BBGN bbgn)
{
using (var _context = new CNPMEntities())
{
_context.BBGNs.Add(bbgn);
_context.SaveChanges();
return(true);
}
}
public ActionResult Create([Bind(Include = "MaKhoa,TenKhoa")] KHOA kHOA)
{
try
{
if (ModelState.IsValid)
{
db.KHOAs.Add(kHOA);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(kHOA));
}
catch (Exception e)
{
return(RedirectToAction("Create", "KHOAs", new { id = 1 }));
}
}
public ActionResult Create([Bind(Include = "MaHKNH,HocKy,Nam1,Nam2,HanDongHocPhi")] HKNH hKNH)
{
try
{
if (ModelState.IsValid)
{
db.HKNHs.Add(hKNH);
db.SaveChanges();
return(RedirectToAction("ListHK", "DS_MONHOC_MO"));
}
return(View(hKNH));
}
catch (Exception e)
{
return(RedirectToAction("Create", "HKNHs", new { id = 1 }));
}
}
public ActionResult Create([Bind(Include = "MaDoiTuong,TenDoiTuong,TiLeGiamHocPhi")] DOITUONG dOITUONG)
{
try
{
if (ModelState.IsValid)
{
db.DOITUONGs.Add(dOITUONG);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dOITUONG));
}
catch (Exception e)
{
return(RedirectToAction("Create", "DOITUONGs", new { id = 1 }));
}
}
public ActionResult Create([Bind(Include = "MaLoaiMon,TenLoaiMon,SoTietTC,SoTienTC")] LOAIMON lOAIMON)
{
try
{
if (ModelState.IsValid)
{
db.LOAIMONs.Add(lOAIMON);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(lOAIMON));
}
catch (Exception e)
{
return(RedirectToAction("Create", "LOAIMONs", new { id = 1 }));
}
}
public static bool AddNhanVien(NhanVien nhanvien)
{
using (var _context = new CNPMEntities())
{
_context.NhanViens.Add(nhanvien);
_context.SaveChanges();
return(true);
}
}
public static bool AddAccount(Account a)
{
using (var _context = new CNPMEntities())
{
_context.Accounts.Add(a);
_context.SaveChanges();
return(true);
}
}
public static bool AddXe(Xe xe)
{
using (var _context = new CNPMEntities())
{
_context.Xes.Add(xe);
_context.SaveChanges();
return(true);
}
}
public ActionResult Create([Bind(Include = "MaTinh,TenTinh")] TINH tINH)
{
try
{
if (ModelState.IsValid)
{
db.TINHs.Add(tINH);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tINH));
}
catch (Exception e)
{
return(RedirectToAction("Create", "TINHs", new { id = 1 }));
}
}
public static bool AddKhachHang(KhachHang khachhang)
{
using (var _context = new CNPMEntities())
{
_context.KhachHangs.Add(khachhang);
_context.SaveChanges();
return(true);
}
}
public static bool AddHopDong(HopDong hopdong)
{
using (var _context = new CNPMEntities())
{
_context.HopDongs.Add(hopdong);
_context.SaveChanges();
return(true);
}
}
public ActionResult Create([Bind(Include = "MaHuyen,TenHuyen,MaTinh,UuTien")] HUYEN hUYEN)
{
try
{
if (ModelState.IsValid)
{
db.HUYENs.Add(hUYEN);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaTinh = new SelectList(db.TINHs, "MaTinh", "TenTinh", hUYEN.MaTinh);
return(View(hUYEN));
}
catch (Exception e)
{
return(RedirectToAction("Create", "HUYENs", new { id = 1 }));
}
}
public ActionResult Create([Bind(Include = "TenDangNhap,MatKhau,IDNhomNguoiDung")] NGUOIDUNG nGUOIDUNG)
{
try
{
if (ModelState.IsValid)
{
db.NGUOIDUNGs.Add(nGUOIDUNG);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IDNhomNguoiDung = new SelectList(db.NHOMNGUOIDUNGs, "IDNhomNguoiDung", "TenNhomNguoiDung", nGUOIDUNG.IDNhomNguoiDung);
return(View(nGUOIDUNG));
}
catch (Exception e)
{
return(RedirectToAction("Create", "NGUOIDUNGs", new { id = 1 }));
}
}
public ActionResult Create([Bind(Include = "MaMonHoc,TenMonHoc,MaLoaiMon,SoTiet")] MONHOC mONHOC)
{
try
{
if (ModelState.IsValid)
{
db.MONHOCs.Add(mONHOC);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaLoaiMon = new SelectList(db.LOAIMONs, "MaLoaiMon", "TenLoaiMon", mONHOC.MaLoaiMon);
return(View(mONHOC));
}
catch (Exception e)
{
return(RedirectToAction("Create", "MONHOCs", new { id = 1 }));
}
}
public ActionResult Create([Bind(Include = "MaNganh,MaKhoa,TenNganh")] NGANH nGANH)
{
try
{
if (ModelState.IsValid)
{
db.NGANHs.Add(nGANH);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaKhoa = new SelectList(db.KHOAs, "MaKhoa", "TenKhoa", nGANH.MaKhoa);
return(View(nGANH));
}
catch (Exception e)
{
return(RedirectToAction("Create", "NGANHs", new { id = 1 }));
}
}
public ActionResult Create([Bind(Include = "MaNganh,MaMonHoc,HocKy")] CT_NGANH cT_NGANH)
{
try
{
if (ModelState.IsValid)
{
db.CT_NGANH.Add(cT_NGANH);
db.SaveChanges();
return(RedirectToAction("Index", "CT_NGANH", new { id = cT_NGANH.MaNganh }));
}
ViewBag.MaMonHoc = new SelectList(db.MONHOCs, "MaMonHoc", "TenMonHoc", cT_NGANH.MaMonHoc);
ViewBag.MaNganh = new SelectList(db.NGANHs, "MaNganh", "TenNganh", cT_NGANH.NGANH.TenNganh);
return(View(cT_NGANH));
}
catch (Exception e)
{
return(RedirectToAction("Create", "CT_NGANH", new { id = 1 }));
}
}
public static bool RemoveLoaiXe(string TenLoai)
{
using (CNPMEntities _context = new CNPMEntities())
{
var dblx = (from lx in _context.LoaiXes
where lx.TenLoai == TenLoai
select lx).FirstOrDefault();
_context.LoaiXes.Remove(dblx);
_context.SaveChanges();
return(true);
}
}
public static bool RemoveAccount(string a)
{
using (CNPMEntities _context = new CNPMEntities())
{
var getaccount = (from ac in _context.Accounts
where ac.TaiKhoan == a
select ac).FirstOrDefault();
_context.Accounts.Remove(getaccount);
_context.SaveChanges();
return(true);
}
}
public static bool RemoveNhanVien(string MaNV)
{
using (CNPMEntities _context = new CNPMEntities())
{
var dbnv = (from nv in _context.NhanViens
where nv.MaNV == MaNV
select nv).FirstOrDefault();
_context.NhanViens.Remove(dbnv);
_context.SaveChanges();
return(true);
}
}
public static bool RemoveXe(string BSX)
{
using (CNPMEntities _context = new CNPMEntities())
{
var dbxe = (from xe in _context.Xes
where xe.Biensoxe == BSX
select xe).FirstOrDefault();
_context.Xes.Remove(dbxe);
_context.SaveChanges();
return(true);
}
}
public static bool RemoveKhachHang(string MaKH)
{
using (CNPMEntities _context = new CNPMEntities())
{
var dbkh = (from kh in _context.KhachHangs
where kh.MaKH == MaKH
select kh).FirstOrDefault();
_context.KhachHangs.Remove(dbkh);
_context.SaveChanges();
return(true);
}
}
public static bool RemoveBBGN(string MaBBGN)
{
using (CNPMEntities _context = new CNPMEntities())
{
var dbbbgn = (from bbgn in _context.BBGNs
where bbgn.MaBBGN == MaBBGN
select bbgn).FirstOrDefault();
_context.BBGNs.Remove(dbbbgn);
_context.SaveChanges();
return(true);
}
}
public static bool RemoveHopDong(string MaHD)
{
using (CNPMEntities _context = new CNPMEntities())
{
var dbhd = (from hd in _context.HopDongs
where hd.MaHD == MaHD
select hd).FirstOrDefault();
_context.HopDongs.Remove(dbhd);
_context.SaveChanges();
return(true);
}
}