public virtual int Fill(MaterialsFooterData.GetMaterialFooterDataTable dataTable, global::System.Nullable <int> EventID, global::System.Nullable <int> FormID)
{
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((EventID.HasValue == true))
{
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(EventID.Value));
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((FormID.HasValue == true))
{
this.Adapter.SelectCommand.Parameters[2].Value = ((int)(FormID.Value));
}
else
{
this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
}
if ((this.ClearBeforeFill == true))
{
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return(returnValue);
}
public virtual MaterialsFooterData.GetMaterialFooterDataTable GetData(global::System.Nullable <int> EventID, global::System.Nullable <int> FormID)
{
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((EventID.HasValue == true))
{
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(EventID.Value));
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((FormID.HasValue == true))
{
this.Adapter.SelectCommand.Parameters[2].Value = ((int)(FormID.Value));
}
else
{
this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
}
MaterialsFooterData.GetMaterialFooterDataTable dataTable = new MaterialsFooterData.GetMaterialFooterDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
