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