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