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