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