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"]); } }