/// <summary>
/// Create a new instance of the Abstract_Job class.
/// </summary>
/// <param name="connectionString">A valid connection string to the database.</param>
public Abstract_Job(string connectionString)
{
if (connectionString == null)
{
throw new ArgumentNullException("connectionString", "connectionString can be an empty string but can not be null.");
}
#if OLYMARS_DEBUG
object olymarsDebugCheck = System.Configuration.ConfigurationSettings.AppSettings["OlymarsDebugCheck"];
if (olymarsDebugCheck == null || (string)olymarsDebugCheck == "True")
{
string DebugConnectionString = connectionString;
if (DebugConnectionString.Length == 0)
{
DebugConnectionString = Bob.DataClasses.Information.GetConnectionStringFromConfigurationFile;
}
if (DebugConnectionString.Length == 0)
{
DebugConnectionString = Bob.DataClasses.Information.GetConnectionStringFromRegistry;
}
if (DebugConnectionString.Length != 0)
{
System.Data.SqlClient.SqlConnection sqlConnection = new System.Data.SqlClient.SqlConnection(DebugConnectionString);
sqlConnection.Open();
System.Data.SqlClient.SqlCommand sqlCommand = sqlConnection.CreateCommand();
sqlCommand.CommandType = System.Data.CommandType.Text;
sqlCommand.CommandText = "Select sysobjects.schema_ver from sysobjects where sysobjects.name = 'Job'";
int CurrentRevision = (int)sqlCommand.ExecuteScalar();
sqlConnection.Close();
int OriginalRevision = ((Bob.DataClasses.OlymarsInformationAttribute)System.Attribute.GetCustomAttribute(this.GetType(), typeof(Bob.DataClasses.OlymarsInformationAttribute), false)).SqlObjectDependancyRevision;
if (CurrentRevision != OriginalRevision)
{
throw new System.InvalidOperationException(System.String.Format("OLYMARS: This code is not in sync anymore with [{0}]. It was generated when [{0}] version was: {2}. Current [{0}] version is: {1}{3}{3}You can either regenerate the code for this class so that it will be based on the new version or edit the configuration file of the class caller application and paste the following code:{3}{3}<?xml version=\"1.0\" encoding=\"utf-8\" ?>{3}<configuration>{3}\t<appSettings>{3}\t\t<add key=\"OlymarsDebugCheck\" value=\"False\" />{3}\t</appSettings>{3}</configuration>{3}{3}You will need to reload the caller application if it is a Windows Forms based application.", "Job", CurrentRevision, OriginalRevision, System.Environment.NewLine));
}
}
}
#endif
this.Param = new Params.spS_Job(true);
this.Param.SetUpConnection(connectionString);
}
/// <summary>
/// Load or reloads a subset of the chosen resultset returned by the stored procedure.
/// You can specify which record you want to be checked by default.
/// </summary>
/// <param name="ArrayOf_PrimaryKeys">Primary keys of the records you want to be checked by default.</param>
/// <param name="startRecord">The zero-based record number to start with.</param>
/// <param name="maxRecords">The maximum number of records to retrieve.</param>
public void RefreshData(object[] ArrayOf_PrimaryKeys, int startRecord, int maxRecords)
{
this.CreateControl();
if (this.LastKnownConnectionType == Bob.DataClasses.ConnectionType.None)
{
throw new InvalidOperationException("You must call the 'Initialize' method before calling this method.");
}
this.param = new Params.spS_Job();
switch (this.LastKnownConnectionType)
{
case Bob.DataClasses.ConnectionType.ConnectionString:
this.param.SetUpConnection(this.connectionString);
break;
case Bob.DataClasses.ConnectionType.SqlConnection:
this.param.SetUpConnection(this.sqlConnection);
break;
}
this.param.CommandTimeOut = this.commandTimeOut;
if (!this.param_JobId.IsNull)
{
this.param.Param_JobId = this.param_JobId;
}
if (!this.param_CustomerId.IsNull)
{
this.param.Param_CustomerId = this.param_CustomerId;
}
System.Data.DataSet DS = null;
SPs.spS_Job SP = new SPs.spS_Job();
if (SP.Execute(ref this.param, ref DS, startRecord, maxRecords))
{
this.BeginUpdate();
this.bindingInProgress = true;
this.DataSource = DS.Tables[this.tableName].DefaultView;
this.ValueMember = this.valueMember;
this.DisplayMember = this.displayMember;
this.bindingInProgress = false;
if (ArrayOf_PrimaryKeys != null && ArrayOf_PrimaryKeys.Length > 0)
{
this.SetRecordsCheckState(ArrayOf_PrimaryKeys, System.Windows.Forms.CheckState.Checked);
}
else
{
base.OnSelectedIndexChanged(EventArgs.Empty);
}
this.EndUpdate();
SP.Dispose();
}
else
{
SP.Dispose();
throw new Bob.DataClasses.CustomException(this.param, "WinCheckedListBoxCustom_spS_Job", "RefreshData");
}
}
/// <summary>
/// [To be supplied.]
/// </summary>
/// <returns>[To be supplied.]</returns>
public bool Refresh()
{
this.displayName = null;
this.col_DescriptionWasUpdated = false;
this.col_DescriptionWasSet = false;
this.col_Description = System.Data.SqlTypes.SqlString.Null;
this.col_PriceWasUpdated = false;
this.col_PriceWasSet = false;
this.col_Price = System.Data.SqlTypes.SqlMoney.Null;
this.col_StartDateWasUpdated = false;
this.col_StartDateWasSet = false;
this.col_StartDate = System.Data.SqlTypes.SqlDateTime.Null;
this.col_EndDateWasUpdated = false;
this.col_EndDateWasSet = false;
this.col_EndDate = System.Data.SqlTypes.SqlDateTime.Null;
this.col_CustomerIdWasUpdated = false;
this.col_CustomerIdWasSet = false;
this.col_CustomerId = System.Data.SqlTypes.SqlInt32.Null;
bool alreadyOpened = false;
Params.spS_Job Param = new Params.spS_Job(true);
Param.CommandTimeOut = this.selectCommandTimeOut;
switch (this.lastKnownConnectionType)
{
case Bob.DataClasses.ConnectionType.ConnectionString:
Param.SetUpConnection(this.connectionString);
break;
case Bob.DataClasses.ConnectionType.SqlConnection:
Param.SetUpConnection(this.sqlConnection);
alreadyOpened = (this.sqlConnection.State == System.Data.ConnectionState.Open);
break;
case Bob.DataClasses.ConnectionType.SqlTransaction:
Param.SetUpConnection(this.sqlTransaction);
break;
}
if (!this.col_JobId.IsNull)
{
Param.Param_JobId = this.col_JobId;
}
System.Data.SqlClient.SqlDataReader sqlDataReader = null;
SPs.spS_Job Sp = new SPs.spS_Job(false);
if (Sp.Execute(ref Param, out sqlDataReader))
{
if (sqlDataReader.Read())
{
if (!sqlDataReader.IsDBNull(SPs.spS_Job.Resultset1.Fields.Column_Description.ColumnIndex))
{
this.col_Description = sqlDataReader.GetSqlString(SPs.spS_Job.Resultset1.Fields.Column_Description.ColumnIndex);
}
if (!sqlDataReader.IsDBNull(SPs.spS_Job.Resultset1.Fields.Column_Price.ColumnIndex))
{
this.col_Price = sqlDataReader.GetSqlMoney(SPs.spS_Job.Resultset1.Fields.Column_Price.ColumnIndex);
}
if (!sqlDataReader.IsDBNull(SPs.spS_Job.Resultset1.Fields.Column_StartDate.ColumnIndex))
{
this.col_StartDate = sqlDataReader.GetSqlDateTime(SPs.spS_Job.Resultset1.Fields.Column_StartDate.ColumnIndex);
}
if (!sqlDataReader.IsDBNull(SPs.spS_Job.Resultset1.Fields.Column_EndDate.ColumnIndex))
{
this.col_EndDate = sqlDataReader.GetSqlDateTime(SPs.spS_Job.Resultset1.Fields.Column_EndDate.ColumnIndex);
}
if (!sqlDataReader.IsDBNull(SPs.spS_Job.Resultset1.Fields.Column_CustomerId.ColumnIndex))
{
this.col_CustomerId = sqlDataReader.GetSqlInt32(SPs.spS_Job.Resultset1.Fields.Column_CustomerId.ColumnIndex);
}
if (sqlDataReader != null && !sqlDataReader.IsClosed)
{
sqlDataReader.Close();
}
CloseConnection(Sp.Connection, alreadyOpened);
this.recordIsLoaded = true;
return(true);
}
else
{
if (sqlDataReader != null && !sqlDataReader.IsClosed)
{
sqlDataReader.Close();
}
CloseConnection(Sp.Connection, alreadyOpened);
this.recordIsLoaded = false;
return(false);
}
}
else
{
if (sqlDataReader != null && !sqlDataReader.IsClosed)
{
sqlDataReader.Close();
}
CloseConnection(Sp.Connection, alreadyOpened);
throw new Bob.DataClasses.CustomException(Param, "Bob.BusinessComponents.Job_Record", "Refresh");
}
}