private static void LoadEventSentEmail(EventRow eventRow, EventDataTable systemEvent, int sentEmailID)
{
BulkLoader bulkLoader;
DataTable eventSentEmailTable;
using (AdoDataConnection connection = new AdoDataConnection(s_dbAdapterContainer.Connection, typeof(SqlDataAdapter), false))
{
// Query an empty table with matching schema --
// union table to itself to eliminate unique key constraints
eventSentEmailTable = connection.RetrieveData("SELECT * FROM EventSentEmail WHERE 1 IS NULL UNION ALL SELECT * FROM EventSentEmail WHERE 1 IS NULL");
eventSentEmailTable.TableName = "EventSentEmail";
}
foreach (MeterData.EventRow evt in systemEvent)
{
if (eventRow.LineID == evt.LineID)
{
eventSentEmailTable.Rows.Add(0, evt.ID, sentEmailID);
}
}
bulkLoader = new BulkLoader();
bulkLoader.Connection = s_dbAdapterContainer.Connection;
bulkLoader.CommandTimeout = s_dbAdapterContainer.CommandTimeout;
bulkLoader.Load(eventSentEmailTable);
}
public override global::System.Data.DataTable Clone()
{
EventDataTable cln = ((EventDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
private void InitClass()
{
this.DataSetName = "SAPDataSetEvent";
this.Prefix = "";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableEvent = new EventDataTable();
base.Tables.Add(this.tableEvent);
}
private void InitClass()
{
this.DataSetName = "Events";
this.Prefix = "";
this.Namespace = "http://tempuri.org/Events.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableEvent = new EventDataTable();
base.Tables.Add(this.tableEvent);
}
private void InitClass()
{
this.DataSetName = "EventsDataSet";
this.Prefix = "";
this.Namespace = "http://schemas.microsoft.com/office/project/server/webservices/EventsDataSet/";
this.EnforceConstraints = false;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableEvent = new EventDataTable();
base.Tables.Add(this.tableEvent);
}
internal void InitVars(bool initTable)
{
this.tableEvent = ((EventDataTable)(base.Tables["Event"]));
if ((initTable == true))
{
if ((this.tableEvent != null))
{
this.tableEvent.InitVars();
}
}
}
internal EventRow(global::System.Data.DataRowBuilder rb) :
base(rb)
{
this.tableEvent = ((EventDataTable)(this.Table));
}
private static void LoadEventSentEmail(EventRow eventRow, EventDataTable systemEvent, int sentEmailID)
{
BulkLoader bulkLoader;
DataTable eventSentEmailTable;
using (AdoDataConnection connection = new AdoDataConnection(s_dbAdapterContainer.Connection, typeof(SqlDataAdapter), false))
{
// Query an empty table with matching schema --
// union table to itself to eliminate unique key constraints
eventSentEmailTable = connection.RetrieveData("SELECT * FROM EventSentEmail WHERE 1 IS NULL UNION ALL SELECT * FROM EventSentEmail WHERE 1 IS NULL");
eventSentEmailTable.TableName = "EventSentEmail";
}
foreach (MeterData.EventRow evt in systemEvent)
{
if (eventRow.LineID == evt.LineID)
eventSentEmailTable.Rows.Add(0, evt.ID, sentEmailID);
}
bulkLoader = new BulkLoader();
bulkLoader.Connection = s_dbAdapterContainer.Connection;
bulkLoader.CommandTimeout = s_dbAdapterContainer.CommandTimeout;
bulkLoader.Load(eventSentEmailTable);
}
