public SystemConfigItem Get(int intSystemConfigItemID, out string LastError)
{
SystemConfigItem objSystemConfigItems = null;
LastError = String.Empty;
try
{
SqlCommand objQuery = new SqlCommand();
objQuery.CommandText = "tblSystemConfigItem_SelByIDENT_SystemConfigItemID_EQ";
objQuery.CommandType = CommandType.StoredProcedure;
// Add the parameter to the Parameters collection.
objQuery.Parameters.Add(new SqlParameter("SystemConfigItemID", intSystemConfigItemID));
objSystemConfigItems = DBUtil.DataTableToObject <SystemConfigItem>(SqlServerDataAccess.Execute(objQuery));
}
catch (System.Data.SqlClient.SqlException exSql)
{
LastError = String.Concat("", exSql.Message, exSql.Number, null);
}
catch (Exception ex)
{
LastError = String.Concat("", ex.Message, null);
}
return(objSystemConfigItems);
}
public MigrationStatus GetByPK(int intMigrationStatusID, out string LastError)
{
MigrationStatus objMigrationStatus = null;
LastError = String.Empty;
try
{
if (intMigrationStatusID == 0)
{
LastError = "The identity value supplied for the records PK cannot be zero and must be a valid integer --> MigrationStatusID";
return(null);
}
SqlCommand objQuery = new SqlCommand();
objQuery.CommandText = "tblMigrationStatus_SelByPK_MigrationStatusID_EQ";
objQuery.CommandType = CommandType.StoredProcedure;
// Add the parameter to the Parameters collection.
objQuery.Parameters.Add(new SqlParameter("MigrationStatusID", intMigrationStatusID));
objMigrationStatus = DBUtil.DataTableToObject <MigrationStatus>(SqlServerDataAccess.Execute(objQuery));
}
catch (System.Data.SqlClient.SqlException exSql)
{
LastError = String.Concat("", exSql.Message, exSql.Number, null);
}
catch (Exception ex)
{
LastError = String.Concat("", ex.Message, null);
}
return(objMigrationStatus);
}
public ChangesetDateGroup GetRecords()
{
string strTSQL = "SELECT MAX(OPE_LAST_MODIFY_DATE) AS MAX_OPE_LAST_MODIFY_DATE, MAX(PL_LAST_MODIFY_DATE) AS MAX_PL_LAST_MODIFY_DATE, MAX(PS_LAST_MODIFY_DATE) as MAX_PS_LAST_MODIFY_DATE FROM tblOrderAddress";
DataTable objDataTable = Get(strTSQL);
return(DBUtil.DataTableToObject <ChangesetDateGroup>(objDataTable));
}
public OrderAddress Get(int intOrderSystemOfRecordID, string strCDWCustomerOrderNumber, string strCDWAddressOne, string strCDWCity, string strCDWState, string strCDWPostalCode, string strCDWCountry, string strCDWFloor, string strCDWRoom, string strCDWSuite, out string LastError)
{
OrderAddress objOrderAddress = null;
LastError = String.Empty;
try
{
if (intOrderSystemOfRecordID == 0)
{
LastError = "The value supplied for 'intOrderSystemOfRecordID' cannot be zero and must be a valid integer that corresponds to an enum";
return(null);
}
SqlCommand objQuery = new SqlCommand();
objQuery.CommandText = "tblOrderAddress_SelBy_OrderSystemOfRecordID_EQ_CDWCustomerOrderNumber_EQ_CDWAddressOne_EQ_CDWCity_EQ_CDWState_EQ_C_TRUNC";
objQuery.CommandType = CommandType.StoredProcedure;
// Add the parameter to the Parameters collection.
objQuery.Parameters.Add(new SqlParameter("OrderSystemOfRecordID", (object)intOrderSystemOfRecordID ?? String.Empty));
objQuery.Parameters.Add(new SqlParameter("CDWCustomerOrderNumber", (object)strCDWCustomerOrderNumber ?? String.Empty));
objQuery.Parameters.Add(new SqlParameter("CDWAddressOne", (object)strCDWAddressOne ?? String.Empty));
objQuery.Parameters.Add(new SqlParameter("CDWCity", (object)strCDWCity ?? String.Empty));
objQuery.Parameters.Add(new SqlParameter("CDWState", (object)strCDWState ?? String.Empty));
objQuery.Parameters.Add(new SqlParameter("CDWPostalCode", (object)strCDWPostalCode ?? String.Empty));
objQuery.Parameters.Add(new SqlParameter("CDWCountry", (object)strCDWCountry ?? String.Empty));
objQuery.Parameters.Add(new SqlParameter("CDWFloor", (object)strCDWFloor ?? String.Empty));
objQuery.Parameters.Add(new SqlParameter("CDWRoom", (object)strCDWRoom ?? String.Empty));
objQuery.Parameters.Add(new SqlParameter("CDWSuite", (object)strCDWSuite ?? String.Empty));
objOrderAddress = DBUtil.DataTableToObject <OrderAddress>(SqlServerDataAccess.Execute(objQuery));
}
catch (System.Data.SqlClient.SqlException exSql)
{
LastError = String.Concat("", exSql.Message, exSql.Number, null);
}
catch (Exception ex)
{
LastError = String.Concat("", ex.Message, null);
}
return(objOrderAddress);
}
