private void FormMember_Load(object sender, EventArgs e)
{
int temp = 0;
temp = Mcontrol.DeaktivasiMember();
if (temp == 0)
{
MessageBox.Show("Tidak ada member yang perlu di deaktivasi");
}
else
{
MessageBox.Show("Ada " + temp + " Pegawai yang ter-deaktivasi");
if (Mcontrol.cekAdaTidakRecordMember(DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString()) == 0)
{
Mcontrol.InsertRecordMemberBaru(DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString(), Mcontrol.totalMemberAktif(), Mcontrol.totalMemberNonAktif(),
Mcontrol.totalMemberAktif() + Mcontrol.totalMemberNonAktif());
}
for (int i = 0; i < temp; i++)
{
Mcontrol.ubahNonAktifMember(DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString());
}
}
TampilMember(this.dataGridView1);
uC_Member1.Visible = false;
uC_Member1.setFlag(1);
if (Pegawai == "Kasir")
{
dataMasterToolStripMenuItem.Visible = false;
}
else
{
transaksiToolStripMenuItem.Visible = false;
presensiMemberToolStripMenuItem.Visible = false;
}
}
private void btnTambah_Click(object sender, EventArgs e)
{
try
{
if (flagperintah == 1)
{
if (cektxt() == true)
{
errorProvider1.Clear();
//cekTanggalLahir tidak boleh kurang dari tanggal sekarang
if (dateTimePicker1.Value >= DateTime.Now)
{
MessageBox.Show("Maaf, tanggal lahir anda salah");
return;
}
if (Mcontrol.CekMemberUnik(edNama.Text, edAlamat.Text, edEmail.Text) != 0)
{
MessageBox.Show("Maaf, data sudah ada. " + Mcontrol.CekMemberUnik(edNama.Text, edAlamat.Text, edEmail.Text), "Kesalahan", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
Mcontrol.EntryMember(edNama.Text, edEmail.Text, edAlamat.Text, dateTimePicker1.Value.ToString("dd/MM"), dateTimePicker1.Value.ToString("yy"));
if (Mcontrol.cekAdaTidakRecordMember(DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString()) == 0)
{
Mcontrol.InsertRecordMemberBaru(DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString(), Mcontrol.totalMemberAktif(), Mcontrol.totalMemberNonAktif(),
Mcontrol.totalMemberAktif() + Mcontrol.totalMemberNonAktif());
}
else
{
Mcontrol.TambahNonAktifMember(DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString());
}
cleartxt();
this.Hide();
FormMember myParent = (FormMember)this.Parent;
myParent.enable();
}
}
else
{
if (cektxt() == true)
{
errorProvider1.Clear();
//if (Mcontrol.CekMemberUnik(edNama.Text, edAlamat.Text, edEmail.Text) > 1) // masih error, salah harusnya ga masuk sini saat edit
//{
// MessageBox.Show("Maaf, data sudah ada. " + Mcontrol.CekMemberUnik(edNama.Text, edAlamat.Text, edEmail.Text), "Kesalahan", MessageBoxButtons.OK, MessageBoxIcon.Error);
// return;
//}
DialogResult dr = MessageBox.Show("Apakah Anda yakin akan mengupdate pegawai ini ?", "Pertanyaan",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
Mcontrol.EditMember(edNama.Text, edAlamat.Text, edEmail.Text, int.Parse(txtID.Text));
}
cleartxt();
this.Hide();
FormMember myParent = (FormMember)this.Parent;
myParent.EnableEdit();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Kesalahan", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnTransaksi_Click(object sender, EventArgs e)
{
try
{
if (cmbPromo.SelectedValue.ToString() == "9")
{
if (!con.IsActiveMember(int.Parse(cmbMember.SelectedValue.ToString())))
{
MessageBox.Show(this, "Maaf, Member ini belum aktif", "Kesalahan", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (txtDeposit.Text == "")
{
MessageBox.Show(this, "Maaf, Harap isikan Data terlebih dahulu.", "Gagal", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (con.GetDepositByIDMember(int.Parse(cmbMember.SelectedValue.ToString())) < (decimal)300000 && double.Parse(txtDeposit.Text) < 300000)
{
MessageBox.Show(this, "Maaf, Deposit anda kurang dari Rp 300.000, silahkan deposit minimal Rp 300.000", "Kesalahan", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
con.TambahTransaksi(int.Parse(cmbPromo.SelectedValue.ToString()), int.Parse(cmbMember.SelectedValue.ToString()),
null, DateTime.Now, decimal.Parse(txtDeposit.Text), Pegawai);
con.DepositReguler(int.Parse(cmbMember.SelectedValue.ToString()), decimal.Parse(txtDeposit.Text));
CetakStrukTransaksi cetak = new CetakStrukTransaksi();
try
{
no_struk = DateTime.Now.ToString("yy") + "." + DateTime.Now.ToString("MM") + "." + con.GetLastIdTransaksi();
cetak.InputCetakStruk(cmbMember.Text, txtNamaMember.Text, txtTotalHarga.Text, no_struk, DateTime.Now.ToString(), nama_pegawai, con.GetTglExpired(int.Parse(cmbMember.SelectedValue.ToString())).ToString(), "", cmbPromo.Text, "", "");
cetak.setListBox(kelas);
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
cetak.ShowDialog();
MessageBox.Show(this, "Data Transaksi Berhasil Disimpan", "Sukses", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else if (cmbPromo.SelectedValue.ToString() == "4") //member get member
{
//cek member aktif blm
if (con.IsActiveMember(int.Parse(cmbMember.SelectedValue.ToString())))
{
MessageBox.Show(this, "Member tersebut sudah aktif");
return;
}
else if (con.IsActiveMember(int.Parse(cmbIdMember2.SelectedValue.ToString())))
{
MessageBox.Show(this, "Member " + int.Parse(cmbIdMember2.SelectedValue.ToString()) + "sudah aktif");
return;
}
con.TambahTransaksi(int.Parse(cmbPromo.SelectedValue.ToString()), int.Parse(cmbMember.SelectedValue.ToString()),
null, DateTime.Now, con.GetHargaPromo(int.Parse(cmbPromo.SelectedValue.ToString())), Pegawai);
CetakStrukTransaksi cetak = new CetakStrukTransaksi();
try
{
no_struk = DateTime.Now.ToString("yy") + "." + DateTime.Now.ToString("MM") + "." + con.GetLastIdTransaksi();
cetak.InputCetakStruk(cmbMember.Text, txtNamaMember.Text, txtTotalHarga.Text, no_struk, DateTime.Now.ToString(), nama_pegawai, con.GetTglExpired(int.Parse(cmbMember.SelectedValue.ToString())).ToString(), "", cmbPromo.Text, cmbIdMember2.Text, txtNamaMember2.Text);
cetak.setListBoxSetelahTransaksi(kelas);
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
cetak.ShowDialog();
con.AktivasiTahunanMemberGetMember(int.Parse(cmbIdMember2.SelectedValue.ToString()), int.Parse(cmbMember.SelectedValue.ToString()));
if (Mcontrol.cekAdaTidakRecordMember(DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString()) == 0)
{
Mcontrol.InsertRecordMemberBaru(DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString(), Mcontrol.totalMemberAktif(), Mcontrol.totalMemberNonAktif(),
Mcontrol.totalMemberAktif() + Mcontrol.totalMemberNonAktif());
}
Mcontrol.UbahAktifMember(DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString());
MessageBox.Show(this, "Data Transaksi Berhasil Disimpan", "Sukses", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (cmbPromo.SelectedValue.ToString() == "3") //couple aktivasi
{
if (con.IsActiveMember(int.Parse(cmbMember.SelectedValue.ToString())))
{
MessageBox.Show(this, "Member " + cmbMember.Text + " sudah aktif");
return;
}
else if (con.IsActiveMember(int.Parse(cmbIdMember2.SelectedValue.ToString())))
{
MessageBox.Show(this, "Member " + cmbIdMember2 + " sudah aktif");
return;
}
con.TambahTransaksi(int.Parse(cmbPromo.SelectedValue.ToString()), int.Parse(cmbMember.SelectedValue.ToString()),
null, DateTime.Now, con.GetHargaPromo(int.Parse(cmbPromo.SelectedValue.ToString())) / 2, Pegawai);
CetakStrukTransaksi cetak = new CetakStrukTransaksi();
try
{
no_struk = DateTime.Now.ToString("yy") + "." + DateTime.Now.ToString("MM") + "." + con.GetLastIdTransaksi();
cetak.InputCetakStruk(cmbMember.Text, txtNamaMember.Text, (double.Parse(txtTotalHarga.Text) / 2).ToString(), no_struk, DateTime.Now.ToString(), nama_pegawai, con.GetTglExpired(int.Parse(cmbMember.SelectedValue.ToString())).ToString(), "", cmbPromo.Text, "", "");
cetak.setListBoxSetelahTransaksi(kelas);
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
con.TambahTransaksi(int.Parse(cmbPromo.SelectedValue.ToString()), int.Parse(cmbIdMember2.SelectedValue.ToString()),
null, DateTime.Now, con.GetHargaPromo(int.Parse(cmbPromo.SelectedValue.ToString())) / 2, Pegawai);
try
{
no_struk = DateTime.Now.ToString("yy") + "." + DateTime.Now.ToString("MM") + "." + con.GetLastIdTransaksi();
cetak.InputCetakStruk(cmbIdMember2.Text, txtNamaMember2.Text, (double.Parse(txtTotalHarga.Text) / 2).ToString(), no_struk, DateTime.Now.ToString(), nama_pegawai, con.GetTglExpired(int.Parse(cmbIdMember2.SelectedValue.ToString())).ToString(), "", cmbPromo.Text, "", "");
cetak.setListBox(kelas);
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
cetak.ShowDialog();
con.AktivasiCouple(int.Parse(cmbMember.SelectedValue.ToString()), int.Parse(cmbIdMember2.SelectedValue.ToString()));
if (Mcontrol.cekAdaTidakRecordMember(DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString()) == 0)
{
Mcontrol.InsertRecordMemberBaru(DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString(), Mcontrol.totalMemberAktif(), Mcontrol.totalMemberNonAktif(),
Mcontrol.totalMemberAktif() + Mcontrol.totalMemberNonAktif());
}
Mcontrol.UbahAktifMember(DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString());
Mcontrol.UbahAktifMember(DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString());
MessageBox.Show(this, "Data Transaksi Berhasil Disimpan", "Sukses", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (cmbPromo.SelectedValue.ToString() == "1")
{
if (con.IsActiveMember(int.Parse(cmbMember.SelectedValue.ToString())))
{
MessageBox.Show(this, "Member " + cmbMember.Text + " tersebut sudah aktif");
return;
}
con.TambahTransaksi(int.Parse(cmbPromo.SelectedValue.ToString()), int.Parse(cmbMember.SelectedValue.ToString()),
null, DateTime.Now, con.GetHargaPromo(int.Parse(cmbPromo.SelectedValue.ToString())), Pegawai);
CetakStrukTransaksi cetak = new CetakStrukTransaksi();
try
{
no_struk = DateTime.Now.ToString("yy") + "." + DateTime.Now.ToString("MM") + "." + con.GetLastIdTransaksi();
cetak.InputCetakStruk(cmbMember.Text, txtNamaMember.Text, txtTotalHarga.Text, no_struk, DateTime.Now.ToString(), nama_pegawai, con.GetTglExpired(int.Parse(cmbMember.SelectedValue.ToString())).ToString(), "", cmbPromo.Text, "", "");
cetak.setListBox(kelas);
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
cetak.ShowDialog();
con.AktivasiReguler(int.Parse(cmbMember.SelectedValue.ToString()));
if (Mcontrol.cekAdaTidakRecordMember(DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString()) == 0)
{
Mcontrol.InsertRecordMemberBaru(DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString(), Mcontrol.totalMemberAktif(), Mcontrol.totalMemberNonAktif(),
Mcontrol.totalMemberAktif() + Mcontrol.totalMemberNonAktif());
}
Mcontrol.UbahAktifMember(DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString());
MessageBox.Show(this, "Data Transaksi Berhasil Disimpan", "Sukses", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if ((cmbMember.SelectedIndex == -1) && cmbPromo.SelectedIndex == -1)
{
MessageBox.Show(this, "Maaf, Harap isikan Data terlebih dahulu.", "Gagal", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (!con.IsActiveMember(int.Parse(cmbMember.SelectedValue.ToString())))
{
MessageBox.Show(this, "Member " + cmbMember.Text + " tersebut belum aktif");
return;
}
else
{
if (con.GetDepositByIDMember(int.Parse(cmbMember.SelectedValue.ToString())) - decimal.Parse(txtTotalHarga.Text) < 300000)
{
MessageBox.Show(this, "Member ini tidak memiliki cukup deposit uang, jika deposit dilakukan");
return;
}
if (con.GetDepositByIDMember(int.Parse(cmbMember.SelectedValue.ToString())) < decimal.Parse(txtTotalHarga.Text))
{
MessageBox.Show(this, "Member ini tidak memiliki cukup deposit uang");
return;
}
if (!con.IsDepositMemberExist(int.Parse(cmbMember.SelectedValue.ToString()), int.Parse(cmbKelas.SelectedValue.ToString())))
{
MessageBox.Show("Data Deposit Belum Ada, Data deposit baru akan di daftarkan");
con.TambahTransaksi(int.Parse(cmbPromo.SelectedValue.ToString()), int.Parse(cmbMember.SelectedValue.ToString()),
int.Parse(cmbKelas.SelectedValue.ToString()), DateTime.Now, decimal.Parse(txtTotalHarga.Text), Pegawai);
con.DepositReguler(int.Parse(cmbMember.SelectedValue.ToString()), -decimal.Parse(txtTotalHarga.Text));
con.TambahDepositKelas(int.Parse(cmbMember.SelectedValue.ToString()), int.Parse(cmbKelas.SelectedValue.ToString()), int.Parse(txtDepositPertemuan.Text), null);
MessageBox.Show(this, "Data Transaksi Berhasil Disimpan", "Sukses", MessageBoxButtons.OK, MessageBoxIcon.Information);
SetDataTransaksi();
CetakStrukTransaksi cetak = new CetakStrukTransaksi();
try
{
no_struk = DateTime.Now.ToString("yy") + "." + DateTime.Now.ToString("MM") + "." + con.GetLastIdTransaksi();
cetak.InputCetakStruk(cmbMember.Text, txtNamaMember.Text, txtTotalHarga.Text, no_struk, DateTime.Now.ToString(), nama_pegawai, con.GetTglExpired(int.Parse(cmbMember.SelectedValue.ToString())).ToString(), cmbKelas.Text, cmbPromo.Text, "", "");
cetak.setListBox(kelas);
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
cetak.ShowDialog();
}
else if (con.IsDepositMemberExist(int.Parse(cmbMember.SelectedValue.ToString()), int.Parse(cmbKelas.SelectedValue.ToString())))
{
MessageBox.Show("Data Deposit Sudah Ada, Data deposit akan di update");
con.TambahTransaksi(int.Parse(cmbPromo.SelectedValue.ToString()), int.Parse(cmbMember.SelectedValue.ToString()),
int.Parse(cmbKelas.SelectedValue.ToString()), DateTime.Now, decimal.Parse(txtTotalHarga.Text), Pegawai);
con.UpdateDepositKelas(int.Parse(cmbMember.SelectedValue.ToString()), int.Parse(cmbKelas.SelectedValue.ToString()), int.Parse(txtDepositPertemuan.Text));
con.DepositReguler(int.Parse(cmbMember.SelectedValue.ToString()), -decimal.Parse(txtTotalHarga.Text));
MessageBox.Show(this, "Data Transaksi Berhasil Disimpan", "Sukses", MessageBoxButtons.OK, MessageBoxIcon.Information);
SetDataTransaksi();
CetakStrukTransaksi cetak = new CetakStrukTransaksi();
try
{
no_struk = DateTime.Now.ToString("yy") + "." + DateTime.Now.ToString("MM") + "." + con.GetLastIdTransaksi();
cetak.InputCetakStruk(cmbMember.Text, txtNamaMember.Text, txtTotalHarga.Text, no_struk, DateTime.Now.ToString(), nama_pegawai, con.GetTglExpired(int.Parse(cmbMember.SelectedValue.ToString())).ToString(), cmbKelas.Text, cmbPromo.Text, "", "");
cetak.setListBox(kelas);
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
cetak.ShowDialog();
}
}
}
clear();
SetDataTransaksi();
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
}
