private void btnSave_Click(object sender, EventArgs e) { JenisBarang jenisBarang = new JenisBarang(); jenisBarang.KodeJenis = Convert.ToInt32(txtKodeJenis.Text); jenisBarang.KeteranganJenis = txtKeterangan.Text; if (jenisBarang.DoCheckExist(jenisBarang) > 0) { MessageBox.Show("Kode Jenis : " + jenisBarang.KodeJenis + " Already exist. "); } else { if (jenisBarang.DoSave(jenisBarang) == true) { MessageBox.Show("Record Saved"); } } }
public Boolean DoSave(JenisBarang jenisBarang) { try { SqlCommand insertCommand = new SqlCommand("INSERT INTO JenisBarang VALUES (" + jenisBarang.kodeJenis + ",'" + jenisBarang.KeteranganJenis + "')",conn); OpenConnection(); insertCommand.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { CloseConnection(); } return true; }
public int DoCheckExist(JenisBarang jenisBarang) { int RecordCount = 0; try { SqlCommand SQLCommand = new SqlCommand("SELECT * FROM JenisBarang WHERE KodeJenis = " + jenisBarang.kodeJenis, conn); OpenConnection(); RecordCount = (int)SQLCommand.ExecuteScalar(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { CloseConnection(); } return RecordCount; }