public FormEdit()
{
//
// The InitializeComponent() call is required for Windows Forms designer support.
//
InitializeComponent();
for (int i = 1980; i <= 2010; i++)
{
editTahun.Items.Add(i);
}
for (int j = 2000; j <= 7000; j += 500)
{
editHarga.Items.Add(j);
}
string sqlQueryString = ("Select * from tbl_tipe_katalog");
TampilData f1 = new TampilData();
OleDbCommand SQLQuery = new OleDbCommand();
DataTable data = null;
OleDbDataAdapter dataAdapter = null;
SQLQuery.CommandText = sqlQueryString;
SQLQuery.Connection = f1.database;
data = new DataTable();
dataAdapter = new OleDbDataAdapter(SQLQuery);
dataAdapter.Fill(data);
foreach (DataRow drRow in data.Rows)
{
string id = drRow["id_tipe_katalog"].ToString();
string nama_kat = drRow["tipe_katalog"].ToString();
editTipe.Items.Add(id + " - " + nama_kat);
}
}
void Button1Click(object sender, EventArgs e)
{
TampilData f1 = new TampilData();
nama = editNama.Text.ToString();
alamat = editAlamat.Text.ToString();
jaminan = cmbJaminan.Text.ToString();
total = editHarga.Text.ToString();
if (rdSudah.Checked == true)
{
status = "sudah";
}
else if (rdBelum.Checked == true)
{
status = "belum";
}
string SQLUpdateString = "update tbl_pelanggan set nama='" + nama + "', alamat='" + alamat + "', jaminan='" + jaminan + "', total_bayar='" + total + "', status='" + status + "' where id_pelanggan=" + id_penyewa + "";
try{
OleDbCommand SQLCommand = new OleDbCommand();
SQLCommand.CommandText = SQLUpdateString;
SQLCommand.Connection = f1.database;
int response = SQLCommand.ExecuteNonQuery();
MessageBox.Show("Update data berhasil...!!!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
}
catch (Exception)
{
MessageBox.Show("Error");
}
}
void Button1Click(object sender, EventArgs e)
{
if (usrName.Text == "admin" && psWord.Text == "admin")
{
Form frmData = new TampilData();
frmData.Show();
this.Hide();
}
else
{
MessageBox.Show("Username dan Password tidak Valid...!!!", "Username & Password Salah...!!!");
}
}
void Button1Click(object sender, EventArgs e)
{
TampilData f1 = new TampilData();
nama = editNamaTipe.Text.ToString();
string SQLUpdateString = "update tbl_tipe_katalog set tipe_katalog='" + nama + "' where id_tipe_katalog=" + id_kat + "";
try{
OleDbCommand SQLCommand = new OleDbCommand();
SQLCommand.CommandText = SQLUpdateString;
SQLCommand.Connection = f1.database;
int response = SQLCommand.ExecuteNonQuery();
MessageBox.Show("Update data berhasil...!!!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
}
catch (Exception)
{
MessageBox.Show("Error");
}
}
void Button1Click(object sender, EventArgs e)
{
TampilData f1 = new TampilData();
nama = editJudul.Text.ToString();
produsen = editPenerbit.Text.ToString();
tipe = editTipe.Text.Substring(0, 1);
tahun = editTahun.Text.ToString();
harga = editHarga.Text.ToString();
string SQLUpdateString = "update tbl_katalog set id_tipe_katalog='" + tipe + "', nama_katalog='" + nama + "', produsen='" + produsen + "', harga_sewa='" + harga + "', tahun_terbit='" + tahun + "' where id_katalog=" + id_cd + "";
try{
OleDbCommand SQLCommand = new OleDbCommand();
SQLCommand.CommandText = SQLUpdateString;
SQLCommand.Connection = f1.database;
int response = SQLCommand.ExecuteNonQuery();
MessageBox.Show("Update data berhasil...!!!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
}
catch (Exception)
{
MessageBox.Show(tipe);
}
}
