public JsonResult Put(MonumentetHistorike mhs)
{
string query = @"
update MonumentetHistorike set
EmriMonumentit = '" + mhs.EmriMonumentit + @"'
EmriLokacionit = '" + mhs.EmriLokacionit + @"'
where MonumentiId = " + mhs.MonumentiId + @"
";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("LlojetEVendeveTuristikeAppCon");
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(MonumentetHistorike mhs)
{
string query = @"
insert into MonumentetHistorike values
('" + mhs.EmriMonumentit + @"',
'" + mhs.EmriLokacionit + @"')
";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("LlojetEVendeveTuristikeAppCon");
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"));
}
