private async void BtnEdit_Clicked(object sender, EventArgs e) { var _request = new RestRequest("api/JenisMotor", Method.PUT); var newJenisMotor = new JenisMotor { IdJenisMotor = Convert.ToInt32(txtIdJenisMotor.Text), NamaMerek = txtNamaMerk.Text, NamaJenisMotor = txtNamaJenisMotor.Text }; _request.AddBody(newJenisMotor); try { var _response = await _client.Execute(_request); if (_response.StatusCode == System.Net.HttpStatusCode.OK) { await Navigation.PopAsync(); } } catch (Exception ex) { await DisplayAlert("Error", "Error : " + ex.Message, "OK"); } }
private void ListJenisMotor_ItemTapped(object sender, ItemTappedEventArgs e) { JenisMotor item = (JenisMotor)e.Item; EditJenisMotorPage editPage = new EditJenisMotorPage(); editPage.BindingContext = item; Navigation.PushAsync(editPage); }
// PUT: api/Kategori/5 public IHttpActionResult Put(JenisMotor jenis) { JenisMotorDAL jenisMotorDAL = new JenisMotorDAL(); try { jenisMotorDAL.Update(jenis); return(Ok()); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public void Create(JenisMotor jenis) { using (SqlConnection conn = new SqlConnection(GetConnStr())) { string strSql = @"insert into JenisMotor(NamaMerk,NamaJenisMotor) values(@NamaMerk,@NamaJenisMotor)"; var par = new { NamaMerk = jenis.NamaMerk, NamaJenisMotor = jenis.NamaJenisMotor }; try { conn.Execute(strSql, par); } catch (SqlException sqlEx) { throw new Exception(sqlEx.Number + "-" + sqlEx.Message); } } }
private async void BtnTambahJenis_Clicked(object sender, EventArgs e) { var _request = new RestRequest("api/JenisMotor", Method.POST); var newJenisMotor = new JenisMotor { NamaJenisMotor = txtNamaJenisMotor.Text }; _request.AddBody(newJenisMotor); try { var _response = await _client.Execute(_request); if (_response.StatusCode == System.Net.HttpStatusCode.OK) { await Navigation.PushAsync(new JenisMotorPage()); } } catch (Exception ex) { await DisplayAlert("Error", "Error : " + ex.Message, "OK"); } }
public void Update(JenisMotor jenis) { using (SqlConnection conn = new SqlConnection(GetConnStr())) { string strSql = @"update JenisMotor set NamaMerk=@NamaMerk,NamaJenisMotor=@NamaJenisMotor where IdJenisMotor=@IdJenisMotor"; var par = new { NamaMerk = jenis.NamaMerk, NamaJenisMotor = jenis.NamaJenisMotor, IdJenisMotor = jenis.IdJenisMotor }; try { conn.Execute(strSql, par); } catch (SqlException sqlEx) { throw new Exception(sqlEx.Number + " - " + sqlEx.Message); } } }