private bool DeActivateBill(int BillID, String FlatNumber, DateTime DeactivationDate)
{
try
{
//Added by Aarshi on 16 Aug 2017 for Placing Sql Code in Bill Cycle Class
//DataAccess dacess = new DataAccess();
//String deactivatePlan = "update dbo.aBillCycle set CycleEnd = '" + DeactivationDate + "' where BillID = '" + billid + "' and FlatID = '" + FlatNumber + "'";
//bool result = dacess.Update(deactivatePlan);
//Added by Aarshi on 16 Aug 2017 for Placing Sql Code in Bill Cycle Class
BillCycle billCycle = new BillCycle();
bool result = billCycle.UpdateDeactiveBill(DeactivationDate, BillID, FlatNumber);
if (result == true)
{
lblbilltypeexist.Text = "plan deactivated Sucessfully";
}
else
{
lblbilltypeexist.Text = "plan deactivated failed";
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public void ExecuteBillCycleRun(BillCycle billCycle)
{
var noOfCustomersInvoiced = 0;
decimal totalInvoiced = 0.0m;
OnBillCycleRunChanged(true, 0);
var customers = GetCustomersToInvoice();
foreach (var customer in customers)
{
var invoice = CreateInvoice(billCycle, customer);
AddCustomerActiveContractsToInvoiceAndUpdateAccounts(invoice, customer);
var prevBal = _transactionsService.GetBalanceForCustomer(invoice.CustomerId);
if (invoice.InvoiceItems.Count > 0 || prevBal != 0)
{
invoice.PreviousBalance = prevBal;
_invoiceRepository.Add(invoice);
totalInvoiced += invoice.InvoicedTotal;
noOfCustomersInvoiced++;
OnBillCycleRunChanged(true, noOfCustomersInvoiced);
}
}
AddBillCycleRun(billCycle, noOfCustomersInvoiced, totalInvoiced);
UpdateLastBillCycle(billCycle);
OnBillCycleRunChanged(false, noOfCustomersInvoiced);
}
public static List <string> GetFlatNumber(string FlatNumber)
{
//Added by Aarshi on 17 Aug 2017 for code restructuring
List <string> Flat = new List <string>();
BillCycle billCycle = new BillCycle();
Flat = billCycle.GetFlatNumber(FlatNumber);
return(Flat);
}
private static Invoice CreateInvoice(BillCycle billCycle, Customer customer)
{
return(new Invoice
{
CustomerId = customer.CustomerId,
BillCycle = billCycle,
InvoiceItems = new List <InvoiceItem>(),
PostedItems = new List <InvoicePosted>(),
InvoiceDate = DateTime.Today
});
}
private void AddBillCycleRun(BillCycle billCycle, int noOfCustomersInvoiced, decimal totalInvoiced)
{
var bcr = new BillCycleRun
{
BillCycle = billCycle,
AmountInvoiced = totalInvoiced,
NoOfCustomersInvoiced = noOfCustomersInvoiced,
DateOfRun = DateTime.Today
};
_billCycleRunRepository.Add(bcr);
}
protected void SocietyBillPlan_ItemDataBound(object sender, DataListItemEventArgs e)
{
try
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
DataRowView drv = e.Item.DataItem as DataRowView;
if (drv != null)
{
string ID = drv.Row[0].ToString();
}
Label lbl = (Label)e.Item.FindControl("lblBillEntity");
String lablstatus = lbl.Text;
if (lablstatus == "1")
{
lbl.Text = "All";
}
if (lablstatus == "0")
{
lbl.Text = "Selected";
}
Label lblID = (Label)e.Item.FindControl("lblID");
String lablID = lblID.Text;
//Added by Aarshi on 17 Aug 2017 for code restructuring
BillCycle billCycle = new BillCycle();
int Count = billCycle.GetFlatIDCount(lablID);
Label lblcounttext = (Label)e.Item.FindControl("lblcount");
lblcounttext.Text = Count.ToString();
}
}
catch (Exception ex)
{
Utility.log("Bill Plan Data Bound Error :" + ex.Message);
}
}
private void UpdateLastBillCycle(BillCycle billCycle)
{
_miscService.UpdateValue(MiscIdentifier.LastBillCycle, billCycle.ToString());
}
public override bool IsBillableThisCycle(BillCycle billCycle)
{
return(base.IsBillableThisCycle(billCycle) && !ContractType.HideFromInvoice);
}
public virtual IEnumerable <Contract> GetListOfContractsToBill(BillCycle billCycle)
{
return(AttachedContracts.Where(attachedContract => attachedContract.IsBillableThisCycle(billCycle)));
}
public Contract()
{
LastBilled = new BillCycle();
}
public virtual bool IsBillableThisCycle(BillCycle billCycle)
{
return((LastBilled.Date == ConstantValues.MinDate && !IsContractScheduledBeyondDate(billCycle.Date)) || ((billCycle.BillCycleNo - LastBilled.BillCycleNo) == PaymentPeriod.PeriodInMonths && IsContractActiveOnDate(billCycle.Date)));
}
protected void btnBillcycleSubmit_Click(object sender, EventArgs e)//Activated Bill
{
DataAccess dacess = new DataAccess();
Double Amount = 0;
String Description = "";
Double PrevBalance = 0;
String billType = HiddenField2.Value;
//Added by Aarshi on 17 Aug 2017 for code restructuring
BillPlan billPlan = new BillPlan();
int billid = billPlan.GetBillID(billType);
String CycleStart = txtCyclestart.Text;
String CycleEnD = txtCycleend.Text;
String ChargeType = HiddenFieldChargeType.Value;
DateTime Date = Utility.GetCurrentDateTimeinUTC();
String CycleType = labelcycletype.Text;
String Rate = labelRate.Text;
String FlatNumber = lblFlatNumber.Text;
//Added by Aarshi on 17 Aug 2017 for code restructuring
BillCycle billCycle = new BillCycle();
// int ID = billCycle.GetFlatID(FlatNumber);
int ID = Convert.ToInt32(FlatNumber);
int count = 0;
if (ID != 0)
{
DateTime startdate = DateTime.ParseExact(CycleStart, "dd-MM-yyyy", null);
DateTime enddate = DateTime.ParseExact(CycleEnD, "dd-MM-yyyy", null);
//BillCycle billCycle = new BillCycle();
// Bill.ActivateBillForFlat(Convert.ToInt32(billid), FlatNumber, Convert.ToDateTime(CycleStart), Convert.ToDateTime(CycleEnD));
// bool result = true; // = billCycle.AddSingleFlatBillCycle(Convert.ToInt32(billid), FlatNumber, Convert.ToDateTime(startdate), Convert.ToDateTime(enddate), "Activate Bill");
GenerateBill genBill = new GenerateBill();
genBill.AmountTobePaid = Convert.ToInt32(Rate);
genBill.AmountPaid = 0;
genBill.AmountPaidDate = DateTime.Now;
genBill.BillDescription = Description;
genBill.BillEndDate = enddate;
genBill.BillMonth = enddate;
genBill.BillTypeID = 5;
genBill.BillStartDate = DateTime.UtcNow;
genBill.CurrentBillAmount = 500;
genBill.ActionType = "Activate";
genBill.Activated = 1;
genBill.CycleType = "Quaterly";
genBill.FlatID = ID;
genBill.InvoiceID = "";
genBill.ModifiedAt = DateTime.UtcNow;
genBill.PaymentDueDate = DateTime.UtcNow.AddDays(7);
genBill.PaymentMode = "";
genBill.PreviousMonthBalance = 0;
genBill.SocietyBillID = 2;
genBill.SocietyID = 1;
genBill.TransactionID = "";
genBill.op_BillType = "";
Bill bill = new Bill();
//bool isInserted = bill.InsertNewBillPay(genBill);
/* if (result)
* {
* // count = Bill.InsertFirstZeroBill(FlatNumber, billid, CycleType, CycleStart);
* }*/
}
else
{
lblbilltypeexist.Text = FlatNumber + " is Not Exist with this Society";
}
if (count == 1)
{
lblbilltypeexist.Text = "Bill Generated Sucessfully";
}
else
{
lblbilltypeexist.Text = "Bill Generated Failed";
}
LoadActivatedBill();
}