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