public int Add(XE xe) { using (QLXeKhachEntities context = new QLXeKhachEntities()) { var user = HttpContext.Current.Session[GlobalConstant.USER]; if (user != null) { NHANVIEN currentUser = (NHANVIEN)user; xe.createUser = currentUser.MaNV; xe.lastupdateUser = currentUser.MaNV; } DateTime current = DateTime.Now; xe.createDate = current; xe.lastupdateDate = current; var result = context.XEs.Add(xe); context.SaveChanges(); LOAIXE loaiXe = context.LOAIXEs.Find(xe.LoaiXe); for (int i = 0; i < loaiXe.SLGhe; i++) { GHE ghe = new GHE(); ghe.createDate = DateTime.Now; ghe.lastupdateDate = DateTime.Now; ghe.MaGhe = i + 1; ghe.MaXe = xe.MaXe; context.GHEs.Add(ghe); context.SaveChanges(); } return(1); } }
public ActionResult Create([Bind(Include = "MaTuyen,DiemDi,DiemDen,QuangDuong,ThoiGian,SoChuyen1Ngay,createUser,lastupdateUser,createDate,lastupdateDate,isDeleted")] TUYENXE tUYENXE) { if (ModelState.IsValid) { db.TUYENXEs.Add(tUYENXE); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tUYENXE)); }
public ActionResult Create([Bind(Include = "MaTT,TenTT,createUser,lastupdateUser,createDate,lastupdateDate,isDeleted")] TINHTHANH tINHTHANH) { if (ModelState.IsValid) { db.TINHTHANHs.Add(tINHTHANH); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tINHTHANH)); }
public ActionResult Create([Bind(Include = "MaXe,LoaiXe,BienSoXe,HangXe,createUser,lastupdateUser,createDate,lastupdateDate,isDeleted")] XE xE) { if (ModelState.IsValid) { db.XEs.Add(xE); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(xE)); }
public ActionResult Create([Bind(Include = "MaTX,TenTX,CMND,SDT,DiaChi,NgaySinh,SoBangLai,LoaiBangLai,ThoiHanBangLai,createUser,lastupdateUser,createDate,lastupdateDate,isDeleted")] TAIXE tAIXE) { if (ModelState.IsValid) { db.TAIXEs.Add(tAIXE); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tAIXE)); }
public ActionResult Create([Bind(Include = "MaTram,TenTram,MaTT,DiaChi,MoTa,createUser,lastupdateUser,createDate,lastupdateDate,isDeleted")] TRAMXE tRAMXE) { if (ModelState.IsValid) { db.TRAMXEs.Add(tRAMXE); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tRAMXE)); }
public ActionResult Create([Bind(Include = "MaXe,MaGhe,createUser,lastupdateUser,createDate,lastupdateDate,isDeleted")] GHE gHE) { if (ModelState.IsValid) { db.GHEs.Add(gHE); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(gHE)); }
public ActionResult Create([Bind(Include = "MaVe,NgayMua,GiaMua,MaGhe,MaXe,MaChuyen,MaKH,TramLen,TramXuong,GioDi,createUser,lastupdateUser,createDate,lastupdateDate,isDeleted")] VE vE) { if (ModelState.IsValid) { db.VEs.Add(vE); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(vE)); }
public ActionResult Create([Bind(Include = "MaNV,LoginTime,LogoutTime,C_Status")] C_SESSION c_SESSION) { if (ModelState.IsValid) { db.C_SESSION.Add(c_SESSION); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(c_SESSION)); }
public ActionResult Create([Bind(Include = "MaHD,NgayLap,GiaThoaThuan,MaTram,ThoiHanThue,MaDT,NguoiLap,MoTa,createUser,lastupdateUser,createDate,lastupdateDate,isDeleted")] HOPDONG hOPDONG) { if (ModelState.IsValid) { db.HOPDONGs.Add(hOPDONG); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hOPDONG)); }
public ActionResult Create([Bind(Include = "MaKH,TenKH,SDT,CMND,DiaChi,NgaySinh,Email,createUser,lastupdateUser,createDate,lastupdateDate,isDeleted")] KHACHHANG kHACHHANG) { if (ModelState.IsValid) { db.KHACHHANGs.Add(kHACHHANG); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(kHACHHANG)); }
public ActionResult Create([Bind(Include = "MaTuyen,MaTram,ThuTu,KhoangThoiGian,createUser,lastupdateUser,createDate,lastupdateDate,isDeleted")] LOTRINH lOTRINH) { if (ModelState.IsValid) { db.LOTRINHs.Add(lOTRINH); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(lOTRINH)); }
public ActionResult Create([Bind(Include = "MaChuyen,NgayKH,NgayDen,MaTuyen,MaXe,MaTX,createUser,lastupdateUser,createDate,lastupdateDate,isDeleted")] CHUYENXE cHUYENXE) { if (ModelState.IsValid) { db.CHUYENXEs.Add(cHUYENXE); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cHUYENXE)); }
public ActionResult Create([Bind(Include = "MaTT1,MaTT2,MaLoai,GiaCoBan1,createUser,lastupdateUser,createDate,lastupdateDate,isDeleted")] GIACOBAN gIACOBAN) { if (ModelState.IsValid) { db.GIACOBANs.Add(gIACOBAN); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(gIACOBAN)); }
public ActionResult Create([Bind(Include = "MaDT,TenDT,NguoiDaiDien,SDT,DiaChi,Email,createUser,lastupdateUser,createDate,lastupdateDate,isDeleted")] DOITAC dOITAC) { if (ModelState.IsValid) { db.DOITACs.Add(dOITAC); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(dOITAC)); }
//public IList<NHANVIEN> Search(string input) //{ // using (QLXeKhachEntities context = new QLXeKhachEntities()) // { // return context.NHANVIENs.Where(x => x.isDeleted!=1 &&(x.TenNV.Contains(input) || input == "")).ToList(); // } //} public void LogOut() { var session = HttpContext.Current.Session[GlobalConstant.SESSION_ID]; if (session != null) { C_SESSION mySession = (C_SESSION)session; mySession.LogoutTime = DateTime.Now; using (QLXeKhachEntities context = new QLXeKhachEntities()) { try { var entity = context.C_SESSION.Find(mySession.MaSession); if (entity == null) { return; } context.Entry(entity).CurrentValues.SetValues(session); context.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); } } HttpContext.Current.Session.Clear(); } else { return; } }
public NHANVIEN Login(string email, string password) { using (QLXeKhachEntities context = new QLXeKhachEntities()) { //kiểm tra tồn tại string sqlString = "SELECT * FROM NHANVIEN WHERE Email='" + email + "' AND Password='******'"; List <NHANVIEN> result = context.NHANVIENs.SqlQuery(sqlString).ToList <NHANVIEN>(); if (result.Count > 0) { //tạo session C_SESSION session = new C_SESSION(); session.C_Status = 1; session.LoginTime = DateTime.Now; session.MaNV = result[0].MaNV; try { C_SESSION resultSession = context.C_SESSION.Add(session); context.SaveChanges(); HttpContext.Current.Session[GlobalConstant.SESSION_ID] = resultSession; } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); } HttpContext.Current.Session[GlobalConstant.USER] = result[0]; return(result[0]); } else { return(null); } } }
public ActionResult Create(string temp) { string maTT1 = Request["ttDi"]; string maTT2 = Request["ttDen"]; string maLoai = Request["maLoai"]; string gia = Request["gia"]; GIACOBAN gcb = new GIACOBAN(); gcb.MaTT1 = maTT1; gcb.MaTT2 = maTT2; gcb.MaLoai = int.Parse(maLoai); gcb.GiaCoBan1 = int.Parse(gia); gcb.isDeleted = 0; gcb.createDate = DateTime.Now; gcb.lastupdateDate = DateTime.Now; db.GIACOBANs.Add(gcb); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit() { string maTuyen = Request["maTuyen"]; string maTram = Request["maTram"]; string tgian = Request["tgian"]; if (maTuyen == null || maTram == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LOTRINH lOTRINH = db.LOTRINHs.Find(Int32.Parse(maTuyen), Int32.Parse(maTram)); if (lOTRINH == null) { return(HttpNotFound()); } lOTRINH.KhoangThoiGian = Int32.Parse(tgian); db.Entry(lOTRINH).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
public void Delete(LOTRINH ltrinh) { var user = HttpContext.Current.Session[GlobalConstant.USER]; if (user != null) { NHANVIEN currentUser = (NHANVIEN)user; ltrinh.lastupdateUser = currentUser.MaNV; } DateTime current = DateTime.Now; ltrinh.lastupdateDate = current; using (QLXeKhachEntities context = new QLXeKhachEntities()) { context.Entry(ltrinh).State = EntityState.Modified; context.SaveChanges(); } }
public int Add(LOTRINH ltrinh) { using (QLXeKhachEntities context = new QLXeKhachEntities()) { var user = HttpContext.Current.Session[GlobalConstant.USER]; if (user != null) { NHANVIEN currentUser = (NHANVIEN)user; ltrinh.createUser = currentUser.MaNV; ltrinh.lastupdateUser = currentUser.MaNV; } DateTime current = DateTime.Now; ltrinh.createDate = current; ltrinh.lastupdateDate = current; context.LOTRINHs.Add(ltrinh); context.SaveChanges(); return(1); } }
public int Add(HOPDONG hd) { using (QLXeKhachEntities context = new QLXeKhachEntities()) { var user = HttpContext.Current.Session[GlobalConstant.USER]; if (user != null) { NHANVIEN currentUser = (NHANVIEN)user; hd.createUser = currentUser.MaNV; hd.lastupdateUser = currentUser.MaNV; } DateTime current = DateTime.Now; hd.createDate = current; hd.lastupdateDate = current; context.HOPDONGs.Add(hd); context.SaveChanges(); return(1); } }
public int Add(GIACOBAN dtac) { using (QLXeKhachEntities context = new QLXeKhachEntities()) { var user = HttpContext.Current.Session[GlobalConstant.USER]; if (user != null) { NHANVIEN currentUser = (NHANVIEN)user; dtac.createUser = currentUser.MaNV; dtac.lastupdateUser = currentUser.MaNV; } DateTime current = DateTime.Now; dtac.createDate = current; dtac.lastupdateDate = current; context.GIACOBANs.Add(dtac); context.SaveChanges(); return(1); } }
public int Add(KHACHHANG kh) { using (QLXeKhachEntities context = new QLXeKhachEntities()) { var user = HttpContext.Current.Session[GlobalConstant.USER]; if (user != null) { NHANVIEN currentUser = (NHANVIEN)user; kh.createUser = currentUser.MaNV; kh.lastupdateUser = currentUser.MaNV; } DateTime current = DateTime.Now; kh.createDate = current; kh.lastupdateDate = current; context.KHACHHANGs.Add(kh); context.SaveChanges(); return(kh.MaKH); } }
public int Add(TRAMXE tram) { using (QLXeKhachEntities context = new QLXeKhachEntities()) { var user = HttpContext.Current.Session[GlobalConstant.USER]; if (user != null) { NHANVIEN currentUser = (NHANVIEN)user; tram.createUser = currentUser.MaNV; tram.lastupdateUser = currentUser.MaNV; } DateTime current = DateTime.Now; tram.createDate = current; tram.lastupdateDate = current; context.TRAMXEs.Add(tram); context.SaveChanges(); return(1); } }
public void ResetPassword(string password, string confirmPassword) { if (password == confirmPassword) { var user = HttpContext.Current.Session[GlobalConstant.USER]; if (user != null) { NHANVIEN currentUser = (NHANVIEN)user; currentUser.Password = EncryptionUtil.instant(password); currentUser.TrangThaiTaiKhoan = 1; //change password using (QLXeKhachEntities context = new QLXeKhachEntities()) { try { var entity = context.NHANVIENs.Find(currentUser.MaNV); if (entity == null) { return; } context.Entry(entity).CurrentValues.SetValues(currentUser); context.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); } } } } else { throw new ArgumentException("Mật khẩu xác nhận không chính xác"); } }