private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
bValidation = false;
BeforeUpdate();
if (bValidation == false)
{
MASTERMEMBER mmMst = (from mas in db.MASTERMEMBERs where mas.MEMBER_CODE == dMember_Code select mas).FirstOrDefault();
var OldData = new JSonHelper().ConvertObjectToJSon(mmMst);
mmMst.Tdf_PaymentDate = Convert.ToDateTime(dtpPaymentDate.SelectedDate);
mmMst.TDF_AMOUNT = Convert.ToDecimal(txtAmount.Text);
db.SaveChanges();
var NewData = new JSonHelper().ConvertObjectToJSon(mmMst);
AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "MASTERMEMBER", "TDF MANUAL ENTRY");
MessageBox.Show("Saved Sucessfully");
fClear();
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
private void dgArrearPost_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
{
try
{
if (e.EditAction == DataGridEditAction.Commit)
{
var column = e.Column as DataGridBoundColumn;
if (column != null)
{
var sColumnName = (column.Binding as Binding).Path.Path;
if (sColumnName == "YEAR")
{
var el = e.EditingElement as TextBox;
if (!string.IsNullOrEmpty(el.Text))
{
int iRow = dgArrearPost.SelectedIndex;
if (!string.IsNullOrEmpty(el.Text) && Convert.ToInt32(el.Text) != 0)
{
dtArrearPost.Rows[iRow]["YEAR"] = el.Text;
}
dgArrearPost.CurrentCell = new DataGridCellInfo(dgArrearPost.Items[iRow], dgArrearPost.Columns[1]);
dgArrearPost.BeginEdit();
}
}
else if (sColumnName == "MONTH")
{
var el = e.EditingElement as TextBox;
if (!string.IsNullOrEmpty(el.Text))
{
int iRow = dgArrearPost.SelectedIndex;
if (!string.IsNullOrEmpty(el.Text))
{
dtArrearPost.Rows[iRow]["MONTH"] = el.Text;
}
dgArrearPost.CurrentCell = new DataGridCellInfo(dgArrearPost.Items[iRow], dgArrearPost.Columns[2]);
dgArrearPost.BeginEdit();
}
}
else if (sColumnName == "AMOUNT")
{
var el = e.EditingElement as TextBox;
if (!string.IsNullOrEmpty(el.Text))
{
int iRow = dgArrearPost.SelectedIndex;
if (!string.IsNullOrEmpty(el.Text))
{
if (Convert.ToInt32(el.Text) != 0)
{
MASTERMEMBER mm = (from mas in db.MASTERMEMBERs where mas.MEMBER_CODE == dMember_Code select mas).FirstOrDefault();
dtArrearPost.Rows[iRow]["AMOUNT"] = el.Text;
dtArrearPost.Rows[iRow]["BF"] = Convert.ToInt32(mm.MONTHLYBF);
dtArrearPost.Rows[iRow]["INSURANCE"] = 4;
dtArrearPost.Rows[iRow]["SUBSCRIPTION"] = Convert.ToInt32(el.Text) - (Convert.ToInt32(mm.MONTHLYBF) + 4);
fTotalAmount();
if (dgArrearPost.Items.Count <= (iRow + 1))
{
fNewRow();
if (bNewRow == true)
{
dgArrearPost.CurrentCell = new DataGridCellInfo(dgArrearPost.Items[iRow + 1], dgArrearPost.Columns[0]);
dgArrearPost.BeginEdit();
}
}
}
}
}
}
}
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
bValidation = false;
BeforeUpdate();
if (bValidation == false)
{
MASTERMEMBER mmMst = (from mas in db.MASTERMEMBERs where mas.MEMBER_CODE == dMember_Code select mas).FirstOrDefault();
if (bUpdate == false)
{
DataView dv = new DataView(dtArrearPost);
dv.RowFilter = "AMOUNT>0";
int iTotalDuePay = dv.Count;
ArrearPostMaster arrearMaster = new ArrearPostMaster
{
MemberCode = dMember_Code,
EntryDate = DateTime.Now,
BeforeLastPaymentDate = mmMst.LASTPAYMENT_DATE,
BeforeTotalBF = mmMst.ACCBF,
BeforeTotalSubscription = mmMst.ACCSUBSCRIPTION,
BeforeTotalMonthsPaid = Convert.ToInt32(mmMst.TOTALMONTHSPAID),
TotalDuePay = iTotalDuePay,
UpdatedStatus = "Not Updated"
};
db.ArrearPostMasters.Add(arrearMaster);
db.SaveChanges();
var NewData = new JSonHelper().ConvertObjectToJSon(arrearMaster);
AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData, "ArrearPostMaster");
DataTable dtTemp = new DataTable();
dtTemp = ((DataView)dgArrearPost.ItemsSource).ToTable();
var iMasterId = Convert.ToInt32(db.ArrearPostMasters.Max(x => x.ID));
List <ArrearPostDetail> lstArrearDtl = new List <ArrearPostDetail>();
foreach (DataRow row in dtTemp.Rows)
{
if (Convert.ToDecimal(row["AMOUNT"]) != 0)
{
ArrearPostDetail arrearDtl = new ArrearPostDetail
{
MasterId = iMasterId,
Year = Convert.ToInt32(row["YEAR"]),
Month = Convert.ToDateTime("1/" + row["MONTH"] + row["YEAR"]).Month,
TotalAmount = Convert.ToDecimal(row["AMOUNT"]),
AmounBF = Convert.ToDecimal(row["BF"]),
AmountInsurance = Convert.ToDecimal(row["INSURANCE"]),
AmountSubscription = Convert.ToDecimal(row["SUBSCRIPTION"]),
UpdatedStatus = "Not Updated",
MemberCode = Convert.ToInt32(dMember_Code)
};
lstArrearDtl.Add(arrearDtl);
}
}
if (lstArrearDtl.Count > 0)
{
db.ArrearPostDetails.AddRange(lstArrearDtl);
db.SaveChanges();
var NewData1 = new JSonHelper().ConvertObjectToJSon(lstArrearDtl);
AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData1, "ArrearPostDetail");
}
MessageBox.Show("Details are Saved Sucessfully");
fClear();
}
else
{
ArrearPostMaster mst = (from mas in db.ArrearPostMasters where mas.ID == iArrearMst_ID select mas).FirstOrDefault();
var OldData = new JSonHelper().ConvertObjectToJSon(mst);
DataView dv = new DataView(dtArrearPost);
dv.RowFilter = "AMOUNT>0";
int iTotalDuePay = dv.Count;
if (mst != null)
{
mst.UpdatedEntryDate = DateTime.Now;
mst.IsEdited = true;
mst.TotalDuePay = iTotalDuePay;
}
db.SaveChanges();
var NewData = new JSonHelper().ConvertObjectToJSon(mst);
AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "ArrearPostMaster");
ArrearPostDetail dtl = (from mas in db.ArrearPostDetails where mas.MasterId == iArrearMst_ID select mas).FirstOrDefault();
var OldData1 = new JSonHelper().ConvertObjectToJSon(dtl);
if (dtl != null)
{
db.ArrearPostDetails.RemoveRange(db.ArrearPostDetails.Where(x => x.MasterId == iArrearMst_ID));
db.SaveChanges();
}
DataTable dtTemp = new DataTable();
dtTemp = ((DataView)dgArrearPost.ItemsSource).ToTable();
List <ArrearPostDetail> lstArrearDtl = new List <ArrearPostDetail>();
foreach (DataRow row in dtTemp.Rows)
{
if (Convert.ToDecimal(row["AMOUNT"]) != 0)
{
ArrearPostDetail arrearDtl = new ArrearPostDetail
{
MasterId = iArrearMst_ID,
Year = Convert.ToInt32(row["YEAR"]),
Month = Convert.ToDateTime("1/" + row["MONTH"] + row["YEAR"]).Month,
TotalAmount = Convert.ToDecimal(row["AMOUNT"]),
AmounBF = Convert.ToDecimal(row["BF"]),
AmountInsurance = Convert.ToDecimal(row["INSURANCE"]),
AmountSubscription = Convert.ToDecimal(row["SUBSCRIPTION"]),
UpdatedStatus = "Not Updated",
MemberCode = Convert.ToInt32(dMember_Code)
};
lstArrearDtl.Add(arrearDtl);
}
}
if (lstArrearDtl.Count > 0)
{
db.ArrearPostDetails.AddRange(lstArrearDtl);
db.SaveChanges();
var NewData1 = new JSonHelper().ConvertObjectToJSon(lstArrearDtl);
AppLib.EventHistory(this.Tag.ToString(), 1, OldData1, NewData1, "ArrearPostDetail");
}
MessageBox.Show("Details are Updated Sucessfully");
fClear();
}
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
bValidation = false;
BeforeUpdate();
if (bValidation == false)
{
MASTERMEMBER mm = (from mas in db.MASTERMEMBERs where mas.MEMBER_CODE == dMember_Code select mas).FirstOrDefault();
//var OldData = new JSonHelper().ConvertObjectToJSon(mm);
if (mm != null)
{
mm.BANK_CODE = Convert.ToDecimal(cmbBankName.SelectedValue);
mm.BRANCH_CODE = Convert.ToDecimal(cmbBranchName.SelectedValue);
db.SaveChanges();
//var NewData = new JSonHelper().ConvertObjectToJSon(mm);
//AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "MASTERMEMBER");
MemberTransfer mt = new MemberTransfer();
mt.EntryDate = DateTime.Now.Date;
mt.MemberCode = dMember_Code;
mt.BankCodeBF = dBankCodeBF;
mt.BranchCodeBF = dBranchCodeBF;
mt.BankCodeAF = Convert.ToDecimal(cmbBankCode.SelectedValue);
mt.BranchCodeAF = Convert.ToDecimal(cmbBranchCode.SelectedValue);
mt.UserId = AppLib.iUserCode;
db.MemberTransfers.Add(mt);
db.SaveChanges();
var NewData1 = new JSonHelper().ConvertObjectToJSon(mt);
//AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData1, "MEMBERTRANSFER");
MessageBox.Show(txtMemberName.Text + " Member Has Tranfered Sucessfully");
if (MessageBox.Show("Do you want to Send Mail to NUBE?", "EMAIL Confirmation ", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
//string sMemberMailID = mm.EMAIL.ToString();
if (mm.EMAIL == null)
{
MessageBox.Show("This Member Does Not Contain any Email Address!");
fNew();
return;
}
else
{
progressBar1.Minimum = 1;
progressBar1.Maximum = 10;
progressBar1.Visibility = Visibility.Visible;
MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");
var mn = (from m in db.MASTERNAMESETUPs select m).FirstOrDefault();
mail.To.Add(mm.EMAIL.ToString());
if (mn != null)
{
mail.CC.Add(mn.CCEamilId1.ToString());
mail.CC.Add(mn.CCEamilId1.ToString());
}
mail.From = new MailAddress(mn.SenderEmailId.ToString());
mail.Subject = "NUBE TRANSFER MAIL";
mail.Body = "Dear Mr/Ms." + txtMemberName.Text.ToString() + ", \r" +
" Your Bank Transfer has Successfully Transfered \r\r" +
" Given Below the Bank & Branch Details are \r" +
" From " + txtBankName.Text.ToString() + " - " + txtBranchName.Text.ToString() + "\r" +
" To " + cmbBankName.Text.ToString() + " - " + cmbBranchName.Text.ToString();
progressBar1.Value = 2;
System.Windows.Forms.Application.DoEvents();
if (MessageBox.Show("Do you want to Attach any Files in this Email?", "EMAIL Attachment", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
progressBar1.Value = 4;
System.Windows.Forms.Application.DoEvents();
OpenFileDialog OpenDialogBox = new OpenFileDialog();
OpenDialogBox.DefaultExt = ".txt";
OpenDialogBox.Filter = "txt files (*.txt)|*.txt|All files (*.*)|*.*";
var browsefile = OpenDialogBox.ShowDialog();
if (browsefile == true)
{
progressBar1.Value = 6;
System.Windows.Forms.Application.DoEvents();
System.Net.Mail.Attachment attachment;
attachment = new System.Net.Mail.Attachment(OpenDialogBox.FileName.ToString());
mail.Attachments.Add(attachment);
}
}
progressBar1.Value = 7;
System.Windows.Forms.Application.DoEvents();
SmtpServer.Port = 587;
SmtpServer.Credentials = new System.Net.NetworkCredential(mn.SenderEmailId.ToString(), mn.SenderPassword.ToString());
SmtpServer.EnableSsl = true;
progressBar1.Value = 9;
System.Windows.Forms.Application.DoEvents();
SmtpServer.Send(mail);
progressBar1.Value = 10;
System.Windows.Forms.Application.DoEvents();
MessageBox.Show("Mail Send Sucessfully!");
progressBar1.Visibility = Visibility.Hidden;
}
}
fNew();
}
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
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();
}
}
}
}
public JsonResult Approve(decimal MemberCode)
{
try
{
DAL.nubebfsEntities db = new DAL.nubebfsEntities();
var wm = (from x in db.MemberInsertBranches where x.MEMBER_CODE == MemberCode 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.CountryName;
mm.UpdatedBy = 0;
mm.UpdatedOn = DateTime.Now;
mm.IsBranchRegister = true;
mm.BranchMemberCode = Convert.ToInt32(MemberCode);
db.MASTERMEMBERs.Add(mm);
wm.IsApproved = 1;
db.SaveChanges();
int iMemberCode = Convert.ToInt32(db.MASTERMEMBERs.Max(x => x.MEMBER_CODE));
var ni = (from x in db.NomineeInsertBranches where x.MEMBER_CODE == MemberCode 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.CITY_CODE = ni.CITY_CODE;
mn.STATE_CODE = ni.STATE_CODE;
mn.COUNTRY = ni.COUNTRY;
db.MASTERNOMINEEs.Add(mn);
db.SaveChanges();
}
var gi = (from x in db.GuardianInsertBranches where x.MEMBER_CODE == MemberCode 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.CITY_CODE = gi.CITY_CODE;
mg.STATE_CODE = gi.STATE_CODE;
mg.COUNTRY = gi.COUNTRY;
db.MASTERGUARDIANs.Add(mg);
db.SaveChanges();
}
return(Json(new { MemberId = mm.MEMBER_ID, Msg = "Approved Sucessfuly" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { ErrMsg = "No Records Found" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { isSaved = false, ErrMsg = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
