public bool Delete(Jasa p)
{
bool isSuccess = false;
// conn.Open();
try
{
string sql = "DELETE FROM jasa_service WHERE ID_JASA_SERVICE=@ID";
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@ID", p.ID);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool Insert(Jasa p)
{
bool isSuccess = false;
conn.Open();
try
{
string sql = "INSERT INTO jasa_service(ID_JASA_SERVICE,NAMA_JASA,HARGA_JASA) VALUES(@ID,@NAMA,@HARGA)";
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@ID", p.ID);
cmd.Parameters.AddWithValue("@NAMA", p.Name);
cmd.Parameters.AddWithValue("@HARGA", p.biaya);
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool Update(Jasa p)
{
bool isSuccess = false;
conn.Open();
try
{
string sql = "UPDATE jasa_service SET NAMA_JASA=@NAMA,HARGA_JASA=@HARGA WHERE ID_JASA_SERVICE=@ID ";
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@ID", p.ID);
cmd.Parameters.AddWithValue("@NAMA", p.Name);
cmd.Parameters.AddWithValue("@HARGA", p.biaya);
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}