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