public void ThenTheUpdateCustomerEventDetailsAreStoredInVSSDB() { string customerUID = customerServiceSupport.UpdateCustomerModel.CustomerUID.ToString().Replace("-", ""); string customerName = String.IsNullOrEmpty(customerServiceSupport.UpdateCustomerModel.CustomerName) ? customerServiceSupport.CreateCustomerModel.CustomerName : customerServiceSupport.UpdateCustomerModel.CustomerName; string customerType = customerServiceSupport.CreateCustomerModel.CustomerType.ToString(); string primaryContactEmail = customerServiceSupport.UpdateCustomerModel.PrimaryContactEmail == null ? customerServiceSupport.CreateCustomerModel.PrimaryContactEmail : customerServiceSupport.UpdateCustomerModel.PrimaryContactEmail; string firstName = customerServiceSupport.UpdateCustomerModel.FirstName == null ? customerServiceSupport.CreateCustomerModel.FirstName : customerServiceSupport.UpdateCustomerModel.FirstName; string lastName = customerServiceSupport.UpdateCustomerModel.LastName == null ? customerServiceSupport.CreateCustomerModel.LastName : customerServiceSupport.UpdateCustomerModel.LastName; CommonUtil.WaitToProcess("2"); //Wait for the data to get persisted in DB List <string> columnList = new List <string>() { "CustomerUID", "CustomerName", "CustomerType", "PrimaryContactEmail", "FirstName", "LastName" }; List <string> updateCustomerDetails = new List <string>(); updateCustomerDetails.Add(customerUID.ToUpper()); updateCustomerDetails.Add(customerName); updateCustomerDetails.Add(GetCustomerTypeId(customerType)); updateCustomerDetails.Add(primaryContactEmail); updateCustomerDetails.Add(firstName); updateCustomerDetails.Add(lastName); string validateQuery = CustomerServiceMySqlQueries.CustomerDetailsByCustomerUID + customerUID + "')"; string validateDateQuery = CustomerServiceMySqlQueries.CustomerUpdateUTCByCustomerUID + customerUID + "')"; MySqlUtil.ValidateMySQLQuery(MySqlConnectionString, validateQuery, updateCustomerDetails); MySqlUtil.ValidateMySQLDateValueQuery(MySqlConnectionString, validateDateQuery, DateTime.UtcNow.AddMinutes(-2), "LESS_THAN_DB"); }
public void ThenTheAssociateCustomerUserEventDetailsAreStoredInVSSDB() { customerUID = customerUserServiceSupport.AssociateCustomerUserModel.CustomerUID.ToString(); userUID = customerUserServiceSupport.AssociateCustomerUserModel.UserUID.ToString(); string validateQuery = CustomerListSqlQueries.CustomerUserDetailsByCustomerUID + userUID + "'"; MySqlUtil.ValidateMySQLQuery(MySqlConnectionString, validateQuery, customerUID); }
public void ThenTheAssociateCustomerUserEventDetailsForAllCustomersAreStoredInVSSDB() { userUID = customerUserServiceSupport.AssociateCustomerUserModel.UserUID.ToString(); for (int index = 0; index <= 2; index++) { string validateQuery = CustomerListSqlQueries.CustomerUserDetailsByUserUID + multipleCustomerGUID[index].ToString() + "'"; MySqlUtil.ValidateMySQLQuery(MySqlConnectionString, validateQuery, userUID); } }
public void ThenTheUpdateCustomerEventDetailsAreUpdatedInVSSDB() { customerUID = customerServiceSupport.UpdateCustomerModel.CustomerUID.ToString(); customerName = customerServiceSupport.UpdateCustomerModel.CustomerName; string validateQuery = CustomerListSqlQueries.CustomerNameUpdateByCustomerUID + customerUID + "'"; string validateDateQuery = CustomerListSqlQueries.CustomerUpdateUTCByCustomerUID + customerUID + "'"; MySqlUtil.ValidateMySQLQuery(MySqlConnectionString, validateQuery, customerName.ToString()); MySqlUtil.ValidateMySQLDateValueQuery(MySqlConnectionString, validateDateQuery, actionUTC, "LESS_THAN_DB"); }
public void ThenTheAssociateCustomerUserEventDetailsAreStoredInVSSDB() { CommonUtil.WaitToProcess("2"); string customerUID = customerAssetServiceSupport.AssociateCustomerAssetModel.CustomerUID.ToString(); string assetUID = customerAssetServiceSupport.AssociateCustomerAssetModel.AssetUID.ToString(); string assetRelationType = customerAssetServiceSupport.AssociateCustomerAssetModel.RelationType.ToString(); List <string> columnList = new List <string>() { "fk_CustomerUID", "fk_AssetUID", "fk_AssetRelationTypeID" }; List <string> createCustomerDetails = new List <string>(); createCustomerDetails.Add(customerUID); createCustomerDetails.Add(assetUID); createCustomerDetails.Add(GetAssetRelationTypeId(assetRelationType)); string validateQuery = CustomerServiceMySqlQueries.CustomerAssetDetailsByCustomerUID + customerUID + "'"; MySqlUtil.ValidateMySQLQuery(MySqlConnectionString, validateQuery, customerUID); }
public void ThenTheCreateCustomerRelationshipEventDetailsAreStoredInVSSDB() { CommonUtil.WaitToProcess("2"); string parentCustomerUid = customerRelationshipServiceSupport.CreateCustomerRelationshipModel.ParentCustomerUID.ToString(); string childCustomerUid = customerRelationshipServiceSupport.CreateCustomerRelationshipModel.ChildCustomerUID.ToString(); List <string> columnList = new List <string>() { "fk_ParentCustomerUID", "fk_CustomerUID", "fk_RootCustomerUID", "LeftNodePosition", "RightNodePosition" }; List <string> parentCustomerDetails = new List <string>(); parentCustomerDetails.Add(parentCustomerUid); parentCustomerDetails.Add(parentCustomerUid); parentCustomerDetails.Add(parentCustomerUid); parentCustomerDetails.Add("1"); parentCustomerDetails.Add("4"); string validateQuery = CustomerServiceMySqlQueries.CustomerRelationshipByParentCustomerUID + parentCustomerUid + "'and fk_CustomerUID='" + parentCustomerUid + "'"; MySqlUtil.ValidateMySQLQuery(MySqlConnectionString, validateQuery, parentCustomerDetails); List <string> childcolumnList = new List <string>() { "fk_ParentCustomerUID", "fk_CustomerUID", "fk_RootCustomerUID", "LeftNodePosition", "RightNodePosition" }; List <string> childCustomerDetails = new List <string>(); childCustomerDetails.Add(parentCustomerUid); childCustomerDetails.Add(childCustomerUid); childCustomerDetails.Add(parentCustomerUid); childCustomerDetails.Add("2"); childCustomerDetails.Add("3"); string validateChildCustomerQuery = CustomerServiceMySqlQueries.CustomerRelationshipByChildCustomerUID + childCustomerUid + "'"; MySqlUtil.ValidateMySQLQuery(MySqlConnectionString, validateChildCustomerQuery, childCustomerDetails); }
public void ThenTheCreateCustomerEventDetailsAreStoredInVSSDB() { customerUID = customerServiceSupport.CreateCustomerModel.CustomerUID.ToString(); customerName = customerServiceSupport.CreateCustomerModel.CustomerName; customerType = customerServiceSupport.CreateCustomerModel.CustomerType.ToString(); CommonUtil.WaitToProcess(CustomerListConfig.KafkaTimeoutThreshold); List <string> columnList = new List <string>() { "CustomerUID", "CustomerName", "CustomerType" }; List <string> createCustomerDetails = new List <string>(); createCustomerDetails.Add(customerUID); createCustomerDetails.Add(customerName); createCustomerDetails.Add(GetCustomerTypeId(customerType)); string validateQuery = CustomerListSqlQueries.CustomerDetailsByCustomerUID + customerUID + "'"; string validateDateQuery = CustomerListSqlQueries.CustomerUpdateUTCByCustomerUID + customerUID + "'"; MySqlUtil.ValidateMySQLQuery(MySqlConnectionString, validateQuery, createCustomerDetails); MySqlUtil.ValidateMySQLDateValueQuery(MySqlConnectionString, validateDateQuery, DateTime.UtcNow.AddMinutes(-2), "LESS_THAN_DB"); }
public void ThenTheDissociateCustomerUserEventDetailsAreInvalidUserNOTRemovedInVSSDB() { string validateQuery = CustomerListSqlQueries.CustomerUserDetailsByUserUID + customerUID + "'"; MySqlUtil.ValidateMySQLQuery(MySqlConnectionString, validateQuery, userUID); // NOT Removed In VSS DB }
public void ThenTheCreateCustomerEventDetailsAreNOTUpdatedInVSSDB() { string validateQuery = CustomerListSqlQueries.CustomerTypeIdByCustomerUID + customerUID + "'"; MySqlUtil.ValidateMySQLQuery(MySqlConnectionString, validateQuery, "1"); //Not Updated As Customer }