public void AssignLocalVariables(DataRow dr)
{
DataHash = DBSafeConvert.ToStringN(dr["DataHash"]);
OrderSystemOfRecordID = DBSafeConvert.ToInt32N(dr["OrderSystemOfRecordID"]);
OrderSystemOfRecordDesc = DBSafeConvert.ToStringN(dr["OrderSystemOfRecordDesc"]);
DateCreated = DBSafeConvert.ToDateTimeUtcN(dr["DateCreated"]);
DateUpdated = DBSafeConvert.ToDateTimeUtcN(dr["DateUpdated"]);
}
public void AssignLocalVariables(DataRow dr)
{
DataHash = DBSafeConvert.ToStringN(dr["DataHash"]);
SystemLogItemID = DBSafeConvert.ToInt32N(dr["SystemLogItemID"]);
Note = DBSafeConvert.ToStringN(dr["Note"]);
DateCreated = DBSafeConvert.ToDateTimeUtcN(dr["DateCreated"]);
DateUpdated = DBSafeConvert.ToDateTimeUtcN(dr["DateUpdated"]);
}
public void AssignLocalVariables(DataRow dr)
{
DataHash = DBSafeConvert.ToStringN(dr["DataHash"]);
SystemConfigItemID = DBSafeConvert.ToInt32N(dr["SystemConfigItemID"]);
ConfigSettingName = DBSafeConvert.ToStringN(dr["ConfigSettingName"]);
ConfigSettingValue = DBSafeConvert.ToStringN(dr["ConfigSettingValue"]);
DateCreated = DBSafeConvert.ToDateTimeUtcN(dr["DateCreated"]);
DateUpdated = DBSafeConvert.ToDateTimeUtcN(dr["DateUpdated"]);
}
public void AssignLocalVariables(DataRow dr)
{
DataHash = DBSafeConvert.ToStringN(dr["DataHash"]);
MigrationStatusID = DBSafeConvert.ToInt32N(dr["MigrationStatusID"]);
MigrationStatusDesc = DBSafeConvert.ToStringN(dr["MigrationStatusDesc"]);
MigrationStatusExtendedDescription = DBSafeConvert.ToStringN(dr["MigrationStatusExtendedDescription"]);
DateCreated = DBSafeConvert.ToDateTimeUtcN(dr["DateCreated"]);
DateUpdated = DBSafeConvert.ToDateTimeUtcN(dr["DateUpdated"]);
}
public void AssignLocalVariables(DataRow dr)
{
DataHash = DBSafeConvert.ToStringN(dr["DataHash"]);
APICallLogItemID = DBSafeConvert.ToInt32N(dr["APICallLogItemID"]);
OrderAddressID = DBSafeConvert.ToInt32N(dr["OrderAddressID"]);
Host = DBSafeConvert.ToStringN(dr["Host"]);
FullUrl = DBSafeConvert.ToStringN(dr["FullUrl"]);
ResponseCode = DBSafeConvert.ToStringN(dr["ResponseCode"]);
RunTimeHumanReadable = DBSafeConvert.ToStringN(dr["RunTimeHumanReadable"]);
RunTimeInTicksString = DBSafeConvert.ToStringN(dr["RunTimeInTicksString"]);
DateCreated = DBSafeConvert.ToDateTimeUtcN(dr["DateCreated"]);
DateUpdated = DBSafeConvert.ToDateTimeUtcN(dr["DateUpdated"]);
}
public void AssignLocalVariables(DataRow dr)
{
DataHash = DBSafeConvert.ToStringN(dr["DataHash"]);
OrderAddressLogItemID = DBSafeConvert.ToInt32N(dr["OrderAddressLogItemID"]);
OrderAddressID = DBSafeConvert.ToInt32N(dr["OrderAddressID"]);
MigrationStatusID = DBSafeConvert.ToInt32N(dr["MigrationStatusID"]);
LogMessage = DBSafeConvert.ToStringN(dr["LogMessage"]);
DateCreated = DBSafeConvert.ToDateTimeUtcN(dr["DateCreated"]);
DateUpdated = DBSafeConvert.ToDateTimeUtcN(dr["DateUpdated"]);
// JOINS
if (dr.GetValue("MigrationStatusDesc") != null)
{
MigrationStatusDesc = DBSafeConvert.ToStringN(dr["MigrationStatusDesc"]);
}
if (dr.GetValue("MigrationStatusExtendedDescription") != null)
{
MigrationStatusExtendedDescription = DBSafeConvert.ToStringN(dr["MigrationStatusExtendedDescription"]);
}
}
public void AssignLocalVariables(DataRow dr)
{
CustomerOrderNumber = DBSafeConvert.ToStringN(dr["CUST_ORDER_NBR"]);
ServiceOrderNumber = DBSafeConvert.ToStringN(dr["SERV_ORDER_NBR"]);
ServiceOrderStatusCode = DBSafeConvert.ToStringN(dr["SERV_ORDER_STATUS_CD"]);
DataWarehouseSourceSystemCode = DBSafeConvert.ToStringN(dr["DW_SOURCE_SYSTEM_CD"]);
CLIICode = DBSafeConvert.ToStringN(dr["CLLI_CD"]);
Line1Address = DBSafeConvert.ToStringN(dr["LINE1_ADDR"]);
CityName = DBSafeConvert.ToStringN(dr["CITY_NAME"]);
StateCode = DBSafeConvert.ToStringN(dr["STATE_CD"]);
PostalCode = DBSafeConvert.ToStringN(dr["POSTAL_SHORT_CD"]);
CountryName = DBSafeConvert.ToStringN(dr["COUNTRY_ISO_3_CD"]);
FloorName = DBSafeConvert.ToStringN(dr["FLOOR_NAME"]);
RoomName = DBSafeConvert.ToStringN(dr["ROOM_NAME"]);
SuiteName = DBSafeConvert.ToStringN(dr["SUITE_NAME"]);
FIRST_ORDER_CREATE_DT = DBSafeConvert.ToDateTimeUtcN(dr["FIRST_ORDER_CREATE_DT"]);
OPE_LAST_MODIFY_DATE = DBSafeConvert.ToDateTimeUtcN(dr["OPE_LAST_MODIFY_DATE"]);
PL_LAST_MODIFY_DATE = DBSafeConvert.ToDateTimeUtcN(dr["PL_LAST_MODIFY_DATE"]);
PS_LAST_MODIFY_DATE = DBSafeConvert.ToDateTimeUtcN(dr["PS_LAST_MODIFY_DATE"]);
}
public void AssignLocalVariables(DataRow dr)
{
MAX_OPE_LAST_MODIFY_DATE = DBSafeConvert.ToDateTimeUtcN(dr["MAX_OPE_LAST_MODIFY_DATE"]);
MAX_PL_LAST_MODIFY_DATE = DBSafeConvert.ToDateTimeUtcN(dr["MAX_PL_LAST_MODIFY_DATE"]);
MAX_PS_LAST_MODIFY_DATE = DBSafeConvert.ToDateTimeUtcN(dr["MAX_PS_LAST_MODIFY_DATE"]);
}
public void AssignLocalVariables(DataRow dr)
{
DataHash = DBSafeConvert.ToStringN(dr["DataHash"]);
OrderAddressID = DBSafeConvert.ToInt32N(dr["OrderAddressID"]);
OrderAddressTypeID = DBSafeConvert.ToInt32N(dr["OrderAddressTypeID"]);
MigrationStatusID = DBSafeConvert.ToInt32N(dr["MigrationStatusID"]);
OrderSystemOfRecordID = DBSafeConvert.ToInt32N(dr["OrderSystemOfRecordID"]);
CDWCustomerOrderNumber = DBSafeConvert.ToStringN(dr["CDWCustomerOrderNumber"]);
CDWAddressOne = DBSafeConvert.ToStringN(dr["CDWAddressOne"]);
CDWCity = DBSafeConvert.ToStringN(dr["CDWCity"]);
CDWState = DBSafeConvert.ToStringN(dr["CDWState"]);
CDWPostalCode = DBSafeConvert.ToStringN(dr["CDWPostalCode"]);
CDWCountry = DBSafeConvert.ToStringN(dr["CDWCountry"]);
CDWFloor = DBSafeConvert.ToStringN(dr["CDWFloor"]);
CDWRoom = DBSafeConvert.ToStringN(dr["CDWRoom"]);
CDWSuite = DBSafeConvert.ToStringN(dr["CDWSuite"]);
CDWCLII = DBSafeConvert.ToStringN(dr["CDWCLII"]);
ValidCLII = DBSafeConvert.ToBooleanN(dr["ValidCLII"]);
NumberOfFailedGLMSiteCalls = DBSafeConvert.ToInt32N(dr["NumberOfFailedGLMSiteCalls"]);
ExistsInGLMAsSite = DBSafeConvert.ToBooleanN(dr["ExistsInGLMAsSite"]);
GLMPLNumber = DBSafeConvert.ToStringN(dr["GLMPLNumber"]);
NumberOfFailedGLMSiteCodeExistenceCalls = DBSafeConvert.ToInt32N(dr["NumberOfFailedGLMSiteCodeExistenceCalls"]);
NumberOfFailedGLMSiteCodeCreationCalls = DBSafeConvert.ToInt32N(dr["NumberOfFailedGLMSiteCodeCreationCalls"]);
GLMSiteCode = DBSafeConvert.ToStringN(dr["GLMSiteCode"]);
HasGLMSiteCode = DBSafeConvert.ToBooleanN(dr["HasGLMSiteCode"]);
NumberOfFailedSAPSiteAddressSearchCalls = DBSafeConvert.ToInt32N(dr["NumberOfFailedSAPSiteAddressSearchCalls"]);
NumberOfFailedSAPSiteAddressImportCalls = DBSafeConvert.ToInt32N(dr["NumberOfFailedSAPSiteAddressImportCalls"]);
ExistsInSAPAsSiteAddress = DBSafeConvert.ToBooleanN(dr["ExistsInSAPAsSiteAddress"]);
NumberOfRecordsInSAPWithPL = DBSafeConvert.ToInt32N(dr["NumberOfRecordsInSAPWithPL"]);
NumberOfFailedGLMServiceLocationSearchCalls = DBSafeConvert.ToInt32N(dr["NumberOfFailedGLMServiceLocationSearchCalls"]);
NumberOfFailedGLMServiceLocationCreationCalls = DBSafeConvert.ToInt32N(dr["NumberOfFailedGLMServiceLocationCreationCalls"]);
GLMSLNumber = DBSafeConvert.ToStringN(dr["GLMSLNumber"]);
ExistsInGLMAsServiceLocation = DBSafeConvert.ToBooleanN(dr["ExistsInGLMAsServiceLocation"]);
NumberOfFailedGLMSCodeExistenceCalls = DBSafeConvert.ToInt32N(dr["NumberOfFailedGLMSCodeExistenceCalls"]);
NumberOfFailedGLMSCodeCreationCalls = DBSafeConvert.ToInt32N(dr["NumberOfFailedGLMSCodeCreationCalls"]);
GLMSCode = DBSafeConvert.ToStringN(dr["GLMSCode"]);
HasGLMSCode = DBSafeConvert.ToBooleanN(dr["HasGLMSCode"]);
NumberOfFailedSAPServiceLocationAddressSearchCalls = DBSafeConvert.ToInt32N(dr["NumberOfFailedSAPServiceLocationAddressSearchCalls"]);
NumberOfFailedSAPServiceLocationAddressImportCalls = DBSafeConvert.ToInt32N(dr["NumberOfFailedSAPServiceLocationAddressImportCalls"]);
ExistsInSAPAsServiceLocationAddress = DBSafeConvert.ToBooleanN(dr["ExistsInSAPAsServiceLocationAddress"]);
NumberOfRecordsInSAPWithSL = DBSafeConvert.ToInt32N(dr["NumberOfRecordsInSAPWithSL"]);
SourceCreationDate = DBSafeConvert.ToDateTimeUtcN(dr["SourceCreationDate"]);
SourceLastModifyDate = DBSafeConvert.ToDateTimeUtcN(dr["SourceLastModifyDate"]);
DateTimeOfLastMigrationStatusUpdate = DBSafeConvert.ToDateTimeUtcN(dr["DateTimeOfLastMigrationStatusUpdate"]);
DateTimeOfLastDupDetection = DBSafeConvert.ToDateTimeUtcN(dr["DateTimeOfLastDupDetection"]);
DateCreated = DBSafeConvert.ToDateTimeUtcN(dr["DateCreated"]);
DateUpdated = DBSafeConvert.ToDateTimeUtcN(dr["DateUpdated"]);
ServiceOrderNumber = DBSafeConvert.ToStringN(dr["ServiceOrderNumber"]);
FIRST_ORDER_CREATE_DT = DBSafeConvert.ToDateTimeUtcN(dr["FIRST_ORDER_CREATE_DT"]);
OPE_LAST_MODIFY_DATE = DBSafeConvert.ToDateTimeUtcN(dr["OPE_LAST_MODIFY_DATE"]);
PL_LAST_MODIFY_DATE = DBSafeConvert.ToDateTimeUtcN(dr["PL_LAST_MODIFY_DATE"]);
PS_LAST_MODIFY_DATE = DBSafeConvert.ToDateTimeUtcN(dr["PS_LAST_MODIFY_DATE"]);
TotalProcessingTimeInTickString = DBSafeConvert.ToStringN(dr["TotalProcessingTimeInTickString"]);
TotalProcessingTimeAsHumanReadable = DBSafeConvert.ToStringN(dr["TotalProcessingTimeAsHumanReadable"]);
// JOINS
if (dr.GetValue("MigrationStatusDesc") != null)
{
MigrationStatusDesc = DBSafeConvert.ToStringN(dr["MigrationStatusDesc"]);
}
if (dr.GetValue("OrderAddressTypeDesc") != null)
{
OrderAddressTypeDesc = DBSafeConvert.ToStringN(dr["OrderAddressTypeDesc"]);
}
if (dr.GetValue("OrderSystemOfRecordDesc") != null)
{
OrderSystemOfRecordDesc = DBSafeConvert.ToStringN(dr["OrderSystemOfRecordDesc"]);
}
}
