public bool Add_EODDeployed(int EODDepositID, string workplaceId, string Report_Date) { try { StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO dbo.tbl_DCS_EODDeployed (EODDepositID, DaysGracePeriod, Posted_Date, LastUpdated_Date) "); sb.Append(" VALUES "); sb.Append("(@EODDepositID, @DaysGracePeriod, GETDATE(), GETDATE()) "); OpenConnection(); cmd = new SqlCommand(sb.ToString(), con); cmd.Parameters.AddWithValue("EODDepositID", EODDepositID); //if(workplaceId=="1") // cmd.Parameters.AddWithValue("DaysGracePeriod", 1); //else // cmd.Parameters.AddWithValue("DaysGracePeriod", 2); cmd.Parameters.AddWithValue("DaysGracePeriod", EOD.GetGracePeriod((Program.workplaceId)Convert.ToInt32(workplaceId), Convert.ToDateTime(Report_Date))); ExecuteNonQuery(CommandType.Text); return(true); } catch (Exception ex) { strErrorMessage = ex.Message; return(false); } }
private static bool ProcessEODData() { EOD eod = null; //string reportDate = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd"); //string reportDate = ""; //string dateToday = DateTime.Now.ToString("yyyy-MM-dd"); ////tempo //reportDate = "2020-09-0"; //dateToday = Convert.ToDateTime(reportDate).AddDays(1).ToString("yyyy-MM-dd"); //eod = new EOD(reportDate, dateToday); //if (!eod.GenerateEndOfDay()) logger.Error("Failed to generate end of day report for " + reportDate); //return false; ////tempo if (File.Exists(reportDateFile)) { reportDate = System.IO.File.ReadAllText(reportDateFile); dateToday = Convert.ToDateTime(reportDate).Date.AddDays(1).ToString("yyyy-MM-dd"); eod = new EOD(reportDate, dateToday); if (!eod.GenerateEndOfDay()) { logger.Error("Failed to generated end of day report for " + reportDate); } else { eod = null; eod = new EOD(dateToday, dateToday); if (!eod.GenerateEndOfDay()) { logger.Error("Failed to generated end of day report for " + dateToday); } } } else { DataTable dtLastTwoEntryDates = null; if (!dalLocal.SelectLastTwoEntryDates()) { logger.Error("Failed to get last 2 dates of member table"); return(false); } else { dtLastTwoEntryDates = dalLocal.TableResult; } if (Convert.ToDateTime(dtLastTwoEntryDates.Rows[0][0].ToString()).Date != DateTime.Now.Date) { reportDate = Convert.ToDateTime(dtLastTwoEntryDates.Rows[0][0]).ToString("yyyy-MM-dd"); eod = new EOD(reportDate, dateToday); if (!eod.GenerateEndOfDay()) { logger.Error("Failed to generate end of day report for " + reportDate); } } else { reportDate = Convert.ToDateTime(dtLastTwoEntryDates.Rows[1][0]).ToString("yyyy-MM-dd"); eod = new EOD(reportDate, dateToday); if (!eod.GenerateEndOfDay()) { logger.Error("Failed to generated end of day report for " + reportDate); } else { eod = null; eod = new EOD(dateToday, dateToday); if (!eod.GenerateEndOfDay()) { logger.Error("Failed to generated end of day report for " + dateToday); } } } } if (!dalSys.GenerateConsumbalesDailyEnv(config.BankID.ToString(), dateToday)) { logger.Error("GenerateConsumbalesDailyEnv() failed. Error " + dalSys.ErrorMessage); return(false); } return(true); }