private void btnHome_Click(object sender, RoutedEventArgs e) { try { if (sFormName == "HomeMember") { frmHomeMembership frm = new frmHomeMembership(); this.Close(); frm.ShowDialog(); } else if (sFormName == "Registration") { frmMemberRegistration frm = new frmMemberRegistration(0); this.Close(); frm.ShowDialog(); } else if (sFormName == "PostArrear") { frmArrearPost16 frm = new frmArrearPost16(0); this.Close(); frm.ShowDialog(); } else if (sFormName == "PreArrear") { frmArrearPre16 frm = new frmArrearPre16(0); this.Close(); frm.ShowDialog(); } else if (sFormName == "Resingation") { frmResingation frm = new frmResingation(0); this.Close(); frm.ShowDialog(); } else if (sFormName == "Transfer") { frmTransfer frm = new frmTransfer(0); this.Close(); frm.ShowDialog(); } else if (sFormName == "LEVY") { frmLevy frm = new frmLevy(0); this.Close(); frm.ShowDialog(); } else if (sFormName == "TDF") { frmTDF frm = new frmTDF(0); this.Close(); frm.ShowDialog(); } } catch (Exception ex) { ExceptionLogging.SendErrorToText(ex); } }
private void registrationToolStripMenuItem_Click(object sender, EventArgs e) { if (_memberReg == null || _memberReg.IsDisposed == true) { _memberReg = new frmMemberRegistration(); _memberReg.Show(); } _memberReg.BringToFront(); }
private void LnkLblMemberReg_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { if (_memberReg == null || _memberReg.IsDisposed == true) { _memberReg = new frmMemberRegistration(); _memberReg.Show(); } _memberReg.BringToFront(); }
private void btnDetailUnPaid_Click(object sender, RoutedEventArgs e) { var mm = dgvUnPaidMember.SelectedItem as Model.MonthSubsUnPaidMember; if (mm != null) { frmMemberRegistration f = new frmMemberRegistration(mm.MemberCode); f.ShowDialog(); } }
private void dgvUnPaidMember_MouseDoubleClick(object sender, MouseButtonEventArgs e) { var mm = dgvUnPaidMember.SelectedItem as Model.MonthSubsUnPaidMember; if (mm != null) { frmMemberRegistration f = new frmMemberRegistration(mm.MemberCode); f.ShowDialog(); } }
private void btnDetail_Click(object sender, RoutedEventArgs e) { var mm = dgvMember.SelectedItem as Model.MonthlySubsMember; if (mm != null && mm?.Membercode != null) { frmMemberRegistration f = new frmMemberRegistration(mm.Membercode.Value); f.ShowDialog(); } }
private void DgvMember_MouseDoubleClick(object sender, MouseButtonEventArgs e) { var mm = dgvMember.SelectedItem as Model.MonthlySubsMember; if (mm != null && mm?.Membercode != null) { frmMemberRegistration f = new frmMemberRegistration(mm.Membercode.Value); f.ShowDialog(); } }
private void btnMemberRegistration_Click(object sender, RoutedEventArgs e) { frmMemberRegistration frm = new frmMemberRegistration(); userPrevilage = new UserPrevilage(this.btnMemberRegistration.Tag.ToString()); if (userPrevilage.Show == true) { frm.btnSave.IsEnabled = Convert.ToBoolean(userPrevilage.AddNew); frm.btnDelete.IsEnabled = Convert.ToBoolean(userPrevilage.Remove); frm.btnSearch.IsEnabled = Convert.ToBoolean(userPrevilage.Edit); this.Close(); frm.ShowDialog(); } }
private void OnDelete(object sender, RoutedEventArgs e) { try { DataRowView drv = (DataRowView)dgvMemberApproval.SelectedItem; if (drv != null) { var btn = e.OriginalSource as Button; decimal dMemberCode = 0; dMemberCode = Convert.ToDecimal(btn.Tag); if (dMemberCode != 0) { if (rbtPending.IsChecked == true || rbtDeclain.IsChecked == true) { var mm = (from x in db.MemberInsertBranches where x.MEMBER_CODE == dMemberCode select x).FirstOrDefault(); if (mm != null) { frmMemberRegistration frm = new frmMemberRegistration(mm.MEMBER_CODE, true); frm.Height = 600; frm.Width = 1000; frm.btnApprove.Visibility = Visibility.Visible; frm.btnDenied.Visibility = Visibility.Collapsed; frm.WindowStartupLocation = WindowStartupLocation.CenterScreen; frm.btnNew.Visibility = Visibility.Collapsed; frm.btnSave.Visibility = Visibility.Collapsed; frm.btnDelete.Visibility = Visibility.Collapsed; frm.btnHistory.Visibility = Visibility.Collapsed; frm.btnSearch.Visibility = Visibility.Collapsed; frm.btnHome.Visibility = Visibility.Collapsed; frm.btnMembercard.Visibility = Visibility.Collapsed; frm.btnNomAdd.Visibility = Visibility.Collapsed; frm.btnNomClear.Visibility = Visibility.Collapsed; frm.tiPhoto.Visibility = Visibility.Visible; frm.ShowDialog(); filteration(); } else { MessageBox.Show("No Data Found!"); } } else { var mm = (from x in db.MASTERMEMBERs where x.BranchMemberCode == dMemberCode select x).FirstOrDefault(); if (mm != null) { frmMemberRegistration frm = new frmMemberRegistration(mm.MEMBER_CODE, false); frm.Height = 600; frm.Width = 1000; frm.btnApprove.Visibility = Visibility.Collapsed; frm.btnDenied.Visibility = Visibility.Visible; frm.WindowStartupLocation = WindowStartupLocation.CenterScreen; frm.btnNew.Visibility = Visibility.Collapsed; frm.btnSave.Visibility = Visibility.Collapsed; frm.btnDelete.Visibility = Visibility.Collapsed; frm.btnHistory.Visibility = Visibility.Collapsed; frm.btnSearch.Visibility = Visibility.Collapsed; frm.btnHome.Visibility = Visibility.Collapsed; frm.btnMembercard.Visibility = Visibility.Collapsed; frm.btnNomAdd.Visibility = Visibility.Collapsed; frm.btnNomClear.Visibility = Visibility.Collapsed; frm.tiPhoto.Visibility = Visibility.Visible; frm.ShowDialog(); filteration(); } else { MessageBox.Show("No Data Found!"); } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void dgvMemberApproval_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (dgvMemberApproval.CurrentCell.Column.Header.ToString() == "View") { DataRowView drv = (DataRowView)dgvMemberApproval.SelectedItem; if (drv != null) { decimal dMemberCode = Convert.ToDecimal(drv["MEMBER_CODE"]); if (rbtPending.IsChecked == true || rbtDeclain.IsChecked == true) { var mm = (from x in db.MemberInsertBranches where x.MEMBER_CODE == dMemberCode select x).FirstOrDefault(); if (mm != null) { frmMemberRegistration frm = new frmMemberRegistration(mm.MEMBER_CODE, true); frm.Height = 600; frm.Width = 1000; frm.WindowStartupLocation = WindowStartupLocation.CenterScreen; frm.btnApprove.Visibility = Visibility.Visible; frm.btnDenied.Visibility = Visibility.Collapsed; frm.tiPhoto.Visibility = Visibility.Visible; frm.btnNew.Visibility = Visibility.Collapsed; frm.btnSave.Visibility = Visibility.Collapsed; frm.btnDelete.Visibility = Visibility.Collapsed; frm.btnHistory.Visibility = Visibility.Collapsed; frm.btnSearch.Visibility = Visibility.Collapsed; frm.btnHome.Visibility = Visibility.Collapsed; frm.btnMembercard.Visibility = Visibility.Collapsed; frm.btnNomAdd.Visibility = Visibility.Collapsed; frm.btnNomClear.Visibility = Visibility.Collapsed; frm.ShowDialog(); filteration(); } else { MessageBox.Show("No Data Found!"); } } else { var mm = (from x in db.MASTERMEMBERs where x.BranchMemberCode == dMemberCode select x).FirstOrDefault(); if (mm != null) { frmMemberRegistration frm = new frmMemberRegistration(mm.MEMBER_CODE, false); frm.Height = 600; frm.Width = 1000; frm.btnApprove.Visibility = Visibility.Collapsed; frm.btnDenied.Visibility = Visibility.Visible; frm.WindowStartupLocation = WindowStartupLocation.CenterScreen; frm.btnNew.Visibility = Visibility.Collapsed; frm.btnSave.Visibility = Visibility.Collapsed; frm.btnDelete.Visibility = Visibility.Collapsed; frm.btnHistory.Visibility = Visibility.Collapsed; frm.btnSearch.Visibility = Visibility.Collapsed; frm.btnHome.Visibility = Visibility.Collapsed; frm.btnMembercard.Visibility = Visibility.Collapsed; frm.btnNomAdd.Visibility = Visibility.Collapsed; frm.btnNomClear.Visibility = Visibility.Collapsed; frm.ShowDialog(); filteration(); } else { MessageBox.Show("No Data Found!"); } } } } else if ((dgvMemberApproval.CurrentCell.Column.Header.ToString() == "Approve" || dgvMemberApproval.CurrentCell.Column.Header.ToString() == "Declain") && rbtApproved.IsChecked == false) { DataRowView drv = (DataRowView)dgvMemberApproval.SelectedItem; if (drv != null) { if (MessageBox.Show(this, "Are you Sure to Approve this Member? It will Affect Current Data!", "Save Confirmation", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { decimal dMemberCode = Convert.ToDecimal(drv["MEMBER_CODE"]); var wm = (from x in db.MemberInsertBranches where x.MEMBER_CODE == dMemberCode select x).FirstOrDefault(); if (wm != null) { decimal dMemberId = Convert.ToDecimal(db.MASTERMEMBERs.Max(x => x.MEMBER_ID)) + 1; MASTERMEMBER mm = new MASTERMEMBER(); mm.MEMBERTYPE_CODE = wm.MEMBERTYPE_CODE; mm.MEMBER_ID = dMemberId; mm.MEMBER_TITLE = wm.MEMBER_TITLE; mm.MEMBER_NAME = wm.MEMBER_NAME; mm.DATEOFBIRTH = wm.DATEOFBIRTH; mm.AGE_IN_YEARS = wm.AGE_IN_YEARS; mm.SEX = wm.SEX; mm.REJOINED = wm.REJOINED; mm.RACE_CODE = wm.RACE_CODE; mm.ICNO_NEW = wm.ICNO_NEW; mm.ICNO_OLD = wm.ICNO_OLD; mm.DATEOFJOINING = wm.DATEOFJOINING; mm.BANK_CODE = wm.BANK_CODE; mm.BRANCH_CODE = wm.BANKBRANCH_CODE; mm.DATEOFEMPLOYMENT = wm.DATEOFEMPLOYMENT; mm.Salary = wm.Salary; mm.LEVY = wm.LEVY; mm.TDF = wm.TDF; mm.LEVY_AMOUNT = wm.LEVY_AMOUNT; mm.TDF_AMOUNT = wm.TDF_AMOUNT; //mm.LevyPaymentDate = DateTime.Now; //mm.Tdf_PaymentDate = DateTime.Now; mm.ENTRANCEFEE = wm.ENTRANCEFEE; mm.MONTHLYBF = wm.MONTHLYBF; mm.ACCBF = wm.ACCBF; mm.CURRENT_YTDBF = wm.CURRENT_YTDBF; mm.MONTHLYSUBSCRIPTION = wm.MONTHLYSUBSCRIPTION; mm.ACCSUBSCRIPTION = wm.ACCSUBSCRIPTION; mm.CURRENT_YTDSUBSCRIPTION = wm.CURRENT_YTDSUBSCRIPTION; mm.ACCBENEFIT = wm.ACCBENEFIT; mm.TOTALMONTHSPAID = wm.TOTALMONTHSPAID; mm.ADDRESS1 = wm.ADDRESS1; mm.ADDRESS2 = wm.ADDRESS2; mm.ADDRESS3 = wm.ADDRESS3; mm.PHONE = wm.PHONE; mm.MOBILE = wm.MOBILE; mm.EMAIL = wm.EMAIL; mm.CITY_CODE = wm.CITY_CODE; mm.ZIPCODE = wm.ZIPCODE; mm.STATE_CODE = wm.STATE_CODE; mm.COUNTRY = wm.COUNTRY; mm.UpdatedBy = AppLib.iUserCode; mm.UpdatedOn = DateTime.Now; mm.IsBranchRegister = true; mm.BranchMemberCode = Convert.ToInt32(dMemberCode); db.MASTERMEMBERs.Add(mm); wm.IsApproved = 1; db.SaveChanges(); var bk = (from x in db.MASTERBANKs where x.BANK_CODE == wm.BANK_CODE select x).FirstOrDefault(); var bb = (from x in db.MASTERBANKBRANCHes where x.BANKBRANCH_CODE == wm.BANKBRANCH_CODE select x).FirstOrDefault(); MemberStatusLog ms = new MemberStatusLog(); ms.MEMBER_CODE = Convert.ToInt32(mm.MEMBER_CODE); ms.MEMBER_NAME = wm.MEMBER_NAME; ms.MEMBER_ID = Convert.ToInt32(mm.MEMBER_ID); ms.MEMBERTYPE_CODE = Convert.ToInt32(wm.MEMBERTYPE_CODE); if (Convert.ToInt32(wm.MEMBERTYPE_CODE) == 1) { ms.MEMBERTYPE_NAME = "C"; } else { ms.MEMBERTYPE_NAME = "N"; } ms.SEX = wm.SEX; if (wm.SEX == "Male") { ms.SEX_MF = "M"; } else { ms.SEX_MF = "F"; } if (wm.RACE_CODE == 1) { ms.RACE = "M"; } else if (wm.RACE_CODE == 2) { ms.RACE = "I"; } else if (wm.RACE_CODE == 3) { ms.RACE = "C"; } else { ms.RACE = "O"; } ms.ICNO_NEW = string.IsNullOrEmpty(wm.ICNO_NEW) ? "" : wm.ICNO_NEW; ms.ICNO_OLD = string.IsNullOrEmpty(wm.ICNO_OLD) ? "" : wm.ICNO_OLD; ms.Levy = wm.LEVY; ms.TDF = wm.TDF; ms.CITY_CODE = Convert.ToInt32(wm.CITY_CODE); ms.STATE_CODE = Convert.ToInt32(wm.STATE_CODE); ms.MOBILE_NO = wm.MOBILE; ms.DATEOFBIRTH = wm.DATEOFBIRTH; ms.BANK_CODE = Convert.ToInt32(wm.BANK_CODE); ms.BANKUSER_CODE = bk.BANK_USERCODE; ms.BRANCH_CODE = Convert.ToInt32(wm.BANKBRANCH_CODE); ms.BRANCH_USER_CODE = bb.BANKBRANCH_USERCODE; ms.BRANCH_NAME = bb.BANKBRANCH_NAME; ms.DATEOFJOINING = wm.DATEOFJOINING; ms.REJOINED = Convert.ToBoolean(wm.REJOINED); ms.TOTALMONTHSPAID = 1; ms.TOTALMOTHSDUE = 0; ms.LASTPAYMENT_DATE = DateTime.Today; ms.MEMBERSTATUS = "ACTIVE"; ms.MEMBERSTATUSCODE = 1; db.MemberStatusLogs.Add(ms); db.SaveChanges(); int iMemberCode = Convert.ToInt32(db.MASTERMEMBERs.Max(x => x.MEMBER_CODE)); var ni = (from x in db.NomineeInsertBranches where x.MEMBER_CODE == dMemberCode select x).FirstOrDefault(); if (ni != null) { MASTERNOMINEE mn = new MASTERNOMINEE(); mn.MEMBER_CODE = iMemberCode; mn.NAME = ni.NAME; mn.ICNO_NEW = ni.ICNO_NEW; mn.SEX = ni.SEX; mn.AGE = ni.AGE; mn.RELATION_CODE = ni.RELATION_CODE; mn.ADDRESS1 = ni.ADDRESS1; mn.ADDRESS2 = ni.ADDRESS2; mn.ADDRESS3 = ni.ADDRESS3; mn.CITY_CODE = ni.CITY_CODE; mn.STATE_CODE = ni.STATE_CODE; mn.COUNTRY = ni.COUNTRY; mn.ZIPCODE = ni.ZIPCODE; mn.PHONE = ni.PHONE; mn.MOBILE = ni.MOBILE; db.MASTERNOMINEEs.Add(mn); db.SaveChanges(); } var gi = (from x in db.GuardianInsertBranches where x.MEMBER_CODE == dMemberCode select x).FirstOrDefault(); if (gi != null) { MASTERGUARDIAN mg = new MASTERGUARDIAN(); mg.MEMBER_CODE = iMemberCode; mg.NAME = gi.NAME; mg.ICNO_NEW = gi.ICNO_NEW; mg.SEX = gi.SEX; mg.AGE = gi.AGE; mg.RELATION_CODE = gi.RELATION_CODE; mg.ADDRESS1 = gi.ADDRESS1; mg.ADDRESS2 = gi.ADDRESS2; mg.ADDRESS3 = gi.ADDRESS3; mg.CITY_CODE = gi.CITY_CODE; mg.STATE_CODE = gi.STATE_CODE; mg.COUNTRY = gi.COUNTRY; mg.ZIPCODE = gi.ZIPCODE; mg.PHONE = gi.PHONE; mg.MOBILE = gi.MOBILE; db.MASTERGUARDIANs.Add(mg); db.SaveChanges(); } MessageBox.Show("Member Added Sucessfully!", "Sucessfully"); txtBankName.Text = ""; txtBranchName.Text = ""; txtMF.Text = ""; txtICNo.Text = ""; txtMemberName.Text = ""; txtNubeBranch.Text = ""; txtMemberType.Text = ""; txtMemberNo.Text = ""; txtNoofMembers.Text = ""; load_Form(); } } } } else if (rbtApproved.IsChecked == true) { DataRowView drv = (DataRowView)dgvMemberApproval.SelectedItem; if (drv != null) { if (MessageBox.Show(this, "Are you Sure to Decline this Member? It will Affect Current Data!", "Save Confirmation", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { decimal dMemberCode = Convert.ToDecimal(drv["MEMBER_CODE"]); var mm = (from x in db.MASTERMEMBERs where x.BranchMemberCode == dMemberCode select x).FirstOrDefault(); if (mm != null) { var sl = (from x in db.MemberStatusLogs where x.MEMBER_CODE == mm.MEMBER_CODE select x).FirstOrDefault(); if (sl != null) { db.MemberStatusLogs.Remove(sl); } var nm = (from x in db.MASTERNOMINEEs where x.MEMBER_CODE == mm.MEMBER_CODE select x).FirstOrDefault(); if (nm != null) { db.MASTERNOMINEEs.Remove(nm); } var gr = (from x in db.MASTERGUARDIANs where x.MEMBER_CODE == mm.MEMBER_CODE select x).FirstOrDefault(); if (gr != null) { db.MASTERGUARDIANs.Remove(gr); } db.MASTERMEMBERs.Remove(mm); db.SaveChanges(); } var wm = (from x in db.MemberInsertBranches where x.MEMBER_CODE == dMemberCode select x).FirstOrDefault(); if (wm != null) { wm.IsApproved = 2; db.SaveChanges(); } MessageBox.Show("Member Decline Sucessfully!", "Sucessfully"); txtBankName.Text = ""; txtBranchName.Text = ""; txtMF.Text = ""; txtICNo.Text = ""; txtMemberName.Text = ""; txtNubeBranch.Text = ""; txtMemberType.Text = ""; txtMemberNo.Text = ""; txtNoofMembers.Text = ""; load_Form(); } } } }
private void LnkLblMemberReg_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { frmMemberRegistration frminfo = new frmMemberRegistration(); frminfo.Show(); }
private void dgvDetails_MouseDoubleClick(object sender, MouseButtonEventArgs e) { try { //if ((sFormName == "Registration" || sFormName == "LEVY" || sFormName == "TDF" || sFormName == "Resingation" || // sFormName == "Transfer" || sFormName == "PostArrear" || sFormName == "PreArrear" || sFormName == "HomeMember" || // sFormName== "Annual Statement") && (dgvDetails.SelectedItem != null)) if ((dgvDetails.SelectedItem != null)) { DataRowView drv = (DataRowView)dgvDetails.SelectedItem; dMember_Code = Convert.ToDecimal(drv["MEMBER_CODE"]); if (dMember_Code != 0) { if (sFormName == "Transfer") { frmTransfer frm = new frmTransfer(dMember_Code); frm.Show(); this.Hide(); } else if (sFormName == "PostArrear") { frmArrearPost16 frm = new frmArrearPost16(dMember_Code, 0); frm.Show(); this.Hide(); } else if (sFormName == "PreArrear") { frmArrearPre16 frm = new frmArrearPre16(dMember_Code, 0); frm.Show(); this.Hide(); } else if (sFormName == "Resingation") { frmResingation frm = new frmResingation(dMember_Code); frm.Show(); this.Hide(); } else if (sFormName == "LEVY") { frmLevy frm = new frmLevy(dMember_Code); frm.Show(); this.Close(); } else if (sFormName == "TDF") { frmTDF frm = new frmTDF(dMember_Code); frm.Show(); this.Close(); } else if (sFormName == "Annual Statement") { Reports.frmAnnualStatement frm = new Reports.frmAnnualStatement(dMember_Code); frm.Show(); this.Close(); } else { frmMemberRegistration frm = new frmMemberRegistration(dMember_Code, false); frm.Show(); this.Hide(); } } } } catch (Exception ex) { ExceptionLogging.SendErrorToText(ex); } }