/**
**@ brief: this method removes the data from bookibg table which becomes useless when the date passes
**@ Params: IJobExecutionContext context
**/
public void Execute(IJobExecutionContext context)
{
try
{
DAO dao = new DAO();
DateTime currentDate = DateTime.Now;
currentDate = currentDate.AddDays(-3);
string dateStr = currentDate.ToString("yyyy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture);
dateStr = DateFormatter.removeTime(dateStr);
dateStr = DateFormatter.setDateFormat(dateStr);
DateTime dateValue = DateTime.ParseExact(dateStr, "yyyy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture);
List <BookingTable> listData = (from obj in dao.BookingTable_DBset
where obj.bookingDate <= dateValue
select obj).ToList();
if (listData.Count >= 1)
{
foreach (BookingTable item in listData)
{
dao.BookingTable_DBset.Remove(item);
dao.SaveChanges();
}
}
}
catch (Exception ex)
{
}
}
