public JsonResult Put(Produktet pro)
{
string query = @"
update dbo.Produktet set
Emri = '" + pro.Emri + @"'
,Kodi = '" + pro.Kodi + @"'
,Sasia = '" + pro.Sasia + @"'
,Qmimi = '" + pro.Qmimi + @"'
,DataSkadimit = '" + pro.DataSkadimit + @"'
,Menaxhimi = '" + pro.Menaxhimi + @"'
where produktetId = " + pro.produktetId + @"
";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("RestaurantAppCon");
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(Produktet pro)
{
string query = @"
insert into dbo.Produktet values
('" + pro.Emri + @"',
'" + pro.Kodi + @"',
'" + pro.Sasia + @"',
'" + pro.Qmimi + @"',
'" + pro.DataSkadimit + @"',
'" + pro.Menaxhimi + @"'
)";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("RestaurantAppCon");
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"));
}
