//public DataTable RateDataTable
//{
// get
// {
// if (HttpRuntime.Cache[this.Name] != null)
// {
// return (DataTable)HttpRuntime.Cache[this.Name];
// }
// else
// {
// return null;
// }
// }
//}
// QSO rate constructor
public SeriesObj(ContestInfoDTO ContestInfoDTO, Color ptColor, LoadOLEDataTabledelegate DTFunc)
{
this.ContestInfoDTO = ContestInfoDTO;
Call = ContestInfoDTO.Call;
this.LegendText = ContestInfoDTO.Call;
this.Name = Enum.GetName(typeof(common.Enum.CallGroupEnum), ContestInfoDTO.CallGroup) + Call + "_" + ContestInfoDTO.ContestID;
this.Color = ptColor;
this.DTFunc = DTFunc;
}
public string GenerateQuery(ContestInfoDTO ContestInfoDTO, ChartAreaDto ChartAreaDto, string sIntvTime,
string sQCnt, string colTime, string whereClause, string sumField)
{
//sumfield is biy field
string QSOQuery = string.Empty;
if (sumField == "QPoints")
{//sum 4 fields
QSOQuery = @"SELECT [Time1] AS " + sIntvTime + ", Sum(Qry5minintervals.N) AS " + sQCnt +
" FROM (SELECT convert(datetime, Format(" + colTime + ",'d') + ' ' " +
"+ Format(DatePart(hh," + colTime + "),'00') + ':' " +
"+ Format((DatePart(n," + colTime + ")/" + ChartAreaDto.ChartPointtInterval + ")*" +
ChartAreaDto.ChartPointtInterval + ",'00') )AS [Time1] , " +
"Sum( " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts1]) + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts2])*2 + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts4])*4 + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts8])*8 ) " +
"AS N" +
" FROM " + ContestInfoDTO.QsoDatabaseTableName +
" INNER JOIN Log ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[LogId] = [Log].[LogId] " +
"INNER JOIN CallSign ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[CallsignId] = [CallSign].[CallSignId]" +
" AND [Log].[LogId] = " + ContestInfoDTO.LogId +
whereClause +
" GROUP BY " + colTime + " ) AS Qry5minintervals" +
" GROUP BY [Time1] " +
"ORDER By 1 asc";
}
else
{
QSOQuery = @"SELECT [Time1] AS " + sIntvTime + ", Sum(Qry5minintervals.N) AS " + sQCnt +
" FROM (SELECT convert(datetime, Format(" + colTime + ",'d') + ' ' " +
"+ Format(DatePart(hh," + colTime + "),'00') + ':' " +
"+ Format((DatePart(n," + colTime + ")/" + ChartAreaDto.ChartPointtInterval + ")*" +
ChartAreaDto.ChartPointtInterval + ",'00') )AS [Time1] , " +
"Sum(convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[" + sumField + "]) ) AS N" +
" FROM " + ContestInfoDTO.QsoDatabaseTableName +
" INNER JOIN Log ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[LogId] = [Log].[LogId] " +
"INNER JOIN CallSign ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[CallsignId] = [CallSign].[CallSignId]" +
" AND [Log].[LogId] = " + ContestInfoDTO.LogId +
whereClause +
" GROUP BY " + colTime + " ) AS Qry5minintervals" +
" GROUP BY [Time1] " +
"ORDER By 1 asc";
}
return QSOQuery;
}
protected bool SetMixedYears(DataCallInfoDto[] DataCallInfoDto, ContestInfoDTO ContestInfoDTO1, ContestInfoDTO ContestInfoDTO2, ContestInfoDTO ContestInfoDTO3)
{
bool MixedYears = true;
if ((ContestInfoDTO1 != null && DataCallInfoDto[0].Disabled) && (ContestInfoDTO2 != null && DataCallInfoDto[1].Disabled) ||
(ContestInfoDTO1 != null && DataCallInfoDto[0].Disabled) && (ContestInfoDTO3 != null && DataCallInfoDto[2].Disabled) ||
(ContestInfoDTO2 != null && DataCallInfoDto[1].Disabled) && (ContestInfoDTO3 != null && DataCallInfoDto[2].Disabled))
{
MixedYears = false;
}
else if (ContestInfoDTO1 != null && DataCallInfoDto[0].Disabled)
{
if ( (ContestInfoDTO2 != null && ContestInfoDTO3 != null) && DataCallInfoDto[1].SelectedContestName == DataCallInfoDto[2].SelectedContestName)
{
MixedYears = false;
}
}
else if (ContestInfoDTO2 != null && DataCallInfoDto[1].Disabled)
{
if ((ContestInfoDTO1 != null && ContestInfoDTO3 != null) && DataCallInfoDto[0].SelectedContestName == DataCallInfoDto[2].SelectedContestName)
{
MixedYears = false;
}
}
else if (ContestInfoDTO3 != null && DataCallInfoDto[2].Disabled)
{
if ((ContestInfoDTO1 != null && ContestInfoDTO2 != null) && DataCallInfoDto[0].SelectedContestName == DataCallInfoDto[1].SelectedContestName)
{
MixedYears = false;
}
}
else if (ContestInfoDTO1 != null && ContestInfoDTO2 != null && ContestInfoDTO3 != null)
if (DataCallInfoDto[0].SelectedContestName == DataCallInfoDto[1].SelectedContestName && DataCallInfoDto[0].SelectedContestName == DataCallInfoDto[2].SelectedContestName)
{
MixedYears = false;
}
return MixedYears;
}
public void GetQuery(IRepositoryAsync<Log> LogRepository, string ChartID, QSOLogFilter QSOFilter,QsoRadioStationFilter QsoRadioStationFilter,
DataCallInfoDto DataCallInfoDto, ControlSettingsDto ControlSettingsDto, ContestInfoDTO ContestInfoDTO,
ChartAreaDto ChartAreaDto, string sChartFunction, out ContestViewParmsDTO ContestViewParmsDTO, string Username)
{
string sIntvTime = "IntvTime";
string sQCnt = "N";
//string sQCnt2;
//string sQCnt3;
string SerTablename = string.Empty;
ContestViewParmsDTO = null;
ContestTypeEnum ContestTypeEnum = (ContestTypeEnum)Enum.Parse(typeof(ContestTypeEnum), ContestInfoDTO.ContestType);
string whereClause = string.Empty;
SerTablename = ContestInfoDTO.Call + ChartID + ContestInfoDTO.ContestID + "_S" + ContestInfoDTO.basedstartTime.ToOADate() + "_E" +
ContestInfoDTO.basedendTime.ToOADate() + "_" + sIntvTime + string.Format("_I{0}", ChartAreaDto.ChartPointtInterval) +
string.Format("_M{0}", ChartAreaDto.MixedYears + "_T" + ChartAreaDto.charttype + "_T" + sChartFunction);
if (QSOFilter.QsoCB != true && QSOFilter.Filter != string.Empty)
{
SerTablename += string.Format("_Qb{0}_QC{1}_Qc{2}_QZ{3}_QE{4}",
ControlSettingsDto.ControlFiltersSettingsDto.FiltBand,
ControlSettingsDto.ControlFiltersSettingsDto.FiltContinent,
ControlSettingsDto.ControlFiltersSettingsDto.FiltCountryInnerHTML,
ControlSettingsDto.ControlFiltersSettingsDto.FiltCQZone,
QSOFilter.QsoCB);
whereClause = " WHERE " + QSOFilter.Filter;
}
if (QsoRadioStationFilter.QsoRadioTypeEnum != QsoRadioTypeEnum.ALL)
{
if (whereClause != string.Empty)
{
whereClause += " AND [Qso].[QsoRadioTypeEnum] = " + (int)QsoRadioStationFilter.QsoRadioTypeEnum;
}
else
{
whereClause += " WHERE [Qso].[QsoRadioTypeEnum] = " + (int)QsoRadioStationFilter.QsoRadioTypeEnum;
}
}
if (QsoRadioStationFilter.StationFilter != null && QsoRadioStationFilter.StationFilter != "ALL")
{
if (whereClause != string.Empty)
{
whereClause += " AND [Qso].[StationName] = '" + QsoRadioStationFilter.StationFilter + "' ";
}
else
{
whereClause += " WHERE [Qso].[StationName] = '" + QsoRadioStationFilter.StationFilter + "' ";
}
}
string colTime = string.Format("[{0}].[QsoDateTime]", ContestInfoDTO.QsoDatabaseTableName);
string QSOQuery = string.Empty;
switch (sChartFunction)
{
case "QSO Rate":
//string colTime = string.Format("{0}.Time", CtestLogInfo.ContestInfo.ContestTblName);
//string colContestID = string.Format("{0}.ContestID", CtestLogInfo.ContestInfo.ContestTblName);
//string QSOQuery = @"SELECT [Time1] AS " + IntvTime + ", Sum(Qry5minintervals.N) AS " + sQCnt +
// " FROM (SELECT Format([" + colTime + "],'Short Date') & ' ' " +
// "& Format(DatePart('h',[" + colTime + "]),'00') & ':' " +
// "& Format(Int(DatePart('n',[" + colTime + "])/" + Interval + ")*" + Interval + ",'00')AS [Time1] , Count(*) AS N" +
// " FROM QSOs" +
// " WHERE (((" + colContestID + ")='" + CtestLogInfo.ContestInfo.ContestID + "'))" +
// " GROUP BY [" + colTime + "] ) AS Qry5minintervals" +
// " GROUP BY [Time1] ";
//SELECT [Time1] AS IntvTime, Sum(Qry5minintervals.N) AS N
//FROM (SELECT Format([CqwwQsos.QDateTime],'Short Date')
// & ' ' & Format(DatePart('h',[CqwwQsos.QDateTime]),'00')
// & ':' & Format(Int(DatePart('n',[CqwwQsos.QDateTime])/60)*60,'00')AS [Time1] ,
//Count(*) AS N
// FROM CqwwQsos INNER JOIN QCountries ON CqwwQsos.ID = QCountries.ID
// GROUP BY [CqwwQsos.QDateTime] ) AS Qry5minintervals
// GROUP BY [Time1]
//=============================================================
//SQL
//=========================================================
//SELECT [Time1] AS IntvTime, Sum(Qry5minintervals.N) AS N
//FROM (SELECT Format([Qso].[QsoDateTime],'d')
// + ' ' + Format(DatePart(hh,[Qso].[QsoDateTime]),'00')
// + ':' + Format((DatePart(n,[Qso].[QsoDateTime])/60)*60,'00')AS [Time1] ,
//Count(*) AS N
// FROM Qso INNER JOIN Log ON Qso.LogId = log.LogId
// INNER JOIN CallSign ON [Qso].[CallsignId] = [CallSign].[CallSignId]
// AND Log.LogId = 1
// GROUP BY [Qso].[QsoDateTime] ) AS Qry5minintervals
// GROUP BY [Time1]
//Convert 120 is Zulu time
QSOQuery = @"SELECT [Time1] AS " + sIntvTime + ", Sum(Qry5minintervals.N) AS " + sQCnt +
" FROM (SELECT convert(datetime, Format(" + colTime + ",'d') + ' ' " +
"+ Format(DatePart(hh," + colTime + "),'00') + ':' " +
"+ Format((DatePart(n," + colTime + ")/" + ChartAreaDto.ChartPointtInterval + ")*" +
ChartAreaDto.ChartPointtInterval + ",'00') )AS [Time1] , Count(*) AS N" +
" FROM " + ContestInfoDTO.QsoDatabaseTableName +
" INNER JOIN Log ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[LogId] = [Log].[LogId] " +
"INNER JOIN CallSign ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[CallsignId] = [CallSign].[CallSignId]" +
" AND [Log].[LogId] = " + ContestInfoDTO.LogId +
whereClause +
//" WHERE (((" + colContestID + ")='" + CtestLogInfo.ContestInfo.ContestID + "'))" +
" GROUP BY " + colTime + " ) AS Qry5minintervals" +
" GROUP BY [Time1] " +
"ORDER By 1 asc";
ContestViewParmsDTO = new ContestViewParmsDTO(sChartFunction, SerTablename, sIntvTime, sQCnt, "QSO Rate",
"QSOs Per " + ChartAreaDto.ChartPointtInterval.ToString() + " Minutes", QSOQuery, false);
break;
case "QSO Sum":
QSOQuery = @"SELECT [Time1] AS " + sIntvTime + ", Sum(Qry5minintervals.N) AS " + sQCnt +
" FROM (SELECT convert(datetime, Format(" + colTime + ",'d') + ' ' " +
"+ Format(DatePart(hh," + colTime + "),'00') + ':' " +
"+ Format((DatePart(n," + colTime + ")/" + ChartAreaDto.ChartPointtInterval + ")*" +
ChartAreaDto.ChartPointtInterval + ",'00') )AS [Time1] , Count(*) AS N" +
" FROM " + ContestInfoDTO.QsoDatabaseTableName +
" INNER JOIN Log ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[LogId] = [Log].[LogId] " +
"INNER JOIN CallSign ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[CallsignId] = [CallSign].[CallSignId]" +
" AND [Log].[LogId] = " + ContestInfoDTO.LogId +
whereClause +
" GROUP BY " + colTime + " ) AS Qry5minintervals" +
" GROUP BY [Time1] " +
"ORDER By 1 asc";
ContestViewParmsDTO = new ContestViewParmsDTO(sChartFunction, SerTablename, sIntvTime, sQCnt, "QSO Sum",
"QSOs Per " + ChartAreaDto.ChartPointtInterval.ToString() + " Minutes", QSOQuery, true);
break;
case "Zone Rate":
//if (whereClause == string.Empty)
//{
// whereClause = " WHERE " + CtestLogInfo.ContestInfo.ContestTblName + ".QZoneMult= 1";
//}else
//{
// whereClause += " AND " + CtestLogInfo.ContestInfo.ContestTblName + ".QZoneMult= 1";
//}
QSOQuery = GenerateQuery(ContestInfoDTO, ChartAreaDto, sIntvTime, sQCnt, colTime, whereClause, "QZoneMult");
// SELECT [Time1], Sum(Qryminintervals.N) AS Zones
//FROM (SELECT Format([QSOs.Time],"Short Date") & " " & Format(DatePart("h",[QSOs.Time]),"00") & ":" & Format(Int(DatePart("n",[QSOs.Time])/15)*15,"00") AS Time1, Count(*) AS N
//FROM QSOs
//WHERE (((QSOs.ContestID)="CQWWSSB2009") And ((QSOs.Mlt1)<>""))
//GROUP BY [QSOs.Time], [QSOs.Mlt2] ) AS Qryminintervals
//GROUP BY [Time1];
ContestViewParmsDTO = new ContestViewParmsDTO(sChartFunction, SerTablename, sIntvTime, sQCnt, "Zone Rate",
"Zones Per " + ChartAreaDto.ChartPointtInterval.ToString() + " Minutes", QSOQuery, false);
break;
case "Zone Sum":
QSOQuery = GenerateQuery(ContestInfoDTO, ChartAreaDto, sIntvTime, sQCnt, colTime, whereClause, "QZoneMult");
ContestViewParmsDTO = new ContestViewParmsDTO(sChartFunction, SerTablename, sIntvTime, sQCnt, "Zone Sum",
"Zones Per " + ChartAreaDto.ChartPointtInterval.ToString() + " Minutes", QSOQuery, true);
break;
case "Country Rate":
QSOQuery = GenerateQuery(ContestInfoDTO, ChartAreaDto, sIntvTime, sQCnt, colTime, whereClause, "QCtyMult");
ContestViewParmsDTO = new ContestViewParmsDTO(sChartFunction, SerTablename, sIntvTime, sQCnt, "Country Rate",
"Countries Per " + ChartAreaDto.ChartPointtInterval.ToString() + " Mins", QSOQuery, false);
break;
case "Country Sum":
QSOQuery = GenerateQuery(ContestInfoDTO, ChartAreaDto, sIntvTime, sQCnt, colTime, whereClause, "QCtyMult");
ContestViewParmsDTO = new ContestViewParmsDTO(sChartFunction, SerTablename, sIntvTime, sQCnt, "Country Sum",
"Countries Per " + ChartAreaDto.ChartPointtInterval.ToString() + " Mins", QSOQuery, true);
break;
case "Point Rate":
QSOQuery = GenerateQuery(ContestInfoDTO, ChartAreaDto, sIntvTime, sQCnt, colTime, whereClause, "QPoints");
ContestViewParmsDTO = new ContestViewParmsDTO(sChartFunction, SerTablename, sIntvTime, sQCnt, "Point Rate",
"Points Per " + ChartAreaDto.ChartPointtInterval.ToString() + " Minutes", QSOQuery, false);
break;
case "Point Sum":
QSOQuery = GenerateQuery(ContestInfoDTO, ChartAreaDto, sIntvTime, sQCnt, colTime, whereClause, "QPoints");
ContestViewParmsDTO = new ContestViewParmsDTO(sChartFunction, SerTablename, sIntvTime, sQCnt, "Point Sum",
"Points Per " + ChartAreaDto.ChartPointtInterval.ToString() + " Minutes", QSOQuery, true);
break;
case "Prefix Rate":
QSOQuery = GenerateQuery(ContestInfoDTO, ChartAreaDto, sIntvTime, sQCnt, colTime, whereClause, "QPrefixMult");
ContestViewParmsDTO = new ContestViewParmsDTO(sChartFunction, SerTablename, sIntvTime, sQCnt, "Prefix Rate",
"Prefixess Per " + ChartAreaDto.ChartPointtInterval.ToString() + " Minutes", QSOQuery, false);
break;
case "Prefix Sum":
QSOQuery = GenerateQuery(ContestInfoDTO, ChartAreaDto, sIntvTime, sQCnt, colTime, whereClause, "QPrefixMult");
ContestViewParmsDTO = new ContestViewParmsDTO(sChartFunction, SerTablename, sIntvTime, sQCnt, "Prefix Sum",
"Prefixes Per " + ChartAreaDto.ChartPointtInterval.ToString() + " Minutes", QSOQuery, true);
break;
case "Mult Rate":
switch (ContestTypeEnum)
{
case ContestTypeEnum.CQWW:
//Zones + Countries
QSOQuery = @"SELECT [Time1] AS " + sIntvTime + ", Sum(Qry5minintervals.N) AS " + sQCnt +
" FROM (SELECT convert(datetime, Format(" + colTime + ",'d') + ' ' " +
"+ Format(DatePart(hh," + colTime + "),'00') + ':' " +
"+ Format((DatePart(n," + colTime + ")/" + ChartAreaDto.ChartPointtInterval + ")*" +
ChartAreaDto.ChartPointtInterval + ",'00') )AS [Time1] , " +
"Sum(convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QZoneMult]) + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QCtyMult]) " +
") AS N" +
" FROM " + ContestInfoDTO.QsoDatabaseTableName +
" INNER JOIN Log ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[LogId] = [Log].[LogId] " +
"INNER JOIN CallSign ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[CallsignId] = [CallSign].[CallSignId] " +
" AND [Log].[LogId] = " + ContestInfoDTO.LogId +
whereClause +
" GROUP BY " + colTime + " ) AS Qry5minintervals" +
" GROUP BY [Time1] " +
"ORDER By 1 asc";
break;
case ContestTypeEnum.CQWPX:
QSOQuery = GenerateQuery(ContestInfoDTO, ChartAreaDto, sIntvTime, sQCnt, colTime, whereClause, "QPrefixMult");
//prefixes
break;
case ContestTypeEnum.CQ160:
break;
case ContestTypeEnum.RUSDXC:
//oblasts plus countries
break;
default:
break;
}
ContestViewParmsDTO = new ContestViewParmsDTO(sChartFunction, SerTablename, sIntvTime, sQCnt, "Mult Rate",
"Mults Per " + ChartAreaDto.ChartPointtInterval.ToString() + " Minutes", QSOQuery, false);
break;
case "Mult Sum":
switch (ContestTypeEnum)
{
case ContestTypeEnum.CQWW:
//Zones + Countries
QSOQuery = @"SELECT [Time1] AS " + sIntvTime + ", Sum(Qry5minintervals.N) AS " + sQCnt +
" FROM (SELECT convert(datetime, Format(" + colTime + ",'d') + ' ' " +
"+ Format(DatePart(hh," + colTime + "),'00') + ':' " +
"+ Format((DatePart(n," + colTime + ")/" + ChartAreaDto.ChartPointtInterval + ")*" +
ChartAreaDto.ChartPointtInterval + ",'00') )AS [Time1] , " +
"Sum(convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QZoneMult]) + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QCtyMult]) " +
") AS N" +
" FROM " + ContestInfoDTO.QsoDatabaseTableName +
" INNER JOIN Log ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[LogId] = [Log].[LogId] " +
"INNER JOIN CallSign ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[CallsignId] = [CallSign].[CallSignId] " +
" AND [Log].[LogId] = " + ContestInfoDTO.LogId +
whereClause +
" GROUP BY " + colTime + " ) AS Qry5minintervals" +
" GROUP BY [Time1] " +
"ORDER By 1 asc";
break;
case ContestTypeEnum.CQWPX:
QSOQuery = GenerateQuery(ContestInfoDTO, ChartAreaDto, sIntvTime, sQCnt, colTime, whereClause, "QPrefixMult");
//prefixes
break;
case ContestTypeEnum.CQ160:
break;
case ContestTypeEnum.RUSDXC:
//oblasts plus countries
break;
default:
break;
}
ContestViewParmsDTO = new ContestViewParmsDTO(sChartFunction, SerTablename, sIntvTime, sQCnt, "Mult Sum",
"Mults Per " + ChartAreaDto.ChartPointtInterval.ToString() + " Minutes", QSOQuery, true);
break;
case "Score Rate":
switch (ContestTypeEnum)
{
case ContestTypeEnum.CQWW:
//(Zones + Countries) * pts
QSOQuery = @"SELECT [Time1] AS " + sIntvTime + ", Sum(Qry5minintervals.N) * Sum(Qry5minintervals.Mults) AS " + sQCnt +
" FROM (SELECT convert(datetime, Format(" + colTime + ",'d') + ' ' " +
"+ Format(DatePart(hh," + colTime + "),'00') + ':' " +
"+ Format((DatePart(n," + colTime + ")/" + ChartAreaDto.ChartPointtInterval + ")*" +
ChartAreaDto.ChartPointtInterval + ",'00') )AS [Time1] , " +
"Sum( " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts1]) + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts2])*2 + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts4])*4 + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts8])*8 ) AS N," +
"Sum( " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QZoneMult]) + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QCtyMult]) )" +
"AS Mults" +
" FROM " + ContestInfoDTO.QsoDatabaseTableName +
" INNER JOIN Log ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[LogId] = [Log].[LogId] " +
"INNER JOIN CallSign ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[CallsignId] = [CallSign].[CallSignId]" +
" AND [Log].[LogId] = " + ContestInfoDTO.LogId +
whereClause +
" GROUP BY " + colTime + " ) AS Qry5minintervals" +
" GROUP BY [Time1] " +
"ORDER By 1 asc";
break;
case ContestTypeEnum.CQWPX:
//prefix * pts
QSOQuery = @"SELECT [Time1] AS " + sIntvTime + ", Sum(Qry5minintervals.N) * Sum(Qry5minintervals.Mults) AS AS " + sQCnt +
" FROM (SELECT convert(datetime, Format(" + colTime + ",'d') + ' ' " +
"+ Format(DatePart(hh," + colTime + "),'00') + ':' " +
"+ Format((DatePart(n," + colTime + ")/" + ChartAreaDto.ChartPointtInterval + ")*" +
ChartAreaDto.ChartPointtInterval + ",'00') )AS [Time1] , " +
"Sum( " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts1]) + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts2])*2 + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts4])*4 + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts8])*8 ) AS N," +
"Sum( " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPrefixMult]) )" +
"AS Mults" +
" FROM " + ContestInfoDTO.QsoDatabaseTableName +
" INNER JOIN Log ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[LogId] = [Log].[LogId] " +
"INNER JOIN CallSign ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[CallsignId] = [CallSign].[CallSignId]" +
" AND [Log].[LogId] = " + ContestInfoDTO.LogId +
whereClause +
" GROUP BY " + colTime + " ) AS Qry5minintervals" +
" GROUP BY [Time1] " +
"ORDER By 1 asc";
QSOQuery = GenerateQuery(ContestInfoDTO, ChartAreaDto, sIntvTime, sQCnt, colTime, whereClause, "QPrefixMult");
//prefixes
break;
case ContestTypeEnum.CQ160:
break;
case ContestTypeEnum.RUSDXC:
//oblasts plus countries
break;
default:
break;
}
ContestViewParmsDTO = new ContestViewParmsDTO(sChartFunction, SerTablename, sIntvTime, sQCnt, "Score Rate",
"Score Per" + ChartAreaDto.ChartPointtInterval.ToString() + " Mins", QSOQuery, false);
break;
case "Score Sum":
switch (ContestTypeEnum)
{
case ContestTypeEnum.CQWW:
//(Zones + Countries) * pts
QSOQuery = @"SELECT [Time1] AS " + sIntvTime + ", Sum(Qry5minintervals.N) As 'Points', Sum(Qry5minintervals.Mults) AS Mults " +
" FROM (SELECT convert(datetime, Format(" + colTime + ",'d') + ' ' " +
"+ Format(DatePart(hh," + colTime + "),'00') + ':' " +
"+ Format((DatePart(n," + colTime + ")/" + ChartAreaDto.ChartPointtInterval + ")*" +
ChartAreaDto.ChartPointtInterval + ",'00') )AS [Time1] , " +
"Sum( " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts1]) + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts2])*2 + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts4])*4 + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts8])*8 ) AS N," +
"Sum( " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QZoneMult]) + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QCtyMult]) )" +
"AS Mults" +
" FROM " + ContestInfoDTO.QsoDatabaseTableName +
" INNER JOIN Log ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[LogId] = [Log].[LogId] " +
"INNER JOIN CallSign ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[CallsignId] = [CallSign].[CallSignId]" +
" AND [Log].[LogId] = " + ContestInfoDTO.LogId +
whereClause +
" GROUP BY " + colTime + " ) AS Qry5minintervals" +
" GROUP BY [Time1] " +
"ORDER By 1 asc";
break;
case ContestTypeEnum.CQWPX:
//prefix * pts
QSOQuery = @"SELECT [Time1] AS " + sIntvTime + ", Sum(Qry5minintervals.N) As 'Points', Sum(Qry5minintervals.Mults) AS Mults " +
" FROM (SELECT convert(datetime, Format(" + colTime + ",'d') + ' ' " +
"+ Format(DatePart(hh," + colTime + "),'00') + ':' " +
"+ Format((DatePart(n," + colTime + ")/" + ChartAreaDto.ChartPointtInterval + ")*" +
ChartAreaDto.ChartPointtInterval + ",'00') )AS [Time1] , " +
"Sum( " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts1]) + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts2])*2 + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts4])*4 + " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPts8])*8 ) AS N," +
"Sum( " +
"convert(int,[" + ContestInfoDTO.QsoDatabaseTableName + "].[QPrefixMult]) )" +
"AS Mults" +
" FROM " + ContestInfoDTO.QsoDatabaseTableName +
" INNER JOIN Log ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[LogId] = [Log].[LogId] " +
"INNER JOIN CallSign ON [" + ContestInfoDTO.QsoDatabaseTableName + "].[CallsignId] = [CallSign].[CallSignId]" +
" AND [Log].[LogId] = " + ContestInfoDTO.LogId +
whereClause +
" GROUP BY " + colTime + " ) AS Qry5minintervals" +
" GROUP BY [Time1] " +
"ORDER By 1 asc";
//prefixes
break;
case ContestTypeEnum.CQ160:
break;
case ContestTypeEnum.RUSDXC:
//oblasts plus countries
break;
default:
break;
}
ContestViewParmsDTO = new ContestViewParmsDTO(sChartFunction, SerTablename, sIntvTime, sQCnt, "Score Sum",
"Score Per" + ChartAreaDto.ChartPointtInterval.ToString() + " Mins", QSOQuery, true);
break;
default:
break;
}
}