public JsonResult Put(Disponibel dis) { string query = @" update Disponibel set OraId = '" + dis.OraId + @"', KlasaId = '" + dis.KlasaId + @"', Perdorur = '" + dis.Perdorur + @"' where DitaId = " + dis.DitaId + @""; DataTable table = new DataTable(); string sqlDataSource = _configuration.GetConnectionString("OrariAppCon"); SqlDataReader myReader; using (SqlConnection myCon = new SqlConnection(sqlDataSource)) { myCon.Open(); using (SqlCommand myCommand = new SqlCommand(query, myCon)) { myReader = myCommand.ExecuteReader(); table.Load(myReader);; myReader.Close(); myCon.Close(); } } return(new JsonResult("Disponibel u Updatua me Sukses")); }
public IHttpActionResult PostDisponibel(Disponibel disponibel) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Disponibels.Add(disponibel); try { db.SaveChanges(); } catch (DbUpdateException) { if (DisponibelExists(disponibel.DitaId)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = disponibel.DitaId }, disponibel)); }
public IHttpActionResult PutDisponibel(int id, Disponibel disponibel) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != disponibel.DitaId) { return(BadRequest()); } db.Entry(disponibel).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!DisponibelExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GetDisponibel(int id) { Disponibel disponibel = db.Disponibels.Find(id); if (disponibel == null) { return(NotFound()); } return(Ok(disponibel)); }
public IHttpActionResult DeleteDisponibel(int id) { Disponibel disponibel = db.Disponibels.Find(id); if (disponibel == null) { return(NotFound()); } db.Disponibels.Remove(disponibel); db.SaveChanges(); return(Ok(disponibel)); }
public IHttpActionResult PutDisponibel(DisponibelDTO disp) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Disponibel disponibel = db.Disponibels.Where(x => x.KlasaId == disp.KlasaId && x.OraId == disp.OraId && x.DitaId == disp.DitaId).First(); disponibel.Perdorur = true; db.Entry(disponibel).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { return(NotFound()); } return(StatusCode(HttpStatusCode.NoContent)); }