private void btnSimpan_Click(object sender, EventArgs e)
{
connDb.koneksi();
string KodeBarang = txtKodeBarang.Text;
string NamaBarang = txtNamaBarang.Text;
string Satuan = txtSatuan.Text;
string Stok = txtStok.Text;
string Harga = txtHarga.Text;
string sql = "INSERT INTO TBarang (kode_barang,nama_barang,satuan,stok,harga) VALUES(" +
"'" + KodeBarang + "','" + NamaBarang + "'," +
"'" + Satuan + "','" + Stok + "'," +
"'" + Harga + "')";
cmd = new SqlCommand(sql, connDb.conn);
try
{
cmd.ExecuteNonQuery();
MessageBox.Show("Data berhasil tersimpan");
clearText();
}
catch (Exception ex)
{
MessageBox.Show("Data Tidak Berhasil Disimpan" + ex.ToString());
}
}
private void btnSimpan_Click(object sender, EventArgs e)
{
connDb.koneksi();
string IdCustomer = txtIdCustomer.Text;
string NamaCustomer = txtNamaCustomer.Text;
string Alamat = txtAlamat.Text;
string Telepon = txtTelepon.Text;
string sql = "INSERT INTO TCustomer (id_customer,nama_customer,alamat,telepon) VALUES(" +
"'" + IdCustomer + "','" + NamaCustomer + "'," +
"'" + Alamat + "','" + Telepon + "')";
cmd = new SqlCommand(sql, connDb.conn);
try
{
cmd.ExecuteNonQuery();
MessageBox.Show("Data berhasil tersimpan");
clearText();
}
catch (Exception ex)
{
MessageBox.Show("Data Tidak Berhasil Disimpan" + ex.ToString());
}
}
private void btnOK_Click(object sender, EventArgs e)
{
connDb.koneksi();
try
{
string username = txtUsername.Text.Trim();
string password = txtPassword.Text.Trim();
string sql = "SELECT * FROM TUser WHERE nama_user='******' and password='******'";
cmd = new SqlCommand(sql, connDb.conn);
reader = cmd.ExecuteReader();
if (reader.Read())
{
FormMaster objFormMaster = new FormMaster();
this.Hide();
objFormMaster.Show();
}
else
{
MessageBox.Show("Username dan Password Salah !!!");
}
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}
private void btnSimpan_Click(object sender, EventArgs e)
{
connDb.koneksi();
string IdUser = txtIdUser.Text;
string NamaLengkap = txtNamaLengkap.Text;
string NamaUser = txtNamaUser.Text;
string Password = txtPassword.Text;
string sql = "INSERT INTO TUser (id_user,nama_lengkap,nama_user,password) VALUES(" +
"'" + IdUser + "','" + NamaLengkap + "'," +
"'" + NamaUser + "','" + Password + "')";
cmd = new SqlCommand(sql, connDb.conn);
try
{
cmd.ExecuteNonQuery();
MessageBox.Show("Data berhasil tersimpan");
clearText();
}
catch (Exception ex)
{
MessageBox.Show("Data Tidak Berhasil Disimpan" + ex.ToString());
}
}
void isiComboID()
{
connDb.koneksi();
try
{
string sql = "SELECT id_customer FROM TCustomer";
cmd = new SqlCommand(sql, connDb.conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
cmbIdCustomer.Items.Add(reader[0]);
}
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}