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