private void DgrStatus_MouseDoubleClick(object sender, MouseButtonEventArgs e) { try { mmStatus = dgrStatus.SelectedItem as MemberMonthEndStatu; mmStatus.LASTPAYMENTDATE = mmStatus.StatusMonth; this.gbxStatus.DataContext = mmStatus; }catch (Exception ex) { } }
private void btnClear_Click(object sender, RoutedEventArgs e) { try { mmStatus = new MemberMonthEndStatu(); mmStatus.MEMBERTYPE_CODE = data.MEMBERTYPE_CODE; mmStatus.BANK_CODE = data.BANK_CODE; mmStatus.BRANCH_CODE = data.BRANCH_CODE; mmStatus.NUBE_BRANCH_CODE = data.MASTERBANKBRANCH.NUBE_BRANCH_CODE; this.gbxStatus.DataContext = mmStatus; }catch (Exception ex) { } }
private void BtnSave_Click(object sender, RoutedEventArgs e) { try { var dtFrom = mmStatus.StatusMonth.Value; var dtTo = mmStatus.LASTPAYMENTDATE.Value; while (dtFrom <= dtTo) { var st = data.MemberMonthEndStatus.FirstOrDefault(x => x.StatusMonth == dtFrom); if (st == null) { st = new MemberMonthEndStatu(); st.MEMBERTYPE_CODE = data.MEMBERTYPE_CODE; st.BANK_CODE = data.BANK_CODE; st.BRANCH_CODE = data.BRANCH_CODE; st.NUBE_BRANCH_CODE = data.MASTERBANKBRANCH.NUBE_BRANCH_CODE; st.StatusMonth = dtFrom; data.MemberMonthEndStatus.Add(st); } st.TOTAL_MONTHS = mmStatus.TOTAL_MONTHS; st.TOTALSUBCRP_AMOUNT = mmStatus.TOTALSUBCRP_AMOUNT; st.TOTALBF_AMOUNT = mmStatus.TOTALBF_AMOUNT; st.TOTALINSURANCE_AMOUNT = mmStatus.TOTALINSURANCE_AMOUNT; if ((st.StatusMonth.Value.Year == 2005 && st.StatusMonth.Value.Month == 9) || (st.StatusMonth.Value.Year == data.DATEOFJOINING.Value.Year && st.StatusMonth.Value.Month == data.DATEOFJOINING.Value.Month)) { st.LASTPAYMENTDATE = data.DATEOFJOINING.Value; var cmon = data.DATEOFJOINING.Value.MonthDiff(st.StatusMonth.Value) + 1; var pmon = st.TOTAL_MONTHS; var dmon = cmon - pmon; st.TOTALMONTHSCONTRIBUTION = cmon; st.TOTALMONTHSPAID = pmon; st.TOTALMONTHSDUE = dmon; st.ACCSUBSCRIPTION = st.TOTALSUBCRP_AMOUNT; st.ACCBF = st.TOTALBF_AMOUNT; st.ACCINSURANCE = st.TOTALINSURANCE_AMOUNT; try { st.SUBSCRIPTION_AMOUNT = st.ACCSUBSCRIPTION / st.TOTALMONTHSPAID; st.BF_AMOUNT = st.ACCBF / st.TOTALMONTHSPAID; st.INSURANCE_AMOUNT = st.ACCINSURANCE / st.TOTALMONTHSPAID; st.SUBSCRIPTIONDUE = st.SUBSCRIPTION_AMOUNT * st.TOTALMONTHSDUE; st.BFDUE = st.BF_AMOUNT * st.TOTALMONTHSDUE; st.INSURANCEDUE = st.INSURANCE_AMOUNT * st.TOTALMONTHSDUE; } catch (Exception ex) { } } dtFrom = dtFrom.AddMonths(1); } data.IsHistoryClean = false; db.SaveChanges(); MessageBox.Show("Saved"); try { var MEMBER_ID = Convert.ToDecimal(txtMemberId.Text); Search(MEMBER_ID); } catch (Exception ex) { } } catch (Exception ex) { } }