/// <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="PrimaryKey">Primary key of the record you want to be selected 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 PrimaryKey, int startRecord, int maxRecords)
{
if (this.LastKnownConnectionType == OlymarsDemo.DataClasses.ConnectionType.None)
{
throw new InvalidOperationException("You must call the 'Initialize' method before calling this method.");
}
this.param = new Params.spS_tblCustomer();
switch (this.LastKnownConnectionType)
{
case OlymarsDemo.DataClasses.ConnectionType.ConnectionString:
this.param.SetUpConnection(this.connectionString);
break;
case OlymarsDemo.DataClasses.ConnectionType.SqlConnection:
this.param.SetUpConnection(this.sqlConnection);
break;
}
this.param.CommandTimeOut = this.commandTimeOut;
if (!this.param_Cus_LngID.IsNull)
{
this.param.Param_Cus_LngID = this.param_Cus_LngID;
}
System.Data.DataSet DS = null;
SPs.spS_tblCustomer SP = new SPs.spS_tblCustomer();
if (SP.Execute(ref this.param, ref DS, startRecord, maxRecords))
{
this.DataSource = DS.Tables[this.tableName].DefaultView;
this.DataValueField = this.valueMember;
this.DataTextField = this.displayMember;
if (this.doDataBindAfterRefreshData)
{
this.DataBind();
}
if (PrimaryKey != null)
{
System.Web.UI.WebControls.ListItem listItem = this.Items.FindByValue(Convert.ToString(PrimaryKey));
if (listItem != null)
{
listItem.Selected = true;
}
}
}
else
{
SP.Dispose();
throw new OlymarsDemo.DataClasses.CustomException(this.param, "WebDropDownListCustom_spS_tblCustomer", "RefreshData");
}
}
public Tables.tblCustomer_Record GetOne_tblCustomer_Record(Int32 id)
{
Params.spS_tblCustomer param = new Params.spS_tblCustomer(true);
param.SetUpConnection(string.Empty);
param.Param_Cus_LngID = id;
using (SPs.spS_tblCustomer sp = new SPs.spS_tblCustomer(true)) {
System.Data.SqlClient.SqlDataReader sqlDataReader = null;
sp.Execute(ref param, out sqlDataReader);
param.Dispose();
if (sqlDataReader.Read())
{
Tables.tblCustomer_Record record = new Tables.tblCustomer_Record();
record.Col_Cus_LngID.UseNull = sqlDataReader.IsDBNull(SPs.spS_tblCustomer.Resultset1.Fields.Column_Cus_LngID.ColumnIndex);
if (!record.Col_Cus_LngID.UseNull)
{
record.Col_Cus_LngID.Value = sqlDataReader.GetSqlInt32(SPs.spS_tblCustomer.Resultset1.Fields.Column_Cus_LngID.ColumnIndex).Value;
}
record.Customer_Surname.UseNull = sqlDataReader.IsDBNull(SPs.spS_tblCustomer.Resultset1.Fields.Column_Cus_StrLastName.ColumnIndex);
if (!record.Customer_Surname.UseNull)
{
record.Customer_Surname.Value = sqlDataReader.GetSqlString(SPs.spS_tblCustomer.Resultset1.Fields.Column_Cus_StrLastName.ColumnIndex).Value;
}
record.Col_Cus_StrFirstName.UseNull = sqlDataReader.IsDBNull(SPs.spS_tblCustomer.Resultset1.Fields.Column_Cus_StrFirstName.ColumnIndex);
if (!record.Col_Cus_StrFirstName.UseNull)
{
record.Col_Cus_StrFirstName.Value = sqlDataReader.GetSqlString(SPs.spS_tblCustomer.Resultset1.Fields.Column_Cus_StrFirstName.ColumnIndex).Value;
}
record.Col_Cus_StrEmail.UseNull = sqlDataReader.IsDBNull(SPs.spS_tblCustomer.Resultset1.Fields.Column_Cus_StrEmail.ColumnIndex);
if (!record.Col_Cus_StrEmail.UseNull)
{
record.Col_Cus_StrEmail.Value = sqlDataReader.GetSqlString(SPs.spS_tblCustomer.Resultset1.Fields.Column_Cus_StrEmail.ColumnIndex).Value;
}
sqlDataReader.Close();
sp.Connection.Close();
return(record);
}
else
{
sqlDataReader.Close();
sp.Connection.Close();
return(null);
}
}
}
/// <summary>
/// Create a new instance of the Abstract_tblCustomer class.
/// </summary>
/// <param name="connectionString">A valid connection string to the database.</param>
public Abstract_tblCustomer(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 = OlymarsDemo.DataClasses.Information.GetConnectionStringFromConfigurationFile;
}
if (DebugConnectionString.Length == 0)
{
DebugConnectionString = OlymarsDemo.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 = 'tblCustomer'";
int CurrentRevision = (int)sqlCommand.ExecuteScalar();
sqlConnection.Close();
int OriginalRevision = ((OlymarsDemo.DataClasses.OlymarsInformationAttribute)System.Attribute.GetCustomAttribute(this.GetType(), typeof(OlymarsDemo.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.", "tblCustomer", CurrentRevision, OriginalRevision, System.Environment.NewLine));
}
}
}
#endif
this.Param = new Params.spS_tblCustomer(true);
this.Param.SetUpConnection(connectionString);
}
/// <summary>
/// Load or reloads a subset of the table content. In order to successfully call this method, you need to call first
/// the Initialize method.
/// </summary>
/// <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(int startRecord, int maxRecords)
{
if (this.LastKnownConnectionType == OlymarsDemo.DataClasses.ConnectionType.None)
{
throw new InvalidOperationException("You must call the 'Initialize' method before calling this method.");
}
this.param = new Params.spS_tblCustomer(true);
switch (this.LastKnownConnectionType)
{
case OlymarsDemo.DataClasses.ConnectionType.ConnectionString:
this.param.SetUpConnection(this.connectionString);
break;
case OlymarsDemo.DataClasses.ConnectionType.SqlConnection:
this.param.SetUpConnection(this.sqlConnection);
break;
}
System.Data.DataSet DS = null;
SPs.spS_tblCustomer SP = new SPs.spS_tblCustomer(false);
if (SP.Execute(ref this.param, ref DS, startRecord, maxRecords))
{
this.DataSource = DS.Tables["spS_tblCustomer"].DefaultView;
this.DataKeyField = "Cus_LngID";
if (this.doDataBindAfterRefreshData)
{
this.DataBind();
}
SP.Dispose();
}
else
{
SP.Dispose();
throw new OlymarsDemo.DataClasses.CustomException(this.param, "WebDataGrid_tblCustomer : System.Web.UI.WebControls.DataGrid", "RefreshData");
}
}
/// <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="PrimaryKey">Primary key of the record you want to be selected 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 PrimaryKey, int startRecord, int maxRecords)
{
this.CreateControl();
if (this.LastKnownConnectionType == OlymarsDemo.DataClasses.ConnectionType.None)
{
throw new InvalidOperationException("You must call the 'Initialize' method before calling this method.");
}
this.param = new Params.spS_tblCustomer();
switch (this.LastKnownConnectionType)
{
case OlymarsDemo.DataClasses.ConnectionType.ConnectionString:
this.param.SetUpConnection(this.connectionString);
break;
case OlymarsDemo.DataClasses.ConnectionType.SqlConnection:
this.param.SetUpConnection(this.sqlConnection);
break;
}
this.param.CommandTimeOut = this.commandTimeOut;
if (!this.param_Cus_LngID.IsNull)
{
this.param.Param_Cus_LngID = this.param_Cus_LngID;
}
System.Data.DataSet DS = null;
SPs.spS_tblCustomer SP = new SPs.spS_tblCustomer();
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 (PrimaryKey != null)
{
this.SelectedValue = PrimaryKey;
}
else
{
base.OnSelectedIndexChanged(EventArgs.Empty);
}
this.EndUpdate();
SP.Dispose();
}
else
{
SP.Dispose();
throw new OlymarsDemo.DataClasses.CustomException(this.param, "WinListBoxCustom_spS_tblCustomer", "RefreshData");
}
}
/// <summary>
/// [To be supplied.]
/// </summary>
/// <returns>[To be supplied.]</returns>
public bool Refresh()
{
this.displayName = null;
this.col_Cus_StrLastNameWasUpdated = false;
this.col_Cus_StrLastNameWasSet = false;
this.col_Cus_StrLastName = System.Data.SqlTypes.SqlString.Null;
this.col_Cus_StrFirstNameWasUpdated = false;
this.col_Cus_StrFirstNameWasSet = false;
this.col_Cus_StrFirstName = System.Data.SqlTypes.SqlString.Null;
this.col_Cus_StrEmailWasUpdated = false;
this.col_Cus_StrEmailWasSet = false;
this.col_Cus_StrEmail = System.Data.SqlTypes.SqlString.Null;
bool alreadyOpened = false;
Params.spS_tblCustomer Param = new Params.spS_tblCustomer(true);
Param.CommandTimeOut = this.selectCommandTimeOut;
switch (this.lastKnownConnectionType)
{
case OlymarsDemo.DataClasses.ConnectionType.ConnectionString:
Param.SetUpConnection(this.connectionString);
break;
case OlymarsDemo.DataClasses.ConnectionType.SqlConnection:
Param.SetUpConnection(this.sqlConnection);
alreadyOpened = (this.sqlConnection.State == System.Data.ConnectionState.Open);
break;
case OlymarsDemo.DataClasses.ConnectionType.SqlTransaction:
Param.SetUpConnection(this.sqlTransaction);
break;
}
if (!this.col_Cus_LngID.IsNull)
{
Param.Param_Cus_LngID = this.col_Cus_LngID;
}
System.Data.SqlClient.SqlDataReader sqlDataReader = null;
SPs.spS_tblCustomer Sp = new SPs.spS_tblCustomer(false);
if (Sp.Execute(ref Param, out sqlDataReader))
{
if (sqlDataReader.Read())
{
if (!sqlDataReader.IsDBNull(SPs.spS_tblCustomer.Resultset1.Fields.Column_Cus_StrLastName.ColumnIndex))
{
this.col_Cus_StrLastName = sqlDataReader.GetSqlString(SPs.spS_tblCustomer.Resultset1.Fields.Column_Cus_StrLastName.ColumnIndex);
}
if (!sqlDataReader.IsDBNull(SPs.spS_tblCustomer.Resultset1.Fields.Column_Cus_StrFirstName.ColumnIndex))
{
this.col_Cus_StrFirstName = sqlDataReader.GetSqlString(SPs.spS_tblCustomer.Resultset1.Fields.Column_Cus_StrFirstName.ColumnIndex);
}
if (!sqlDataReader.IsDBNull(SPs.spS_tblCustomer.Resultset1.Fields.Column_Cus_StrEmail.ColumnIndex))
{
this.col_Cus_StrEmail = sqlDataReader.GetSqlString(SPs.spS_tblCustomer.Resultset1.Fields.Column_Cus_StrEmail.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 OlymarsDemo.DataClasses.CustomException(Param, "OlymarsDemo.BusinessComponents.tblCustomer_Record", "Refresh");
}
}
