public JsonResult Put(Vendet 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 JsonResult Post(Vendet 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"));
}
