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