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