private void btnEditOldDue_Click(object sender, RoutedEventArgs e)
{
try
{
if (dMember_Code != 0)
{
ArrearPreMaster mst = (from mas in db.ArrearPreMasters where mas.MemberCode == dMember_Code select mas).FirstOrDefault();
if (mst != null)
{
frmArrearDueList frm = new frmArrearDueList(dMember_Code, "PreArrear", txtMemberType.Text, txtMemberName.Text, txtMemberNo.Text);
this.Close();
frm.ShowDialog();
}
else
{
MessageBox.Show("No Data Found!");
txtMemberNo.Focus();
}
}
else
{
MessageBox.Show("Please Enter the Membership No!");
txtMemberNo.Focus();
}
}
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(dtArrearPre);
dv.RowFilter = "AMOUNT>0";
int iTotalDuePay = dv.Count;
ArrearPreMaster arrearMaster = new ArrearPreMaster
{
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.ArrearPreMasters.Add(arrearMaster);
db.SaveChanges();
var NewData = new JSonHelper().ConvertObjectToJSon(arrearMaster);
AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData, "ArrearPreMaster");
DataTable dtTemp = new DataTable();
dtTemp = ((DataView)dgArrearPre.ItemsSource).ToTable();
var iMasterId = Convert.ToInt32(db.ArrearPreMasters.Max(x => x.ID));
List<ArrearPreDetail> lstArrearDtl = new List<ArrearPreDetail>();
foreach (DataRow row in dtTemp.Rows)
{
if (Convert.ToDecimal(row["AMOUNT"]) != 0)
{
ArrearPreDetail arrearDtl = new ArrearPreDetail
{
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"]),
AmountSubscription = Convert.ToDecimal(row["SUBSCRIPTION"]),
UpdatedStatus = "Not Updated",
MemberCode = Convert.ToInt32(dMember_Code)
};
lstArrearDtl.Add(arrearDtl);
}
}
if (lstArrearDtl.Count > 0)
{
db.ArrearPreDetails.AddRange(lstArrearDtl);
db.SaveChanges();
var NewData1 = new JSonHelper().ConvertObjectToJSon(lstArrearDtl);
AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData1, "ArrearPreDetail");
}
MessageBox.Show("Details are Saved Sucessfully");
fClear();
}
else
{
ArrearPreMaster mst = (from mas in db.ArrearPreMasters where mas.ID == iArrearMst_ID select mas).FirstOrDefault();
var OldData = new JSonHelper().ConvertObjectToJSon(mst);
if (mst != null)
{
mst.UpdatedEntryDate = DateTime.Now;
mst.IsEdited = true;
}
db.SaveChanges();
var NewData = new JSonHelper().ConvertObjectToJSon(mst);
AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "ArrearPreMaster");
ArrearPreDetail dtl = (from mas in db.ArrearPreDetails where mas.MasterId == iArrearMst_ID select mas).FirstOrDefault();
var OldData1 = new JSonHelper().ConvertObjectToJSon(dtl);
if (dtl != null)
{
db.ArrearPreDetails.RemoveRange(db.ArrearPreDetails.Where(x => x.MasterId == iArrearMst_ID));
db.SaveChanges();
}
DataTable dtTemp = new DataTable();
dtTemp = ((DataView)dgArrearPre.ItemsSource).ToTable();
List<ArrearPreDetail> lstArrearDtl = new List<ArrearPreDetail>();
foreach (DataRow row in dtTemp.Rows)
{
if (Convert.ToDecimal(row["AMOUNT"]) != 0)
{
ArrearPreDetail arrearDtl = new ArrearPreDetail
{
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"]),
AmountSubscription = Convert.ToDecimal(row["SUBSCRIPTION"]),
UpdatedStatus = "Not Updated",
MemberCode = Convert.ToInt32(dMember_Code)
};
lstArrearDtl.Add(arrearDtl);
}
}
if (lstArrearDtl.Count > 0)
{
db.ArrearPreDetails.AddRange(lstArrearDtl);
db.SaveChanges();
var NewData1 = new JSonHelper().ConvertObjectToJSon(lstArrearDtl);
AppLib.EventHistory(this.Tag.ToString(), 1, OldData1, NewData1, "ArrearPreDetail");
}
MessageBox.Show("Details are Updated Sucessfully");
fClear();
}
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
