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