public TeamFileSummaryModule() { this.Name = "TeamFileSummaryModule"; this.Label = "Team Summary"; this.HelpHref = "teamsummary"; this.Version = "1.0.0.2"; this.ModuleType = PSAddinModules.ModuleType.Workbook; _SqlSatementModule = new SqlStatementsModule(); _tblSummaryFileTempDefinition = new List<ExcelToSql.SqlTransmitter.TableDefinition>(); _tblSummaryFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 1, FieldName = "Combo", IsNotNullable = true }); _tblSummaryFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 2, FieldName = "Status" }); _tblSummaryFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 3, FieldName = "Comment" }); }
public CurrentTeamModule() { this.Name = "CurrentTeam"; this.Label = "Current Team"; this.HelpHref = "currentteam"; this.Version = "1.0.0.0"; this.ModuleType = PSAddinModules.ModuleType.Workbook; _SqlSatementModule = new SqlStatementsModule(); _tblCurrentTeam = new List<ExcelToSql.SqlTransmitter.TableDefinition>(); _tblCurrentTeam.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 1, FieldName = "Combo" }); _tblCurrentTeam.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 2, FieldName = "TLeaderFullName" }); _tblCurrentTeam.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 3, FieldName = "TLeaderStaffCode" }); _tblCurrentTeam.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 4, FieldName = "TMemberFullName" }); _tblCurrentTeam.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 5, FieldName = "TMemberStaffCode" }); _tblCurrentTeam.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 6, FieldName = "ValueType" }); _tblCurrentTeam.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 7, FieldName = "Value" }); _tblCurrentTeam.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 8, FieldName = "Date From" }); _tblCurrentTeam.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 9, FieldName = "Date To" }); }
public TeamFileModule() { this.Name = "TeamFileModule"; this.HelpHref = "team"; this.Label = "Team File"; this.Version = "1.0.0.0"; this.ModuleType = PSAddinModules.ModuleType.Workbook; _SqlSatementModule = new SqlStatementsModule(); _SendMessageModule = new SendMessageModule(); _tblTeamFileTempDefinition = new List<ExcelToSql.SqlTransmitter.TableDefinition>(); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 1, FieldName = "Details" }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 2, FieldName = "TMemberFullName" }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 3, FieldName = "FullFTE" }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 4, FieldName = "Bridge" }); //* _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 5, FieldName = "BridgeCurrentTeam" }); //* _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 6, FieldName = "CurrentTeamTotal" }); //* _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 7, FieldName = "CurrentTeamLS" }); //* _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 8, FieldName = "CurrentTeamWOLS" }); //* _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 9, FieldName = "AdditionalAllocationLS" }); //* _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 10, FieldName = "AdditionalAllocationWOLS" }); //* _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 11, FieldName = "DateFrom" }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 12, FieldName = "DateTo" }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 13, FieldName = "RevisedTeam" }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 14, FieldName = "RevisedTeamLS" }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 15, FieldName = "RevisedTeamWOLS" }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 16, FieldName = "InForecastLS" }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 17, FieldName = "InForecastWOLS" }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 18, FieldName = "TotalForecasted" }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 19, FieldName = "AvailableCapacity" }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 20, FieldName = "Comment" }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 21, FieldName = "RowNr" }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 22, FieldName = "TMemberStaffCode", IsNotNullable = true }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 23, FieldName = "Combo" }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 24, FieldName = "Status" }); _tblTeamFileTempDefinition.Add(new ExcelToSql.SqlTransmitter.TableDefinition { FieldOrder = 25, FieldName = "TLeaderStaffCode" }); InitValidationList(); }