public List <tblBillHistory> SearchPreviousBillStatements([FromUri] string startDate, [FromUri] string endDate)
{
var sDate = DateTime.ParseExact(startDate, "dd/MM/yyyy", CultureInfo.InvariantCulture);
var eDate = DateTime.ParseExact(endDate, "dd/MM/yyyy", CultureInfo.InvariantCulture);
List <tblBillHistory> list = null;
string keyname = "BillHistory_" + sDate + eDate + Session.Login_ID;
if (RedisCacheHelper.keyExistsInCache(keyname))
{
list = RedisCacheHelper.GetCacheData <tblBillHistory>(keyname);
}
else
{
list = db.tblBillHistories.Where(x => x.BillDate >= sDate && x.BillDate <= eDate).ToList();
RedisCacheHelper.addItemCache <tblBillHistory>(keyname, list);
}
return(list != null && list.Count > 0 ? list : new List <tblBillHistory>());
}
/// <summary>
/// Add Bill for consumers
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool AddBill([FromBody] Bill obj)
{
tblBillHistory billHistoryObj = new tblBillHistory();
if (obj != null)
{
var billDate = DateTime.ParseExact(obj.BillDate, "dd/MM/yyyy", CultureInfo.InvariantCulture);
billHistoryObj.BillDate = billDate;
billHistoryObj.UnitsConsumed = obj.Units;
billHistoryObj.BillAmount = obj.Amount;
billHistoryObj.Consumer_ID = obj.ConsumerID;
billHistoryObj.BillPaidDate = Convert.ToDateTime("1900/01/01");
billHistoryObj.Paid = false;
db.tblBillHistories.Add(billHistoryObj);
db.SaveChanges();
RedisCacheHelper.ClearAllCacheData("BillHistory_");
}
return(billHistoryObj.ID > 0);
}
