private void Form1_Load(object sender, EventArgs e)
{
hapus_edit();
hapus_member();
cmbkjrsan.SelectedIndex = 0;
AutoGeneratedID autoid = new AutoGeneratedID();
string id_member = autoid.AutoIDMember();
txtidmember.Text = id_member;
txtidmember.ReadOnly = true;
try
{
koneksi = conn.con();
koneksi.Open();
sql = "Select * from tb_Member order by id_member desc";
adapter.SelectCommand = new SqlCommand(sql, koneksi);
adapter.Fill(ds, "Member");
dv = new DataView();
dv.Table = ds.Tables[0];
dataGridView1.DataSource = dv;
dataGridView2.DataSource = dv;
dataGridView3.DataSource = dv;
dataGridView4.DataSource = dv;
koneksi.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
koneksi.Close();
}
}
private void button1_Click_1(object sender, EventArgs e)
{
try
{
String nama = txtnama.Text;
String nim = txtnim.Text;
String kelas = txtkelas.Text;
String alamat = riscalmt.Text;
String no_telp = txttlpn.Text;
Regex reg = new Regex(@"^[A-Z a-z]+$");
Match match_huruf = reg.Match(nama);
Regex reg1 = new Regex(@"^[0-9]+$");
Match match_angka = reg1.Match(nim);
Match match_angka1 = reg1.Match(no_telp);
if (nim == "")
{
errorProvider1.Clear();
errorProvider1.SetError(txtnim, "Nim Tidak Boleh Kosong!");
var warning = MessageBox.Show("Nim Tidak Boleh Kosong!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (!match_angka.Success)
{
errorProvider1.Clear();
errorProvider1.SetError(txtnim, "Nim Harus Berupa Angka!");
var warning = MessageBox.Show("Nim Harus Berupa Angka!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (nim.Length < 9)
{
errorProvider1.Clear();
errorProvider1.SetError(txtnim, "Nim Minimal Harus 9 Digit Angka!");
var warning = MessageBox.Show("Nim Minimal Harus 9 Digit Angka!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (nim.Length > 11)
{
errorProvider1.Clear();
errorProvider1.SetError(txtnim, "Nim Maksimal Harus 11 Digit Angka!");
var warning = MessageBox.Show("Nim Maksimal Harus 11 Digit Angka!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (nama == "")
{
errorProvider1.Clear();
errorProvider1.SetError(txtnama, "Nama Tidak Boleh Kosong!");
var warning = MessageBox.Show("Nama Tidak Boleh Kosong!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (!match_huruf.Success)
{
errorProvider1.Clear();
errorProvider1.SetError(txtnama, "Nama Harus Berupa Huruf!");
var warning = MessageBox.Show("Nama Harus Berupa Huruf!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (nama.Length < 3)
{
errorProvider1.Clear();
errorProvider1.SetError(txtnama, "Nama Minimal 3 Huruf!");
var warning = MessageBox.Show("Nama Minimal 3 Huruf!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (nama.Length > 30)
{
errorProvider1.Clear();
errorProvider1.SetError(txtnama, "Nama Maksimal 30 Huruf!");
var warning = MessageBox.Show("Nama Maksimal 30 Huruf!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (kelas == "")
{
errorProvider1.Clear();
errorProvider1.SetError(txtkelas, "Kelas Tidak Boleh Kosong!");
var warning = MessageBox.Show("Kelas Tidak Boleh Kosong!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (kelas.Length < 4)
{
errorProvider1.Clear();
errorProvider1.SetError(txtkelas, "Kelas Minimal 4 Character!");
var warning = MessageBox.Show("Kelas Minimal 4 Character!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (kelas.Length > 6)
{
errorProvider1.Clear();
errorProvider1.SetError(txtkelas, "Kelas Maksimal 5 Character!");
var warning = MessageBox.Show("Kelas Maksimal 5 Character!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (cmbkjrsan.SelectedIndex == 0)
{
errorProvider1.Clear();
errorProvider1.SetError(cmbkjrsan, "Jurusan Harus Dipilih!");
var warning = MessageBox.Show("Jurusan Harus Dipilih!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (alamat == "")
{
errorProvider1.Clear();
errorProvider1.SetError(riscalmt, "Alamat Tidak Boleh Kosong!");
var warning = MessageBox.Show("Alamat Tidak Boleh Kosong!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (alamat.Length < 4)
{
errorProvider1.Clear();
errorProvider1.SetError(riscalmt, "Alamat Minimal 4 Huruf!");
var warning = MessageBox.Show("Alamat Minimal 4 Huruf!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (alamat.Length > 50)
{
errorProvider1.Clear();
errorProvider1.SetError(riscalmt, "Alamat Maksimal 50 Character!");
var warning = MessageBox.Show("Alamat Maksimal 50 Character!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (no_telp == "")
{
errorProvider1.Clear();
errorProvider1.SetError(txttlpn, "No Telp/Hp Tidak Boleh Kosong!");
var warning = MessageBox.Show("No Telp/Hp Tidak Boleh Kosong!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (!match_angka1.Success)
{
errorProvider1.Clear();
errorProvider1.SetError(txttlpn, "No Telp/Hp Harus Berupa Angka!");
var warning = MessageBox.Show("No Telp/Hp Harus Berupa Angka!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (no_telp.Length < 3)
{
errorProvider1.Clear();
errorProvider1.SetError(txttlpn, "No Telp/Hp Minimal 3 Digit Angka!");
var warning = MessageBox.Show("No Telp/Hp Minimal 3 Digit Angka!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else if (no_telp.Length > 13)
{
errorProvider1.Clear();
errorProvider1.SetError(txttlpn, "No Telp/Hp Maksimal 13 Digit Angka!");
var warning = MessageBox.Show("No Telp/Hp Maksimal 13 Digit Angka!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
else
{
string jk = "";
if (radioButton1.Checked || radioButton2.Checked)
{
if (radioButton1.Checked)
{
jk = "Pria";
}
else
{
jk = "Wanita";
}
koneksi = conn.con();
SqlCommand command = new SqlCommand("insert into tb_Member (id_member, NIM, nama, kelas, jurusan, alamat, no_telp, jenis_kelamin) values ('" + txtidmember.Text + "','" + txtnim.Text + "','" + txtnama.Text + "','" + txtkelas.Text + "','" + cmbkjrsan.SelectedItem + "','" + riscalmt.Text + "','" + txttlpn.Text + "','" + jk + "');", koneksi);
adapter = new SqlDataAdapter("select * from tb_Member order by id_member desc", koneksi);
koneksi.Open();
DataTable dtMember = new DataTable();
command.ExecuteNonQuery();
dataGridView1.DataSource = dtMember;
dataGridView2.DataSource = dtMember;
dataGridView3.DataSource = dtMember;
adapter.SelectCommand.ExecuteNonQuery();
adapter.Fill(dtMember);
MessageBox.Show("Data success ditambah");
AutoGeneratedID autoid = new AutoGeneratedID();
string id_member = autoid.AutoIDMember();
txtidmember.Text = id_member;
txtidmember.ReadOnly = true;
//dataGridView1.DataSource = dtMember;
errorProvider1.Clear();
hapus();
koneksi.Close();
}
else
{
errorProvider1.Clear();
errorProvider1.SetError(radioButton2, "Jenis Kelamin Harus Dipilih!");
var warning = MessageBox.Show("Jenis Kelamin Harus Dipilih!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
if (warning == DialogResult.Cancel)
{
hapus();
errorProvider1.Clear();
}
}
}
}
catch (SqlException se)
{
MessageBox.Show(se.Message);
}
}
