private void btnDelete_Click(object sender, RoutedEventArgs e) { try { if (ID != 0) { var s = txtBankName.Text; if (MessageBox.Show("Do you want to Delete '" + s + "'?", "Delete Confirmation", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { decimal i = Convert.ToDecimal(ID); MASTERBANK mb = db.MASTERBANKs.Where(x => x.BANK_CODE == ID).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(mb); db.MASTERBANKs.Remove(mb); db.SaveChanges(); AppLib.EventHistory(this.Tag.ToString(), 2, OldData, "", "MASTERBANK"); MessageBox.Show("Deleted Successfully"); ClearForm(); LoadWindow(); } } else { MessageBox.Show("Please Select Any Bank! (Double Click to Select)"); } } catch (Exception ex) { Nube.ExceptionLogging.SendErrorToText(ex); } }
void loadBank(MASTERBANK bank) { Model.MonthEndClosed mec = new Model.MonthEndClosed(); mec.BankCode = bank.BANK_CODE; mec.BankName = $"{bank.BANK_USERCODE} - {bank.BANK_NAME}"; mec.PaidA = lstPaidMember.Count(x => x.MASTERMEMBER.BANK_CODE == bank.BANK_CODE && x.MonthlySubcriptionMemberStatusId == (int)AppLib.MemberStatus.Active); mec.PaidD = lstPaidMember.Count(x => x.MASTERMEMBER.BANK_CODE == bank.BANK_CODE && x.MonthlySubcriptionMemberStatusId == (int)AppLib.MemberStatus.Defaulter); mec.Paid = mec.PaidA + mec.PaidD; mec.UnpaidA = lstMasterMember.Count(x => x.BANK_CODE == bank.BANK_CODE && x.STATUS_CODE == (decimal)AppLib.MemberStatus.Active) - mec.PaidA; mec.UnpaidD = lstMasterMember.Count(x => x.BANK_CODE == bank.BANK_CODE && x.STATUS_CODE == (decimal)AppLib.MemberStatus.Defaulter) - mec.PaidD; mec.Unpaid = mec.UnpaidA + mec.UnpaidD; mec.Total = lstMasterMember.Count(x => x.BANK_CODE == bank.BANK_CODE); if (mec.Total != 0) { lstMonthEndClosed.Add(mec); System.Windows.Forms.Application.DoEvents(); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (txtBankName.Text == "") { MessageBox.Show("Enter Bank Name!"); txtBankName.Focus(); } else if (txtBankUserCode.Text == "") { MessageBox.Show("Enter User Code!"); txtBankUserCode.Focus(); } //else if (cmbNubeBranch.Text == "") //{ // MessageBox.Show("Enter Branch Name!"); // cmbNubeBranch.Focus(); //} else if (MessageBox.Show("Do You want to save this Record?", "Save Confirmation", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { if (ID != 0) { decimal id = (decimal)ID; MASTERBANK mb = db.MASTERBANKs.Where(x => x.BANK_CODE == id).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(mb); mb.BANK_NAME = txtBankName.Text; mb.BANK_USERCODE = txtBankUserCode.Text; //mb.NUBE_BRANCH = 2; db.SaveChanges(); AppLib.lstMASTERBANK = db.MASTERBANKs.OrderBy(x => x.BANK_NAME).ToList(); var NewData = new JSonHelper().ConvertObjectToJSon(mb); AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "MASTERBANK"); MessageBox.Show("Saved Successfully"); ClearForm(); } else { MASTERBANK mb = new MASTERBANK(); mb.BANK_NAME = txtBankName.Text; mb.BANK_USERCODE = txtBankUserCode.Text; //mb.NUBE_BRANCH = 2; db.MASTERBANKs.Add(mb); db.SaveChanges(); AppLib.lstMASTERBANK = db.MASTERBANKs.OrderBy(x => x.BANK_NAME).ToList(); var NewData = new JSonHelper().ConvertObjectToJSon(mb); AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData, "MASTERBANK"); MessageBox.Show("Saved Successfully"); ClearForm(); } } } catch (Exception ex) { Nube.ExceptionLogging.SendErrorToText(ex); } }