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