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