private static int?CalculateCustomerHubID(int organizationID, int?customerHubID, int?productFamilyID) { int?customerHubIDToProcess = null; //If we have a hubID that is the best possible scenario if (customerHubID != null) { customerHubIDToProcess = customerHubID; } //Try by productFamilyID else if (productFamilyID != null && productFamilyID != -1) { CustomerHubs hubHelper = new CustomerHubs(LoginUser.Anonymous); hubHelper.LoadByProductFamilyID((int)productFamilyID); //because who doesn't love doing it this way!? if (hubHelper.Any()) { customerHubIDToProcess = hubHelper[0].CustomerHubID; } } //Try and choose the first hub that is not product line associated if no other options are met else { customerHubIDToProcess = CustomerHubs.LoadFirstNonProductAssociatedHubID(organizationID); } return(customerHubIDToProcess); }
public static int?LoadFirstNonProductAssociatedHubID(int organizationID) { CustomerHubs customerHubHelper = new CustomerHubs(LoginUser.Anonymous); customerHubHelper.LoadByOrganizationID(organizationID); CustomerHub returnHub = customerHubHelper.Where(hub => hub.ProductFamilyID == null && hub.IsActive == true).First(); return(returnHub?.CustomerHubID); }
public static void DeleteByCustomerHubID(LoginUser loginUser, int customerHubID) { CustomerHubs customerHubs = new CustomerHubs(loginUser); using (SqlCommand command = new SqlCommand()) { command.CommandText = "Delete FROM [CustomerHubAuthentication] WHERE CustomerHubID = @CustomerHubID"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@CustomerHubID", customerHubID); customerHubs.ExecuteNonQuery(command, "CustomerHubAuthentication"); } }
public static CustomerHub GetCustomerHub(LoginUser loginUser, int customerHubID) { CustomerHubs customerHubs = new CustomerHubs(loginUser); customerHubs.LoadByCustomerHubID(customerHubID); if (customerHubs.IsEmpty) { return(null); } else { return(customerHubs[0]); } }
public CustomerHub(DataRow row, CustomerHubs customerHubs) : base(row, customerHubs) { _customerHubs = customerHubs; }