//public int GetRow(DailySummaryDTO oDailySummaryDTO)
//{
// int rows = SysDAL.DALfunctions.ExecuteSqlQuery(_ConnectionString, getRowSql(), null, oDailySummaryDTO, LoadReadRowToDTO);
// return rows;
//}
static void populateDTO(List <string> ocValues, object DTO)
{
// 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
AdjustmentsDailyDTO oAdjustmentsDailyDTO = (AdjustmentsDailyDTO)DTO;
ocValues.Add(oAdjustmentsDailyDTO.LeagueName.ToString());
ocValues.Add(oAdjustmentsDailyDTO.GameDate.ToString());
ocValues.Add(oAdjustmentsDailyDTO.RotNum.ToString());
ocValues.Add(oAdjustmentsDailyDTO.Team.ToString());
ocValues.Add(oAdjustmentsDailyDTO.AdjustmentAmount.ToString());
}
private void writeAdjustmentDaily(AdjustmentsDailyDO oAdjustmentsDaily, DateTime GameDate, string LeagueName, int RotNum, string Team, double AdjustmentAmount)
{
AdjustmentsDailyDTO oAdjustmentsDailyDTO = new AdjustmentsDailyDTO()
{
LeagueName = LeagueName
,
GameDate = GameDate
,
RotNum = RotNum
,
Team = Team
,
AdjustmentAmount = AdjustmentAmount
};
oAdjustmentsDaily.InsertRow(oAdjustmentsDailyDTO);
}
public void InsertRow(AdjustmentsDailyDTO oAdjustmentsDailyDTO)
{
SqlFunctions.DALInsertRow(TableName, ColumnNames, oAdjustmentsDailyDTO, populateDTO, _ConnectionString);
}
