public static bool GenerateUngeneratedReport() { try { DateTime minsalesdate = DataHandler.GetMinimumSaleDate(); DateTime lastZread = DataHandler.GetLastZReadDate(); if (lastZread.Date == DateTime.Now.Date) { return(true); } if (lastZread.Date == DateTime.Now.AddDays(-1).Date) { return(true); } else { DataBaseHelper.SetDB(@"DELETE FROM Reports WHERE transdate >= '" + lastZread.Date.ToString("yyyy-MM-dd") + "'"); foreach (DateTime day in EachDay(lastZread, DateTime.Now.AddDays(-1))) { GenerateReport.XRead(day); GenerateReport.ZRead(day); } } return(true); } catch { return(false); } }
public static DateTime GetLastZReadDate() { DataTable dt = DataBaseHelper.GetDB(string.Format(@"SELECT MIN(date) as date FROM Reports WHERE readtype = 3")); if (dt.Rows.Count == 0 || dt == null) { return(DataHandler.GetMinimumSaleDate()); } else { try { return(Convert.ToDateTime(dt.Rows[0]["date"])); } catch { return(DataHandler.GetMinimumSaleDate()); } } }