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