public async Task <ActionResult <VendetTuristike> > PostVendetTuristike(VendetTuristike vendetTuristike)
{
_context.VendetTuristike.Add(vendetTuristike);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetVendetTuristike", new { id = vendetTuristike.Id }, vendetTuristike));
}
public JsonResult Put(VendetTuristike app)
{
string query = @"
update VendetTuristike set
VendiName = '" + app.VendiName + @"'
,VendLokacioni = '" + app.VendLokacioni + @"'
where VendiId = " + app.VendiId + @"
";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("TravelAppCon");
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("Updated Successfully"));
}
public async Task <IActionResult> PutVendetTuristike(int id, VendetTuristike vendetTuristike)
{
if (id != vendetTuristike.Id)
{
return(BadRequest());
}
_context.Entry(vendetTuristike).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VendetTuristikeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public JsonResult Post(VendetTuristike app)
{
string query = @"
insert into VendetTuristike
(VendiName,VendLokacioni)
values
(
'" + app.VendiName + @"'
,'" + app.VendLokacioni + @"'
)
";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("TravelAppCon");
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("Added Successfully"));
}
