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