public static OrganizationProduct GetOrganizationProduct(LoginUser loginUser, int organizationProductID) { OrganizationProducts organizationProducts = new OrganizationProducts(loginUser); organizationProducts.LoadByOrganizationProductID(organizationProductID); if (organizationProducts.IsEmpty) { return(null); } else { return(organizationProducts[0]); } }
public void RemoveCustomer(int organizationProductID) { OrganizationProducts organizationProducts = new OrganizationProducts(LoginUser); organizationProducts.LoadItemInfo(organizationProductID); if (organizationProducts.IsEmpty) { return; } OrganizationProduct organizationProduct = organizationProducts[0]; /*using (SqlCommand command = new SqlCommand()) * { * command.CommandText = "DELETE FROM OrganizationProducts WHERE (OrganizationProductID = @OrganizationProductID)"; * command.CommandType = CommandType.Text; * command.Parameters.AddWithValue("@OrganizationProductID", organizationProductID); * ExecuteNonQuery(command, "OrganizationProducts"); * }*/ string description; if (organizationProduct.ProductVersionID != null) { description = "Removed product '" + (string)organizationProduct.Row["ProductName"] + "' version '" + (string)organizationProduct.Row["VersionNumber"] + "' from customer '" + (string)organizationProduct.Row["OrganizationName"] + "'"; ActionLogs.AddActionLog(LoginUser, ActionLogType.Delete, ReferenceType.ProductVersions, (int)organizationProduct.ProductVersionID, description); } else { description = "Removed product '" + (string)organizationProduct.Row["ProductName"] + "' from customer '" + (string)organizationProduct.Row["OrganizationName"] + "'"; } ActionLogs.AddActionLog(LoginUser, ActionLogType.Delete, ReferenceType.Organizations, organizationProduct.OrganizationID, description); ActionLogs.AddActionLog(LoginUser, ActionLogType.Delete, ReferenceType.Products, organizationProduct.ProductID, description); organizationProducts.DeleteFromDB(organizationProductID); }
public OrganizationProduct(DataRow row, OrganizationProducts organizationProducts) : base(row, organizationProducts) { _organizationProducts = organizationProducts; }