public ActionResult DeleteConfirmed(int id)
{
CHUYENXE cHUYENXE = db.CHUYENXEs.Find(id);
db.CHUYENXEs.Remove(cHUYENXE);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "MaChuyen,NgayKH,NgayDen,MaTuyen,MaXe,MaTX,createUser,lastupdateUser,createDate,lastupdateDate,isDeleted")] CHUYENXE cHUYENXE)
{
if (ModelState.IsValid)
{
db.Entry(cHUYENXE).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(cHUYENXE));
}
public ActionResult Create([Bind(Include = "MaChuyen,NgayKH,NgayDen,MaTuyen,MaXe,MaTX,createUser,lastupdateUser,createDate,lastupdateDate,isDeleted")] CHUYENXE cHUYENXE)
{
if (ModelState.IsValid)
{
cHUYENXE.isDeleted = 0;
service.Add(cHUYENXE);
return(RedirectToAction("Index"));
}
return(View(cHUYENXE));
}
// GET: CHUYENXEs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CHUYENXE cHUYENXE = service.Detail(id);
if (cHUYENXE == null)
{
return(HttpNotFound());
}
return(View(cHUYENXE));
}
// GET: CHUYENXEs/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CHUYENXE cHUYENXE = db.CHUYENXEs.Find(id);
if (cHUYENXE == null)
{
return(HttpNotFound());
}
return(View(cHUYENXE));
}
public ActionResult Edit([Bind(Include = "MaChuyen,NgayKH,NgayDen,MaTuyen,MaXe,MaTX,createUser,lastupdateUser,createDate,lastupdateDate,isDeleted")] CHUYENXE cHUYENXE)
{
if (ModelState.IsValid)
{
CHUYENXE cx = service.Detail(cHUYENXE.MaChuyen);
cx.NgayKH = cHUYENXE.NgayKH;
cx.NgayDen = cHUYENXE.NgayDen;
cx.MaTuyen = cHUYENXE.MaTuyen;
cx.MaTX = cHUYENXE.MaTX;
cx.MaXe = cHUYENXE.MaXe;
service.Update(cx);
return(RedirectToAction("Index"));
}
return(View(cHUYENXE));
}
public ActionResult DeleteMany()
{
string temp = Request.Form["deletecheckbox"];
if (temp == null)
{
return(RedirectToAction("Index"));
}
string[] listDelete = temp.Split(',');
for (int i = 0; i < listDelete.Length; i++)
{
CHUYENXE cHUYENXE = service.Detail(int.Parse(listDelete[i]));
cHUYENXE.isDeleted = 1;
service.Delete(cHUYENXE);
}
return(RedirectToAction("Index"));
}
public ActionResult Guests(string chuyenDi)
{
//Session["driver"] = "1";
// //Lấy mã nv từ session
short manv = short.Parse(Session["driver"].ToString());
// //Lấy danh sách các chuyến xe của tài xế đó
DataTable tableChuyenXe = load.queryTable("select MACHUYEN, TENCHUYEN from NHANVIEN, XE, CHUYENXE where NHANVIEN.MANV = XE.MANV and XE.MAXE = CHUYENXE.MAXE and NHANVIEN.MANV = " + manv); //(from CHUYENXE in db.CHUYENXEs where CHUYENXE.MANV == manv select CHUYENXE).ToList();
List <CHUYENXE> listChuyenXe = new List <CHUYENXE>();
for (int i = 0; i < tableChuyenXe.Rows.Count; i++)
{
CHUYENXE item = new CHUYENXE();
item.MACHUYEN = tableChuyenXe.Rows[i][0].ToString();
item.TENCHUYEN = tableChuyenXe.Rows[i][1].ToString();
listChuyenXe.Add(item);
}
// //đổ dữ liệu vào select với value là MACHUYEN, text là TENCHUYEN
CHUYENXE init = new CHUYENXE();
init.MACHUYEN = "0";
init.TENCHUYEN = "Chọn chuyến xe";
listChuyenXe.Add(init);
SelectList select = new SelectList(listChuyenXe, "MACHUYEN", "TENCHUYEN", init);
// //gắn select vào view
ViewBag.select = select;
string queryListVe = "select mave, tenkh, vitrighengoi from VEXE, KHACHHANG where VEXE.MAKH = KHACHHANG.MAKH ";
if (chuyenDi != null)
{
queryListVe += "and MACHUYENXE = " + chuyenDi;
}
DataTable tbVe = load.queryTable(queryListVe);
List <Chuyen> listLinks = new List <Chuyen>();
for (int i = 0; i < tbVe.Rows.Count; i++)
{
Chuyen temp = new Chuyen();
temp.MAVE = tbVe.Rows[i][0].ToString();
temp.HOTEN = tbVe.Rows[i][1].ToString();
temp.SOGHE = int.Parse(tbVe.Rows[i][2].ToString());
listLinks.Add(temp);
}
ViewBag.ls = listLinks;
return(View());
}
public void Delete(CHUYENXE cx)
{
var user = HttpContext.Current.Session[GlobalConstant.USER];
if (user != null)
{
NHANVIEN currentUser = (NHANVIEN)user;
cx.lastupdateUser = currentUser.MaNV;
}
DateTime current = DateTime.Now;
cx.lastupdateDate = current;
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
context.Entry(cx).State = EntityState.Modified;
context.SaveChanges();
}
}
public int Add(CHUYENXE cx)
{
using (QLXeKhachEntities context = new QLXeKhachEntities())
{
var user = HttpContext.Current.Session[GlobalConstant.USER];
if (user != null)
{
NHANVIEN currentUser = (NHANVIEN)user;
cx.createUser = currentUser.MaNV;
cx.lastupdateUser = currentUser.MaNV;
}
DateTime current = DateTime.Now;
cx.createDate = current;
cx.lastupdateDate = current;
context.CHUYENXEs.Add(cx);
context.SaveChanges();
return(1);
}
}
