2821 lines
149 KiB
C#
2821 lines
149 KiB
C#
//------------------------------------------------------------------------------
|
|
// <auto-generated>
|
|
// This code was generated by a tool.
|
|
// Runtime Version:4.0.30319.42000
|
|
//
|
|
// Changes to this file may cause incorrect behavior and will be lost if
|
|
// the code is regenerated.
|
|
// </auto-generated>
|
|
//------------------------------------------------------------------------------
|
|
|
|
#pragma warning disable 1591
|
|
|
|
namespace EnVisage.Reports.DataSources {
|
|
|
|
|
|
/// <summary>
|
|
///Represents a strongly typed in-memory cache of data.
|
|
///</summary>
|
|
[global::System.Serializable()]
|
|
[global::System.ComponentModel.DesignerCategoryAttribute("code")]
|
|
[global::System.ComponentModel.ToolboxItem(true)]
|
|
[global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema")]
|
|
[global::System.Xml.Serialization.XmlRootAttribute("ReportingDataSource")]
|
|
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
|
|
public partial class ReportingDataSource : global::System.Data.DataSet {
|
|
|
|
private SummaryReportDataTable tableSummaryReport;
|
|
|
|
private StatusDataTable tableStatus;
|
|
|
|
private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public ReportingDataSource() {
|
|
this.BeginInit();
|
|
this.InitClass();
|
|
global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
|
|
base.Tables.CollectionChanged += schemaChangedHandler;
|
|
base.Relations.CollectionChanged += schemaChangedHandler;
|
|
this.EndInit();
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected ReportingDataSource(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
|
|
base(info, context, false) {
|
|
if ((this.IsBinarySerialized(info, context) == true)) {
|
|
this.InitVars(false);
|
|
global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
|
|
this.Tables.CollectionChanged += schemaChangedHandler1;
|
|
this.Relations.CollectionChanged += schemaChangedHandler1;
|
|
return;
|
|
}
|
|
string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
|
|
if ((this.DetermineSchemaSerializationMode(info, context) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
|
|
global::System.Data.DataSet ds = new global::System.Data.DataSet();
|
|
ds.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
|
|
if ((ds.Tables["SummaryReport"] != null)) {
|
|
base.Tables.Add(new SummaryReportDataTable(ds.Tables["SummaryReport"]));
|
|
}
|
|
if ((ds.Tables["Status"] != null)) {
|
|
base.Tables.Add(new StatusDataTable(ds.Tables["Status"]));
|
|
}
|
|
this.DataSetName = ds.DataSetName;
|
|
this.Prefix = ds.Prefix;
|
|
this.Namespace = ds.Namespace;
|
|
this.Locale = ds.Locale;
|
|
this.CaseSensitive = ds.CaseSensitive;
|
|
this.EnforceConstraints = ds.EnforceConstraints;
|
|
this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
|
|
this.InitVars();
|
|
}
|
|
else {
|
|
this.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
|
|
}
|
|
this.GetSerializationData(info, context);
|
|
global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
|
|
base.Tables.CollectionChanged += schemaChangedHandler;
|
|
this.Relations.CollectionChanged += schemaChangedHandler;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
[global::System.ComponentModel.Browsable(false)]
|
|
[global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
|
|
public SummaryReportDataTable SummaryReport {
|
|
get {
|
|
return this.tableSummaryReport;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
[global::System.ComponentModel.Browsable(false)]
|
|
[global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
|
|
public StatusDataTable Status {
|
|
get {
|
|
return this.tableStatus;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
[global::System.ComponentModel.BrowsableAttribute(true)]
|
|
[global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Visible)]
|
|
public override global::System.Data.SchemaSerializationMode SchemaSerializationMode {
|
|
get {
|
|
return this._schemaSerializationMode;
|
|
}
|
|
set {
|
|
this._schemaSerializationMode = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
[global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
|
|
public new global::System.Data.DataTableCollection Tables {
|
|
get {
|
|
return base.Tables;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
[global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
|
|
public new global::System.Data.DataRelationCollection Relations {
|
|
get {
|
|
return base.Relations;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override void InitializeDerivedDataSet() {
|
|
this.BeginInit();
|
|
this.InitClass();
|
|
this.EndInit();
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public override global::System.Data.DataSet Clone() {
|
|
ReportingDataSource cln = ((ReportingDataSource)(base.Clone()));
|
|
cln.InitVars();
|
|
cln.SchemaSerializationMode = this.SchemaSerializationMode;
|
|
return cln;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override bool ShouldSerializeTables() {
|
|
return false;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override bool ShouldSerializeRelations() {
|
|
return false;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override void ReadXmlSerializable(global::System.Xml.XmlReader reader) {
|
|
if ((this.DetermineSchemaSerializationMode(reader) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
|
|
this.Reset();
|
|
global::System.Data.DataSet ds = new global::System.Data.DataSet();
|
|
ds.ReadXml(reader);
|
|
if ((ds.Tables["SummaryReport"] != null)) {
|
|
base.Tables.Add(new SummaryReportDataTable(ds.Tables["SummaryReport"]));
|
|
}
|
|
if ((ds.Tables["Status"] != null)) {
|
|
base.Tables.Add(new StatusDataTable(ds.Tables["Status"]));
|
|
}
|
|
this.DataSetName = ds.DataSetName;
|
|
this.Prefix = ds.Prefix;
|
|
this.Namespace = ds.Namespace;
|
|
this.Locale = ds.Locale;
|
|
this.CaseSensitive = ds.CaseSensitive;
|
|
this.EnforceConstraints = ds.EnforceConstraints;
|
|
this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
|
|
this.InitVars();
|
|
}
|
|
else {
|
|
this.ReadXml(reader);
|
|
this.InitVars();
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override global::System.Xml.Schema.XmlSchema GetSchemaSerializable() {
|
|
global::System.IO.MemoryStream stream = new global::System.IO.MemoryStream();
|
|
this.WriteXmlSchema(new global::System.Xml.XmlTextWriter(stream, null));
|
|
stream.Position = 0;
|
|
return global::System.Xml.Schema.XmlSchema.Read(new global::System.Xml.XmlTextReader(stream), null);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
internal void InitVars() {
|
|
this.InitVars(true);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
internal void InitVars(bool initTable) {
|
|
this.tableSummaryReport = ((SummaryReportDataTable)(base.Tables["SummaryReport"]));
|
|
if ((initTable == true)) {
|
|
if ((this.tableSummaryReport != null)) {
|
|
this.tableSummaryReport.InitVars();
|
|
}
|
|
}
|
|
this.tableStatus = ((StatusDataTable)(base.Tables["Status"]));
|
|
if ((initTable == true)) {
|
|
if ((this.tableStatus != null)) {
|
|
this.tableStatus.InitVars();
|
|
}
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private void InitClass() {
|
|
this.DataSetName = "ReportingDataSource";
|
|
this.Prefix = "";
|
|
this.Namespace = "http://tempuri.org/ReportingDataSource.xsd";
|
|
this.EnforceConstraints = true;
|
|
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
|
|
this.tableSummaryReport = new SummaryReportDataTable();
|
|
base.Tables.Add(this.tableSummaryReport);
|
|
this.tableStatus = new StatusDataTable();
|
|
base.Tables.Add(this.tableStatus);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private bool ShouldSerializeSummaryReport() {
|
|
return false;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private bool ShouldSerializeStatus() {
|
|
return false;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private void SchemaChanged(object sender, global::System.ComponentModel.CollectionChangeEventArgs e) {
|
|
if ((e.Action == global::System.ComponentModel.CollectionChangeAction.Remove)) {
|
|
this.InitVars();
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
|
|
ReportingDataSource ds = new ReportingDataSource();
|
|
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
|
|
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
|
|
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
|
|
any.Namespace = ds.Namespace;
|
|
sequence.Items.Add(any);
|
|
type.Particle = sequence;
|
|
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
|
|
if (xs.Contains(dsSchema.TargetNamespace)) {
|
|
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
|
|
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
|
|
try {
|
|
global::System.Xml.Schema.XmlSchema schema = null;
|
|
dsSchema.Write(s1);
|
|
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
|
|
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
|
|
s2.SetLength(0);
|
|
schema.Write(s2);
|
|
if ((s1.Length == s2.Length)) {
|
|
s1.Position = 0;
|
|
s2.Position = 0;
|
|
for (; ((s1.Position != s1.Length)
|
|
&& (s1.ReadByte() == s2.ReadByte())); ) {
|
|
;
|
|
}
|
|
if ((s1.Position == s1.Length)) {
|
|
return type;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
finally {
|
|
if ((s1 != null)) {
|
|
s1.Close();
|
|
}
|
|
if ((s2 != null)) {
|
|
s2.Close();
|
|
}
|
|
}
|
|
}
|
|
xs.Add(dsSchema);
|
|
return type;
|
|
}
|
|
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public delegate void SummaryReportRowChangeEventHandler(object sender, SummaryReportRowChangeEvent e);
|
|
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public delegate void StatusRowChangeEventHandler(object sender, StatusRowChangeEvent e);
|
|
|
|
/// <summary>
|
|
///Represents the strongly named DataTable class.
|
|
///</summary>
|
|
[global::System.Serializable()]
|
|
[global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
|
|
public partial class SummaryReportDataTable : global::System.Data.TypedTableBase<SummaryReportRow> {
|
|
|
|
private global::System.Data.DataColumn columnName;
|
|
|
|
private global::System.Data.DataColumn columnScenario_Name;
|
|
|
|
private global::System.Data.DataColumn columnProjectedRevenue;
|
|
|
|
private global::System.Data.DataColumn columnExpectedGrossMargin;
|
|
|
|
private global::System.Data.DataColumn columnCalculatedGrossMargin;
|
|
|
|
private global::System.Data.DataColumn columnCalculatedGrossMargin_LM;
|
|
|
|
private global::System.Data.DataColumn columnStartDate;
|
|
|
|
private global::System.Data.DataColumn columnEndDate;
|
|
|
|
private global::System.Data.DataColumn columnTDDirectCosts;
|
|
|
|
private global::System.Data.DataColumn columnTDDirectCosts_LM;
|
|
|
|
private global::System.Data.DataColumn columnBUDirectCosts;
|
|
|
|
private global::System.Data.DataColumn columnBUDirectCosts_LM;
|
|
|
|
private global::System.Data.DataColumn columnCostSavings;
|
|
|
|
private global::System.Data.DataColumn columnCostSavingsStartDate;
|
|
|
|
private global::System.Data.DataColumn columnTeamId;
|
|
|
|
private global::System.Data.DataColumn columnCostSavingsEndDate;
|
|
|
|
private global::System.Data.DataColumn columnCostSavingsType;
|
|
|
|
private global::System.Data.DataColumn columnIsRevenueGenerating;
|
|
|
|
private global::System.Data.DataColumn columnProject_Name;
|
|
|
|
private global::System.Data.DataColumn columnPriority;
|
|
|
|
private global::System.Data.DataColumn columnProbability;
|
|
|
|
private global::System.Data.DataColumn columnDeadline;
|
|
|
|
private global::System.Data.DataColumn columnStatus_Name;
|
|
|
|
private global::System.Data.DataColumn columnScenarioId;
|
|
|
|
private global::System.Data.DataColumn columnProjectId;
|
|
|
|
private global::System.Data.DataColumn columnProjectStatusId;
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public SummaryReportDataTable() {
|
|
this.TableName = "SummaryReport";
|
|
this.BeginInit();
|
|
this.InitClass();
|
|
this.EndInit();
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
internal SummaryReportDataTable(global::System.Data.DataTable table) {
|
|
this.TableName = table.TableName;
|
|
if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
|
|
this.CaseSensitive = table.CaseSensitive;
|
|
}
|
|
if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
|
|
this.Locale = table.Locale;
|
|
}
|
|
if ((table.Namespace != table.DataSet.Namespace)) {
|
|
this.Namespace = table.Namespace;
|
|
}
|
|
this.Prefix = table.Prefix;
|
|
this.MinimumCapacity = table.MinimumCapacity;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected SummaryReportDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
|
|
base(info, context) {
|
|
this.InitVars();
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn NameColumn {
|
|
get {
|
|
return this.columnName;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn Scenario_NameColumn {
|
|
get {
|
|
return this.columnScenario_Name;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn ProjectedRevenueColumn {
|
|
get {
|
|
return this.columnProjectedRevenue;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn ExpectedGrossMarginColumn {
|
|
get {
|
|
return this.columnExpectedGrossMargin;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn CalculatedGrossMarginColumn {
|
|
get {
|
|
return this.columnCalculatedGrossMargin;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn CalculatedGrossMargin_LMColumn {
|
|
get {
|
|
return this.columnCalculatedGrossMargin_LM;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn StartDateColumn {
|
|
get {
|
|
return this.columnStartDate;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn EndDateColumn {
|
|
get {
|
|
return this.columnEndDate;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn TDDirectCostsColumn {
|
|
get {
|
|
return this.columnTDDirectCosts;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn TDDirectCosts_LMColumn {
|
|
get {
|
|
return this.columnTDDirectCosts_LM;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn BUDirectCostsColumn {
|
|
get {
|
|
return this.columnBUDirectCosts;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn BUDirectCosts_LMColumn {
|
|
get {
|
|
return this.columnBUDirectCosts_LM;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn CostSavingsColumn {
|
|
get {
|
|
return this.columnCostSavings;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn CostSavingsStartDateColumn {
|
|
get {
|
|
return this.columnCostSavingsStartDate;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn TeamIdColumn {
|
|
get {
|
|
return this.columnTeamId;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn CostSavingsEndDateColumn {
|
|
get {
|
|
return this.columnCostSavingsEndDate;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn CostSavingsTypeColumn {
|
|
get {
|
|
return this.columnCostSavingsType;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn IsRevenueGeneratingColumn {
|
|
get {
|
|
return this.columnIsRevenueGenerating;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn Project_NameColumn {
|
|
get {
|
|
return this.columnProject_Name;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn PriorityColumn {
|
|
get {
|
|
return this.columnPriority;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn ProbabilityColumn {
|
|
get {
|
|
return this.columnProbability;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn DeadlineColumn {
|
|
get {
|
|
return this.columnDeadline;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn Status_NameColumn {
|
|
get {
|
|
return this.columnStatus_Name;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn ScenarioIdColumn {
|
|
get {
|
|
return this.columnScenarioId;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn ProjectIdColumn {
|
|
get {
|
|
return this.columnProjectId;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn ProjectStatusIdColumn {
|
|
get {
|
|
return this.columnProjectStatusId;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
[global::System.ComponentModel.Browsable(false)]
|
|
public int Count {
|
|
get {
|
|
return this.Rows.Count;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public SummaryReportRow this[int index] {
|
|
get {
|
|
return ((SummaryReportRow)(this.Rows[index]));
|
|
}
|
|
}
|
|
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public event SummaryReportRowChangeEventHandler SummaryReportRowChanging;
|
|
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public event SummaryReportRowChangeEventHandler SummaryReportRowChanged;
|
|
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public event SummaryReportRowChangeEventHandler SummaryReportRowDeleting;
|
|
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public event SummaryReportRowChangeEventHandler SummaryReportRowDeleted;
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void AddSummaryReportRow(SummaryReportRow row) {
|
|
this.Rows.Add(row);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public SummaryReportRow AddSummaryReportRow(
|
|
string Name,
|
|
string Scenario_Name,
|
|
decimal ProjectedRevenue,
|
|
decimal ExpectedGrossMargin,
|
|
decimal CalculatedGrossMargin,
|
|
decimal CalculatedGrossMargin_LM,
|
|
System.DateTime StartDate,
|
|
System.DateTime EndDate,
|
|
decimal TDDirectCosts,
|
|
decimal TDDirectCosts_LM,
|
|
decimal BUDirectCosts,
|
|
decimal BUDirectCosts_LM,
|
|
decimal CostSavings,
|
|
System.DateTime CostSavingsStartDate,
|
|
System.Guid TeamId,
|
|
System.DateTime CostSavingsEndDate,
|
|
short CostSavingsType,
|
|
bool IsRevenueGenerating,
|
|
string Project_Name,
|
|
int Priority,
|
|
decimal Probability,
|
|
System.DateTime Deadline,
|
|
string Status_Name,
|
|
System.Guid ScenarioId,
|
|
System.Guid ProjectId,
|
|
System.Guid ProjectStatusId) {
|
|
SummaryReportRow rowSummaryReportRow = ((SummaryReportRow)(this.NewRow()));
|
|
object[] columnValuesArray = new object[] {
|
|
Name,
|
|
Scenario_Name,
|
|
ProjectedRevenue,
|
|
ExpectedGrossMargin,
|
|
CalculatedGrossMargin,
|
|
CalculatedGrossMargin_LM,
|
|
StartDate,
|
|
EndDate,
|
|
TDDirectCosts,
|
|
TDDirectCosts_LM,
|
|
BUDirectCosts,
|
|
BUDirectCosts_LM,
|
|
CostSavings,
|
|
CostSavingsStartDate,
|
|
TeamId,
|
|
CostSavingsEndDate,
|
|
CostSavingsType,
|
|
IsRevenueGenerating,
|
|
Project_Name,
|
|
Priority,
|
|
Probability,
|
|
Deadline,
|
|
Status_Name,
|
|
ScenarioId,
|
|
ProjectId,
|
|
ProjectStatusId};
|
|
rowSummaryReportRow.ItemArray = columnValuesArray;
|
|
this.Rows.Add(rowSummaryReportRow);
|
|
return rowSummaryReportRow;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public SummaryReportRow FindByTeamIdScenarioId(System.Guid TeamId, System.Guid ScenarioId) {
|
|
return ((SummaryReportRow)(this.Rows.Find(new object[] {
|
|
TeamId,
|
|
ScenarioId})));
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public override global::System.Data.DataTable Clone() {
|
|
SummaryReportDataTable cln = ((SummaryReportDataTable)(base.Clone()));
|
|
cln.InitVars();
|
|
return cln;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override global::System.Data.DataTable CreateInstance() {
|
|
return new SummaryReportDataTable();
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
internal void InitVars() {
|
|
this.columnName = base.Columns["Name"];
|
|
this.columnScenario_Name = base.Columns["Scenario_Name"];
|
|
this.columnProjectedRevenue = base.Columns["ProjectedRevenue"];
|
|
this.columnExpectedGrossMargin = base.Columns["ExpectedGrossMargin"];
|
|
this.columnCalculatedGrossMargin = base.Columns["CalculatedGrossMargin"];
|
|
this.columnCalculatedGrossMargin_LM = base.Columns["CalculatedGrossMargin_LM"];
|
|
this.columnStartDate = base.Columns["StartDate"];
|
|
this.columnEndDate = base.Columns["EndDate"];
|
|
this.columnTDDirectCosts = base.Columns["TDDirectCosts"];
|
|
this.columnTDDirectCosts_LM = base.Columns["TDDirectCosts_LM"];
|
|
this.columnBUDirectCosts = base.Columns["BUDirectCosts"];
|
|
this.columnBUDirectCosts_LM = base.Columns["BUDirectCosts_LM"];
|
|
this.columnCostSavings = base.Columns["CostSavings"];
|
|
this.columnCostSavingsStartDate = base.Columns["CostSavingsStartDate"];
|
|
this.columnTeamId = base.Columns["TeamId"];
|
|
this.columnCostSavingsEndDate = base.Columns["CostSavingsEndDate"];
|
|
this.columnCostSavingsType = base.Columns["CostSavingsType"];
|
|
this.columnIsRevenueGenerating = base.Columns["IsRevenueGenerating"];
|
|
this.columnProject_Name = base.Columns["Project_Name"];
|
|
this.columnPriority = base.Columns["Priority"];
|
|
this.columnProbability = base.Columns["Probability"];
|
|
this.columnDeadline = base.Columns["Deadline"];
|
|
this.columnStatus_Name = base.Columns["Status_Name"];
|
|
this.columnScenarioId = base.Columns["ScenarioId"];
|
|
this.columnProjectId = base.Columns["ProjectId"];
|
|
this.columnProjectStatusId = base.Columns["ProjectStatusId"];
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private void InitClass() {
|
|
this.columnName = new global::System.Data.DataColumn("Name", typeof(string), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnName);
|
|
this.columnScenario_Name = new global::System.Data.DataColumn("Scenario_Name", typeof(string), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnScenario_Name);
|
|
this.columnProjectedRevenue = new global::System.Data.DataColumn("ProjectedRevenue", typeof(decimal), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnProjectedRevenue);
|
|
this.columnExpectedGrossMargin = new global::System.Data.DataColumn("ExpectedGrossMargin", typeof(decimal), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnExpectedGrossMargin);
|
|
this.columnCalculatedGrossMargin = new global::System.Data.DataColumn("CalculatedGrossMargin", typeof(decimal), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnCalculatedGrossMargin);
|
|
this.columnCalculatedGrossMargin_LM = new global::System.Data.DataColumn("CalculatedGrossMargin_LM", typeof(decimal), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnCalculatedGrossMargin_LM);
|
|
this.columnStartDate = new global::System.Data.DataColumn("StartDate", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnStartDate);
|
|
this.columnEndDate = new global::System.Data.DataColumn("EndDate", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnEndDate);
|
|
this.columnTDDirectCosts = new global::System.Data.DataColumn("TDDirectCosts", typeof(decimal), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnTDDirectCosts);
|
|
this.columnTDDirectCosts_LM = new global::System.Data.DataColumn("TDDirectCosts_LM", typeof(decimal), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnTDDirectCosts_LM);
|
|
this.columnBUDirectCosts = new global::System.Data.DataColumn("BUDirectCosts", typeof(decimal), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnBUDirectCosts);
|
|
this.columnBUDirectCosts_LM = new global::System.Data.DataColumn("BUDirectCosts_LM", typeof(decimal), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnBUDirectCosts_LM);
|
|
this.columnCostSavings = new global::System.Data.DataColumn("CostSavings", typeof(decimal), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnCostSavings);
|
|
this.columnCostSavingsStartDate = new global::System.Data.DataColumn("CostSavingsStartDate", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnCostSavingsStartDate);
|
|
this.columnTeamId = new global::System.Data.DataColumn("TeamId", typeof(global::System.Guid), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnTeamId);
|
|
this.columnCostSavingsEndDate = new global::System.Data.DataColumn("CostSavingsEndDate", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnCostSavingsEndDate);
|
|
this.columnCostSavingsType = new global::System.Data.DataColumn("CostSavingsType", typeof(short), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnCostSavingsType);
|
|
this.columnIsRevenueGenerating = new global::System.Data.DataColumn("IsRevenueGenerating", typeof(bool), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnIsRevenueGenerating);
|
|
this.columnProject_Name = new global::System.Data.DataColumn("Project_Name", typeof(string), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnProject_Name);
|
|
this.columnPriority = new global::System.Data.DataColumn("Priority", typeof(int), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnPriority);
|
|
this.columnProbability = new global::System.Data.DataColumn("Probability", typeof(decimal), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnProbability);
|
|
this.columnDeadline = new global::System.Data.DataColumn("Deadline", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnDeadline);
|
|
this.columnStatus_Name = new global::System.Data.DataColumn("Status_Name", typeof(string), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnStatus_Name);
|
|
this.columnScenarioId = new global::System.Data.DataColumn("ScenarioId", typeof(global::System.Guid), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnScenarioId);
|
|
this.columnProjectId = new global::System.Data.DataColumn("ProjectId", typeof(global::System.Guid), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnProjectId);
|
|
this.columnProjectStatusId = new global::System.Data.DataColumn("ProjectStatusId", typeof(global::System.Guid), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnProjectStatusId);
|
|
this.Constraints.Add(new global::System.Data.UniqueConstraint("SummaryReportKey1", new global::System.Data.DataColumn[] {
|
|
this.columnTeamId,
|
|
this.columnScenarioId}, true));
|
|
this.columnName.MaxLength = 400;
|
|
this.columnScenario_Name.MaxLength = 800;
|
|
this.columnTeamId.AllowDBNull = false;
|
|
this.columnIsRevenueGenerating.AllowDBNull = false;
|
|
this.columnProject_Name.MaxLength = 800;
|
|
this.columnPriority.AllowDBNull = false;
|
|
this.columnProbability.AllowDBNull = false;
|
|
this.columnStatus_Name.MaxLength = 1600;
|
|
this.columnScenarioId.AllowDBNull = false;
|
|
this.columnProjectId.AllowDBNull = false;
|
|
this.columnProjectStatusId.AllowDBNull = false;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public SummaryReportRow NewSummaryReportRow() {
|
|
return ((SummaryReportRow)(this.NewRow()));
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
|
|
return new SummaryReportRow(builder);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override global::System.Type GetRowType() {
|
|
return typeof(SummaryReportRow);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
|
|
base.OnRowChanged(e);
|
|
if ((this.SummaryReportRowChanged != null)) {
|
|
this.SummaryReportRowChanged(this, new SummaryReportRowChangeEvent(((SummaryReportRow)(e.Row)), e.Action));
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
|
|
base.OnRowChanging(e);
|
|
if ((this.SummaryReportRowChanging != null)) {
|
|
this.SummaryReportRowChanging(this, new SummaryReportRowChangeEvent(((SummaryReportRow)(e.Row)), e.Action));
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
|
|
base.OnRowDeleted(e);
|
|
if ((this.SummaryReportRowDeleted != null)) {
|
|
this.SummaryReportRowDeleted(this, new SummaryReportRowChangeEvent(((SummaryReportRow)(e.Row)), e.Action));
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
|
|
base.OnRowDeleting(e);
|
|
if ((this.SummaryReportRowDeleting != null)) {
|
|
this.SummaryReportRowDeleting(this, new SummaryReportRowChangeEvent(((SummaryReportRow)(e.Row)), e.Action));
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void RemoveSummaryReportRow(SummaryReportRow row) {
|
|
this.Rows.Remove(row);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
|
|
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
|
|
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
|
|
ReportingDataSource ds = new ReportingDataSource();
|
|
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
|
|
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
|
|
any1.MinOccurs = new decimal(0);
|
|
any1.MaxOccurs = decimal.MaxValue;
|
|
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
|
|
sequence.Items.Add(any1);
|
|
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
|
|
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
|
|
any2.MinOccurs = new decimal(1);
|
|
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
|
|
sequence.Items.Add(any2);
|
|
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
|
|
attribute1.Name = "namespace";
|
|
attribute1.FixedValue = ds.Namespace;
|
|
type.Attributes.Add(attribute1);
|
|
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
|
|
attribute2.Name = "tableTypeName";
|
|
attribute2.FixedValue = "SummaryReportDataTable";
|
|
type.Attributes.Add(attribute2);
|
|
type.Particle = sequence;
|
|
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
|
|
if (xs.Contains(dsSchema.TargetNamespace)) {
|
|
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
|
|
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
|
|
try {
|
|
global::System.Xml.Schema.XmlSchema schema = null;
|
|
dsSchema.Write(s1);
|
|
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
|
|
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
|
|
s2.SetLength(0);
|
|
schema.Write(s2);
|
|
if ((s1.Length == s2.Length)) {
|
|
s1.Position = 0;
|
|
s2.Position = 0;
|
|
for (; ((s1.Position != s1.Length)
|
|
&& (s1.ReadByte() == s2.ReadByte())); ) {
|
|
;
|
|
}
|
|
if ((s1.Position == s1.Length)) {
|
|
return type;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
finally {
|
|
if ((s1 != null)) {
|
|
s1.Close();
|
|
}
|
|
if ((s2 != null)) {
|
|
s2.Close();
|
|
}
|
|
}
|
|
}
|
|
xs.Add(dsSchema);
|
|
return type;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Represents the strongly named DataTable class.
|
|
///</summary>
|
|
[global::System.Serializable()]
|
|
[global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
|
|
public partial class StatusDataTable : global::System.Data.TypedTableBase<StatusRow> {
|
|
|
|
private global::System.Data.DataColumn columnId;
|
|
|
|
private global::System.Data.DataColumn columnName;
|
|
|
|
private global::System.Data.DataColumn columnColor;
|
|
|
|
private global::System.Data.DataColumn columnIsSystem;
|
|
|
|
private global::System.Data.DataColumn columnProbability100;
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public StatusDataTable() {
|
|
this.TableName = "Status";
|
|
this.BeginInit();
|
|
this.InitClass();
|
|
this.EndInit();
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
internal StatusDataTable(global::System.Data.DataTable table) {
|
|
this.TableName = table.TableName;
|
|
if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
|
|
this.CaseSensitive = table.CaseSensitive;
|
|
}
|
|
if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
|
|
this.Locale = table.Locale;
|
|
}
|
|
if ((table.Namespace != table.DataSet.Namespace)) {
|
|
this.Namespace = table.Namespace;
|
|
}
|
|
this.Prefix = table.Prefix;
|
|
this.MinimumCapacity = table.MinimumCapacity;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected StatusDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
|
|
base(info, context) {
|
|
this.InitVars();
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn IdColumn {
|
|
get {
|
|
return this.columnId;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn NameColumn {
|
|
get {
|
|
return this.columnName;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn ColorColumn {
|
|
get {
|
|
return this.columnColor;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn IsSystemColumn {
|
|
get {
|
|
return this.columnIsSystem;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataColumn Probability100Column {
|
|
get {
|
|
return this.columnProbability100;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
[global::System.ComponentModel.Browsable(false)]
|
|
public int Count {
|
|
get {
|
|
return this.Rows.Count;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public StatusRow this[int index] {
|
|
get {
|
|
return ((StatusRow)(this.Rows[index]));
|
|
}
|
|
}
|
|
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public event StatusRowChangeEventHandler StatusRowChanging;
|
|
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public event StatusRowChangeEventHandler StatusRowChanged;
|
|
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public event StatusRowChangeEventHandler StatusRowDeleting;
|
|
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public event StatusRowChangeEventHandler StatusRowDeleted;
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void AddStatusRow(StatusRow row) {
|
|
this.Rows.Add(row);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public StatusRow AddStatusRow(System.Guid Id, string Name, string Color, bool IsSystem, bool Probability100) {
|
|
StatusRow rowStatusRow = ((StatusRow)(this.NewRow()));
|
|
object[] columnValuesArray = new object[] {
|
|
Id,
|
|
Name,
|
|
Color,
|
|
IsSystem,
|
|
Probability100};
|
|
rowStatusRow.ItemArray = columnValuesArray;
|
|
this.Rows.Add(rowStatusRow);
|
|
return rowStatusRow;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public StatusRow FindById(System.Guid Id) {
|
|
return ((StatusRow)(this.Rows.Find(new object[] {
|
|
Id})));
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public override global::System.Data.DataTable Clone() {
|
|
StatusDataTable cln = ((StatusDataTable)(base.Clone()));
|
|
cln.InitVars();
|
|
return cln;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override global::System.Data.DataTable CreateInstance() {
|
|
return new StatusDataTable();
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
internal void InitVars() {
|
|
this.columnId = base.Columns["Id"];
|
|
this.columnName = base.Columns["Name"];
|
|
this.columnColor = base.Columns["Color"];
|
|
this.columnIsSystem = base.Columns["IsSystem"];
|
|
this.columnProbability100 = base.Columns["Probability100"];
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private void InitClass() {
|
|
this.columnId = new global::System.Data.DataColumn("Id", typeof(global::System.Guid), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnId);
|
|
this.columnName = new global::System.Data.DataColumn("Name", typeof(string), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnName);
|
|
this.columnColor = new global::System.Data.DataColumn("Color", typeof(string), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnColor);
|
|
this.columnIsSystem = new global::System.Data.DataColumn("IsSystem", typeof(bool), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnIsSystem);
|
|
this.columnProbability100 = new global::System.Data.DataColumn("Probability100", typeof(bool), null, global::System.Data.MappingType.Element);
|
|
base.Columns.Add(this.columnProbability100);
|
|
this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
|
|
this.columnId}, true));
|
|
this.columnId.AllowDBNull = false;
|
|
this.columnId.Unique = true;
|
|
this.columnName.MaxLength = 1600;
|
|
this.columnColor.MaxLength = 128;
|
|
this.columnIsSystem.AllowDBNull = false;
|
|
this.columnProbability100.AllowDBNull = false;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public StatusRow NewStatusRow() {
|
|
return ((StatusRow)(this.NewRow()));
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
|
|
return new StatusRow(builder);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override global::System.Type GetRowType() {
|
|
return typeof(StatusRow);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
|
|
base.OnRowChanged(e);
|
|
if ((this.StatusRowChanged != null)) {
|
|
this.StatusRowChanged(this, new StatusRowChangeEvent(((StatusRow)(e.Row)), e.Action));
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
|
|
base.OnRowChanging(e);
|
|
if ((this.StatusRowChanging != null)) {
|
|
this.StatusRowChanging(this, new StatusRowChangeEvent(((StatusRow)(e.Row)), e.Action));
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
|
|
base.OnRowDeleted(e);
|
|
if ((this.StatusRowDeleted != null)) {
|
|
this.StatusRowDeleted(this, new StatusRowChangeEvent(((StatusRow)(e.Row)), e.Action));
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
|
|
base.OnRowDeleting(e);
|
|
if ((this.StatusRowDeleting != null)) {
|
|
this.StatusRowDeleting(this, new StatusRowChangeEvent(((StatusRow)(e.Row)), e.Action));
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void RemoveStatusRow(StatusRow row) {
|
|
this.Rows.Remove(row);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
|
|
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
|
|
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
|
|
ReportingDataSource ds = new ReportingDataSource();
|
|
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
|
|
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
|
|
any1.MinOccurs = new decimal(0);
|
|
any1.MaxOccurs = decimal.MaxValue;
|
|
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
|
|
sequence.Items.Add(any1);
|
|
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
|
|
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
|
|
any2.MinOccurs = new decimal(1);
|
|
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
|
|
sequence.Items.Add(any2);
|
|
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
|
|
attribute1.Name = "namespace";
|
|
attribute1.FixedValue = ds.Namespace;
|
|
type.Attributes.Add(attribute1);
|
|
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
|
|
attribute2.Name = "tableTypeName";
|
|
attribute2.FixedValue = "StatusDataTable";
|
|
type.Attributes.Add(attribute2);
|
|
type.Particle = sequence;
|
|
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
|
|
if (xs.Contains(dsSchema.TargetNamespace)) {
|
|
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
|
|
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
|
|
try {
|
|
global::System.Xml.Schema.XmlSchema schema = null;
|
|
dsSchema.Write(s1);
|
|
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
|
|
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
|
|
s2.SetLength(0);
|
|
schema.Write(s2);
|
|
if ((s1.Length == s2.Length)) {
|
|
s1.Position = 0;
|
|
s2.Position = 0;
|
|
for (; ((s1.Position != s1.Length)
|
|
&& (s1.ReadByte() == s2.ReadByte())); ) {
|
|
;
|
|
}
|
|
if ((s1.Position == s1.Length)) {
|
|
return type;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
finally {
|
|
if ((s1 != null)) {
|
|
s1.Close();
|
|
}
|
|
if ((s2 != null)) {
|
|
s2.Close();
|
|
}
|
|
}
|
|
}
|
|
xs.Add(dsSchema);
|
|
return type;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Represents strongly named DataRow class.
|
|
///</summary>
|
|
public partial class SummaryReportRow : global::System.Data.DataRow {
|
|
|
|
private SummaryReportDataTable tableSummaryReport;
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
internal SummaryReportRow(global::System.Data.DataRowBuilder rb) :
|
|
base(rb) {
|
|
this.tableSummaryReport = ((SummaryReportDataTable)(this.Table));
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public string Name {
|
|
get {
|
|
try {
|
|
return ((string)(this[this.tableSummaryReport.NameColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'Name\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.NameColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public string Scenario_Name {
|
|
get {
|
|
try {
|
|
return ((string)(this[this.tableSummaryReport.Scenario_NameColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'Scenario_Name\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.Scenario_NameColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public decimal ProjectedRevenue {
|
|
get {
|
|
try {
|
|
return ((decimal)(this[this.tableSummaryReport.ProjectedRevenueColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'ProjectedRevenue\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.ProjectedRevenueColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public decimal ExpectedGrossMargin {
|
|
get {
|
|
try {
|
|
return ((decimal)(this[this.tableSummaryReport.ExpectedGrossMarginColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'ExpectedGrossMargin\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.ExpectedGrossMarginColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public decimal CalculatedGrossMargin {
|
|
get {
|
|
try {
|
|
return ((decimal)(this[this.tableSummaryReport.CalculatedGrossMarginColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'CalculatedGrossMargin\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.CalculatedGrossMarginColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public decimal CalculatedGrossMargin_LM {
|
|
get {
|
|
try {
|
|
return ((decimal)(this[this.tableSummaryReport.CalculatedGrossMargin_LMColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'CalculatedGrossMargin_LM\' in table \'SummaryReport\' is DBNul" +
|
|
"l.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.CalculatedGrossMargin_LMColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public System.DateTime StartDate {
|
|
get {
|
|
try {
|
|
return ((global::System.DateTime)(this[this.tableSummaryReport.StartDateColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'StartDate\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.StartDateColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public System.DateTime EndDate {
|
|
get {
|
|
try {
|
|
return ((global::System.DateTime)(this[this.tableSummaryReport.EndDateColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'EndDate\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.EndDateColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public decimal TDDirectCosts {
|
|
get {
|
|
try {
|
|
return ((decimal)(this[this.tableSummaryReport.TDDirectCostsColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'TDDirectCosts\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.TDDirectCostsColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public decimal TDDirectCosts_LM {
|
|
get {
|
|
try {
|
|
return ((decimal)(this[this.tableSummaryReport.TDDirectCosts_LMColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'TDDirectCosts_LM\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.TDDirectCosts_LMColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public decimal BUDirectCosts {
|
|
get {
|
|
try {
|
|
return ((decimal)(this[this.tableSummaryReport.BUDirectCostsColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'BUDirectCosts\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.BUDirectCostsColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public decimal BUDirectCosts_LM {
|
|
get {
|
|
try {
|
|
return ((decimal)(this[this.tableSummaryReport.BUDirectCosts_LMColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'BUDirectCosts_LM\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.BUDirectCosts_LMColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public decimal CostSavings {
|
|
get {
|
|
try {
|
|
return ((decimal)(this[this.tableSummaryReport.CostSavingsColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'CostSavings\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.CostSavingsColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public System.DateTime CostSavingsStartDate {
|
|
get {
|
|
try {
|
|
return ((global::System.DateTime)(this[this.tableSummaryReport.CostSavingsStartDateColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'CostSavingsStartDate\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.CostSavingsStartDateColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public System.Guid TeamId {
|
|
get {
|
|
return ((global::System.Guid)(this[this.tableSummaryReport.TeamIdColumn]));
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.TeamIdColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public System.DateTime CostSavingsEndDate {
|
|
get {
|
|
try {
|
|
return ((global::System.DateTime)(this[this.tableSummaryReport.CostSavingsEndDateColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'CostSavingsEndDate\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.CostSavingsEndDateColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public short CostSavingsType {
|
|
get {
|
|
try {
|
|
return ((short)(this[this.tableSummaryReport.CostSavingsTypeColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'CostSavingsType\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.CostSavingsTypeColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsRevenueGenerating {
|
|
get {
|
|
return ((bool)(this[this.tableSummaryReport.IsRevenueGeneratingColumn]));
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.IsRevenueGeneratingColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public string Project_Name {
|
|
get {
|
|
try {
|
|
return ((string)(this[this.tableSummaryReport.Project_NameColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'Project_Name\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.Project_NameColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public int Priority {
|
|
get {
|
|
return ((int)(this[this.tableSummaryReport.PriorityColumn]));
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.PriorityColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public decimal Probability {
|
|
get {
|
|
return ((decimal)(this[this.tableSummaryReport.ProbabilityColumn]));
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.ProbabilityColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public System.DateTime Deadline {
|
|
get {
|
|
try {
|
|
return ((global::System.DateTime)(this[this.tableSummaryReport.DeadlineColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'Deadline\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.DeadlineColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public string Status_Name {
|
|
get {
|
|
try {
|
|
return ((string)(this[this.tableSummaryReport.Status_NameColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'Status_Name\' in table \'SummaryReport\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.Status_NameColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public System.Guid ScenarioId {
|
|
get {
|
|
return ((global::System.Guid)(this[this.tableSummaryReport.ScenarioIdColumn]));
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.ScenarioIdColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public System.Guid ProjectId {
|
|
get {
|
|
return ((global::System.Guid)(this[this.tableSummaryReport.ProjectIdColumn]));
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.ProjectIdColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public System.Guid ProjectStatusId {
|
|
get {
|
|
return ((global::System.Guid)(this[this.tableSummaryReport.ProjectStatusIdColumn]));
|
|
}
|
|
set {
|
|
this[this.tableSummaryReport.ProjectStatusIdColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsNameNull() {
|
|
return this.IsNull(this.tableSummaryReport.NameColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetNameNull() {
|
|
this[this.tableSummaryReport.NameColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsScenario_NameNull() {
|
|
return this.IsNull(this.tableSummaryReport.Scenario_NameColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetScenario_NameNull() {
|
|
this[this.tableSummaryReport.Scenario_NameColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsProjectedRevenueNull() {
|
|
return this.IsNull(this.tableSummaryReport.ProjectedRevenueColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetProjectedRevenueNull() {
|
|
this[this.tableSummaryReport.ProjectedRevenueColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsExpectedGrossMarginNull() {
|
|
return this.IsNull(this.tableSummaryReport.ExpectedGrossMarginColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetExpectedGrossMarginNull() {
|
|
this[this.tableSummaryReport.ExpectedGrossMarginColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsCalculatedGrossMarginNull() {
|
|
return this.IsNull(this.tableSummaryReport.CalculatedGrossMarginColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetCalculatedGrossMarginNull() {
|
|
this[this.tableSummaryReport.CalculatedGrossMarginColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsCalculatedGrossMargin_LMNull() {
|
|
return this.IsNull(this.tableSummaryReport.CalculatedGrossMargin_LMColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetCalculatedGrossMargin_LMNull() {
|
|
this[this.tableSummaryReport.CalculatedGrossMargin_LMColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsStartDateNull() {
|
|
return this.IsNull(this.tableSummaryReport.StartDateColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetStartDateNull() {
|
|
this[this.tableSummaryReport.StartDateColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsEndDateNull() {
|
|
return this.IsNull(this.tableSummaryReport.EndDateColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetEndDateNull() {
|
|
this[this.tableSummaryReport.EndDateColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsTDDirectCostsNull() {
|
|
return this.IsNull(this.tableSummaryReport.TDDirectCostsColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetTDDirectCostsNull() {
|
|
this[this.tableSummaryReport.TDDirectCostsColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsTDDirectCosts_LMNull() {
|
|
return this.IsNull(this.tableSummaryReport.TDDirectCosts_LMColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetTDDirectCosts_LMNull() {
|
|
this[this.tableSummaryReport.TDDirectCosts_LMColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsBUDirectCostsNull() {
|
|
return this.IsNull(this.tableSummaryReport.BUDirectCostsColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetBUDirectCostsNull() {
|
|
this[this.tableSummaryReport.BUDirectCostsColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsBUDirectCosts_LMNull() {
|
|
return this.IsNull(this.tableSummaryReport.BUDirectCosts_LMColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetBUDirectCosts_LMNull() {
|
|
this[this.tableSummaryReport.BUDirectCosts_LMColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsCostSavingsNull() {
|
|
return this.IsNull(this.tableSummaryReport.CostSavingsColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetCostSavingsNull() {
|
|
this[this.tableSummaryReport.CostSavingsColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsCostSavingsStartDateNull() {
|
|
return this.IsNull(this.tableSummaryReport.CostSavingsStartDateColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetCostSavingsStartDateNull() {
|
|
this[this.tableSummaryReport.CostSavingsStartDateColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsCostSavingsEndDateNull() {
|
|
return this.IsNull(this.tableSummaryReport.CostSavingsEndDateColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetCostSavingsEndDateNull() {
|
|
this[this.tableSummaryReport.CostSavingsEndDateColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsCostSavingsTypeNull() {
|
|
return this.IsNull(this.tableSummaryReport.CostSavingsTypeColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetCostSavingsTypeNull() {
|
|
this[this.tableSummaryReport.CostSavingsTypeColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsProject_NameNull() {
|
|
return this.IsNull(this.tableSummaryReport.Project_NameColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetProject_NameNull() {
|
|
this[this.tableSummaryReport.Project_NameColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsDeadlineNull() {
|
|
return this.IsNull(this.tableSummaryReport.DeadlineColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetDeadlineNull() {
|
|
this[this.tableSummaryReport.DeadlineColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsStatus_NameNull() {
|
|
return this.IsNull(this.tableSummaryReport.Status_NameColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetStatus_NameNull() {
|
|
this[this.tableSummaryReport.Status_NameColumn] = global::System.Convert.DBNull;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Represents strongly named DataRow class.
|
|
///</summary>
|
|
public partial class StatusRow : global::System.Data.DataRow {
|
|
|
|
private StatusDataTable tableStatus;
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
internal StatusRow(global::System.Data.DataRowBuilder rb) :
|
|
base(rb) {
|
|
this.tableStatus = ((StatusDataTable)(this.Table));
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public System.Guid Id {
|
|
get {
|
|
return ((global::System.Guid)(this[this.tableStatus.IdColumn]));
|
|
}
|
|
set {
|
|
this[this.tableStatus.IdColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public string Name {
|
|
get {
|
|
try {
|
|
return ((string)(this[this.tableStatus.NameColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'Name\' in table \'Status\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableStatus.NameColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public string Color {
|
|
get {
|
|
try {
|
|
return ((string)(this[this.tableStatus.ColorColumn]));
|
|
}
|
|
catch (global::System.InvalidCastException e) {
|
|
throw new global::System.Data.StrongTypingException("The value for column \'Color\' in table \'Status\' is DBNull.", e);
|
|
}
|
|
}
|
|
set {
|
|
this[this.tableStatus.ColorColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsSystem {
|
|
get {
|
|
return ((bool)(this[this.tableStatus.IsSystemColumn]));
|
|
}
|
|
set {
|
|
this[this.tableStatus.IsSystemColumn] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool Probability100 {
|
|
get {
|
|
return ((bool)(this[this.tableStatus.Probability100Column]));
|
|
}
|
|
set {
|
|
this[this.tableStatus.Probability100Column] = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsNameNull() {
|
|
return this.IsNull(this.tableStatus.NameColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetNameNull() {
|
|
this[this.tableStatus.NameColumn] = global::System.Convert.DBNull;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool IsColorNull() {
|
|
return this.IsNull(this.tableStatus.ColorColumn);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public void SetColorNull() {
|
|
this[this.tableStatus.ColorColumn] = global::System.Convert.DBNull;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Row event argument class
|
|
///</summary>
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public class SummaryReportRowChangeEvent : global::System.EventArgs {
|
|
|
|
private SummaryReportRow eventRow;
|
|
|
|
private global::System.Data.DataRowAction eventAction;
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public SummaryReportRowChangeEvent(SummaryReportRow row, global::System.Data.DataRowAction action) {
|
|
this.eventRow = row;
|
|
this.eventAction = action;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public SummaryReportRow Row {
|
|
get {
|
|
return this.eventRow;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataRowAction Action {
|
|
get {
|
|
return this.eventAction;
|
|
}
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Row event argument class
|
|
///</summary>
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public class StatusRowChangeEvent : global::System.EventArgs {
|
|
|
|
private StatusRow eventRow;
|
|
|
|
private global::System.Data.DataRowAction eventAction;
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public StatusRowChangeEvent(StatusRow row, global::System.Data.DataRowAction action) {
|
|
this.eventRow = row;
|
|
this.eventAction = action;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public StatusRow Row {
|
|
get {
|
|
return this.eventRow;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public global::System.Data.DataRowAction Action {
|
|
get {
|
|
return this.eventAction;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
namespace EnVisage.Reports.DataSources.ReportingDataSourceTableAdapters {
|
|
|
|
|
|
/// <summary>
|
|
///Represents the connection and commands used to retrieve and save data.
|
|
///</summary>
|
|
[global::System.ComponentModel.DesignerCategoryAttribute("code")]
|
|
[global::System.ComponentModel.ToolboxItem(true)]
|
|
[global::System.ComponentModel.DataObjectAttribute(true)]
|
|
[global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
|
|
", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
|
|
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
|
|
public partial class SummaryReportTableAdapter : global::System.ComponentModel.Component {
|
|
|
|
private global::System.Data.SqlClient.SqlDataAdapter _adapter;
|
|
|
|
private global::System.Data.SqlClient.SqlConnection _connection;
|
|
|
|
private global::System.Data.SqlClient.SqlTransaction _transaction;
|
|
|
|
private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
|
|
|
|
private bool _clearBeforeFill;
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public SummaryReportTableAdapter() {
|
|
this.ClearBeforeFill = true;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
|
|
get {
|
|
if ((this._adapter == null)) {
|
|
this.InitAdapter();
|
|
}
|
|
return this._adapter;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
internal global::System.Data.SqlClient.SqlConnection Connection {
|
|
get {
|
|
if ((this._connection == null)) {
|
|
this.InitConnection();
|
|
}
|
|
return this._connection;
|
|
}
|
|
set {
|
|
this._connection = value;
|
|
if ((this.Adapter.InsertCommand != null)) {
|
|
this.Adapter.InsertCommand.Connection = value;
|
|
}
|
|
if ((this.Adapter.DeleteCommand != null)) {
|
|
this.Adapter.DeleteCommand.Connection = value;
|
|
}
|
|
if ((this.Adapter.UpdateCommand != null)) {
|
|
this.Adapter.UpdateCommand.Connection = value;
|
|
}
|
|
for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
|
|
if ((this.CommandCollection[i] != null)) {
|
|
((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
internal global::System.Data.SqlClient.SqlTransaction Transaction {
|
|
get {
|
|
return this._transaction;
|
|
}
|
|
set {
|
|
this._transaction = value;
|
|
for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
|
|
this.CommandCollection[i].Transaction = this._transaction;
|
|
}
|
|
if (((this.Adapter != null)
|
|
&& (this.Adapter.DeleteCommand != null))) {
|
|
this.Adapter.DeleteCommand.Transaction = this._transaction;
|
|
}
|
|
if (((this.Adapter != null)
|
|
&& (this.Adapter.InsertCommand != null))) {
|
|
this.Adapter.InsertCommand.Transaction = this._transaction;
|
|
}
|
|
if (((this.Adapter != null)
|
|
&& (this.Adapter.UpdateCommand != null))) {
|
|
this.Adapter.UpdateCommand.Transaction = this._transaction;
|
|
}
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
|
|
get {
|
|
if ((this._commandCollection == null)) {
|
|
this.InitCommandCollection();
|
|
}
|
|
return this._commandCollection;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool ClearBeforeFill {
|
|
get {
|
|
return this._clearBeforeFill;
|
|
}
|
|
set {
|
|
this._clearBeforeFill = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private void InitAdapter() {
|
|
this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
|
|
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
|
|
tableMapping.SourceTable = "Table";
|
|
tableMapping.DataSetTable = "SummaryReport";
|
|
tableMapping.ColumnMappings.Add("Name", "Name");
|
|
tableMapping.ColumnMappings.Add("Scenario_Name", "Scenario_Name");
|
|
tableMapping.ColumnMappings.Add("ProjectedRevenue", "ProjectedRevenue");
|
|
tableMapping.ColumnMappings.Add("ExpectedGrossMargin", "ExpectedGrossMargin");
|
|
tableMapping.ColumnMappings.Add("CalculatedGrossMargin", "CalculatedGrossMargin");
|
|
tableMapping.ColumnMappings.Add("CalculatedGrossMargin_LM", "CalculatedGrossMargin_LM");
|
|
tableMapping.ColumnMappings.Add("StartDate", "StartDate");
|
|
tableMapping.ColumnMappings.Add("EndDate", "EndDate");
|
|
tableMapping.ColumnMappings.Add("TDDirectCosts", "TDDirectCosts");
|
|
tableMapping.ColumnMappings.Add("TDDirectCosts_LM", "TDDirectCosts_LM");
|
|
tableMapping.ColumnMappings.Add("BUDirectCosts", "BUDirectCosts");
|
|
tableMapping.ColumnMappings.Add("BUDirectCosts_LM", "BUDirectCosts_LM");
|
|
tableMapping.ColumnMappings.Add("CostSavings", "CostSavings");
|
|
tableMapping.ColumnMappings.Add("CostSavingsStartDate", "CostSavingsStartDate");
|
|
tableMapping.ColumnMappings.Add("TeamId", "TeamId");
|
|
tableMapping.ColumnMappings.Add("CostSavingsEndDate", "CostSavingsEndDate");
|
|
tableMapping.ColumnMappings.Add("CostSavingsType", "CostSavingsType");
|
|
tableMapping.ColumnMappings.Add("IsRevenueGenerating", "IsRevenueGenerating");
|
|
tableMapping.ColumnMappings.Add("Project_Name", "Project_Name");
|
|
tableMapping.ColumnMappings.Add("Priority", "Priority");
|
|
tableMapping.ColumnMappings.Add("Probability", "Probability");
|
|
tableMapping.ColumnMappings.Add("Deadline", "Deadline");
|
|
tableMapping.ColumnMappings.Add("Status_Name", "Status_Name");
|
|
tableMapping.ColumnMappings.Add("ScenarioId", "ScenarioId");
|
|
tableMapping.ColumnMappings.Add("ProjectId", "ProjectId");
|
|
tableMapping.ColumnMappings.Add("ProjectStatusId", "ProjectStatusId");
|
|
this._adapter.TableMappings.Add(tableMapping);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private void InitConnection() {
|
|
this._connection = new global::System.Data.SqlClient.SqlConnection();
|
|
this._connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private void InitCommandCollection() {
|
|
this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
|
|
this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
|
|
this._commandCollection[0].Connection = this.Connection;
|
|
this._commandCollection[0].CommandText = @"select t.Name, s.Name as Scenario_Name,
|
|
s.ProjectedRevenue,
|
|
s.ExpectedGrossMargin,
|
|
s.CalculatedGrossMargin,
|
|
s.CalculatedGrossMargin_LM, s.StartDate,
|
|
s.EndDate, s.TDDirectCosts,
|
|
s.TDDirectCosts_LM, s.BUDirectCosts,
|
|
s.BUDirectCosts_LM, s.CostSavings,
|
|
s.CostSavingsStartDate, t.id as TeamId,
|
|
s.CostSavingsEndDate, s.CostSavingsType,
|
|
p.IsRevenueGenerating, p.Name as Project_Name, p.Priority,
|
|
p.Probability, p.Deadline, st.Name as Status_Name, p.StatusId AS ProjectStatusId,
|
|
s.Id as ScenarioId, p.Id as ProjectId
|
|
from Project p,
|
|
Scenario s,
|
|
Team t,
|
|
Team2Project tp,
|
|
Status st
|
|
where t.Id = tp.TeamId
|
|
and p.Id = tp.ProjectId
|
|
and s.ParentId = p.Id
|
|
and st.Id = p.StatusId
|
|
";
|
|
this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
|
|
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
|
|
public virtual int Fill(ReportingDataSource.SummaryReportDataTable dataTable) {
|
|
this.Adapter.SelectCommand = this.CommandCollection[0];
|
|
if ((this.ClearBeforeFill == true)) {
|
|
dataTable.Clear();
|
|
}
|
|
int returnValue = this.Adapter.Fill(dataTable);
|
|
return returnValue;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
|
|
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
|
|
public virtual ReportingDataSource.SummaryReportDataTable GetData() {
|
|
this.Adapter.SelectCommand = this.CommandCollection[0];
|
|
ReportingDataSource.SummaryReportDataTable dataTable = new ReportingDataSource.SummaryReportDataTable();
|
|
this.Adapter.Fill(dataTable);
|
|
return dataTable;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Represents the connection and commands used to retrieve and save data.
|
|
///</summary>
|
|
[global::System.ComponentModel.DesignerCategoryAttribute("code")]
|
|
[global::System.ComponentModel.ToolboxItem(true)]
|
|
[global::System.ComponentModel.DataObjectAttribute(true)]
|
|
[global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
|
|
", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
|
|
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
|
|
public partial class StatusTableAdapter : global::System.ComponentModel.Component {
|
|
|
|
private global::System.Data.SqlClient.SqlDataAdapter _adapter;
|
|
|
|
private global::System.Data.SqlClient.SqlConnection _connection;
|
|
|
|
private global::System.Data.SqlClient.SqlTransaction _transaction;
|
|
|
|
private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
|
|
|
|
private bool _clearBeforeFill;
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public StatusTableAdapter() {
|
|
this.ClearBeforeFill = true;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
|
|
get {
|
|
if ((this._adapter == null)) {
|
|
this.InitAdapter();
|
|
}
|
|
return this._adapter;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
internal global::System.Data.SqlClient.SqlConnection Connection {
|
|
get {
|
|
if ((this._connection == null)) {
|
|
this.InitConnection();
|
|
}
|
|
return this._connection;
|
|
}
|
|
set {
|
|
this._connection = value;
|
|
if ((this.Adapter.InsertCommand != null)) {
|
|
this.Adapter.InsertCommand.Connection = value;
|
|
}
|
|
if ((this.Adapter.DeleteCommand != null)) {
|
|
this.Adapter.DeleteCommand.Connection = value;
|
|
}
|
|
if ((this.Adapter.UpdateCommand != null)) {
|
|
this.Adapter.UpdateCommand.Connection = value;
|
|
}
|
|
for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
|
|
if ((this.CommandCollection[i] != null)) {
|
|
((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
internal global::System.Data.SqlClient.SqlTransaction Transaction {
|
|
get {
|
|
return this._transaction;
|
|
}
|
|
set {
|
|
this._transaction = value;
|
|
for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
|
|
this.CommandCollection[i].Transaction = this._transaction;
|
|
}
|
|
if (((this.Adapter != null)
|
|
&& (this.Adapter.DeleteCommand != null))) {
|
|
this.Adapter.DeleteCommand.Transaction = this._transaction;
|
|
}
|
|
if (((this.Adapter != null)
|
|
&& (this.Adapter.InsertCommand != null))) {
|
|
this.Adapter.InsertCommand.Transaction = this._transaction;
|
|
}
|
|
if (((this.Adapter != null)
|
|
&& (this.Adapter.UpdateCommand != null))) {
|
|
this.Adapter.UpdateCommand.Transaction = this._transaction;
|
|
}
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
|
|
get {
|
|
if ((this._commandCollection == null)) {
|
|
this.InitCommandCollection();
|
|
}
|
|
return this._commandCollection;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool ClearBeforeFill {
|
|
get {
|
|
return this._clearBeforeFill;
|
|
}
|
|
set {
|
|
this._clearBeforeFill = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private void InitAdapter() {
|
|
this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
|
|
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
|
|
tableMapping.SourceTable = "Table";
|
|
tableMapping.DataSetTable = "Status";
|
|
tableMapping.ColumnMappings.Add("Id", "Id");
|
|
tableMapping.ColumnMappings.Add("Name", "Name");
|
|
tableMapping.ColumnMappings.Add("Color", "Color");
|
|
tableMapping.ColumnMappings.Add("IsSystem", "IsSystem");
|
|
tableMapping.ColumnMappings.Add("Probability100", "Probability100");
|
|
this._adapter.TableMappings.Add(tableMapping);
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private void InitConnection() {
|
|
this._connection = new global::System.Data.SqlClient.SqlConnection();
|
|
this._connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private void InitCommandCollection() {
|
|
this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
|
|
this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
|
|
this._commandCollection[0].Connection = this.Connection;
|
|
this._commandCollection[0].CommandText = "SELECT Id, Name, Color, IsSystem, Probability100\r\nFROM Status";
|
|
this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
|
|
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
|
|
public virtual int Fill(ReportingDataSource.StatusDataTable dataTable) {
|
|
this.Adapter.SelectCommand = this.CommandCollection[0];
|
|
if ((this.ClearBeforeFill == true)) {
|
|
dataTable.Clear();
|
|
}
|
|
int returnValue = this.Adapter.Fill(dataTable);
|
|
return returnValue;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
|
|
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
|
|
public virtual ReportingDataSource.StatusDataTable GetData() {
|
|
this.Adapter.SelectCommand = this.CommandCollection[0];
|
|
ReportingDataSource.StatusDataTable dataTable = new ReportingDataSource.StatusDataTable();
|
|
this.Adapter.Fill(dataTable);
|
|
return dataTable;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios
|
|
///</summary>
|
|
[global::System.ComponentModel.DesignerCategoryAttribute("code")]
|
|
[global::System.ComponentModel.ToolboxItem(true)]
|
|
[global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD" +
|
|
"esigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
|
|
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")]
|
|
public partial class TableAdapterManager : global::System.ComponentModel.Component {
|
|
|
|
private UpdateOrderOption _updateOrder;
|
|
|
|
private bool _backupDataSetBeforeUpdate;
|
|
|
|
private global::System.Data.IDbConnection _connection;
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public UpdateOrderOption UpdateOrder {
|
|
get {
|
|
return this._updateOrder;
|
|
}
|
|
set {
|
|
this._updateOrder = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public bool BackupDataSetBeforeUpdate {
|
|
get {
|
|
return this._backupDataSetBeforeUpdate;
|
|
}
|
|
set {
|
|
this._backupDataSetBeforeUpdate = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
[global::System.ComponentModel.Browsable(false)]
|
|
public global::System.Data.IDbConnection Connection {
|
|
get {
|
|
if ((this._connection != null)) {
|
|
return this._connection;
|
|
}
|
|
return null;
|
|
}
|
|
set {
|
|
this._connection = value;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
[global::System.ComponentModel.Browsable(false)]
|
|
public int TableAdapterInstanceCount {
|
|
get {
|
|
int count = 0;
|
|
return count;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Update rows in top-down order.
|
|
///</summary>
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private int UpdateUpdatedRows(ReportingDataSource dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
|
|
int result = 0;
|
|
return result;
|
|
}
|
|
|
|
/// <summary>
|
|
///Insert rows in top-down order.
|
|
///</summary>
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private int UpdateInsertedRows(ReportingDataSource dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
|
|
int result = 0;
|
|
return result;
|
|
}
|
|
|
|
/// <summary>
|
|
///Delete rows in bottom-up order.
|
|
///</summary>
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private int UpdateDeletedRows(ReportingDataSource dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows) {
|
|
int result = 0;
|
|
return result;
|
|
}
|
|
|
|
/// <summary>
|
|
///Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first
|
|
///</summary>
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
|
|
if (((updatedRows == null)
|
|
|| (updatedRows.Length < 1))) {
|
|
return updatedRows;
|
|
}
|
|
if (((allAddedRows == null)
|
|
|| (allAddedRows.Count < 1))) {
|
|
return updatedRows;
|
|
}
|
|
global::System.Collections.Generic.List<global::System.Data.DataRow> realUpdatedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
|
|
for (int i = 0; (i < updatedRows.Length); i = (i + 1)) {
|
|
global::System.Data.DataRow row = updatedRows[i];
|
|
if ((allAddedRows.Contains(row) == false)) {
|
|
realUpdatedRows.Add(row);
|
|
}
|
|
}
|
|
return realUpdatedRows.ToArray();
|
|
}
|
|
|
|
/// <summary>
|
|
///Update all changes to the dataset.
|
|
///</summary>
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public virtual int UpdateAll(ReportingDataSource dataSet) {
|
|
if ((dataSet == null)) {
|
|
throw new global::System.ArgumentNullException("dataSet");
|
|
}
|
|
if ((dataSet.HasChanges() == false)) {
|
|
return 0;
|
|
}
|
|
global::System.Data.IDbConnection workConnection = this.Connection;
|
|
if ((workConnection == null)) {
|
|
throw new global::System.ApplicationException("TableAdapterManager contains no connection information. Set each TableAdapterMana" +
|
|
"ger TableAdapter property to a valid TableAdapter instance.");
|
|
}
|
|
bool workConnOpened = false;
|
|
if (((workConnection.State & global::System.Data.ConnectionState.Broken)
|
|
== global::System.Data.ConnectionState.Broken)) {
|
|
workConnection.Close();
|
|
}
|
|
if ((workConnection.State == global::System.Data.ConnectionState.Closed)) {
|
|
workConnection.Open();
|
|
workConnOpened = true;
|
|
}
|
|
global::System.Data.IDbTransaction workTransaction = workConnection.BeginTransaction();
|
|
if ((workTransaction == null)) {
|
|
throw new global::System.ApplicationException("The transaction cannot begin. The current data connection does not support transa" +
|
|
"ctions or the current state is not allowing the transaction to begin.");
|
|
}
|
|
global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
|
|
global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
|
|
global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter> adaptersWithAcceptChangesDuringUpdate = new global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter>();
|
|
global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection> revertConnections = new global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection>();
|
|
int result = 0;
|
|
global::System.Data.DataSet backupDataSet = null;
|
|
if (this.BackupDataSetBeforeUpdate) {
|
|
backupDataSet = new global::System.Data.DataSet();
|
|
backupDataSet.Merge(dataSet);
|
|
}
|
|
try {
|
|
// ---- Prepare for update -----------
|
|
//
|
|
//
|
|
//---- Perform updates -----------
|
|
//
|
|
if ((this.UpdateOrder == UpdateOrderOption.UpdateInsertDelete)) {
|
|
result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
|
|
result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
|
|
}
|
|
else {
|
|
result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
|
|
result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
|
|
}
|
|
result = (result + this.UpdateDeletedRows(dataSet, allChangedRows));
|
|
//
|
|
//---- Commit updates -----------
|
|
//
|
|
workTransaction.Commit();
|
|
if ((0 < allAddedRows.Count)) {
|
|
global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
|
|
allAddedRows.CopyTo(rows);
|
|
for (int i = 0; (i < rows.Length); i = (i + 1)) {
|
|
global::System.Data.DataRow row = rows[i];
|
|
row.AcceptChanges();
|
|
}
|
|
}
|
|
if ((0 < allChangedRows.Count)) {
|
|
global::System.Data.DataRow[] rows = new System.Data.DataRow[allChangedRows.Count];
|
|
allChangedRows.CopyTo(rows);
|
|
for (int i = 0; (i < rows.Length); i = (i + 1)) {
|
|
global::System.Data.DataRow row = rows[i];
|
|
row.AcceptChanges();
|
|
}
|
|
}
|
|
}
|
|
catch (global::System.Exception ex) {
|
|
workTransaction.Rollback();
|
|
// ---- Restore the dataset -----------
|
|
if (this.BackupDataSetBeforeUpdate) {
|
|
global::System.Diagnostics.Debug.Assert((backupDataSet != null));
|
|
dataSet.Clear();
|
|
dataSet.Merge(backupDataSet);
|
|
}
|
|
else {
|
|
if ((0 < allAddedRows.Count)) {
|
|
global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
|
|
allAddedRows.CopyTo(rows);
|
|
for (int i = 0; (i < rows.Length); i = (i + 1)) {
|
|
global::System.Data.DataRow row = rows[i];
|
|
row.AcceptChanges();
|
|
row.SetAdded();
|
|
}
|
|
}
|
|
}
|
|
throw ex;
|
|
}
|
|
finally {
|
|
if (workConnOpened) {
|
|
workConnection.Close();
|
|
}
|
|
if ((0 < adaptersWithAcceptChangesDuringUpdate.Count)) {
|
|
global::System.Data.Common.DataAdapter[] adapters = new System.Data.Common.DataAdapter[adaptersWithAcceptChangesDuringUpdate.Count];
|
|
adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters);
|
|
for (int i = 0; (i < adapters.Length); i = (i + 1)) {
|
|
global::System.Data.Common.DataAdapter adapter = adapters[i];
|
|
adapter.AcceptChangesDuringUpdate = true;
|
|
}
|
|
}
|
|
}
|
|
return result;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected virtual void SortSelfReferenceRows(global::System.Data.DataRow[] rows, global::System.Data.DataRelation relation, bool childFirst) {
|
|
global::System.Array.Sort<global::System.Data.DataRow>(rows, new SelfReferenceComparer(relation, childFirst));
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
protected virtual bool MatchTableAdapterConnection(global::System.Data.IDbConnection inputConnection) {
|
|
if ((this._connection != null)) {
|
|
return true;
|
|
}
|
|
if (((this.Connection == null)
|
|
|| (inputConnection == null))) {
|
|
return true;
|
|
}
|
|
if (string.Equals(this.Connection.ConnectionString, inputConnection.ConnectionString, global::System.StringComparison.Ordinal)) {
|
|
return true;
|
|
}
|
|
return false;
|
|
}
|
|
|
|
/// <summary>
|
|
///Update Order Option
|
|
///</summary>
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public enum UpdateOrderOption {
|
|
|
|
InsertUpdateDelete = 0,
|
|
|
|
UpdateInsertDelete = 1,
|
|
}
|
|
|
|
/// <summary>
|
|
///Used to sort self-referenced table's rows
|
|
///</summary>
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private class SelfReferenceComparer : object, global::System.Collections.Generic.IComparer<global::System.Data.DataRow> {
|
|
|
|
private global::System.Data.DataRelation _relation;
|
|
|
|
private int _childFirst;
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
internal SelfReferenceComparer(global::System.Data.DataRelation relation, bool childFirst) {
|
|
this._relation = relation;
|
|
if (childFirst) {
|
|
this._childFirst = -1;
|
|
}
|
|
else {
|
|
this._childFirst = 1;
|
|
}
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
private global::System.Data.DataRow GetRoot(global::System.Data.DataRow row, out int distance) {
|
|
global::System.Diagnostics.Debug.Assert((row != null));
|
|
global::System.Data.DataRow root = row;
|
|
distance = 0;
|
|
|
|
global::System.Collections.Generic.IDictionary<global::System.Data.DataRow, global::System.Data.DataRow> traversedRows = new global::System.Collections.Generic.Dictionary<global::System.Data.DataRow, global::System.Data.DataRow>();
|
|
traversedRows[row] = row;
|
|
|
|
global::System.Data.DataRow parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
|
|
for (
|
|
; ((parent != null)
|
|
&& (traversedRows.ContainsKey(parent) == false));
|
|
) {
|
|
distance = (distance + 1);
|
|
root = parent;
|
|
traversedRows[parent] = parent;
|
|
parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
|
|
}
|
|
|
|
if ((distance == 0)) {
|
|
traversedRows.Clear();
|
|
traversedRows[row] = row;
|
|
parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
|
|
for (
|
|
; ((parent != null)
|
|
&& (traversedRows.ContainsKey(parent) == false));
|
|
) {
|
|
distance = (distance + 1);
|
|
root = parent;
|
|
traversedRows[parent] = parent;
|
|
parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
|
|
}
|
|
}
|
|
|
|
return root;
|
|
}
|
|
|
|
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
|
|
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
|
|
public int Compare(global::System.Data.DataRow row1, global::System.Data.DataRow row2) {
|
|
if (object.ReferenceEquals(row1, row2)) {
|
|
return 0;
|
|
}
|
|
if ((row1 == null)) {
|
|
return -1;
|
|
}
|
|
if ((row2 == null)) {
|
|
return 1;
|
|
}
|
|
|
|
int distance1 = 0;
|
|
global::System.Data.DataRow root1 = this.GetRoot(row1, out distance1);
|
|
|
|
int distance2 = 0;
|
|
global::System.Data.DataRow root2 = this.GetRoot(row2, out distance2);
|
|
|
|
if (object.ReferenceEquals(root1, root2)) {
|
|
return (this._childFirst * distance1.CompareTo(distance2));
|
|
}
|
|
else {
|
|
global::System.Diagnostics.Debug.Assert(((root1.Table != null)
|
|
&& (root2.Table != null)));
|
|
if ((root1.Table.Rows.IndexOf(root1) < root2.Table.Rows.IndexOf(root2))) {
|
|
return -1;
|
|
}
|
|
else {
|
|
return 1;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
#pragma warning restore 1591 |