/// <summary>
///
/// </summary>
/// <param name="partner"></param>
/// <param name="fromDate"></param>
/// <param name="toDate"></param>
/// <returns></returns>
public ChartDTO GetProjectChartData(string partner, string fromDate, string toDate)
{
//dynamic MyDynamic = new System.Dynamic.ExpandoObject();
ChartDTO retVal = new ChartDTO();
try
{
DataSet ds = new ProjectDB(Utility.ConfigurationHelper.GPD_Connection).GetProjectChartData(partner, fromDate, toDate);
if (ds != null && ds.Tables.Count == 1 && ds.Tables[0].Rows.Count > 0)
{
string tempAppType = "";
LinesDTO line = new LinesDTO();
foreach (DataRow dr in ds.Tables[0].Rows)
{
string appType = dr["APP_TYPE"].ToString();
if (appType.ToUpper() != tempAppType)
{
tempAppType = appType.ToUpper();
line = new LinesDTO();
line.Name = appType;
retVal.Lines.Add(line);
}
line.Dates.Add(((DateTime)dr["C_DATE"]).ToString("yyyy-MM-dd"));
line.Values.Add(Convert.ToInt32(dr["P_COUNT"].ToString()));
}
}
}
catch (Exception exc)
{
log.Error("Unable to get data for project-chart. ERROR: " + exc.ToString());
}
return(retVal);
}
private LinesDTO populateDTO()
{
LinesDTO oLinesDTO = new LinesDTO();
oLinesDTO.LeagueName = _oLeagueDTO.LeagueName;
// ...
return(oLinesDTO);
}
public void InsertRow()
{
List <string> ocValues = new List <string>();
LinesDTO oLinesDTO = populateDTO();
populate_ocValuesForInsert(ocValues, oLinesDTO);
// TableName ColNames(csv) DTO Insert into DTO Method
SqlFunctions.DALInsertRow(TableName, TableColumns, ocValues, _ConnectionString);
}
private void populate_ocValuesForInsert(List <string> ocValues, LinesDTO oLinesDTO)
{
ocValues.Add(oLinesDTO.LeagueName.ToString());
ocValues.Add(oLinesDTO.GameDate.ToString());
ocValues.Add(oLinesDTO.RotNum.ToString());
ocValues.Add(oLinesDTO.TeamAway.ToString());
ocValues.Add(oLinesDTO.TeamHome.ToString());
ocValues.Add(oLinesDTO.Line.ToString());
ocValues.Add(oLinesDTO.PlayType.ToString());
ocValues.Add(oLinesDTO.PlayDuration.ToString());
ocValues.Add(oLinesDTO.CreateDate.ToString());
ocValues.Add(oLinesDTO.LineSource.ToString());
}
static void populateDTOFromRdr(List <object> ocRows, object oRow, SqlDataReader rdr)
{
// Column Updates Procedure
// 1) Update Table Columns
// 2) Select 1000, Cut Column names, Insert in Textpad, run Sql Columns macro, Replace {table}Columns with macro Op
// 3) Use CodeGeneration.xlsm to generate populateBoxScoreValues entries
// 4) Update CoversBoxScore.PopulateBoxScoresDTO
LinesDTO oLeagueDTO = (LinesDTO)oRow;
oLeagueDTO.LeagueName = rdr["LeagueName"].ToString().Trim();
oLeagueDTO.RotNum = (int)rdr["RotNum"];
// DateTime double
// oLeagueDTO.MultiYearLeague = (bool)rdr["MultiYearLeague"];
}
public int GetRow(LinesDTO oLinesDTO)
{
int rows = SysDAL.DALfunctions.ExecuteSqlQuery(_ConnectionString, getRowSql(), null, oLinesDTO, populateDTOFromRdr);
return(rows);
}
