private static SO_vFOR_Message[] getRecord(
DataTable dataTable_in
) {
DataColumn _dc_idmessage = null;
DataColumn _dc_idmessage__parent = null;
DataColumn _dc_isthread = null;
DataColumn _dc_issticky = null;
DataColumn _dc_subject = null;
DataColumn _dc_message__charvar8000 = null;
DataColumn _dc_message__text = null;
DataColumn _dc_iduser = null;
DataColumn _dc_name = null;
DataColumn _dc_publish_date = null;
DataColumn _dc_ifapplication = null;
DataColumn _dc_login = null;
SO_vFOR_Message[] _output
= new SO_vFOR_Message[dataTable_in.Rows.Count];
for (int r = 0; r < dataTable_in.Rows.Count; r++) {
if (r == 0) {
_dc_idmessage = dataTable_in.Columns["IDMessage"];
_dc_idmessage__parent = dataTable_in.Columns["IDMessage__parent"];
_dc_isthread = dataTable_in.Columns["isThread"];
_dc_issticky = dataTable_in.Columns["isSticky"];
_dc_subject = dataTable_in.Columns["Subject"];
_dc_message__charvar8000 = dataTable_in.Columns["Message__charvar8000"];
_dc_message__text = dataTable_in.Columns["Message__text"];
_dc_iduser = dataTable_in.Columns["IDUser"];
_dc_name = dataTable_in.Columns["Name"];
_dc_publish_date = dataTable_in.Columns["Publish_date"];
_dc_ifapplication = dataTable_in.Columns["IFApplication"];
_dc_login = dataTable_in.Columns["Login"];
}
_output[r] = new SO_vFOR_Message();
if (dataTable_in.Rows[r][_dc_idmessage] == System.DBNull.Value) {
_output[r].idmessage_ = 0L;
} else {
_output[r].idmessage_ = (long)dataTable_in.Rows[r][_dc_idmessage];
}
if (dataTable_in.Rows[r][_dc_idmessage__parent] == System.DBNull.Value) {
_output[r].IDMessage__parent_isNull = true;
} else {
_output[r].idmessage__parent_ = (long)dataTable_in.Rows[r][_dc_idmessage__parent];
}
if (dataTable_in.Rows[r][_dc_isthread] == System.DBNull.Value) {
_output[r].isThread_isNull = true;
} else {
_output[r].isthread_ = (bool)dataTable_in.Rows[r][_dc_isthread];
}
if (dataTable_in.Rows[r][_dc_issticky] == System.DBNull.Value) {
_output[r].isSticky_isNull = true;
} else {
_output[r].issticky_ = (bool)dataTable_in.Rows[r][_dc_issticky];
}
if (dataTable_in.Rows[r][_dc_subject] == System.DBNull.Value) {
_output[r].Subject_isNull = true;
} else {
_output[r].subject_ = (string)dataTable_in.Rows[r][_dc_subject];
}
if (dataTable_in.Rows[r][_dc_message__charvar8000] == System.DBNull.Value) {
_output[r].Message__charvar8000_isNull = true;
} else {
_output[r].message__charvar8000_ = (string)dataTable_in.Rows[r][_dc_message__charvar8000];
}
if (dataTable_in.Rows[r][_dc_message__text] == System.DBNull.Value) {
_output[r].Message__text_isNull = true;
} else {
_output[r].message__text_ = (string)dataTable_in.Rows[r][_dc_message__text];
}
if (dataTable_in.Rows[r][_dc_iduser] == System.DBNull.Value) {
_output[r].IDUser_isNull = true;
} else {
_output[r].iduser_ = (long)dataTable_in.Rows[r][_dc_iduser];
}
if (dataTable_in.Rows[r][_dc_name] == System.DBNull.Value) {
_output[r].Name_isNull = true;
} else {
_output[r].name_ = (string)dataTable_in.Rows[r][_dc_name];
}
if (dataTable_in.Rows[r][_dc_publish_date] == System.DBNull.Value) {
_output[r].Publish_date_isNull = true;
} else {
_output[r].publish_date_ = (DateTime)dataTable_in.Rows[r][_dc_publish_date];
}
if (dataTable_in.Rows[r][_dc_ifapplication] == System.DBNull.Value) {
_output[r].IFApplication_isNull = true;
} else {
_output[r].ifapplication_ = (int)dataTable_in.Rows[r][_dc_ifapplication];
}
if (dataTable_in.Rows[r][_dc_login] == System.DBNull.Value) {
_output[r].Login_isNull = true;
} else {
_output[r].login_ = (string)dataTable_in.Rows[r][_dc_login];
}
_output[r].haschanges_ = false;
}
return _output;
}
/// <summary>
/// Selects vFOR_Message values from Database (based on the search condition) and assigns them to the appropriate DO0_vFOR_Message property.
/// </summary>
/// <param name="IDMessage_search_in">IDMessage search condition</param>
/// <param name="dbConnection_in">Database connection, making the use of Database Transactions possible on a sequence of operations across the same or multiple DataObjects</param>
/// <returns>null if vFOR_Message doesn't exists at Database</returns>
public static SO_vFOR_Message getObject_byMessage(
long IDMessage_search_in,
DBConnection dbConnection_in
) {
SO_vFOR_Message _output = null;
DBConnection _connection = (dbConnection_in == null)
? DO__utils.DBConnection_createInstance(
DO__utils.DBServerType,
DO__utils.DBConnectionstring,
DO__utils.DBLogfile
)
: dbConnection_in;
IDbDataParameter[] _dataparameters = new IDbDataParameter[] {
_connection.newDBDataParameter("IDMessage_search_", DbType.Int64, ParameterDirection.Input, IDMessage_search_in, 0),
_connection.newDBDataParameter("IDMessage", DbType.Int64, ParameterDirection.Output, null, 0),
_connection.newDBDataParameter("IDMessage__parent", DbType.Int64, ParameterDirection.Output, null, 0),
_connection.newDBDataParameter("isThread", DbType.Boolean, ParameterDirection.Output, null, 0),
_connection.newDBDataParameter("isSticky", DbType.Boolean, ParameterDirection.Output, null, 0),
_connection.newDBDataParameter("Subject", DbType.AnsiString, ParameterDirection.Output, null, 255),
_connection.newDBDataParameter("Message__charvar8000", DbType.AnsiString, ParameterDirection.Output, null, 8000),
_connection.newDBDataParameter("Message__text", DbType.AnsiString, ParameterDirection.Output, null, 0),
_connection.newDBDataParameter("IDUser", DbType.Int64, ParameterDirection.Output, null, 0),
_connection.newDBDataParameter("Name", DbType.AnsiString, ParameterDirection.Output, null, 255),
_connection.newDBDataParameter("Publish_date", DbType.DateTime, ParameterDirection.Output, null, 0),
_connection.newDBDataParameter("IFApplication", DbType.Int32, ParameterDirection.Output, null, 0),
_connection.newDBDataParameter("Login", DbType.AnsiString, ParameterDirection.Output, null, 255)
};
_connection.Execute_SQLFunction(
"sp0_vFOR_Message_getObject_byMessage",
_dataparameters
);
if (dbConnection_in == null) { _connection.Dispose(); }
if (_dataparameters[1].Value != DBNull.Value) {
_output = new SO_vFOR_Message();
if (_dataparameters[1].Value == System.DBNull.Value) {
_output.IDMessage = 0L;
} else {
_output.IDMessage = (long)_dataparameters[1].Value;
}
if (_dataparameters[2].Value == System.DBNull.Value) {
_output.IDMessage__parent_isNull = true;
} else {
_output.IDMessage__parent = (long)_dataparameters[2].Value;
}
if (_dataparameters[3].Value == System.DBNull.Value) {
_output.isThread_isNull = true;
} else {
_output.isThread = (bool)_dataparameters[3].Value;
}
if (_dataparameters[4].Value == System.DBNull.Value) {
_output.isSticky_isNull = true;
} else {
_output.isSticky = (bool)_dataparameters[4].Value;
}
if (_dataparameters[5].Value == System.DBNull.Value) {
_output.Subject_isNull = true;
} else {
_output.Subject = (string)_dataparameters[5].Value;
}
if (_dataparameters[6].Value == System.DBNull.Value) {
_output.Message__charvar8000_isNull = true;
} else {
_output.Message__charvar8000 = (string)_dataparameters[6].Value;
}
if (_dataparameters[7].Value == System.DBNull.Value) {
_output.Message__text_isNull = true;
} else {
_output.Message__text = (string)_dataparameters[7].Value;
}
if (_dataparameters[8].Value == System.DBNull.Value) {
_output.IDUser_isNull = true;
} else {
_output.IDUser = (long)_dataparameters[8].Value;
}
if (_dataparameters[9].Value == System.DBNull.Value) {
_output.Name_isNull = true;
} else {
_output.Name = (string)_dataparameters[9].Value;
}
if (_dataparameters[10].Value == System.DBNull.Value) {
_output.Publish_date_isNull = true;
} else {
_output.Publish_date = (DateTime)_dataparameters[10].Value;
}
if (_dataparameters[11].Value == System.DBNull.Value) {
_output.IFApplication_isNull = true;
} else {
_output.IFApplication = (int)_dataparameters[11].Value;
}
if (_dataparameters[12].Value == System.DBNull.Value) {
_output.Login_isNull = true;
} else {
_output.Login = (string)_dataparameters[12].Value;
}
return _output;
}
return null;
}
private static SO_vFOR_Message[] getRecord(
DataTable dataTable_in
) {
DataColumn _dc_idmessage = null;
DataColumn _dc_idmessage__parent = null;
DataColumn _dc_isthread = null;
DataColumn _dc_issticky = null;
DataColumn _dc_subject = null;
DataColumn _dc_message__small = null;
DataColumn _dc_message__large = null;
DataColumn _dc_iduser = null;
DataColumn _dc_name = null;
DataColumn _dc_publish_date = null;
DataColumn _dc_ifapplication = null;
DataColumn _dc_login = null;
SO_vFOR_Message[] _output
= new SO_vFOR_Message[dataTable_in.Rows.Count];
for (int r = 0; r < dataTable_in.Rows.Count; r++) {
if (r == 0) {
_dc_idmessage = dataTable_in.Columns["IDMessage"];
_dc_idmessage__parent = dataTable_in.Columns["IDMessage__parent"];
_dc_isthread = dataTable_in.Columns["isThread"];
_dc_issticky = dataTable_in.Columns["IsSticky"];
_dc_subject = dataTable_in.Columns["Subject"];
_dc_message__small = dataTable_in.Columns["Message__small"];
_dc_message__large = dataTable_in.Columns["Message__large"];
_dc_iduser = dataTable_in.Columns["IDUser"];
_dc_name = dataTable_in.Columns["Name"];
_dc_publish_date = dataTable_in.Columns["Publish_date"];
_dc_ifapplication = dataTable_in.Columns["IFApplication"];
_dc_login = dataTable_in.Columns["Login"];
}
_output[r] = new SO_vFOR_Message();
if (dataTable_in.Rows[r][_dc_idmessage] == System.DBNull.Value) {
_output[r].IDMessage = 0L;
} else {
_output[r].IDMessage = (long)dataTable_in.Rows[r][_dc_idmessage];
}
if (dataTable_in.Rows[r][_dc_idmessage__parent] == System.DBNull.Value) {
_output[r].IDMessage__parent_isNull = true;
} else {
_output[r].IDMessage__parent = (long)dataTable_in.Rows[r][_dc_idmessage__parent];
}
if (dataTable_in.Rows[r][_dc_isthread] == System.DBNull.Value) {
_output[r].isThread_isNull = true;
} else {
_output[r].isThread = (bool)dataTable_in.Rows[r][_dc_isthread];
}
if (dataTable_in.Rows[r][_dc_issticky] == System.DBNull.Value) {
_output[r].IsSticky = false;
} else {
_output[r].IsSticky = (bool)dataTable_in.Rows[r][_dc_issticky];
}
if (dataTable_in.Rows[r][_dc_subject] == System.DBNull.Value) {
_output[r].Subject_isNull = true;
} else {
_output[r].Subject = (string)dataTable_in.Rows[r][_dc_subject];
}
if (dataTable_in.Rows[r][_dc_message__small] == System.DBNull.Value) {
_output[r].Message__small_isNull = true;
} else {
_output[r].Message__small = (string)dataTable_in.Rows[r][_dc_message__small];
}
if (dataTable_in.Rows[r][_dc_message__large] == System.DBNull.Value) {
_output[r].Message__large_isNull = true;
} else {
_output[r].Message__large = (string)dataTable_in.Rows[r][_dc_message__large];
}
if (dataTable_in.Rows[r][_dc_iduser] == System.DBNull.Value) {
_output[r].IDUser_isNull = true;
} else {
_output[r].IDUser = (long)dataTable_in.Rows[r][_dc_iduser];
}
if (dataTable_in.Rows[r][_dc_name] == System.DBNull.Value) {
_output[r].Name_isNull = true;
} else {
_output[r].Name = (string)dataTable_in.Rows[r][_dc_name];
}
if (dataTable_in.Rows[r][_dc_publish_date] == System.DBNull.Value) {
_output[r].Publish_date = new DateTime(1900, 1, 1);
} else {
_output[r].Publish_date = (DateTime)dataTable_in.Rows[r][_dc_publish_date];
}
if (dataTable_in.Rows[r][_dc_ifapplication] == System.DBNull.Value) {
_output[r].IFApplication_isNull = true;
} else {
_output[r].IFApplication = (int)dataTable_in.Rows[r][_dc_ifapplication];
}
if (dataTable_in.Rows[r][_dc_login] == System.DBNull.Value) {
_output[r].Login = string.Empty;
} else {
_output[r].Login = (string)dataTable_in.Rows[r][_dc_login];
}
_output[r].HasChanges = false;
}
return _output;
}
