private void SubmitCommissionOverrideSummaries(DateTime CheckDate) { Dictionary <string, string> parameters = new Dictionary <string, string>(); string SQLstring = string.Format(@";WITH StartDateTable AS ( SELECT MAX(DATEADD(DAY, 1, [WeekEnding])) [StartDate] FROM [PAYOUTPMCheckDates] WHERE [WeekEnding] < '{0}' ) SELECT CASE WHEN (SELECT [StartDate] FROM StartDateTable) IS NULL THEN DATEADD(DAY, -14, (SELECT MIN([WeekEnding]) FROM [PAYOUTPMCheckDates])) ELSE (SELECT [StartDate] FROM StartDateTable) END", CheckDate.ToString()); string startDate = Common.ApplyDateFormat(Queries.GetResultsFromQueryString(SQLstring).Rows[0][0].ToString()); string endDate = Common.ApplyDateFormat(CheckDate); parameters.Add("@webStartDate", startDate); parameters.Add("@webEndDate", endDate); parameters.Add("@webTrainer", ""); parameters.Add("@Action", "INSERT"); Queries.ExecuteFromStoreProcedure("spx_PAYOUTsummaryOverrides", parameters); Queries.ExecuteFromStoreProcedure("spx_PAYOUTsummaryCommissionDaily", parameters); }
//This method is built in order to clean all duplicates in Audit table which inevitably are being //generated when edit import and exceptions are executed in different browsers private void CleanDuplicates() { Dictionary <string, string> Params = new Dictionary <string, string>(); Params.Add("Action", "CLEANUP"); Queries.ExecuteFromStoreProcedure("spx_PAYOUTAuditSales", Params); }