// 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));
            }
        }
        // POST: api/Chuxe
        public HttpResponseMessage Post([FromBody] Chuxe chuxe)
        {
            try
            {
                using (GTVTContext context = new GTVTContext())
                {
                    context.Chuxes.Add(chuxe);
                    context.SaveChanges();

                    var message = Request.CreateResponse(HttpStatusCode.Created, chuxe);
                    message.Headers.Location = new Uri(Request.RequestUri +
                                                       chuxe.ChuxeId.ToString());

                    return(message);
                }
            }
            catch (Exception ex)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
            }
        }
        public void InsertChuxeXe(int ChuxeId, int XeId)
        {
            using (GTVTContext context = new GTVTContext())
            {
                Chuxe chuxe = new Chuxe {
                    ChuxeId = ChuxeId
                };
                context.Chuxes.Add(chuxe);
                context.Chuxes.Attach(chuxe);

                Xe xe = new Xe {
                    XeId = XeId
                };
                context.Xes.Add(xe);
                context.Xes.Attach(xe);

                chuxe.Xes = new List <Xe>();
                chuxe.Xes.Add(xe);
                context.SaveChanges();
            }
        }
        public void InsertChuxeBanglai(int ChuxeId, int BanglaiId)
        {
            using (GTVTContext context = new GTVTContext())
            {
                var chuxe = new Chuxe {
                    ChuxeId = ChuxeId
                };
                //    context.Chuxes.Add(chuxe);
                //    context.Chuxes.Attach(chuxe);

                var banglai = new Banglai {
                    BanglaiId = BanglaiId
                };
                //    context.Banglais.Add(banglai);
                //    context.Banglais.Attach(banglai);
                var ChuxeBanglai = new ChuXevaBangLai
                {
                    ChuxeId   = chuxe.ChuxeId,
                    BanglaiId = banglai.BanglaiId
                };

                context.ChuXevaBangLais.Add(ChuxeBanglai);
                context.SaveChanges();

                //    chuxe.

                //context.SaveChanges();
                //GTVTContext context = new GTVTContext();
                //var cmdText = "sp_ThemTaixeBanglai @ChuxeId, @BanglaiId";
                //var sqlParams = new[]{
                //new SqlParameter("ChuxeId", ChuxeId),
                //new SqlParameter("BanglaiId", BanglaiId)};
                //context.Database.SqlQuery<ChuXevaBangLai>(cmdText, sqlParams);
                ////return lstChuxe;
            }
        }