private void btnPaid_Click(object sender, EventArgs e)
{
MeterBill mb = new MeterBill();
BindMeterBillEntity(mb);
if (meterBillCalculateservices.UpdateMeterBill(mb))
{
if (rdoadvancemoney.Checked)
{
AdvanceMoneyCustomer amc = new AdvanceMoneyCustomer();
BindAdvanceMoneyCustomerEntity(amc);
if (advanceMoneyCustomerServices.SaveAdvanceMoney(amc))
{
}
} //end of Advance Money save
if (Convert.ToDecimal(txtpunishment.Text) > 0)
{
PunishmentCustomer pc = new PunishmentCustomer();
BindPunishmentCustomerEntity(pc);
if (punishmentCutomerServices.Save(pc))
{
} //end of Punishment Customer function save
}
MessageBox.Show("Payment is Complete Successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
} //end of meter bill payment paid
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try {
MeterBill mb = new MeterBill();
mb.MeterBillID = vm.MeterBillID;
mb.MeterBillCode = vm.MeterBillCode;
mb.InvoiceDate = vm.InvoiceDate;
mb.LastBillPaidDate = vm.LastBillPaidDate;
mb.ServicesFees = Convert.ToDecimal(txtServiceFees.Text);
mb.MeterFees = Convert.ToDecimal(txtMeterFees.Text);
mb.StreetLightFees = Convert.ToDecimal(txtStreetLightFees.Text);
mb.TotalFees = Convert.ToDecimal(txtTotalFees.Text);
mb.UsageUnit = vm.UsageUnit;
mb.CurrentMonthUnit = vm.CurrentMonthUnit;
mb.PreviousMonthUnit = vm.PreviousMonthUnit;
mb.isPaid = vm.isPaid;
mb.Remark = vm.Remark;
mb.RecivedAmount = vm.RecivedAmount;
mb.HorsePowerFees = Convert.ToDecimal(txtHorsePowerFees.Text);
mb.AdditionalFees1 = Convert.ToDecimal(txtAdditionalFees1.Text);
mb.AdditionalFees2 = Convert.ToDecimal(txtAdditionalFees2.Text);
mb.AdditionalFees3 = Convert.ToDecimal(txtAdditionalFees3.Text);
mb.MeterUnitCollectID = vm.MeterUnitCollectID;
mb.Active = true;
mb.CreatedDate = vm.CreatedDate;
mb.CreatedUserID = vm.CreatedUserID;
mterBillCalculateServices.UpdateMeterBill(mb);
MessageBox.Show("Meter bill record is updated successfully.", "information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex) {
MessageBox.Show("Error occur" + ex.Message);
}
}
private void BindMeterBillEntity(MeterBill mb)
{
mb.MeterBillID = vm.MeterBillID;
mb.MeterBillCode = vm.MeterBillCode;
mb.InvoiceDate = vm.InvoiceDate;
mb.LastBillPaidDate = vm.LastBillPaidDate;
mb.ServicesFees = vm.ServicesFees;
mb.MeterFees = vm.MeterFees;
mb.TotalFees = Convert.ToDecimal(txtFinalTotalFees.Text); //vm.TotalFees;
mb.StreetLightFees = vm.StreetLightFees;
mb.UsageUnit = vm.UsageUnit;
mb.CurrentMonthUnit = vm.CurrentMonthUnit;
mb.PreviousMonthUnit = vm.PreviousMonthUnit;
mb.AdvanceMoney = Convert.ToDecimal(txtAdvanceMoney.Text);
mb.isPaid = true;
mb.Remark = vm.Remark;
mb.RecivedAmount = Convert.ToDecimal(txtReceivedAmount.Text);
mb.HorsePowerFees = vm.HorsePowerFees;
mb.AdditionalFees1 = vm.AdditionalFees1;
mb.AdditionalFees2 = vm.AdditionalFees2;
mb.AdditionalFees3 = vm.AdditionalFees3;
mb.MeterUnitCollectID = vm.MeterUnitCollectID;
mb.Active = true;
mb.CreatedDate = vm.CreatedDate;
mb.CreatedUserID = vm.CreatedUserID;
}
private bool IsBillCalculateSuccess(List <MBMS.DAL.MeterUnitCollect> dataList, DateTime fromDate, DateTime toDate)
{
List <MeterBill> meterbillList = new List <MeterBill>();
try {
foreach (MBMS.DAL.MeterUnitCollect item in dataList)
{
MeterBill mb = new MeterBill();
mb.MeterBillID = Guid.NewGuid().ToString();
mb.MeterBillCode = item.Customer.Meter.MeterNo;
mb.InvoiceDate = item.FromDate;
mb.LastBillPaidDate = item.ToDate;
mb.ServicesFees = 0;
//getting multiplier value from customer's meter value
meterMultiplier = (int)item.Customer.Meter.Multiplier;
mb.MeterFees = getMeterFeesAmountwith7LayerCode(item);
StreetLightFee streetLightFeeEntity = mbmsEntities.StreetLightFees.Where(x => x.Active == true && x.QuarterID == item.Customer.QuarterID).SingleOrDefault();
if (streetLightFeeEntity == null)
{
mb.StreetLightFees = Utility.SettingController.StreetLightFees;
}
else
{
mb.StreetLightFees = streetLightFeeEntity.Amount;
}
mb.HorsePowerFees = 0;
mb.TotalFees = Convert.ToDecimal((mb.ServicesFees + mb.MeterFees + mb.StreetLightFees + mb.HorsePowerFees));
//multiply totol meter unit with multiplier value
mb.UsageUnit = (item.TotalMeterUnit * meterMultiplier);
mb.PreviousMonthUnit = 0;
mb.CurrentMonthUnit = (item.TotalMeterUnit - mb.PreviousMonthUnit);
//calculate advance money
List <AdvanceMoneyCustomer> advmoneyList = mbmsEntities.AdvanceMoneyCustomers.Where(x => x.Active == true && x.MeterBill.MeterUnitCollect.CustomerID == item.CustomerID && EntityFunctions.TruncateTime(x.ForMonth) != item.FromDate.Date).ToList();
decimal TotalAdvance = 0;
foreach (AdvanceMoneyCustomer i in advmoneyList)
{
TotalAdvance += i.AdvanceMonthAmount;
}
mb.AdvanceMoney = TotalAdvance;
mb.CreditAmount = 0;
mb.isPaid = false;
mb.Remark = "bill data for " + item.FromDate.ToString("MMMM");
mb.MeterUnitCollectID = item.MeterUnitCollectID;
mb.Active = true;
mb.CreatedDate = DateTime.Now;
mb.CreatedUserID = UserID;
meterbillList.Add(mb);
} //end of foreach loop after adding Meter Bill List
meterbillcalculateservice.MeterBillCalculate(meterbillList, fromDate, toDate);
}catch (Exception ex) {
MessageBox.Show("Error occur" + ex.Message, "Information", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
return(true);
}
public bool UpdateMeterBill(MeterBill _meterbill)
{
try {
mBMSEntities.MeterBills.AddOrUpdate(_meterbill);
mBMSEntities.SaveChanges();
}
catch (Exception) {
return(false);
}
return(true);
}
