// GET: api/KhuVuc public IEnumerable <KhuVuc> Get() { GTVTContext context = new GTVTContext(); var lstKhuVuc = context.KhuVucs.ToList(); return(lstKhuVuc); }
// PUT: api/NguoiQuanLyGT/5 public IHttpActionResult Put(int id, NguoiQuanLyGT nguoiQuanLyGT) { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } using (var ctx = new GTVTContext()) { var existingNguoiQuanLyGT = ctx.NguoiQuanLyGTs.Where(s => s.Id == id) .FirstOrDefault <NguoiQuanLyGT>(); if (existingNguoiQuanLyGT != null) { existingNguoiQuanLyGT.Ten = nguoiQuanLyGT.Ten; existingNguoiQuanLyGT.NgaySinh = nguoiQuanLyGT.NgaySinh; existingNguoiQuanLyGT.Username = nguoiQuanLyGT.Username; existingNguoiQuanLyGT.Password = nguoiQuanLyGT.Password; ctx.SaveChanges(); } else { return(NotFound()); } } return(Ok()); }
// PUT: api/DenGT_ThayDoi/5 public IHttpActionResult Put(int id, DenGT_ThayDoi denGT_ThayDoi) { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } using (var ctx = new GTVTContext()) { var existingDenGT_ThayDoi = ctx.DenGT_ThayDois.Where(s => s.Id == id) .FirstOrDefault <DenGT_ThayDoi>(); if (existingDenGT_ThayDoi != null) { existingDenGT_ThayDoi.ThoiDiemThayDoi = denGT_ThayDoi.ThoiDiemThayDoi; existingDenGT_ThayDoi.ThoiGianDoi = denGT_ThayDoi.ThoiGianDoi; existingDenGT_ThayDoi.Do_TD = denGT_ThayDoi.Do_TD; existingDenGT_ThayDoi.Vang_TD = denGT_ThayDoi.Vang_TD; existingDenGT_ThayDoi.Xanh_TD = denGT_ThayDoi.Xanh_TD; existingDenGT_ThayDoi.TuDong = denGT_ThayDoi.TuDong; // existingDenGT_ThayDoi.DenGiaoThong_Id = denGT_ThayDoi.DenGiaoThong_Id; // existingDenGT_ThayDoi.NguoiQuanLyGT_Id = denGT_ThayDoi.NguoiQuanLyGT_Id; ctx.SaveChanges(); } else { return(NotFound()); } } return(Ok()); }
// DELETE: api/Banglai/5 public HttpResponseMessage Delete(int id) { try { using (GTVTContext context = new GTVTContext()) { var entity = context.Banglais.FirstOrDefault(e => e.BanglaiId == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Bang lai voi Id = " + id.ToString() + " khong co de xoa")); } else { context.Banglais.Remove(entity); context.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
// PUT: api/Xe/5 public HttpResponseMessage Put(int id, [FromBody] Xe xe) { try { using (GTVTContext context = new GTVTContext()) { var entity = context.Xes.FirstOrDefault(e => e.XeId == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Xe voi Id " + id.ToString() + " khong co de sua")); } else { entity.BienSoXe = xe.BienSoXe; entity.Hang = xe.Hang; entity.Loai = xe.Loai; entity.MauSac = xe.MauSac; entity.Nam = xe.Nam; entity.TrangThai = xe.TrangThai; entity.Chuxe = xe.Chuxe; context.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
// GET: api/TinhTrangDuong public IEnumerable <TinhTrangDuong> Get() { GTVTContext context = new GTVTContext(); var lstTinhTrangDuong = context.TinhTrangDuongs.ToList(); return(lstTinhTrangDuong); }
//// GET: api/Xe public IEnumerable <Xe> Get() { GTVTContext context = new GTVTContext(); var lstXe = context.Xes.ToList(); return(lstXe); }
// GET: api/BaoCao/5 public IEnumerable <BaoCao> Get(int id) { GTVTContext context = new GTVTContext(); var listReport = context.BaoCaos.Where(x => x.NguoiViPham == id).Include(b => b.ViPhamLuatGTs).ToList(); return(listReport); }
// main git // GET: api/NguoiQuanLyGT public IEnumerable <NguoiQuanLyGT> Get() { GTVTContext context = new GTVTContext(); var lstNguoiQuanLyGT = context.NguoiQuanLyGTs.ToList(); return(lstNguoiQuanLyGT); }
// GET: api/Banglai public IEnumerable <Banglai> Get() { GTVTContext context = new GTVTContext(); var lstBanglai = context.Banglais.ToList(); return(lstBanglai); }
// GET: api/LuatGiaoThong public IEnumerable <LuatGiaoThong> Get() { GTVTContext context = new GTVTContext(); var lstLuatGiaoThong = context.LuatGiaoThongs.ToList(); return(lstLuatGiaoThong); }
// GET: api/Chuxe public IEnumerable <Chuxe> Get() { GTVTContext context = new GTVTContext(); var lstChuxe = context.Chuxes.ToList(); return(lstChuxe); }
// PUT: api/Banglai/5 public HttpResponseMessage Put(int id, [FromBody] Banglai banglai) { try { using (GTVTContext context = new GTVTContext()) { var entity = context.Banglais.FirstOrDefault(e => e.BanglaiId == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Bang lai voi Id " + id.ToString() + " khong co de sua")); } else { entity.LoaiBang = banglai.LoaiBang; entity.ThongTin = banglai.ThongTin; context.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
//GET: api/BaoCao public IEnumerable <BaoCao> Get() { GTVTContext context = new GTVTContext(); var listReport = context.BaoCaos.Include(b => b.ViPhamLuatGTs).ToList(); return(listReport); }
// PUT: api/KhuVuc/5 public IHttpActionResult Put(int id, KhuVuc khuVuc) { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } using (var ctx = new GTVTContext()) { var existingKhuVuc = ctx.KhuVucs.Where(s => s.Id == id) .FirstOrDefault <KhuVuc>(); if (existingKhuVuc != null) { existingKhuVuc.TenKhuVuc = khuVuc.TenKhuVuc; ctx.SaveChanges(); } else { return(NotFound()); } } return(Ok()); }
//POST: api/DenGT_ThayDoi public IHttpActionResult Post(DenGT_ThayDoi denGT_ThayDoi) { DateTime today = DateTime.Now; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } using (var ctx = new GTVTContext()) { ctx.DenGT_ThayDois.Add(new DenGT_ThayDoi() { ThoiDiemThayDoi = denGT_ThayDoi.ThoiDiemThayDoi, ThoiGianDoi = denGT_ThayDoi.ThoiGianDoi, Do_TD = denGT_ThayDoi.Do_TD, Vang_TD = denGT_ThayDoi.Vang_TD, Xanh_TD = denGT_ThayDoi.Xanh_TD, TuDong = denGT_ThayDoi.TuDong, ThoiGianThucHien = denGT_ThayDoi.ThoiGianThucHien, DenGiaoThong_Id = denGT_ThayDoi.DenGiaoThong_Id, NguoiQuanLyGT_Id = denGT_ThayDoi.NguoiQuanLyGT_Id, }); //ctx.DenGT_ThayDois.Add(denGT_ThayDoi); ctx.SaveChanges(); } return(Ok()); }
// main git // GET: api/DenGT_ThayDoi public IEnumerable <DenGT_ThayDoi> Get() { GTVTContext context = new GTVTContext(); var lstDenGT_ThayDoi = context.DenGT_ThayDois.ToList(); return(lstDenGT_ThayDoi); }
// PUT: api/DenGiaoThong/5 public IHttpActionResult Put(int id, DenGiaoThong denGiaoThong) { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } using (var ctx = new GTVTContext()) { var existingDenGiaoThong = ctx.DenGiaoThongs.Where(s => s.Id == id) .FirstOrDefault <DenGiaoThong>(); if (existingDenGiaoThong != null) { existingDenGiaoThong.Do = denGiaoThong.Do; existingDenGiaoThong.Vang = denGiaoThong.Vang; existingDenGiaoThong.Xanh = denGiaoThong.Xanh; existingDenGiaoThong.TrangThai = denGiaoThong.TrangThai; //existingDenGiaoThong.KhuVuc_Id = denGiaoThong.KhuVuc_Id; existingDenGiaoThong.TenDuong = denGiaoThong.TenDuong; ctx.SaveChanges(); } else { return(NotFound()); } } return(Ok()); }
// PUT: api/Chuxe/5 public HttpResponseMessage Put(int id, [FromBody] Chuxe chuxe) { try { using (GTVTContext context = new GTVTContext()) { var entity = context.Chuxes.FirstOrDefault(e => e.ChuxeId == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Chu xe voi Id " + id.ToString() + " khong co de sua")); } else { entity.CMND = chuxe.CMND; entity.HoTen = chuxe.HoTen; entity.DiaChi = chuxe.DiaChi; entity.GioiTinh = chuxe.GioiTinh; entity.NamSinh = chuxe.NamSinh; context.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
// GET: api/LuatGiaoThong/5 public IEnumerable <LuatGiaoThong> GetID(int id) { GTVTContext context = new GTVTContext(); var lstLuatGiaoThong = context.LuatGiaoThongs .Where(b => b.Id == id).ToList();; return(lstLuatGiaoThong); }
public IEnumerable <LuatGiaoThong> Search(string str) { GTVTContext context = new GTVTContext(); var query = (from l in context.LuatGiaoThongs where l.NoiDungLuat.Contains(str) select l).ToList(); return(query); }
// GET: api/DenGiaoThong/5 public DenGiaoThong Get(int id) { GTVTContext context = new GTVTContext(); var DenGiaoThong = context.DenGiaoThongs .Where(b => b.Id == id) .FirstOrDefault(); return(DenGiaoThong); }
// GET: api/NguoiQuanLyGT/5 public NguoiQuanLyGT Get(int id) { GTVTContext context = new GTVTContext(); var NguoiQuanLyGT = context.NguoiQuanLyGTs .Where(b => b.Id == id) .FirstOrDefault(); return(NguoiQuanLyGT); }
// GET: api/DenGT_ThayDoi/5 public DenGT_ThayDoi Get(int id) { GTVTContext context = new GTVTContext(); var DenGT_ThayDoi = context.DenGT_ThayDois .Where(b => b.Id == id) .FirstOrDefault(); return(DenGT_ThayDoi); }
// GET: api/KhuVuc/5 public KhuVuc Get(int id) { GTVTContext context = new GTVTContext(); var KhuVuc = context.KhuVucs .Where(b => b.Id == id) .FirstOrDefault(); return(KhuVuc); }
public TinhTrangDuong Get(int id) { GTVTContext context = new GTVTContext(); var TinhTrangDuong = context.TinhTrangDuongs .Where(b => b.Id == id) .FirstOrDefault(); return(TinhTrangDuong); }
public IEnumerable <Chuxe> GetChuXeViPham(int idXe) { GTVTContext context = new GTVTContext(); var Xe = (from l in context.Chuxes join vp in context.Xes on l.ChuxeId equals vp.ChuxeId where vp.XeId == idXe select l).ToList(); return(Xe); }
public IEnumerable <LuatGiaoThong> GetDSViPham(int idBaoCao) { GTVTContext context = new GTVTContext(); var listLuatViPham = (from l in context.LuatGiaoThongs join vp in context.ViPhamLuatGTs on l.Id equals vp.Id_LuatGiaoThong where vp.Id_BaoCao == idBaoCao select l ).ToList(); return(listLuatViPham); }
// GET: api/Banglai/5 public IEnumerable <Banglai> Get(int id) { GTVTContext context = new GTVTContext(); //var cmdText = "Exec sp_laybanglai_id @Id = @name_param"; //var sqlParams = new[]{ //new SqlParameter("name_param", id) }; //var lstBanglai = context.Database.SqlQuery<Banglai>(cmdText, sqlParams).ToList(); //return lstBanglai; var lstBanglai = context.Banglais .Where(a => a.BanglaiId == id) .ToList(); return(lstBanglai); }
// GET: api/Chuxe/5 public IEnumerable <Chuxe> Get(int Id) { GTVTContext context = new GTVTContext(); //var cmdText = "sp_xemchuxe_theoid @Id = @id_param"; //var sqlParams = new[]{ //new SqlParameter("id_param", Id) }; //var lstChuxe = context.Database.SqlQuery<Chuxe>(cmdText, sqlParams).ToList(); //return lstChuxe; var lstChuxe = context.Chuxes .Where(a => a.ChuxeId == Id) .Include(a => a.Xes).Include(a => a.ChuxevaBanglais) .ToList(); return(lstChuxe); }